/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 vote237 views1 answer
No module named 'pygame' visual studio
Python
0 vote256 views1 answer
How to remove quasi constant column in pandas dataframe
Python
-3 votes234 views1 answer
Django socketio web chat example
Python
0 vote266 views1 answer
Matplotlib.pyplot imshow size
Python
1 vote241 views1 answer
Pyttsx3 language portugues
Python
1 vote221 views1 answer
Python random hex color
Python
17 votes239 views4 answers
Get ip address python
Python
0 vote291 views1 answer
Django force download file
Python
0 vote219 views1 answer
To text pandas
Python
0 vote192 views1 answer
Airindia
Python