/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 vote282 views1 answer
How to convert a pandas series from int to float in python
Python
9 votes252 views2 answers
Python listen to keyboard input
Python
0 vote288 views1 answer
Python force realod
Python
36 votes251 views4 answers
Python sum
Python
-1 vote298 views2 answers
Model deployment with flask
Python Flask
0 vote285 views1 answer
How to check what version of pygame you have instaled
Python
0 vote282 views1 answer
Python tags
Python
3 votes270 views1 answer
How to create a label in tkinter python
Python
0 vote266 views1 answer
Python os.name mac
Python
1 vote255 views2 answers
SSL: CERTIFICATE_VERIFY_FAILED mongo atlas
Python