csvschemavalidation

csvschemavalidation

csvschemavalidation is an implementation of CSV Schema in Python.

This project is at Alpha version and still under heavy development.

Example

>>> from csvschemavalidation.checker import Validator
>>> # demo.csv:
... # id,name,value
... # 1,Ann,"5"
... # 2,Ben,"10"
... # 3,Tom,"14"
>>> schema = {
...     'fields': [
...         {
...             'name': 'value',
...             'type': 'number',
...             'multipleOf': 5
...         }
...     ]
... }
>>> v = Validator(csvfile='demo.csv', schema=schema)
>>> v.validate()

Traceback (most recent call last):
...
<ValidationError: 'Value 14.0 is not multiple of 5'; column name: value; row number: 3>

Note that the validator does not check if the CSV format fits the dialect defined in schema correctly. For example, if wrong delimiter present in schema, validator might read the whole line as one cell.

Installation

pip install csvschemavalidation

Requirements

Python 3.5 or above

TODO

• Documentation and Examples
• Optional header
• Decide whether to rely on Python's built-in int and float function to convert values
• Tests