write a list to csv python code example
Example 1: how to convert list into csv in python
import pandas as pd
list1 = [1,2,3,4,5]
df = pd.DataFrame(list1)
df.to_csv('filename.csv', index=False)
#index =false removes unnecessary indexing/numbering in the csv
Example 2: write a list into csv python
# Convert a list into rows for a column in csv
import csv
for_example = [1, 2, 3, 4, 5, 6]
with open('output.csv', 'w', newline='') as csv_1:
csv_out = csv.writer(csv_1)
csv_out.writerows([for_example[index]] for index in range(0, len(for_example)))