Skip to main content

Convert json array data to csv.

Project description

Convert json array data to csv.

Install

pip install zencore-json2csv

Usage

E:\>json2csv --help
Usage: json2csv [OPTIONS]

Options:
-f, --file FILENAME     Input file name, use - for stdin.
--file-encoding TEXT    Input file encoding.
-o, --output FILENAME   Output file name, use - for stdout.
--output-encoding TEXT  Output file encoding.
-k, --keys TEXT         Output field names. Comma separated string list.
-p, --path TEXT         Path of the data.
--help                  Show this message and exit.

Example 1

INPUT:

[
    [1,2,3],
    [2,3,4]
]

OUTPUT:

1,2,3
2,3,4

COMMAND:

cat input.txt | json2csv -o output.txt

Example 2

INPUT:

[
    {"f1": 11, "f2": 12, "f3": 13},
    {"f1": 21, "f3": 23, "f2": 22}
]

OUTPUT:

11,12,13
21,22,23

COMMAND:

cat input.txt | json2csv -o output.txt -k f1,f2,f3

Example 3

INPUT:

{
    "data": {
        "list": [
            [1,2,3],
            [2,3,4],
        ]
    }
}

OUTPUT:

1,2,3
2,3,4

COMMAND:

cat input.txt | json2csv -o output.txt -p data.list

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
zencore-json2csv-0.1.1.tar.gz (2.7 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page