如果没安装csv和pandas的话  在python安装目录下的Scrpts 下执行

pip install csvpip install pandas

import csvimport pandas as pdstu1 = ['科比', 26]stu2 = ['小明', 23]#写入列名与值out= open('D:\Stu_csv.csv', 'a', newline='')csv_write = csv.writer(out, dialect='excel')csv_write.writerow(["name", "age"])   #写入列名csv_write.writerow(stu1)  csv_write.writerow(stu2)csv_write.writerows([stu2, stu1])   #写入多行print("write over")out.close()#读取csv文件# data = pd.read_csv("D:\Stu_csv.csv")# #print(data)                                #打印所有文件# print(data.head(5))                        #打印前5行# print(data.columns)                         #返回全部列名# print(data.shape)                           #f返回csv文件形状# print(data.loc[1:2])                        #打印第1到2行# data.loc[2:4, ['name', 'age']]       #打印行中特定列