Unpivoting Data with Excel, Open Refine and Python by Tariq Khokhar.
From the post:
“How can I unpivot or transpose my tabular data so that there’s only one record per row?”
I see this question a lot and I thought it was worth a quick Friday blog post.
Data often aren’t quite in the format that you want. We usually provide CSV / XLS access to our data in “pivoted” or “normalized” form so they look like this:
Manipulating data is at least as crucial a skill to authoring a topic map as being able to model data.
Here are some quick tips for your toolkit.