How to create/parse an array list...from a csv list?

Question

I am confused on how to go about parsing an array list from a .csv file. The .csv file gives information on a daily basis, in this format:

{
       "a" : 1,
       "b" : 3,
       "d" : 10
},

The open bracket shows the new day of data, and the closing bracket followed by the comma ends the data (I have no way of changing how the .csv is generated). There are about 400 days worth of data, and each day has the same list items (a,b, and d). How would I go about parsing the .csv data into a readable list format in python? I would post example code, but I have no idea where to even start with this.

Thanks in advance!

Tyler, it very well could be, I am not sure on how the data is exported. I am using python to interpret the .csv that is generated in that format. — icehac
– icehac, Commented Feb 19, 2014 at 4:35
Are there commas between the a and b fields (e. g. is it {"a" : 1, "b": 3 or {"a" : 1 "b" : 3 as in your example)? — Sean Vieira
– Sean Vieira, Commented Feb 19, 2014 at 4:39
Sean, there are commas between the fields. I have updated the original question appropriately. — icehac
– icehac, Commented Feb 19, 2014 at 4:40

Sean Vieira · Accepted Answer · 2014-02-19 04:37:59Z

2

Your CSV file is almost certainly JSON. If it is, then Python has a json library you can import and use:

import json

with open('/path/to/your/file.csv', 'r') as file
    data = json.load(file)
    # do things with data here

answered Feb 19, 2014 at 4:37

Sean Vieira

161k34 gold badges321 silver badges297 bronze badges

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

1 Comment

icehac Over a year ago

Thank you, I was able to import it correctly following your code! A simple json.dumps(data) allows for the customization of arrays (via numpy) for those interested.

Puffin GDI · Accepted Answer · 2014-02-19 05:07:41Z

1

for parsing csv

import csv
a = ["1,2,3","4,5,6"]   # or a = "1,2,3\n4,5,6".split('\n')     
x = csv.reader(a)

print(list(x))
>>> [['1', '2', '3'], ['4', '5', '6']]

edited Feb 19, 2014 at 5:07

Puffin GDI

1,7125 gold badges27 silver badges37 bronze badges

answered Feb 19, 2014 at 4:39

Usman Nisar

3,09936 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to create/parse an array list...from a csv list?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related