export dictionary to csv file in python

Question

enter image description here

I am trying to export an output file as a CSV file.

I have 15 columns and 400 rows.

In my code, I stored data in the dictionary file, which means that I have one dictionary for each column.

So I want to get a CSV file which includes all dictionary in the same file.
I tried to use a (for) loop in order to do that, but it did not work.

What do you mean by 'one dictionary for each column' ? Each dictionary have one key for each row ? You can't use a list instead ? — Elio Maisonneuve
– Elio Maisonneuve, Commented May 28, 2018 at 9:36

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

use Pandas libray

let us Assume your dictionary is like this:

    my_dict = {'key1': '1', 'key2': 'b', 'key3': '123'}

To tackle your problem use :

    import pandas as pd

    (pd.DataFrame.from_dict(data=mydict, orient='columns')
    .to_csv('file_name.csv', header=False))

See Ivan Calderon's Answer for more information.!!

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 28, 2018 at 9:52

Yash Sheth

861 silver badge6 bronze badges

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

Comments

Hayat · Accepted Answer · 2018-05-28 10:04:37Z

0

Please Check the variable as per your need. This should work.

def WriteCsv(csvFileName, csvFieldNames,  row=None ):

    import csv
    import os 
    if row:
        if os.path.exists(csvFileName):

            f_handle = open(csvFileName, 'a')
            csvWriter = csv.DictWriter(f_handle, fieldnames=csvFieldNames)
        else:

            f_handle =  open(csvFileName, 'w+')
            csvWriter = csv.DictWriter(f_handle, fieldnames=csvFieldNames)
            csvWriter.writeheader()
        try:
            csvWriter.writerow(row)
        finally:
            f_handle.close()

for row in dict_data:
    WriteCsv(csvFileName="Names.csv",csvFieldNames=csv_columns,row=row)

edited May 28, 2018 at 10:04

answered May 28, 2018 at 9:59

Hayat

1,6494 gold badges22 silver badges32 bronze badges

Collectives™ on Stack Overflow

export dictionary to csv file in python

2 Answers 2

use Pandas libray

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

use Pandas libray

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related