目录
writerow()函数
csv文件是一个行之间元素用逗号隔开,结尾的时候时用换行符隔开的一种格式。
往csv文件中输入的格式通常是列表、数组。如果输入的列表是一维的,那么就可以用writerow()函数写入。
代码如下:
import random import csv data_csvs=[random.randint(0,9) for i in range(5)] # 写入csv文件 with open('1.csv', 'w', newline='\n') as f: writer = csv.writer(f) writer.writerow(data_csvs)
输出结果显示为:
writerows()函数
代码如下:
import random import csv data_csvs=[[random.randint(0,9) for i in range(5)]for j in range(5)] # 写入csv文件 with open('1.csv', 'w', newline='\n') as f: writer = csv.writer(f) writer.writerows(data_csvs)
输出结果显示为:
补充:Python csv的writerow()和writerows()区别
import csv
writerow()
writerow()将一个列表全部写入csv的同一行。
csv_list = [1,2,3,4] with open("/Users/apple/Downloads/test.csv","w",encoding="UTF-8",newline="") as csvfile: writer = csv.writer(csvfile) writer.writerow(csv_list)
结果:
writerows()
writerows()将一个二维列表中的每一个列表写为一行。
csv_list = [[1],[2],[3],[4]] with open("/Users/apple/Downloads/test.csv","w",encoding="UTF-8",newline="") as csvfile: writer = csv.writer(csvfile) writer.writerows(csv_list)
结果: