Transforming messy data to tidy data

Tidy data has the form:

  • Each variable forms a column.
  • Each observation forms a row.
  • Each observational unit forms a table.

We’ve written an article showing how you can use Easy Data Transform to convert ‘messy data’ into ‘tidy data’ to make it easier to analyze and use:

https://www.easydatatransform.com/tidy_data.html

2 Likes

Nice - sort of like E.F. Codd, translated to plain English.

1 Like

Codd is referenced in Wickham’s paper.

When the day settles down in a few more hours, I’m going to read that in more detail. I’m not a DBA but I am a fan of rational data structure.