pandas写入csv文件，追加列

import pandas as pd

#任意的多组列表
#a = [1,2,3]
#b = [4,5,6]

for i in range(10):
    a = [i,i,i]
    b = [i,i,i]
    #字典中的key值即为csv中列名
    dataframe = pd.DataFrame(`{'a_name':a,'b_name':b}`)

    #将DataFrame存储为csv,index表示是否显示行名，default=True
    dataframe.to_csv(f"test{i}.csv",index=False,mode='w',sep=',')

写

import pandas as pd

dataframe = pd.DataFrame({'url':["a","b","c"]})

dataframe.to_csv(f"aa.csv",index=False,mode='w',sep=',')
dataframe.to_csv(f"aa.csv",index=False,mode='a',sep=',') #追加

读

result = pd.read_csv('aa.csv')
for res in result.index.values:
    row = result.loc[res,result.columns.values].to_dict()
    print(row)

追加列

import pandas as pd

df1 = pd.read_csv('./data.csv')

df2 = pd.DataFrame({'c':['a','b','c']})
dataframe = df1.join(df2)
dataframe.to_csv('./data.csv',index=False,mode='w',sep=',')