3
$\begingroup$
dataset=Dataset[{
<|"a"->1,"b"->"x","c"->{1}|>,
<|"a"->2,"b"->"y","c"->{2,3}|>,
<|"a"->3,"b"->"z","c"->{3}|>,
<|"a"->4,"b"->"x","c"->{4,5}|>,
<|"a"->5,"b"->"y","c"->{5,6,7}|>,
<|"a"->6,"b"->"z","c"->{}|>}]

Export["test.xls", 
Prepend[List @@@ Normal@dataset, Keys@Normal[dataset][[1]]]] like SemanticImport/SemanticExport

or a pivot table with column names and row names and a table_name in left corner.

titanic = ExampleData[{"Dataset", "Titanic"}]

titanic[GroupBy["sex"], GroupBy["class"], ratio, "survived"]

Are there some more stupid/better methods to do this?

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.