/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 vote284 views1 answer
F-string expression part cannot include a backslash
Python
8 votes287 views6 answers
Pandas groupby
Python
0 vote304 views1 answer
How to compare values in dictionary with same key python
Python
0 vote276 views1 answer
Python - How to execute a program or call a system command?
Python
2 votes307 views6 answers
Boolean in python
Python
1 vote304 views1 answer
Python how to remove the title of the index from dataframe
Python
0 vote245 views3 answers
Fibonacci series in python using recursion
Python
0 vote306 views1 answer
How to get one record in django
Python Django
0 vote281 views1 answer
How to have framer read json timestamps
Python
0 vote268 views1 answer
In python, a list of characters is the same as a string.
Python