convert dictionary to csv in python without using pandas?

Question

I have dictionay list which looks like this:

{'match':['football','cricket','baseball'],'player':['2','11','8']}

I want to convert this dictionary into csv but without using pandas.

My code:

import csv
my_dictionary = {'match':['football','cricket','baseball'],'player'['2','11','8']}
with open('data.csv', 'w') as f:
    for key in my_dictionary.keys():
        f.write("%s, %s\n" % (key, my_dictionary[key]))

The output I would like to see:

match     player
football   2
cricket    11
baseball   8

Take a look at csv.DictWriter (and the other classes in that module too) — GPhilo
– GPhilo, Commented Mar 16, 2022 at 9:14
So what is your question? Also, please, fix the indentation of your code, as well the quotes in e.g. '11,'8'. — buran
– buran, Commented Mar 16, 2022 at 9:15
If you want to write line by line iterating over the keys doesn't make much sense. First, write the keys, then iterate over the two lists elements together zipping them. Please in the future avoid using "I want this and that" sentences, explain your problem, explain what you have tried but avoid sounding pretentious — tia.milani
– tia.milani, Commented Mar 16, 2022 at 9:17
Does this answer your question? Write dictionary of lists to a CSV file — Timus
– Timus, Commented Mar 16, 2022 at 9:44

JANO · Accepted Answer · 2022-03-16 09:22:39Z

0

So, if you want to use your technique, you can firstly write all keys into the first line as header and then iterate over the lists for the remaining rows like this:

import csv

my_dictionary = {'match':['football','cricket','baseball'],'player':['2','11','8']}
with open('data.csv', 'w') as f:
    
    headers = ', '.join(my_dictionary.keys()) + '\n'
    f.write(headers)
    
    for row in zip(*my_dictionary.values()):
        string_row = ', '.join(row) + '\n'
        f.write(string_row)

Output:

match, player
football, 2
cricket, 11
baseball, 8

answered Mar 16, 2022 at 9:22

JANO

3,0962 gold badges17 silver badges37 bronze badges

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

Comments

chitown88 · Accepted Answer · 2022-03-16 09:23:06Z

0

Use zip to combine those 2 lists ('match','player') into a list of tuples. Join each tuple with ,. Then simply write each of those to file.

import csv
my_dictionary = {'match':['football','cricket','baseball'],'player':['2','11','8']}
zipList = list(zip(my_dictionary['match'],my_dictionary['player']))
zipList = [','.join(x) for x in zipList]


with open('data.csv', 'w') as f:
    headers = ','.join(my_dictionary.keys()) + '\n'
    f.write(headers)
    for each in zipList:
        f.write("%s\n" % (each))

answered Mar 16, 2022 at 9:23

chitown88

29.1k6 gold badges34 silver badges67 bronze badges

Comments

Martin Evans · Accepted Answer · 2022-03-16 12:45:44Z

0

To avoid using Pandas, use the built in CSV library:

import csv
    
my_dictionary = {'match':['football','cricket','baseball'],'player':['2','11','8']}

with open('output.csv', 'w', newline='') as f_output:
    csv_output = csv.writer(f_output)
    csv_output.writerow(my_dictionary.keys())
    csv_output.writerows([*zip(*my_dictionary.values())])

This would produce output.csv containing:

match,player
football,2
cricket,11
baseball,8

Your dictionary keys give you the header, and if you use a standard *zip(*xxx) trick to transpose the entries you can write all the rows in one go.

answered Mar 16, 2022 at 12:45

Martin Evans

46.9k17 gold badges88 silver badges104 bronze badges

Collectives™ on Stack Overflow

convert dictionary to csv in python without using pandas?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related