csvw 1.4.0

No project description provided

csvw

CSV on the Web

Links

• GitHub: https://github.com/cldf/csvw
• PyPI: https://pypi.org/project/csvw
• Issue Tracker: https://github.com/cldf/csvw/issues

Installation

This package runs under Python 2.7, and 3.4+, use pip to install:

$ pip install csvw

Example

>>> import csvw
>>> tg = csvw.TableGroup.from_file('tests/csv.txt-metadata.json')

>>> tg.check_referential_integrity()
>>> assert len(tg.tables) == 1

>>> assert tg.tables[0] is tg.tabledict['csv.txt']
>>> tg.tables[0].check_primary_key()

>>> from collections import OrderedDict
>>> row = next(tg.tables[0].iterdicts())
>>> assert row == OrderedDict([('ID', 'first'), ('_col.2', 'line')])

>>> assert len(list(tg.tables[0].iterdicts())) == 2

Known limitations

• We read all data which is specified as UTF-8 encoded using the utf-8-sig codecs. Thus, if such data starts with U+FEFF this will be interpreted as BOM and skipped.
• Low level CSV parsing is delegated to the csv module in Python's standard library. Thus, if a commentPrefix is specified in a Dialect instance, this will lead to skipping rows where the first value starts with commentPrefix, even if the value was quoted.

See also

• https://www.w3.org/2013/csvw/wiki/Main_Page
• https://github.com/CLARIAH/COW
• https://github.com/CLARIAH/ruminator
• https://github.com/bloomberg/pycsvw
• https://github.com/frictionlessdata/goodtables-py
• https://github.com/frictionlessdata/tableschema-py
• https://github.com/theodi/csvlint.rb
• https://github.com/ruby-rdf/rdf-tabular
• https://github.com/rdf-ext/rdf-parser-csvw

License

This package is distributed under the Apache 2.0 license.