Taking a list of dictionaries and writing it to a file in CSV form

Help and Support
#1

Can someone explain this piece of code? I am not sure i understand this well:

def write_csv(items, path):
# Open the file in write mode
with open(path, ‘w’) as f:
# Return if there’s nothing to write
if len(items) == 0:
return

    # Write the headers in the first line
    headers = list(items[0].keys())
    f.write(','.join(headers) + '\n')
    
    # Write one item per line
    for item in items:
        values = []
        for header in headers:
            values.append(str(item.get(header, "")))
        f.write(','.join(values) + "\n")
1 Like
#2

Can you give an example of the dictionary that needs to be written in the file?
Any reference link would also be helpful…like where did you find this?

def write_csv(items, path):
    # Open the file in write mode
    with open(path, 'w') as f:
        # Return if there’s nothing to write
        if len(items) == 0:
            return

        # Write the headers in the first line
        headers = list(items[0].keys())
        f.write(','.join(headers) + '\n')
    
        # Write one item per line
        for item in items:
            values = []
            for header in headers:
                values.append(str(item.get(header, "")))
            f.write(','.join(values) + "\n")