JSON to CSV for Python

Question

I know there are many question to this but I am having trouble manipulating the data.

I have this list:

['2017-05-31,20:00:00,71.1,73,', '2017-05-31,20:05:00,71.1,72.7,', '2017-05-31,20:10:00,71.1,72.5,', '2017-05-31,20:15:00,71.1,72.4,']

I need to convert this JSON format to a CSV where the CSV looks like so.

If you have trouble with your code, why didn't you write a question that includes that code, and asks for help fixing it? Instead of writing a question that reads like: "please do my work for me"? Hint: read minimal reproducible example and meta.stackoverflow.com/questions/284236/… — GhostCat
– GhostCat, Commented Jul 3, 2017 at 13:58
So, what have you tried? Exactly what "trouble" did you have? — Daniel Roseman
– Daniel Roseman, Commented Jul 3, 2017 at 13:59
It looks like a list rather than JSON. Also what is the trouble? did you use the csv module? — Sidhin S Thomas
– Sidhin S Thomas, Commented Jul 3, 2017 at 14:01

phd · Accepted Answer · 2017-07-03 14:11:06Z

2

I'd suggest:

my_list = ['2017-05-31,20:00:00,71.1,73,', '2017-05-31,20:05:00,71.1,72.7,', '2017-05-31,20:10:00,71.1,72.5,', '2017-05-31,20:15:00,71.1,72.4,']
# create and open a file for writing
with open("my_file.csv", "w") as fout:
    # iterate through your list
    for element in my_list:
        # write your element in your file plus a \n to trigger a new line
        fout.write(element+"\n")

et voilà!

edited Jul 3, 2017 at 14:11

phd

97.2k14 gold badges165 silver badges223 bronze badges

answered Jul 3, 2017 at 14:00

Trolldejo

4661 gold badge7 silver badges20 bronze badges

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

Comments

Tilak Putta · Accepted Answer · 2017-07-03 14:07:18Z

1

import pandas as pd
result = []
for item in myList:
    row = item.split(',')
    result.append(row)
df = pd.DataFrame(result)
df.to_csv("myFile.csv", index = False)

answered Jul 3, 2017 at 14:07

Tilak Putta

7784 silver badges18 bronze badges

Collectives™ on Stack Overflow

JSON to CSV for Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related