outer,inner,right,left都试过了,看着很简单的代码运行出来就是没有的出正确结果
import numpy as np import pandas as pd from pandas import DataFrame from pandas import Series tr = pd.read_csv("E:/Thesis/KDDCUP/analyse2/"+'trajectories'+".csv") we = pd.read_csv("E:/Thesis/KDDCUP/dataSets/training/weather"+".csv") #cw = pd.merge(tr,we,how="left",on=['date','hour']) cw = pd.merge(tr,we,how="left",on=['date','hour']) cw.to_csv("E:/Thesis/KDDCUP/analyse3/"+'trwe'+".csv")
列名出来了,数据没有,查看了,是一条数据也没合并过来