adding list items into columns csv

Question

I have python list

['Abendgymnasium Wiesbaden', 'Brunhildenstraße 140', '65189', 'Wiesbaden', '+49611315138', '+49611314971', '[email protected]', 'http://www.ag-wi.de/']

I want them to be append in csv file like this

column 1: item 1 of list
coumn 2: item 2 of list
column 3: item 3 of list

It's always a good idea to post your question along with your code, so that other can help you more efficiently :) — Jatin Mehrotra, Apr 02 '21 at 07:47

score 0 · Accepted Answer · answered Apr 02 '21 at 07:41

Try this ( here I have used colum header as fields).There can be many other methods to achieve the same such as using NumPy or pandas library

import csv

#field names
fields = ['Name', 'Place', 'Number', 'Teplehone_Number'] # add more according to your data

# data rows of csv file
rows = [['Abendgymnasium Wiesbaden', 'Brunhildenstraße 140', '65189', 'Wiesbaden']] # add more according to your data

with open('output.csv', 'w') as f:

    # using csv.writer method from CSV package
    write = csv.writer(f)

    write.writerow(fields)
    write.writerows(rows)

adding list items into columns csv

1 Answers1