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
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 details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file jsonflattifier-1.1.6.tar.gz.
File metadata
- Download URL: jsonflattifier-1.1.6.tar.gz
- Upload date:
- Size: 5.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.0 requests-toolbelt/0.9.1 tqdm/4.47.0 CPython/3.7.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ccfd9f3641a10ed19c7fcffcd71dbfc88df2c1e17afbc611a12e704adaad671f
|
|
| MD5 |
d03ce1c24c23bca37a946a35d1a82212
|
|
| BLAKE2b-256 |
a105d899b135d351669912ad22b6b9a778ce6683d985e0adea7f96f4fba9fcba
|
File details
Details for the file jsonflattifier-1.1.6-py3-none-any.whl.
File metadata
- Download URL: jsonflattifier-1.1.6-py3-none-any.whl
- Upload date:
- Size: 7.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.0 requests-toolbelt/0.9.1 tqdm/4.47.0 CPython/3.7.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0b86eb623311975f75882998e2a7cecf8e4a19c75ec88fc99d5d535867ea2393
|
|
| MD5 |
fad45a9ab0c86fd3184dee7a83230641
|
|
| BLAKE2b-256 |
9fba80ad7a4658d33888ed9b37dd1ee6ba217980e81d02bf532d160048798f01
|