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.4.tar.gz
(5.2 kB
view hashes)
Built Distribution
Close
Hashes for jsonflattifier-1.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 31a2442996687efa980009111d1dca3f14904c4f41db862e36032e19797b271e |
|
MD5 | 42d82d147aec980f9316ee43c5c750c3 |
|
BLAKE2b-256 | 6f0e315d0d17206558319dd352a67c2d651fdb8c2ee478e0e2160dbc43ced314 |