/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 vote332 views1 answer
Apyori
Python
4 votes280 views1 answer
Python separate string in groups based on delimiter
Python
0 vote356 views1 answer
Django serializer exclude fields
Python
0 vote288 views1 answer
Django python base 64 encode
Python
1 vote294 views1 answer
Python sorted dictionary multiple keys
Python
0 vote291 views1 answer
Python regex inside quotes
Python
0 vote280 views4 answers
Pip django graphql
Python
2 votes315 views4 answers
Pandas difference between two dataframes
Python
1 vote313 views3 answers
Rgb to grayscale python
Python
3 votes281 views1 answer
Iteration
Python