/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 vote213 views1 answer
Reverse a list using slice operator
Python
0 vote186 views1 answer
Change increment in for loop python
Python
0 vote187 views1 answer
Pydrive set parents
Python
0 vote201 views1 answer
Hide verbose in pip install
Python
1 vote205 views1 answer
Py file open with
Python
0 vote186 views1 answer
Vreverse all elemetns of a list in place python
Python
5 votes196 views2 answers
Python tabulate float format
Python
0 vote180 views1 answer
Matplotlib create histogram edge color
Python
-1 vote183 views3 answers
Download pdf file python
Python
0 vote180 views1 answer
% python nootation
Python