Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Building a year-over-year graph

Level 1
Building a year-over-year graph

I am currently looking at some data (CSV source) with some explanatory columns and columns named 2001_01 to 2015_08. Each row can be identified by a unique identifier (eg: FOO01). The data will have seasonal dependencies and so I am trying to analyze the data year over year.

What would be the proper dataiku way to do this?

For instance, I would like to be able to select one row, plot the data on the Y axis per year and use the months on the X axis per month.

Then, I'll compare data sets: say divide row FOO1 by BAR2 and plot it in the same manner.

What would be the most efficient way to do this?
0 Kudos
1 Reply
Dataiker Alumni

I would first reshape the data so that you have a column year and a column month. The Fold Multiple Columns processor might be helpful:

The data might even have been shaped like this before being transformed into columns 2001_01 to 2015_08.

Then it's straightforward to plot one column (year) agains another (month).
0 Kudos


Labels (2)
A banner prompting to get Dataiku