save from 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: python convert dat file to csv
import csv
with open("infile.dat") as infile, open("outfile.csv", "w") as outfile:
csv_writer = csv.writer(outfile)
prev = ''
csv_writer.writerow(['ID', 'PARENT_ID'])
for line in infile.read().splitlines():
csv_writer.writerow([line, prev])
prev = line