Frictionless Data Compatibility
The Open Data Blend Dataset API is compatible with version 1 of the following Frictionless Data specifications:
​Data Package​
​Data Resource​
​Table Schema​
It also incorporates the following Frictionless Data patterns:
​Data Package Catalogues​
​Compression of Resources​
​
This means there is a growing ecosystem of data tools that you can use to work with Open Data Blend Datasets.
​
The Frictionless Libraries simplify integrations with the Open Data Blend Data API from many languages including Python and R. More specifically, you can use the Data Package libraries to programmatically access our datasets and integrate them into your solutions.
An up-to-date list of the support libraries can be found here, along with documentation on how to use them. Each library varies slightly in its implementation, but the general concepts for working with a Data Package are the same.
​
The following examples demonstrate how you could use the Python library to interact with the Open Data Blend Dataset API. This is the most mature Frictionless library to date, and one that we recommend. The libraries for the other languages implement a similar method to load data packages and these are explained in each library's documentation.
​
Install the frictionless module.
pip install frictionless
Ensure that frictionless 4.0 or later is installed. Prior versions are not stable releases.
​
Import the Package submodule from the frictionless module.
from frictionless import Package
​
Loading the Open Data Blend Catalogue metadata.
catalogue = Package('https://packages.opendatablend.io/v1/open-data-blend-catalogue/datapackage.json')
​
Loading the catalogue metadata for an Open Data Blend Dataset.
dataset = catalogue.resources[0]
The resources property is an array of resources. In this context, 'resources' means 'datasets'. In the above example, we are referencing a dataset by its zero-based index position.
Note: The metadata for a dataset in the catalogue is a subset of its full metadata.
​
Getting the name of the dataset.
dataset_name = catalogue.resources[0].name
​
Getting the friendly name of the dataset.
dataset_name = catalogue.resources[0].title
​
Getting the description of the dataset.
dataset_description = catalogue.resources[0].description
​
Getting the endpoint of the dataset.
dataset_path = catalogue.resources[0].path
​
Loading Open Data Blend Dataset metadata.
dataset = Package('https://packages.opendatablend.io/v1/open-data-blend-anonymised-mot/datapackage.json')
​
Loading the metadata of a data file.
data_file = dataset.resources[0]
The resources property is an array of resources. In this context, 'resources' means 'data files'. In the above example, we are referencing a data file by its zero-based index position.
​
Getting the name of the data file.
data_file_name = dataset.resources[0].name
​
Getting the friendly name of the data file.
data_file_title = dataset.resources[0].title
​
Getting the description of the data file.
data_file_description = dataset.resources[0].description
​
Getting the table schema of the data file.
data_file_schema = dataset.resources[0].schema
​
Getting the download location of the data file.
data_file_path = dataset.resources[0].path
