判断excel表A中的ip是否在另一excel表B的ip中；

作者：SereneMA
链接：https://www.nowcoder.com/discuss/286013
来源：牛客网

import IPy 
import pandas as pd
 
# no header
data = pd.read_excel('xxx/company_ip.xlsx',header=None)
# have header
#data = pd.read_excel('xxx/white_black.xlsx')
 
#1.Read the excel as row, separated by "," or "，"
data_list = []
for i in range(len(data)):
    li = str(data.iloc[i].tolist()[0])
    lis = li.split(',')
    l = lis[0].split('，')
    for j in range(len