CSV (comma-separated values) is a popular file format for data. It is popular because it is very simple: CSV is text-based and any application that can open text files can read or write CSV. This makes it a good fit for digital preservation. We don’t know how many of the datasets in DataCite use CSV because the
format metadata attribute is not used much (this query gives you some examples), but we know that the number is big.
The CSV format has two important shortcomings: a) it is not clearly defined, and b) because of its simplicity it is almost impossible to add metadata describing the data in the CSV file. The closest thing we have to a CSV standard definition is RFC 4180, but that RFC clearly states that It does not specify an Internet standard of any kind.
If for some reason you think that the above sounds very similar to the situation with markdown, a simple format for text documents that until recently was not clearly defined and that provides no easy way to add metadata (such as author, title or date), then you are smarter than me, since I didn’t see the connection until Javier Rovegno commented on my personal blog last week. He proposes to use the YAML frontmatter spec for CSV files, and I think it is a brilliant idea.
YAML frontmatter is a popular way to add metadata to markdown files. YAML is a data serialization format that is very human-readable (in contrast to XML and to a lesser degree JSON). Frontmatter simply means to have the YAML section at the beginning of the document, e.g. the following, taken from the Pandoc documentation:
title: 'This is the title: it contains a colon'
- name: Author One
affiliation: University of Somewhere
- name: Author Two
affiliation: University of Nowhere
tags: [nothing, nothingness]
This is the abstract.
It consists of two paragraphs.
By adding a similar section to CSV files we can add arbitrary metadata, including longer text such as a file description. In other words, all the metadata required to submit a CSV to a data repository and obtain a DOI. This makes data submission even simpler than using a zip bundle as discussed in an earlier post, or using the DataUp tool, a Microsoft Excel add-in that is unfortunately no longer available.
Javier has picked
.csvy as file extension for this modified file format (I like
.ycsv a little bit better). I don’t think we need to define what metadata can go into the YAML frontmatter, because there a number of different use cases. The only exception would be a standardized way to describe the columns in the CSV file, e.g.:
- title: Purchase Date
- title: Item
- title: Amount (€)
The best alternative to using CSV in combination with YAML is JSON, but that format is probably less popular than CSV for the typical data scientist (I like JSON for nested data, which would be very painful in CSV). Most people generate a separate file for CSV metadata now, risking that the data and metadata are separated.
Many tools for reading CSV files – including Microsoft Excel and the