In[]:=
Basic Examples
Basic Examples
Summarize a vector of numbers:
In[]:=
Out[]=
1 column 1 | ||||||||||||
|
Summarize a matrix of strings and specify the column names:
In[]:=
sarr=Transpose[{RandomChoice[CharacterRange["A","Z"],20],RandomWord["CommonWords",20]}];[sarr,{"random letter","random word"}]
Out[]=
,
1 random letter | ||||||||||||||
|
2 random word | ||||||||||||||
|
Summarize a vector of numbers with missing values:
In[]:=
Out[]=
1 column 1 | ||||||||||||||
|
Summarize a full 2D array with numerical and categorical columns (numbers, strings, and symbols):
In[]:=
Block[{n=200},arr=Flatten/@Transpose[{RandomReal[{-10,10},{n,2}],MapAt[ToLowerCase,RandomChoice[CharacterRange["A","Z"],{n,2}],{All,2}],RandomChoice[{,,Γ},n]}]];
In[]:=
Out[]=
,
,
,
,
1 column 1 | ||||||||||||
|
2 column 2 | ||||||||||||
|
3 column 3 | ||||||||||||||
|
4 column 4 | ||||||||||||||
|
5 column 5 | ||||||
|
Summarize a dataset:
In[]:=
Out[]=
,
,
,
,
1 | ||||||||||||
|
2 | ||||||||||||
|
3 | ||||||||||||||
|
4 | ||||||||||||||
|
5 | ||||||
|
Summarize a dataset with column names:
In[]:=
ds=Dataset[arr][All,AssociationThread[{"num1","num2","char1","char2","symb"},#]&];
In[]:=
Out[]=
,
,
,
,
1 num1 | ||||||||||||
|
2 num2 | ||||||||||||
|
3 char1 | ||||||||||||||
|
4 char2 | ||||||||||||||
|
5 symb | ||||||
|
Summarize an association of vectors:
In[]:=
asc=AssociationThread[Range[10]Table[Append[RandomReal[1,2],RandomWord[]],10]];
In[]:=
Out[]=
,
,
1 column 1 | ||||||||||||
|
1 column 1 | ||||||||||||
|
2 column 2 | ||||||||||||
|
3 column 3 | ||||||||||||||
|
In[]:=
Scope
Scope
A larger number of categorical values can be seen using the option :
"MaxTallies"
In[]:=
Out[]=
,
,
,
,
1 num1 | ||||||||||||
|
2 num2 | ||||||||||||
|
3 char1 | ||||||||||||||||||||||||
|
4 char2 | ||||||||||||||||||||||||
|
5 symb | ||||||
|
The function works with missing values and summarizes them separately of the rest of the values in a column:
In[]:=
Out[]=
,
,
,
,
1 num1 | ||||||||||||
|
2 num2 | ||||||||||||||
|
3 char1 | ||||||||||||||||
|
4 char2 | ||||||||||||||
|
5 symb | ||||||
|
Here we make a list of date objects with missing values:
In[]:=
dateObjs=RandomSample[Join[DateObject/@DateRange[{2011,1,1},{2019,12,31},Quantity[3,"Months"]],Table[Missing[],{4}]]];
Here is the summary of the date objects list and with a specified column name:
In[]:=
Out[]=
1 date object | ||||||||||||||
|
Here we make an association of random images:
In[]:=
asc=AssociationThread[Range[40]RandomChoice[Table[RandomImage[4,{40,12}],5],40]];
This summarizes the list of rules in the association:
In[]:=
Out[]=
1 column 1 | ||||||||||||||
|
We can summarize association’s keys and values separately using the option setting ThreadTrue:
A dataset does not have to have named columns:
In[]:=
Options
Options
MaxTallies
MaxTallies
NumberedColumns
NumberedColumns
By default the summarized columns (variables) are automatically numbered:
In[]:=
Thread
Thread
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:
In[]:=
Applications
Applications
In[]:=
Summarize Classify-ready data
Summarize Classify-ready data
Here we summarize the Titanic data:
Here we summarize the Mushroom data:
In[]:=
Summaries browser
Summaries browser
If we have a set of datasets we can easily build an interactive interface that allows browsing of dataset summaries:
In[]:=
Possible Issues
Possible Issues
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:
In[]:=
Neat Examples
Neat Examples
Summarize subsets of Titanic data that correspond to each passenger class: