How to convert csv to json in python?

Question

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

Input

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

Output

{{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?

Input is not csv. Output is not valid json. Do you mean list of dictionary? [{A:”1”, B:”2”, C:”3”, D:”4”}, {A:”5”, B:”6”, C:”7”, D:”8”}] — falsetru
– falsetru, Commented Jul 3, 2016 at 12:48

falsetru · Accepted Answer · 2016-07-03 13:22:52Z

36

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)

edited Jul 3, 2016 at 13:22

answered Jul 3, 2016 at 12:49

falsetru

371k69 gold badges769 silver badges659 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

naren Over a year ago

i just tried that but it didn't work. output is as below [{"A,B,C,D": "1,2,3,4"}, {"A,B,C,D": "5,6,7,8"}, {}, {}]

falsetru Over a year ago

@naren, I tested before post this. It created a file test.json with [{"A": "1", "C": "3", "B": "2", "D": "4"}, {"A": "5", "C": "7", "B": "6", "D": "8"}] as a content.

naren Over a year ago

got it, thanq very much @falsetru , trust your guidence will make me excel in python

falsetru Over a year ago

@naren, Your input file mismatch with the input in the question.

alecxe Over a year ago

@falsetru aren't you reinventing the DictReader? Thanks.

|

Antony Fuentes · Accepted Answer · 2018-05-21 03:48:33Z

4

For those who like one-liners:

import csv
import json

json_data = [json.dumps(d) for d in csv.DictReader(open('file.csv'))]

Checkout this fiddle for a working example: https://pyfiddle.io/fiddle/5992b8f4-552f-4970-91b6-a52cdee16ebc/?i=true

answered May 21, 2018 at 3:48

Antony Fuentes

1,0539 silver badges15 bronze badges

1 Comment

karim Over a year ago

This approach makes my numeric value(int, float) of each key to string. Any way to fix this?

Moises Rezonzew · Accepted Answer · 2016-07-03 13:15:30Z

0

import csv
import json

# Constants to make everything easier
CSV_PATH = './csv.csv'
JSON_PATH = './json'

# Reads the file the same way that you did
csv_file = csv.DictReader(open(CSV_PATH, 'r'))

# Created a list and adds the rows to the list
json_list = []
for row in csv_file:
    json_list.append(row)

# Writes the json output to the file
file(JSON_PATH, 'w').write(json.dumps(json_list))

answered Jul 3, 2016 at 13:15

Moises Rezonzew

1756 bronze badges

Comments

davland7 · Accepted Answer · 2017-10-06 01:01:12Z

0

Convert CSV to Json Python

import csv
import urllib2

url = '<YOURCSVURL>'
response = urllib2.urlopen(url)
cr = csv.reader(response)

line = {}
data = []

for index, row in enumerate(cr):
    if index:
        for index, col in enumerate(row):
            line[name[index]] = col

        data.append(line.copy())
    else:
        name = row

print data

edited Oct 6, 2017 at 1:01

answered Oct 6, 2017 at 0:36

davland7

90610 silver badges12 bronze badges

Comments

Kenstars · Accepted Answer · 2018-12-10 11:22:16Z

-3

You can attempt it using this code :

def inputfunction(lists):
 tmpdict = {}
 for element_index in range(len(lists)):
     tmpdict[headers[elementindex]] = lists[element_index]
 return tmpdict

def run(filename):
 filelist = [eachline.split(',') for eachline in open(inputfile,'r')]
 headers = filelist[0]
 values = filelist[1:]
 finallist = []
 for lists in values:
     finallist.append(inputfunction(lists))
 return finallist

edited Dec 10, 2018 at 11:22

answered Jan 17, 2017 at 6:11

Kenstars

6604 silver badges11 bronze badges

2 Comments

martineau Over a year ago

The code in your answer isn't indented properly. Also, the return you have in that for loop at the end of the run() function will only allow the loop to execute one iteration.

Paras jain Over a year ago

1: Not properly indented. 2: You are just creating a dictionary of every list which is not a JSON format.3: You have to pass "headers" also an argument in your 'input function" 4: In the run function you have to change "filename "parameter to "inputfile" or vice-versa.

Collectives™ on Stack Overflow

How to convert csv to json in python?

5 Answers 5

8 Comments

1 Comment

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

8 Comments

1 Comment

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related