/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

0 vote223 views1 answer
Python how to compress pytorch model
Python
4 votes266 views1 answer
Python django shell command
Python Django
0 vote210 views1 answer
Add prefix to names in directory python
Python
0 vote234 views6 answers
ORing two cv mat objects
Python
0 vote237 views1 answer
Inherit functions from other classes
Python
2 votes219 views1 answer
How to reapete the code in python
Python
4 votes214 views6 answers
If statement python
Python
-1 vote272 views2 answers
Python increment
Python
7 votes221 views2 answers
How to execute python script in another script
Python
0 vote247 views1 answer
Python read vcf file line by line
Python