On the last community call on July 28th, we heard David Raznick (an ex OKFer, now working at Open Data Services (opens new window)) presenting Flatterer, a tool he developed to convert structured JSON data into tabular data, using Frictionless Data specifications.
David has been working with many different open data standards functioning with deeply nested JSON. To make the data in standard formats more human readable, users often flatten JSON files with flattening tools, but the result they get are very large spreadsheets, which can be difficult to work with.
Flattening tools are also often used to unflatten tabular data in JSON. That way, the data, initially written in a more human readable format, can then be used according to the standards. Unfortunately the result is not optimal, the output of flattening tools is often not user-friendly and the user would probably still need to tweak it by hand, for example modifying headers’ names and/or the way tables are joined together.
Flatterer aims at making these processes easier and faster. It can convert in the blink of an eye your JSON file in the tabular format of your choice: csv, xlsx, parquet, postgres and sqlite. Flatterer will convert your JSON file into a main table, with keys to link one-to-many tables to their parents. That way the data is tidy and easier to work with.
If you are interested in knowing more about Flatterer, have a look at David’s presentation and demo:
You can also read more about the project here: https://flatterer.opendata.coop/ (opens new window), or have a look at the project documentation (opens new window).
# Join us next month!
Next community call is on August 25th. Frictionless Data developer Shashi Gharti will discuss with the community a tool she would like to add to the Frictionless Framework. Stay tuned to know more!
You can sign up for the call already here (opens new window).
Do you want to share something with the community? Let us know when you sign up.
Would you like to present at one of the next community calls? Please fill out this form (opens new window).
# Call Recording
On a final note, here is the recording of the full call: