我是一名有帮助的助手,可以为您翻译以下内容:
我有两个数据集
一个数据集中有一个包含电子邮件地址列表的列:
DF1
Email
xxxx@abc.gov
xxxx@abc.gov
xxxx@abc.gov
xxxx@abc.gov
xxxx@abc.gov
2nd csv Dataframe2
Email
xxxx@abc.gov
xxxx@abc.gov
xxxx@abc.gov
xxxx@abc.gov
dddd@abc.com
dddd@abc.com
3333@abc.com
import pandas as pd
SansList = r'C:\\Sans compare\\SansList.csv'
AllUsers = r'C:\\Sans compare\\AllUser.csv'
## print Name column only and turn into data sets from CSV ##
df1 = pd.read_csv(SansList, usecols=[0])
df2 = pd.read_csv(AllUsers, usecols=[2])
**print(df1['Email'].isin(df2)==False)**
我希望得到的结果是,
Dataframe3
dddd@abc.com
dddd@abc.com
3333@abc.com
我不太确定如何修复我的数据集... :(