lib
libjson2csv
pypi i libjson2csv
lib

libjson2csv

Convert JSON file to CSV and CSV file to JSON.

by Nag Varun Chunduru

0.1.1 (see all)Categories:Vanilla Python CSV to JSON
pypi i libjson2csv
Readme

libjson2csv

Converts nested json object to csv and csv back to json

This package provides functionality to convert valid nested json objects/files to csv and vice versa.

Written in python 3

Usage

To convert json to csv

usage: python -m libjson2csv.json_2_csv [--m] <json_in_file_path> [<csv_out_file_path>]

To convert csv to json

usage: python -m libjson2csv.csv_2_json <csv_in_file_path> [<json_out_file_path>]

If the output file path is not provided the output will be dumped to STDOUT.

Specifications

Scripts expects a valid json.

  • JSON can be a valid nested object or a list.
  • Script will convert each item of the list to a corresponding row in the csv.
  • If JSON is dictionary the outputted csv will contain single row.

Example:

Converts JSON

    {
        "key_1_1": "val_1_1_1",
        "key_1_2": [
            "val_1_2_1",
            "val_1_2_2",
            "val_1_2_3"
        ],
        "key_1_3": [{
            "key_1_3_2_1": "val_1_3_2_1_1"
        }, {
            "key_1_3_2_1": "val_1_3_2_1_2"
        }, {
            "key_1_3_2_1": "val_1_3_2_1_3"
        }],
        "key_1_4": {
            "key_1_4_2_1": "val_1_4_2_1_1"
        },
        "key_1_5": {
            "key_1_5_2_1": [{
                "key_1_5_2_3_1": "val_1_5_2_3_1_1"
            }]
        }
    }

TO

Without --m flag

key_1_1key_1_2[0]key_1_2[1]key_1_2[2]key_1_3[0].key_1_3_2_1key_1_3[1].key_1_3_2_1key_1_3[2].key_1_3_2_1key_1_4.key_1_4_2_1key_1_5.key_1_5_2_1[0].key_1_5_2_3_1
val_1_1_1val_1_2_1val_1_2_2val_1_2_3val_1_3_2_1_1val_1_3_2_1_2val_1_3_2_1_3val_1_4_2_1_1val_1_5_2_3_1_1

With --m flag

*key_1_2key_1_1key_1_3[0].key_1_3_2_1key_1_3[1].key_1_3_2_1key_1_3[2].key_1_3_2_1key_1_4.key_1_4_2_1key_1_5.key_1_5_2_1[0].key_1_5_2_3_1
val_1_2_1;val_1_2_2;val_1_2_3val_1_1_1val_1_3_2_1_1val_1_3_2_1_2val_1_3_2_1_3val_1_4_2_1_1val_1_5_2_3_1_1

--m stores a simple list in a single column with items separated by a semicolon.

0.1.0 (2017-04-15)

- Initial version.

GitHub Stars

6

LAST COMMIT

5yrs ago

MAINTAINERS

1

CONTRIBUTORS

1

OPEN ISSUES

2

OPEN PRs

0
VersionTagPublished
0.1.1
5yrs ago
0.1.0
5yrs ago
0.0.10
5yrs ago
0.0.9
5yrs ago
No tutorials found
Add a tutorial

Rate & Review

100
No reviews found
Be the first to rate