Unexpected display of Dataset object

Question

I have a dataset on which I apply a GroupBy on the rows and columns. I expected the output to be a table with the first grouping on the vertical, and the second grouping on the horizontal. However, what I get is the first grouping on the vertical, and the second grouping also on the vertical, nested inside the first.
The following screenshot from the documentation shows what I expected.

The following screenshot from my notebook is what I got.

Could someone explain to me what I am doing wrong?

Ruben · Answer

I found a solution. Apparently there are two things here that Wolfram doesn't like.

Every cell should have a value
Column names should be strings

I had to fix both for the expected result to appear. Fixing one issue, but not the other, was not enough.
If anyone has an easier method to make this work I will gladly hear it.

Unexpected display of Dataset object

One Answer

Add your own answers!

Ask a Question