Converts a JSON Document with nested objects and their parameters to the JSON Document with Flat Denormalised Data.
Project description
jsonflattifier
Converts a JSON Document with nested objects and their parameters to the JSON Document with Flat Denormalised Data.
Installation
> pip install jsonflattifier
Input
{
"name": "John",
"has": [
"apple",
"peach"
]
}
Get flat JSON
> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}' --json --jsonpath-keys --no-table
[
{
"$['name']": "John",
"$['has'][0]": "apple"
},
{
"$['name']": "John",
"$['has'][1]": "peach"
}
]
Get CSV
> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}' --csv --no-table
['name'],['has']
John,apple
John,peach
Print Table
> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}'
['name'] | ['has'] |
---|---|
John | apple |
John | peach |
2 rows in set
More Examples
https://gitlab.com/v.grigoryevskiy/json-flattifier/-/tree/master/tests/data
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
jsonflattifier-1.1.6.tar.gz
(5.2 kB
view hashes)
Built Distribution
Close
Hashes for jsonflattifier-1.1.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0b86eb623311975f75882998e2a7cecf8e4a19c75ec88fc99d5d535867ea2393 |
|
MD5 | fad45a9ab0c86fd3184dee7a83230641 |
|
BLAKE2b-256 | 9fba80ad7a4658d33888ed9b37dd1ee6ba217980e81d02bf532d160048798f01 |