Tidydata Maker

The small multiple line chart template I developed last year uses tidy data but we are used to seeing data in a wide format as it makes it quicker to grasp what’s going on.

We have been copying and pasting data around to rearrange it to fit the format needed for the template and a colleague asked whether I could make something to do this quickly.

And here it is, the tidy data maker.

I wanted to learn svelte as part of building this tool and use their REPL tool. Here is the svelte code.

To publish the tool. I downloaded the zip file, unzipped it in a new repo and turned on Github pages. The only thing to note is that svelte put links to the root rather than local so once you’ve changed that so it looks like this it works.

<link rel='stylesheet' href='./global.css'>
<link rel='stylesheet' href='./build/bundle.css'>
<script defer src='./build/bundle.js'></script>

Since publishing this tool, many people have pointed out that this functionality exists in Excel as unpivot which is something I didn’t know.