-
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?
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?
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?
Looks good! Yes you can mask out zeros. See this simple example.
You must be logged in to reply to this topic.