Export list to csv file using pandas python

Question

I am trying to export a list that is like that

    [{'Header1': 'Ahmed', 'Notes': 11.96},
 {'Header1': 'Salah', 'Notes': 16.13},
 {'Header1': 'Reda', 'Notes': 20.83}]

I could use csv module like that

with open('Output.csv', 'w', encoding='utf8', newline='') as f:
fc = csv.DictWriter(f, fieldnames=results[0].keys(),)
fc.writeheader()
fc.writerows(results)

and that worked fine How can I use pandas for that purpose?

jezrael · Accepted Answer · 2021-03-12 12:11:11Z

1

Create DataFrame by constructor and then use DataFrame.to_csv:

L =   [{'Header1': 'Ahmed', 'Notes': 11.96},
       {'Header1': 'Salah', 'Notes': 16.13},
       {'Header1': 'Reda', 'Notes': 20.83}]

 df = pd.DataFrame(L)

 df.to_csv('Output.csv', index=False)

edited Mar 12, 2021 at 12:11

answered Mar 12, 2021 at 12:09

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

YasserKhalil Over a year ago

Amazing. I expect you to reply to my question. Thank you very much.

YasserKhalil Over a year ago

Which is better using pandas or csv module?

jezrael Over a year ago

@YasserKhalil - It is really complex question, it depends. If need only write data and no processing, I choose csv module. If need processing data I choose pandas.

Collectives™ on Stack Overflow

Export list to csv file using pandas python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related