not in 两个列表

来源:互联网 发布:网络跳线和网线的区别 编辑:程序博客网 时间:2024/06/13 06:06
import pandas as pddf_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)