import pandas as pd
df_fb = pd.read_excel("fb_title.xlsx" ,sheetname="Sheet1" ,encoding="gbk")
df_exist = pd.read_excel("category_data.xlsx" ,sheetname="category_data" ,encoding="gbk")
notin = []
for ebayno in df_fb.ebayno:
if ebayno not in df_exist.ebayno.values:
notin.append(ebayno)
df = pd.DataFrame(notin , columns=["ebayno"])
df.to_csv("notin.csv",index=False)
not in 两个列表
最新推荐文章于 2022-04-26 23:17:04 发布