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.5.tar.gz
(5.2 kB
view hashes)
Built Distribution
Close
Hashes for jsonflattifier-1.1.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bd7119fda76c2ed27f2eec9143768d9bd8b2722779648c8c02f8aeff51d843bb |
|
MD5 | 3a565b811cd4b0b3cc0edb1123ccebe3 |
|
BLAKE2b-256 | 71dde49acfd90a0a1522030c1d3da9dd72c502f0da97e0437266578332daeb0d |