Python--nested_json-to-normalized_csv

A python script that converts nested json to normalized csv

Description

The script helps convert nested json to a csv file -

• Normalizes the json
• Checks if a csv already exists
  • If not creates a new csv file
  • If yes, appends the new json data to existing csv columns without copying the header row again

How to run this script

• Create a virtual environmennt
• Install all dependecies from the requiremnts.txt file
• Follow the steps below -

Terminal:

YOURCOMPUTER:Python--json-to-normalized_csv user$ python3 -m venv venv
YOURCOMPUTER:Python--json-to-normalized_csv user$ source venv/bin/activate
(venv) YOURCOMPUTER:Python--json-to-normalized_csv user$ pip3 install -r requirements.txt
(venv) YOURCOMPUTER:Python--json-to-normalized_csv user$ python3 json_normalized-csv_converter.py

Example:

Input:

{
  "name":"John",
  "age":30,
  "cars": {
    "car1":"Ford",
    "car2":"BMW",
    "car3":"Fiat"
  }
}

Output:

name	age	cars.car1	cars.car2	cars.car3
John	30	Ford	BMW	Fiat