Socket
Socket
Sign inDemoInstall

libjson2csv

Package Overview
Dependencies
0
Maintainers
1
Alerts
File Explorer

Install Socket

Detect and block malicious and high-risk dependencies

Install

libjson2csv

Converts nested json object to csv and csv back to json

    0.1.1

Maintainers
1

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.

Keywords

FAQs


Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc