prepping data for scalar/heat-map plot

[jibParticipant]

The manual states that data for a scalar plot is to be provided in three columns; x, y, amount. However, the output of my data pipeline provides the X-data in a single column but the Y-data in a set of rows each cell holding the amount value like this:

What is a quick way to restructure this in what DataGraph needs?

[tom lawtonParticipant]

I think what you’re looking for is Data> Flatten Columns – kaboom!

[dgteamModerator]

Exactly!  Here is a link to a help article:

How to Flatten Data

[jibParticipant]

Yeah, you’re right, I simplified the problem too much. This is what the data actually looks like (notice the 2 columns on the left:

and this is a crude heat map for this data created in Numbers:

 

I guess I can combine the two left columns into a new unique index, then flatten, create the heat map and somehow map one of its axis to the two column data labels?

[jibParticipant]

It seems the quickest way is to import the data in stages in a scratch project; each category by its own (the category is “parity” in my case), flatten, copy the relevant columns to the final and plot. Result so far looks like this:

 

Not too shabby.  A few more points to address the most pesky one is all those zeros – any way to mask these from showing?  Of course I can just remove them manually but where is the fun in that?

[dgteamModerator]

Looks good!  Yes you can mask out zeros.  See this simple example.

[Author]

Posts