columns with multiple values

I was wondering if I could get some guidance on whether CSVW supports CSV files where a column contains multiple values.

Some of you are probably familiar with the data curation tool OpenRefine [1]. While it is primarily oriented around tabular data, you can also load JSON and XML into it. Since these formats allow for one-to-many relationships, multiple values get split across multiple rows.

So for example if I load this JSON into OpenRefine:

  [
    {
      "title": "Moby Dick”,
      "subject": [
        "Whaling"
      ]
    },
    {
      "title": "The Prince and the Pauper”,
      "subject": [
        "Royalty",
        "Poverty"
      ]
    }
  ]

it exports as CSV that looks like this:

  Moby Dick,Whaling
  The Prince and the Pauper,Royalty
  ,Poverty

I see there has been some discussion on the Wiki of duplicating rows [2], but I wasn’t sure if this use case was addressed by the model and/or vocabulary at all.

Thanks for any guidance you can provide,

//Ed

[1] http://openrefine.org/
[2] http://www.w3.org/2013/csvw/wiki/CSV-LD#Representing_Multiple_Values

Received on Wednesday, 31 December 2014 12:34:16 UTC