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.

Please provide a [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) — rst-2cv, May 28 '18 at 09:27
give [DictWriter](https://docs.python.org/2/library/csv.html#csv.DictWriter) a read — akshat, May 28 '18 at 09:30
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, May 28 '18 at 09:36

score 1 · Answer 1 · edited Jun 20 '20 at 09:12

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 '20 at 09:12

Community

1
1

answered May 28 '18 at 09:52

Yash Sheth

76
1
6

Hayat · Answer 2 · 2018-05-28T10:04:37.480

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)

export dictionary to csv file in python

2 Answers2

use Pandas libray