python-csv文件的写入

将写入csv文件的数据转换为DataFrame类型,才能使用to_csv命令。

import csv
import numpy as np
import pandas as pd

array1 = [0,1,2,3]
array2 = [1,2,3,4]
array3 = [2,3,4,5]

# 将数组竖向拼接
arr = np.vstack((array1, array2, array3))
# 将数组类型(array)转换为DataFrame类型
columnss = ["a","b","c","d"]
df = pd.DataFrame(arr, columns=columnss)
# 写入csv文件,务必用“/”
df.to_csv("D:/xxx"+"/"+"sss.csv", index=False)

按照行写入。

with open("zzz.csv","w") as csvfile: 
    writer = csv.writer(csvfile)
    writer.writerow(columnss)
    writer.writerow(array1)
    writer.writerow(array2)
    writer.writerow(array3)
	csvfile.close()

版权声明:本文为weixin_45281629原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。