specs icon indicating copy to clipboard operation
specs copied to clipboard
verified publisher icon frictionlessdata

Multi-line header rows

Open rufuspollock opened this issue 5 years ago • 1 comments

This has come up a few times now - including just now in https://github.com/frictionlessdata/forum/issues/41

I think the easiest would be to change header in csv dialect to be a number. This has advantage that current true and false values convert over to 0/1 quite nicely.

Related issues

  • Support ignoreRows for TabularResource https://github.com/frictionlessdata/specs/issues/344
  • Make the header row in the CSV optional https://github.com/frictionlessdata/specs/issues/326

Behavior

Tooling behaviour needs to utilize this.

Research

  • https://github.com/onyxfish/csvkit/issues/188 - csvkit supports --no-header now
  • Postgres COPY command as used in Redshift has "ignoreheader" as a number which is number of rows to skip: http://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html#copy-ignoreheader

rufuspollock avatar May 26 '20 11:05 rufuspollock

Examples of formats with multi-line header rows mentioned recently on Discord:

  • @jen-thomas : https://exchange-format.readthedocs.io/en/latest/
  • @roll : https://hxlstandard.org/

cpina avatar Aug 18 '20 09:08 cpina