Python 用pandas写入csv文件举例

 用pandas写入csv文件举例

 import pandas as pd
import numpy as np

pd.set_option('display.unicode.ambiguous_as_wide', True)
pd.set_option('display.unicode.east_asian_width', True)
with open('dataframe.csv', 'w', encoding='utf-8', newline='') as csvfile:None
rand=np.random.default_rng()
xing = '赵钱孙李周吴郑王冯陈褚卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜'
boy = "澄邈、德泽、海超、海阳、海荣、海逸、海昌、瀚钰、弘文、烨伟、苑博、鹏涛、炎彬、燃烧、鹤轩、伟泽、君昊、熠彤、鸿煊、博涛、苑杰、黎昕、烨霖、哲瀚、雨泽"
girl = '恨桃、依秋、依波、香巧、紫萱、涵易、忆之、幻巧、黎昕、烨霖、哲瀚、雨泽、楷瑞、建辉、致远、鸿恩、希文、希诚、希武、玄华、玄晋'
boy = boy.split(sep='、')
girl = girl.split(sep='、')
nei=[]
for i in range(5):
    boy_name=xing[rand.integers(len(xing))]+boy[rand.integers(len(boy))]
    girl_name=xing[rand.integers(len(xing))]+girl[rand.integers(len(girl))]
    pythons =rand.integers(50, 90)
    nei.append([boy_name,'男',pythons])
    nei.append([girl_name,'女',pythons])
rand.shuffle(nei)
datafile=pd.DataFrame(nei,columns=['name','gender','python'])
count=[]
for i in range(1001,1001+len(datafile.index)):
    count.append(i)
datafile.index=count
df=datafile.to_csv('D:\PYtext\dailytest\date11_23\dataframe.csv')
rf=pd.read_csv('D:\PYtext\dailytest\date11_23\dataframe.csv',index_col=0,header=0)
print(rf.head(5))

效果如下：