JSON to CSV in python separating letters instead of values with comma

Question

I have been trying to convert a JSON fie to CSV in python but the obtained csv is very vague with each letter being separated with comma rather than the word as a whole from the key - value pair. The code which I have tried and the obtained csv output are given below.

SAMPLE JSON FILE

"details":[
    {
         "name": "sreekumar, ananthu",
         "type": "faculty/academician",
         "personal": {
             "age": "28",
             "address":  [
                 {
                     "street": "xyz",
                     "city": "abc",
                 }
             ]
    }

SAMPLE CODE

import json
import csv
with open("json_data.json","r") as f:
    data = json.loads(f)
csv_file = open("csv_file.csv","w")
csv_writer = csv.writer(csv_file)

for details in data['detail'];
    for detail_key, detail_value in details.items():
        if detail_key == 'name':
            csv_writer.writerow(detail_value)
        if detail_key == 'personal':
            for personal_key, personal_value in detail_value.items():
            if personal_key == 'age'
                csv_writer.writerow(personal_value)
csv_file.close()

SAMPLE OUTPUT

s,r,e,e,k,u,m,a,ra,n,a,n,t,h,u,2,8

Answer 1

did you think of this?

https://getbootstrap.com/docs/3.3/components/#nav-dropdowns

but you can also use custom classes