Json to csv

# call csvkit (which is a Python tool) to convert json to csv:
# https://csvkit.readthedocs.io/en/latest/

in2csv data.json > data.csv

Convert json to csv

import pandas as pd
df = pd.read_json (r'input.json')
df.to_csv (r'output.csv', index = None)

Python convert json to csv

import json
import csv
 
with open('G:\Akhil\jsonoutput.json') as json_file:
    jsondata = json.load(json_file)
 
data_file = open('G:\Akhil\jsonoutput.csv', 'w', newline='')
csv_writer = csv.writer(data_file)
 
count = 0
for data in jsondata:
    if count == 0:
        header = data.keys()
        csv_writer.writerow(header)
        count += 1
    csv_writer.writerow(data.values())
 
data_file.close()

Source: geeksforgeeks.org

Csv to json

python -c "import csv,json;print json.dumps(list(csv.reader(open('csv_file.csv'))))"

-1

Source: wiki.python.org

Similar codes

0 vote154 views2 answers
Tar exclude directories from a File
Shell/Bash
0 vote168 views1 answer
The repository 'https://download.docker.com/linux/ubuntu bionic InRelease' is not signed.
Shell/Bash
0 vote156 views1 answer
Fatal: unable to access 'https://github.com/freenas/webui.git/': OpenSSL SSL_read: Connection was reset, errno 10054 code example
Shell/Bash
0 vote153 views2 answers
Git second commit
Shell/Bash
9 votes154 views2 answers
Check ram memory usage linux
Shell/Bash
71 votes157 views6 answers
Kill process at a port ubuntu
Shell/Bash
0 vote150 views1 answer
Ubuntu absolute path of file
Shell/Bash
2 votes157 views1 answer
Range of random numbers bash
Shell/Bash
34 votes168 views6 answers
Update cypress
Shell/Bash
0 vote158 views1 answer
Linux create user with homedir
Shell/Bash