下面是csv存储的一个小例子:
import csv
import psycopg2
list1 = ['1',2,3,4,5,6,7,8,9]
list2 = [['a'],'b','c','d','e','f','g','h','l','p']
#new_line 参数设置为空,可以规避空行问题
file_name = open("ps_save_csv_text.csv",'w',newline = "",encoding="utf-8")
writer = csv.writer(file_name)
#list(zip())函数可以将两个同维的一维数组转换为二维数组
file_datas = [data for data in list(zip(list1,list2))]
for filedata in file_datas:
writer.writerow(filedata)