Converting .csv file into .json format in python

Question

I have collected data into a csv file and data looks like:

1)username;date;retweets;favorites;text;geo;mentions;hashtags;id;permalink
2)CFSharing;2017-05-27 01:59;0;0;"£5 million raised for Manchester bombing victims in just three days #love http:// crowdfunding.einnews.com/article/383427 730/5ppRHGKOfQkNtAFM?ref=rss&ecode=SQUvWbWCp_PWzTRB …";;;#love;"868255418203557888";https://twitter.com/CFSharing/status/868255418203557888
3)TracksuitDavid;2017-05-27 01:58;1;0;"Tony Blair has been eerily silent on the Manchester bombing . For one very good reason. https://www. thecanary.co/2017/05/26/ton y-blair-eerily-silent-manchester-bombing-one-good-reason/ … via @thecanarysays";;@thecanarysays;;"868254940548001792";https://twitter.com/TracksuitDavid/status/868254940548001792

The first row contains column names and rest of rows is the data.

How can I convert the data into json file which looks like:

{{username:CFSharing,date:2017-05-27 01:59,retweets:0,favorites:0,text:,geo:,mentions:,hashtags:,id:"868255418203557888",permalink:https://twitter.com/CFSharing/status/868255418203557888},
{username:TracksuitDavid,date:2017-05-27 01:58;1;0,retweets:,favorites:,text:"Tony Blair has been eerily silent on the Manchester bombing . For one very good reason. https://www. thecanary.co/2017/05/26/ton y-blair-eerily-silent-manchester-bombing-one-good-reason/ … via @thecanarysays",geo:,mentions:@thecanarysays,hashtags:,id:"868254940548001792",permalink:https://twitter.com/TracksuitDavid/status/868254940548001792}}

Note: The numbers 1), 2), 3) represents row numbers

Possible duplicate of Python CSV to JSON

Mathieu de Lorimier
– Mathieu de Lorimier

2017-09-25 17:54:53 +00:00
Commented Sep 25, 2017 at 17:54 — Mathieu de Lorimier
– Mathieu de Lorimier, Commented Sep 25, 2017 at 17:54
csv to json conversion.

wwii
– wwii

2017-09-25 18:02:04 +00:00
Commented Sep 25, 2017 at 18:02 — wwii
– wwii, Commented Sep 25, 2017 at 18:02

Martin Evans · Accepted Answer · 2017-10-06 10:39:57Z

1

This can be done using a Python csv.DictReader() as follows:

import csv
import json

with open('input.csv', 'rb') as f_input, open('output.json', 'w') as f_output:
    first = True

    for row in csv.DictReader(f_input, delimiter=';'):
        if first:
            f_output.write('{')
            first = False
        else:
            f_output.write(',\n')
        json.dump(row, f_output)

    f_output.write('}')

edited Oct 6, 2017 at 10:39

answered Sep 27, 2017 at 15:36

Martin Evans

46.9k17 gold badges88 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

Converting .csv file into .json format in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related