Basic Examples
Basic Examples
In[]:=
ResetDataset conducts useful type deduction and provides attractive column headers for the data after type inference in determining the part of the original fails to capture all the regularities:
"y"
th
With{ds=Dataset[\[LeftAssociation]"x"\[LeftAssociation]"a"\[LeftAssociation]"c"9,"d"4\[RightAssociation],"b"\[LeftAssociation]"c"3,"d"4\[RightAssociation]\[RightAssociation],"y"\[LeftAssociation]"a"\[LeftAssociation]"c"8,"d"5\[RightAssociation],"b"\[LeftAssociation]"c"8,"d"5\[RightAssociation]\[RightAssociation]\[RightAssociation]]},ds["y"],
[ds["y"]]
In[]:=
Out[]=
Scope
Scope
In[]:=
Here the passengers on the Titanic are grouped according to sex and cabin class and then counted, but the original grouping fails to realize that the data is better presented in a “spread” format with row headers and column headers rather than in a narrow way:
titanic=ExampleData[{"Dataset","Titanic"}];
In[]:=
Module{beforeReset,afterReset},beforeReset=titanic[GroupBy[#sex&],GroupBy[#class&],Length,#survived&];afterReset=
[beforeReset];{Labeled[beforeReset,"before reset"],Labeled[afterReset,"after reset"]}
In[]:=
Out[]=
Properties and Relations
Properties and Relations
In[]:=
One can see that the internal representation of the data can change after ResetDataset, here being transformed from a struct in which the values are associations to an in which the values are structs:
With{ds=Dataset[\[LeftAssociation]"x"\[LeftAssociation]"a"\[LeftAssociation]"c"9,"d"4\[RightAssociation],"b"\[LeftAssociation]"c"3,"d"4\[RightAssociation]\[RightAssociation],"y"\[LeftAssociation]"a"\[LeftAssociation]"c"8,"d"5\[RightAssociation],"b"\[LeftAssociation]"c"8,"d"5\[RightAssociation]\[RightAssociation]\[RightAssociation]]},ColumnFramed@TreeForm[Dataset`GetType[ds["y"]],ImageSize500],Framed@TreeFormDataset`GetType
[ds["y"]],ImageSize500
In[]:=
Out[]=
Possible Issues
Possible Issues
In[]:=
Often ResetDataset does nothing, though it would not seem to do any harm:
With{d=Dataset[{3,4}]},d,
[d]
In[]:=
Out[]=
There are limits to what ResetDataset can do; it does not, for example sort the keys in a way that would produce a more attractive presentation: