import pandas as pd    
data = pd.read_excel('c:/users/用户/desktop/数据.xlsx')    
temp = [[name[0],name[1],len(group)] for name,group in data.groupby(['Origin','Destination'])]    
data_re = pd.DataFrame(temp,columns=['Origin','Destination','count'])