Basic Examples
Basic Examples
In[]:=
Summarize a vector of numbers:
In[]:=
1 column 1 | ||||||||||||
|
Out[]=
Summarize a matrix of strings and specify the column names:
sarr=Transpose[{RandomChoice[CharacterRange["A","Z"],20],RandomWord["CommonWords",20]}];[sarr,{"random letter","random word"}]
In[]:=
,
1 random letter | ||||||||||||||
|
2 random word | ||||||||||||||
|
Out[]=
Summarize a vector of numbers with missing values:
In[]:=
1 column 1 | ||||||||||||||
|
Out[]=
Summarize a full 2D array with numerical and categorical columns (numbers, strings, and symbols):
Block[{n=200},arr=Flatten/@Transpose[{RandomReal[{-10,10},{n,2}],MapAt[ToLowerCase,RandomChoice[CharacterRange["A","Z"],{n,2}],{All,2}],RandomChoice[{,,Γ},n]}]];
In[]:=
In[]:=
,
,
,
,
1 column 1 | ||||||||||||
|
2 column 2 | ||||||||||||
|
3 column 3 | ||||||||||||||
|
4 column 4 | ||||||||||||||
|
5 column 5 | ||||||
|
Out[]=
Summarize a dataset:
In[]:=
,
,
,
,
1 | ||||||||||||
|
2 | ||||||||||||
|
3 | ||||||||||||||
|
4 | ||||||||||||||
|
5 | ||||||
|
Out[]=
Summarize a dataset with column names:
ds=Dataset[arr][All,AssociationThread[{"num1","num2","char1","char2","symb"},#]&];
In[]:=
In[]:=
,
,
,
,
1 num1 | ||||||||||||
|
2 num2 | ||||||||||||
|
3 char1 | ||||||||||||||
|
4 char2 | ||||||||||||||
|
5 symb | ||||||
|
Out[]=
Summarize an association of vectors:
asc=AssociationThread[Range[10]Table[Append[RandomReal[1,2],RandomWord[]],10]];
In[]:=
In[]:=
,
,
1 column 1 | ||||||||||||
|
1 column 1 | ||||||||||||
|
2 column 2 | ||||||||||||
|
3 column 3 | ||||||||||||||
|
Out[]=
Scope
Scope
In[]:=
A larger number of categorical values can be seen using the option :
"MaxTallies"
In[]:=
,
,
,
,
1 num1 | ||||||||||||
|
2 num2 | ||||||||||||
|
3 char1 | ||||||||||||||||||||||||
|
4 char2 | ||||||||||||||||||||||||
|
5 symb | ||||||
|
Out[]=
The function works with missing values and summarizes them separately of the rest of the values in a column:
Here we make a list of date objects with missing values:
Here is the summary of the date objects list and with a specified column name:
Here we make an association of random images:
This summarizes the list of rules in the association:
We can summarize association’s keys and values separately using the option setting ThreadTrue:
A dataset does not have to have named columns:
Options
Options
In[]:=
MaxTallies
MaxTallies
NumberedColumns
NumberedColumns
By default the summarized columns (variables) are automatically numbered:
Thread
Thread
In[]:=
The option Thread is used to specify should the summarization be “threaded” if data to be summarized is an association or a list of rules.
Here is an association of 3D points:
Summarizing without threading:
Summarizing with threading:
Optionally column names can be added:
Applications
Applications
In[]:=
Summarize Classify-ready data
Summarize Classify-ready data
In[]:=
Here we summarize the Titanic data:
Here we summarize the Mushroom data:
Summaries browser
Summaries browser
In[]:=
If we have a set of datasets we can easily build an interactive interface that allows browsing of dataset summaries:
Possible Issues
Possible Issues
In[]:=
This fails because dataset cannot be converted to a full 2D array:
A work-around is to use HoldForm for the columns that are not vectors:
If the numerical columns have Quantity values those columns are treated as categorical:
This works though:
Neat Examples
Neat Examples
In[]:=
Summarize subsets of Titanic data that correspond to each passenger class: