naren naren - 1 year ago 61
JSON Question

csv to json convertion with python

i'm very new to programming, have been learning python from past 3/4 weeks and
this is one of the assignment given.


A, B, C, D
1, 2, 3, 4
5, 6, 7, 8


{{A:”1”, B:”2”, C:”3”, D:”4”}, {A:”5”, B:”6”, C:”7”, D:”8”}}

i've been trying with the code as

import csv
import json

csvfile = open('test.csv','r')
jsonfile = open('test.json','w')

x = ("a","b","c","d")

reader = csv.DictReader(csvfile, x)
for row in reader:
json.dump(row, jsonfile)

The output for this code comes as below

{"a": "1", "null": ["5", "6", "7", "8", "9"], "c": "3", "b": "2", "d": "4"}

Can anyone help me on this.

Answer Source

Dump after processing whole rows.

import csv
import json

with open('test.csv') as f:
    reader = csv.DictReader(f)
    rows = list(reader)

with open('test.json', 'w') as f:
    json.dump(rows, f)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download