/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 vote195 views1 answer
Df max count syntax
Python
0 vote200 views1 answer
Print numbers from 1 to 100 in python
Python
1 vote207 views1 answer
Slicing strings in python
Python
0 vote198 views1 answer
Find no of 1's in a binary number
Python
1 vote188 views2 answers
Panda count how many values are less than n in a column
Python
1 vote203 views2 answers
Cv2 save video mp4
Python
0 vote194 views1 answer
Not want to assign all values of a collection of values in python
Python
6 votes209 views3 answers
Pdb step into
Python
0 vote196 views1 answer
Convert 1 to "one" python
Python
0 vote219 views1 answer
Python can you put try except in list comprehension
Python