prepping data for scalar/heat-map plot

Welcome to our Forums Technical Support Getting Started prepping data for scalar/heat-map plot

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #7735
    jib
    Participant

      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:

      Screen Shot 2021-11-25 at 12.47.04 PM

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

      #7736
      tom lawton
      Participant

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

        #7737
        dgteam
        Moderator

          Exactly!  Here is a link to a help article:

          How to Flatten Data

          #7741
          jib
          Participant

            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:

            Screen Shot 2021-11-26 at 10.08.42 AM

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

            Screen Shot 2021-11-26 at 10.08.58 AM

             

            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?

            #7742
            jib
            Participant

              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:

              Screen Shot 2021-11-26 at 1.25.21 PM

               

              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?

              #7743
              dgteam
              Moderator

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

                mask-scalar

              Viewing 6 posts - 1 through 6 (of 6 total)
              • You must be logged in to reply to this topic.

              Welcome to our Forums Technical Support Getting Started prepping data for scalar/heat-map plot