import pandas as pd caozuo= 'D:/caozuo_train.csv'#文件目录 caozuosheet = pd.read_csv(caozuo,usecols=['UID','1'])#读取表的哪几列,列表里面是列名 jiaoyisheet=pd.read_csv(jiaoyi,usecols=['UID','1']) tagsheet2=pd.merge(caozuosheet,jiaoyisheet,left_on='UID',right_on='UID')#按照表1的什么列和表2的什么列匹配进行匹配,如UID相等进行连接。 print(tagsheet2)#dataFram格式
df = pd.DataFrame(data =tagsheet2)#将连接后的dataFram打印出来 df.columns =['UID','c','j']#修改表的列名 df.to_csv('D:/race/racedataset/tagsheet2.csv',index=0)#将表保存,并去掉行索引。