/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

1 vote143 views1 answer
Model checkpoint keras
Python
10 votes172 views4 answers
Python webbrowser module
Python
0 vote143 views1 answer
Print red in python
Python
0 vote206 views1 answer
.defaultdict
Python
21 votes155 views6 answers
Set to List
Python
0 vote170 views1 answer
Same quotes in a quotes
Python
1 vote155 views1 answer
Python sort with comparator
Python
0 vote145 views1 answer
Place legend on location matplotlib
Python
54 votes293 views2 answers
How to run django requirement.txt
Python Django
0 vote149 views1 answer
Normal discord.py codes
Python