Dictionary to CSV using Python with headers style

Question

For this same Stack Overflow question How do I output a list of dictionaries to an Excel sheet?.

For xlsx code by jossef-harush we can use this:

import xlsxwriter

# ...

def create_xlsx_file(file_path: str, headers: dict, items: list):
    with xlsxwriter.Workbook(file_path) as workbook:
        worksheet = workbook.add_worksheet()
        worksheet.write_row(row=0, col=0, data=headers.values())
        header_keys = list(headers.keys())
        for index, item in enumerate(items):
            row = map(lambda field_id: item.get(field_id, ''), header_keys)
            worksheet.write_row(row=index + 1, col=0, data=row)
headers = {
    'bank': 'Money in Bank',
    'dailyWinners': 'Daily Winners',
    'dailyFree': 'Daily Free',
    'user': 'User',
}

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}
]

create_xlsx_file("my xslx file.xlsx", headers, players)

For creating a CSV file, what are the changes I need to do in the above code?

Like create_csv_file("my csv file.csv", headers, players).

You can use csv.DictWriter docs.python.org/3/library/csv.html#csv.DictWriter — Gonzalo Odiard
– Gonzalo Odiard, Commented Sep 7, 2021 at 14:25

AKX · Accepted Answer · 2021-09-07 14:50:39Z

1

import csv

def create_csv_file(file_path, headers, items):
    with open(file_path, "wt") as f:
        dw = csv.DictWriter(f, headers.values(), extrasaction='ignore')
        dw.writeheader()
        for row in items:
            dw.writerow({headers.get(k): v for (k, v) in row.items()})

writes

Money in Bank,Daily Winners,Daily Free,User
0.06,3,,Player1
4.0,3,,Player2
3.1,1,2,Player3
0.32,3,2,Player4

Note that this will ignore any dict keys not in headers; in your case, the dailyFreePlayeds.

edited Sep 7, 2021 at 14:50

answered Sep 7, 2021 at 14:28

AKX

171k16 gold badges147 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Rahul Over a year ago

for row in players: for players can I use dynamic value

AKX Over a year ago

Sorry, typo. That was meant to be items.

Rahul Over a year ago

after running your code it's working fine but after every row new blank row coming inside csv file

AKX Over a year ago

That's not happening on my machine.

AKX Over a year ago

Open the file in a text editor, not Excel. Are there double blank rows there too? If not, that's an Excel issue.

|

Collectives™ on Stack Overflow

Dictionary to CSV using Python with headers style

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related