/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 vote177 views1 answer
Valueerror: must have equal len keys and value when setting with an iterable
Python
82 votes170 views4 answers
Python object to json file
Python
0 vote204 views1 answer
Print python setencode
Python
0 vote163 views1 answer
How to put 2 code n 1 line in python
Python
0 vote185 views1 answer
Python_dsa
Python
1 vote166 views2 answers
Pandas read csv from url
Python
6 votes168 views4 answers
Print all elements in list python
Python
-1 vote169 views1 answer
Matrix python math
Python
0 vote189 views1 answer
Import models
Python
1 vote156 views1 answer
Django m2m .add
Python