/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 vote152 views1 answer
Picobot python
Python
5 votes147 views2 answers
Matplotlib python background color
Python
0 vote158 views2 answers
Pyspark parquet to dataframe
Python
15 votes164 views2 answers
How to run a python script
Python
0 vote144 views1 answer
Decode in django templates
Python
10 votes153 views2 answers
Python create file if not exists
Python
1 vote153 views1 answer
Python text to speech version 3
Python
1 vote203 views4 answers
Flask activ environment
Python Flask
2 votes181 views1 answer
How to install from url in python
Python
0 vote155 views1 answer
Merge two arrays python with three one
Python