Converting data to a CSV file

Question

I'm bringing in data that is json.dumps'd to go through the MQTT broker. After I do a json.loads, I'm getting this data in return.

[['date here', '1713180'], ['date here', '1713181'], ['date here', '1713182'], ['date here', '1713183'], ['date here', '1713184']]

I've tried numerous other threads on csv writing, but I'm completely lost as to how to get this written properly to a CSV.

Possible duplicate of Saving zip list to csv in Python

Netwave
– Netwave

2019-04-22 14:33:48 +00:00
Commented Apr 22, 2019 at 14:33 — Netwave
– Netwave, Commented Apr 22, 2019 at 14:33

razimbres · Accepted Answer · 2019-04-22 14:31:20Z

1

Simply:

import pandas as pd
df=pd.DataFrame([['date here', '1713180'], ['date here', '1713181'], ['date here', '1713182'], ['date here', '1713183'], ['date here', '1713184']])
df.columns=['timestamp','data']
df.to_csv('test.csv',columns=['timestamp','data'],index=False)

answered Apr 22, 2019 at 14:31

razimbres

5,0855 gold badges29 silver badges55 bronze badges

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

Comments

shayelk · Accepted Answer · 2019-04-22 14:27:33Z

1

"You can use pandas:

if you don't have pandas installed run the following in order to install it:

pip install pandas

then, you can use:

import pandas as pd

data = [['date here', '1713180'], ['date here', '1713181'], ['date here', '1713182'], ['date here', '1713183'], ['date here', '1713184']]
df = pd.DataFrame(data)

df.to_csv("path/to/file.csv")

answered Apr 22, 2019 at 14:27

shayelk

1,6861 gold badge17 silver badges32 bronze badges

Collectives™ on Stack Overflow

Converting data to a CSV file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related