4 ms·
Well, if you want to improve tabular data formats: 1. Add a version identifier / content-type on the first line! 2. Create a formal grammar for this CSV forma
by edejong 8y ago
Well, if you want to improve tabular data formats:
1. Add a version identifier / content-type on the first line!
2. Create a formal grammar for this CSV format
3. Specify preferred character-encoding
4. Provide some tooling (validation, CSV 1.1 => HTML, CSV => Excel)
5. Add the option to specify column type (string, int, date)
6. Specify ISO-8601 as the preferred date format
7. Allow 'reheading' the columns in the file itself. This is useful in streaming data.
8. Specify the format of the newlines.
- pishpash 8y agoOr how about include the parser with the file? That's self specifying.
- westurner 8y agoCSVW: CSV on the Web https://w3c.github.io/csvw/ https://w3c.github.io/csvw/ "CSV on the Web: A Primer" http://www.w3.org/TR/tabular-data-primer/ http://www.w3.org/TR/tabular-data-primer/ "Model for Tabular Data and Metadata on the Web" http://www.w3.org/TR/tabular-data-model/ http://www.w3.org/TR/tabular-data-model/ "Generating JSON from Tabular Data on the Web" (csv2json) http://www.w3.org/TR/csv2json/ http://www.w3.org/TR/csv2json/ "Generating RDF from Tabular Data on the Web" (csv2rdf) http://www.w3.org/TR/csv2rdf/ http://www.w3.org/TR/csv2rdf/ ... N. Allow authors to (1) specify how many header rows are metadata and (2) what each row is. For example: 7 metadata header rows: {column label, property URI [path], datatype URI, unit URI, accuracy, precision, significant figures} With URIs, we can merge, join, and concatenate data (when e.g. study control URIs for e.g. single/double/triple blinding/masking indicate that the https://schema.org/Dataset https://schema.org/Dataset meets meta-analysis inclusion criteria). "#LinkedReproducibility"; "#LinkedMetaAnalyses"
- hyperman1 8y agoYou just invented XML or JSON