Json to csv

[pramod]

Hi ,

I am changing json to csv.

As below,

Input: json = {'name':'aaa', 'no':1, 'result1':['a','b','c'],'result2':['d','e'],'result3':[]}

output: csv
name no result grade
aaa 1 result1 a,b,c
aaa 1 result2 d,e
aaa 1 result3

please suggest me how do we get the csv file from the above json.

[micseydel]

What have you tried? We'd love to help, but we're focused on helping people learn Python, not doing their work for them. Also, since this looks like homework I'm moving it to the homework section; please don't take it personally.

[pramod]

d3 = {'name':'aaa', 'no':1, 'result1':['a','b','c'],'result2':['d','e'],'result3':[]}

import csv

Doc = open('Desktop/doc.csv','w')
csvwriter = csv.writer(Doc)
count = 0
for d in d2:
if count == 0:
header = d2.keys()
csvwriter.writer(header)
count += 1
csvwriter.writerow(d2.values())
Doc.close()

Csv looks:
name no result1 result2 result3
aaa 1 [a,b,c] [d,e] []

We need to display below table.
name no result grade
aaa 1 result1 a,b,c
aaa 1 result2 d,e
aaa 1 result3

[pyzyx3qwerty]

Please use proper code tags while posting your code.

[anbu23]

d3 = {'name':'aaa', 'no':1, 'result1':['a','b','c'],'result2':['d','e'],'result3':[]}
print('name no result grade')
for d in d3.keys():
 if type(d3[d]) is list:
  print( d3['name'], d3['no'], d, ','.join(d3[d]))

[pramod]

Thank you. Updated the code. Still needs to add some of the implementation. Please feel free to post the solutions.

with open("C:/Temp/doc.csv","w") as s_doc:
  csvwriter = csv.writer(s_doc)
  header = ['name','no','result','grade']
  for d in d3.keys():
    if type(d3[d] is list:
     csvwriter.writerow([d3['name'],d3['no'],d,','.join(d3[d]))

[pramod]

[quote='pramod' pid='111294' dateline='1587428226']
d3 = {'name':'aaa', 'no':1, 'result1':['a','b','c'],'result2':['d','e'],'result3':[]}

import csv

Doc = open('Desktop/doc.csv','w')
csvwriter = csv.writer(Doc)
count = 0
for d in d2:
  if count == 0:
  header = d2.keys()
  csvwriter.writer(header)
  count += 1
  csvwriter.writerow(d2.values())
Doc.close()

Csv looks:
name no result1 result2 result3
aaa  1  [a,b,c]   [d,e]      []

We need to display below table.
name no result grade
aaa 1 result1  a,b,c
aaa 1 result2  d,e
aaa 1 result3
[/quote]

[python]

[/python]

[anbu23]

Thank you. Updated the code. Still needs to add some of the implementation. Please feel free to post the solutions.

with open("C:/Temp/doc.csv","w") as s_doc:
  csvwriter = csv.writer(s_doc)
  header = ['name','no','result','grade']
  for d in d3.keys():
    if type(d3[d] is list:
     csvwriter.writerow([d3['name'],d3['no'],d,','.join(d3[d]))

Dont you get expected output from the above code?

[pyzyx3qwerty]

d3 = {'name':'aaa', 'no':1, 'result1':['a','b','c'],'result2':['d','e'],'result3':[]}
print('name no result grade')
for d in d3.keys():
 if type(d3[d]) is list:
  print( d3['name'], d3['no'], d, ','.join(d3[d]))

@anbu23, are you aware you just gave a code in the homework section? Have you even read the guidelines? You aren't supposed to post code for others, you are supposed to help them in finishing the code by giving advice

[micseydel]

Have you even read the guidelines?

I tend to be a stickler for this, but anbu23 did wait until the OP posted an attempt. I would have at least explained the changes, even if I were giving an answer (which I personally am less likely to do). In any case, anbu23 you're OK here I think but please do be mindful.