import numpy as np
import pandas as pd
path = r'C:\Users\MSI-NB\Desktop\门架车流.xlsx'
sheet = pd.read_excel(path,'16-19',header=None).values
name1 = set(sheet[:,0])
name2 = set(sheet[:,3])
#提取公共的name
names = name1.intersection(name2)
print(names)



data1 = dict(zip(list(sheet[:,0]),list(sheet[:,1])))
data2 = dict(zip(list(sheet[:,3]),list(sheet[:,4])))
data1_total = []
data2_total = []
for name in names:
    if data1.get(name) != None and data2.get(name) != None:
        res = name + '\t' + str(int(data1.get(name))) + '\t' + name + '\t' + str(int(data2.get(name)))
        print(res)
#
# print(sum(data1_total))
# print(sum(data2_total))