GoodTables

GoodTables is a tool to validate tabular data, for use on the command line and as a Python library. It can check the structure of your data (e.g. all rows have the same number of columns), and its contents (e.g. all dates are valid). Internally, it uses the Data Quality Spec for common tabular data errors, and it is completely customizable with an API for creating custom checks. GoodTables also supports data described by Data Package and Table Schema.

Work with data often involves ensuring that data is interoperable between different systems. Key to interoperability are assurances as to what the data looks like, and conformation that a payload conforms to these expectations. That is exactly the role that GoodTables plays - ensuring your data exactly matches your expectations, and giving helpful, specific insight into where and how it does not.

GoodTables is part of Frictionless Data, a project funded and maintained by the Open Knowledge Foundation and Datopian.

Affordances in data work with goodtables

• Data quality
• Data interoperability
• Actionable reports

# Check it out

• Get the code

# Where it is used

GoodTables is a useful solution when building data pipelines, and particularly for data that goes through human and machine processing.

# A simple example

In Python

import goodtables
report = goodtables.validate('invalid.csv')

Also as a CLI

$ goodtables data.csv