Converting a CSV file to JSON in python

Question

So I'm trying to load in the data in csvfile, convert it to a list of dictionaries and then save the result as JSON to jsonfile. This is what I have right now. When I try to open and load the json file, I get a "ValueError: No JSON object could be decoded" I'd appreciate any tips!

def csv_to_json(csvfile, jsonfile):
    reader = csv.DictReader(csvfile.splitlines(), delimiter=' ', skipinitialspace=True,
                        fieldnames=['dept', 'code', 'section',
                                    'name', 'instructor', 'type','location])
    writer = csv.DictWriter(open(jsonfile,'wb'), fieldnames=reader.fieldnames)

Fujiao Liu · Accepted Answer · 2014-11-17 07:19:34Z

1

try this:

import json
import csv


def csv_to_json(csvfile, jsonfile):
    ''''''
    with open(csvfile, 'rb') as f:
       reader = csv.DictReader(f, delimiter=',', fieldnames=['head1', 'head2']) 
       open(jsonfile, 'w').write(json.dumps(list(reader)) # if your csv file is not very large

answered Nov 17, 2014 at 7:19

Fujiao Liu

2,2732 gold badges25 silver badges28 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:33:41Z

0

Remember JSON isn't the same that python objects/dictionaries, have a look to this answer
So, you must use json.dumps to encode it, and then json.loads to decode it back to a valid python dict

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Nov 17, 2014 at 6:10

xecgr

5,2033 gold badges22 silver badges28 bronze badges

Comments

Amanda · Accepted Answer · 2014-11-26 21:21:29Z

0

I wound up with this, to write arbitrary CSVs:

import json
import csv

def csv_to_json(csvfile, jsonfile):
    """
    Read a CSV file and output it as JSON. Assumes the csv has a header row.
    """
    with open(csvfile, 'rU') as f:
        reader = csv.DictReader(f)
        data_dict = []
        for row in reader:
            data_dict.append(row)
        print(len(data_dict))
        with open(jsonfile, 'w') as g:
            json.dump(data_dict, g)

answered Nov 26, 2014 at 21:21

Amanda

12.8k17 gold badges66 silver badges93 bronze badges

Collectives™ on Stack Overflow

Converting a CSV file to JSON in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related