writerow()函数
csv文件是一个行之间元素用逗号隔开,结尾的时候时用换行符隔开的一种格式。
往csv文件中输入的格式通常是列表、数组。如果输入的列表是一维的,那么就可以用writerow()函数写入。
代码如下:
1 2 3 4 5 6 7 8 | 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()函数
代码如下:
1 2 3 4 5 6 7 8 | 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()区别
1 | import csv |
writerow()
writerow()将一个列表全部写入csv的同一行。
1 | 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()将一个二维列表中的每一个列表写为一行。
1 2 3 4 | 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) |
结果:
总结
到此这篇关于python写入csv时writerow()和writerows()函数的文章就介绍到这了,更多相关python writerow()和writerows()函数内容请搜索IT俱乐部以前的文章或继续浏览下面的相关文章希望大家以后多多支持IT俱乐部!