4 ms·
> On GOV.UK alone, we found 31,121 files with spreadsheet extensions (like .ods, .xlsx or .xls) and 19,251 CSV files, many of which were not in the suggested ti
by scottlamb 7y ago
> On GOV.UK alone, we found 31,121 files with spreadsheet extensions (like .ods, .xlsx or .xls) and 19,251 CSV files, many of which were not in the suggested tidy, tabular data format.
Ugh. The linked wikipedia page [1] is bizarre. The "wide table" form is far more practical than the "one possible tidy version": if you want to actually compute something for each maker based on observations, you can do so easily. And they don't describe at all why one might think the "one possible tidy version" is superior. No wonder many of these files are not in the suggested format; it's stupid.
[1] https://en.wikipedia.org/w/index.php?title=Tidy_data&oldid=903920411 https://en.wikipedia.org/w/index.php?title=Tidy_data&oldid=9...