用于计算MAC地址匹配数量
import pandas as pd
import numpy as np
import re
import os
path = 'D:\Personal\Downloads'
df1 = pd.read_csv(os.path.join(path,'1.csv'),skiprows = 7 ,encoding='gbk')
df2 = pd.read_csv(os.path.join(path,'2.csv'),header = None)
df2.rename(columns = {0:'MAC'},inplace= True)
df2['MAC'] = df2['MAC'].apply(lambda x: x.split()[0])
columns = df1.columns
def Mactostr(mac):
mac = mac.replace(':','')
return str(mac).upper()
for i in columns:
df1[i] = df1[i].apply(lambda x: x[1:])
df1['MAC地址'] = df1['MAC地址'].apply(lambda x: Mactoint(x))
a = list(df2['MAC'])
count = 0
for i in df1['MAC地址']:
if i in a:
count += 1
```