Question 109168 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

How do I turn a 2-column csv into a json list of the key/value pairs using python?

I have a csv like this:

key spanish
no no
yes is
why porque

I want to make it into a json like this:

{
   "no": "no",
   "yes": "si",
   "why": "porque"
}

All the examples I have found online create JSON’s kind of like this:

{
    "no": {
        "key": "no",
        "Spanish": "no"
    }
}

I would like to write a python script that will create the simple key/value pairs in a json file.

Tags:

2

Answers


  1. 0 
    import csv
import json

myDict = {}
with open('path/to/csv') as iFile:
 myCSV = csv.reader(iFile)
 for line in myCSV:
   k,v = line
   myDict[k] = v

myJSON = json.dumps(myDict)
    Login or Signup to reply.
  2. 0

    Load you csv to dataframe, then use this:

    df.set_index('key')['spanish'].to_json('path/to/jsonfile.json')

    Neatly save the dataframe in json format.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search