Week #17 - datapak gem - work with tabular data packages (.csv files w/ datapackage.json) using SQLite (w/ ActiveRecord)
Let’s say you want to share your data with the world or use the data that others share with the world. How to get started? A pragmatic way is to use tabular data packages.What’s a tabular data package?
Tabular Data Package is a simple structure for publishing and sharing tabular data with the following key features:
- Data is stored in CSV (comma separated values) files
- Metadata about the dataset both general (e.g. title, author) and the specific data files (e.g. schema) is stored in a single JSON file named
datapackage.jsonwhich follows the Data Package format
(Source: Tabular Data Packages, Open Knowledge Foundation)
Here’s a minimal example of a tabular data package holding two