python3 read data from csv file and covert it into json

Question

this is my code covert json into csv.

import csv
import json
with open('Documents/SampleCSVStory.csv', 'r') as f:
    reader = csv.reader(f, delimiter=';')
    data_list = list()
    for row in reader:
        data_list.append(row)
data = [dict(zip(data_list[0],row)) for row in data_list]
data.pop(0)
s = json.dumps(data)
print (s)

but the output coming like this

[{"Id,Name,Description": "1,User 1,Python Developer"}

my expectation is

[{"Id:"1",Name:"User 1",Description:"Python Developer"}

can anyone helping me in this please.?

kaidokuuppa · Accepted Answer · 2017-11-10 10:21:57Z

1

import csv
import json

with open('Documents/SampleCSVStory.csv', 'r') as f:
    reader = csv.DictReader(f, delimiter=';')
json.dumps([row for row in reader])

answered Nov 10, 2017 at 10:21

kaidokuuppa

6424 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

python3 read data from csv file and covert it into json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related