/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 vote239 views1 answer
Python os filename without extension
Python
0 vote133 views1 answer
Remove a columns in pandas
Python
0 vote131 views1 answer
How to know google index of a page using python
Python
0 vote208 views1 answer
How to change the size of datapoint in plot python
Python
0 vote133 views1 answer
Python array remove new element
Python
5 votes147 views2 answers
How to plot pie chart in python
Python
1 vote124 views2 answers
How to add numbers in python using for loop
Python
0 vote135 views2 answers
Torch.cat
Python
5 votes150 views3 answers
How to add images in hml while using flask
Python
0 vote143 views2 answers
Pandas fast way to view distribution by group
Python