PyCSVSchema

PyCSVSchema is an implementation of CSV Schema in Python.

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

Example

>>>frompycsvschema.checkerimportValidator>>># 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 (mostrecentcalllast):
...
<ValidationError: 'Value 14.0 is not multiple of 5'; columnname: value; rownumber: 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 pycsvschema

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