/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 vote173 views1 answer
Catch error data with except python
Python
7 votes194 views2 answers
Pandas profile
Python
0 vote175 views2 answers
Rotatelist in python
Python
2 votes170 views1 answer
Create an array string using for in python
Python
0 vote178 views1 answer
How to create new header of a dataframe in python
Python
2 votes173 views1 answer
Test_size
Python
6 votes185 views4 answers
Python show all columns
Python
7 votes172 views2 answers
Python euclidean algorithm
Python
0 vote183 views1 answer
Strftime python multiple formats
Python
16 votes172 views6 answers
Turtle
Python