/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 vote323 views1 answer
Intersection of dataframes based on column
Python
1 vote336 views1 answer
How to use arjun tool
Python
0 vote360 views1 answer
Compare input with list python
Python
1 vote338 views1 answer
Discord.py dm specific user
Python
0 vote326 views1 answer
Random point seeds within a cyircle python
Python
2 votes344 views1 answer
How to make exe from.py file
Python
0 vote353 views1 answer
Aiml python install
Python
3 votes352 views3 answers
Pandas merge two dataframes remove duplicates
Python
0 vote334 views1 answer
Pycharm writing issue
Python
0 vote377 views1 answer
Take screenshot of video python
Python