John Mount takes us through a common data wrangling problem:
In many data science projects we have the data, but it “is in the wrong format.” Fortunately re-formatting or reshaping data is a solved problem, with many different available tools.
For this note, I would like to show how to reshape data using the data algebra‘s cdata data reshaping tool. This should give you familiarity with a tool to use on your own data.
Click through for an example in Python. Mount and Nina Zumel also have an R package for cdata.