/Python/Python list of dictionaries to excel

Python list of dictionaries to excel

from csv import DictWriter

players = [{'dailyWinners': 3, 'dailyFreePlayed': 2, 'user': 'Player1', 'bank': 0.06},
{'dailyWinners': 3, 'dailyFreePlayed': 2, 'user': 'Player2', 'bank': 4.0},
{'dailyWinners': 1, 'dailyFree': 2, 'user': 'Player3', 'bank': 3.1},            
{'dailyWinners': 3, 'dailyFree': 2, 'user': 'Player4', 'bank': 0.32}]

with open('spreadsheet.csv','w') as outfile:
    writer = DictWriter(outfile, ('dailyWinners','dailyFreePlayed','dailyFree','user','bank'))
    writer.writeheader()
    writer.writerows(players)

Source: stackoverflow.com

Similar codes

9 votes206 views2 answers
Lambda condition python
Python
71 votes222 views6 answers
Python ide online
Python
0 vote189 views1 answer
Find no of 1's in a binary number
Python
9 votes152 views3 answers
Can you compile python to an exe
Python
0 vote178 views1 answer
Figure in matplotlib
Python
0 vote175 views1 answer
Read excel file in computer
Python
0 vote189 views1 answer
Convert a text file data to dataframe in python without pandas
Python
1 vote203 views4 answers
How to test wifi speed py
Python
-1 vote211 views1 answer
Return an RDD with the keys of each tuple.
Python
10 votes166 views2 answers
How to use modulo in python
Python