Json to csv

Simply transform a json to a csv

This tool helps you create a csv from a json. It creates csv's columns using json hierarchy and a separator delimiter. For instance if the delimiter is . and the json is like this:

{
    'team':{
        'captain':
        'defend':
        'str' :
    }
}

The csv column's will be

team_captain, team_defend, team_str

Up until now, ljson are handled. Jsons are handled if in the file indicated as input is in one of the following format:

• Json array with one element per line
• One json element in the first line

Installation

OS X, Linux & Windows:

pip install git+https://github.com/Besedo/json-to-csv

Usage example

usage: Create csv from multiple files containing one json per line.
       [-h] [--path_data_jsonperline PATH_DATA_JSONPERLINE] [--streaming]
       [--sep SEP] [--int_to_float] [--path_output PATH_OUTPUT]
       [--remove_null] [--is_json] [--flatten_list]

optional arguments:
  -h, --help            show this help message and exit
  --path_data_jsonperline PATH_DATA_JSONPERLINE
                        File or folder of files containing one json per line
  --streaming           Create the csv in a stream way instead of loading
                        every json in memory (default False)
  --sep SEP             Separator used to create columns' names
  --int_to_float        Cast int to float (default False)
  --path_output PATH_OUTPUT
                        Path output
  --remove_null         Remove null values (default False)
  --is_json             Indicate if input file is a json (default False)
  --flatten_list        If true, flatten list of objects (default False)

Please refer to here for examples.

Meta

Distributed under the Apache license v2.0. See LICENSE for more information.

https://github.com/Besedo/json-to-csv