CSV string to JSON in Python

Question

Im retrieving a report from the google adwords api as string which contains csv (using downloadReportAsString). I want to convert this to JSON, only all the converters expect a csv file type but mine is currently a string. How do I get the string to csv file? I read something about stringIO. I'm using python 3

Unclear what format of JSON you want. Please give example

OneCricketeer
– OneCricketeer

2017-06-09 16:25:01 +00:00
Commented Jun 9, 2017 at 16:25 — OneCricketeer
– OneCricketeer, Commented Jun 9, 2017 at 16:25

Brobin · Accepted Answer · 2017-06-09 16:22:54Z

13

By using io.StringIO you can use the normal csv readers and then dump it out to json.

>>> import csv, io, json
>>> 
>>> string = """a,b,c
... 1,2,3
... 4,5,6
... """
>>> 
>>> reader = csv.DictReader(io.StringIO(string))
>>> 
>>> json_data = json.dumps(list(reader))
>>> json_data
'[{"a": "1", "b": "2", "c": "3"}, {"a": "4", "b": "5", "c": "6"}]'

answered Jun 9, 2017 at 16:22

Brobin

3,3362 gold badges21 silver badges35 bronze badges

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

3 Comments

Brobin Over a year ago

I actually didn't take it right from there. I guess abc123 is common test data. Thanks for linking though! That answer also has a bit better explanation.

OneCricketeer Over a year ago

Also: CSV to JSON

eduardosufan Over a year ago

json_data is a string. How can be obtained as a Python dictionary?

Collectives™ on Stack Overflow

CSV string to JSON in Python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related