我试图遍历三个数据框以发现它们之间的差异。我有一个包含所有内容的主数据框架,还有两个包含其他部分主数据框架的数据框架。我正在尝试编写python代码来识别其他两个文件中缺少的内容。主文件如下所示:

ID  Name
1   Mike
2   Dani
3   Scott
4   Josh
5   Nate
6   Sandy


第二个数据帧如下所示:

ID  Name
1   Mike
2   Dani
3   Scott
6   Sandy


第三个数据帧如下所示:

ID  Name
1   Mike
2   Dani
3   Scott
4   Josh
5   Nate


这样就会有两个输出数据帧。所需的输出看起来像下面的第二个数据帧:

ID  Name
4   Josh
5   Nate


第三个数据帧的所需输出如下所示:

ID  Name
6   Sandy


我在Google上找不到任何类似的内容。我尝试了这个:

for i in second['ID'], third['ID']:
   if i not in master['ID']:
     print(i)


它返回主文件中的所有数据。

另外,如果我尝试此代码:

import pandas as pd

names = ["Mike", "Dani", "Scott", "Josh", "Nate", "Sandy"]
ids = [1, 2, 3, 4, 5, 6]
master = pd.DataFrame({"ID": ids, "Name": names})
# print(master)

names_second = ["Mike", "Dani", "Scott", "Sandy"]
ids_second = [1, 2, 3, 6]
second = pd.DataFrame({"ID": ids_second, "Name": names_second})
# print(second)

names_third = ["Mike", "Dani", "Scott", "Josh", "Nate"]
ids_third = [1, 2, 3, 4, 5]
third = pd.DataFrame({"ID": ids_third, "Name": names_third})
# print(third)
for i in master['ID']:
    if i not in second["ID"]:
        print("NOT IN SECOND", i)
    if i not in third["ID"]:
        print("NOT IN THIRD", i)


输出::

NOT IN SECOND 4
NOT IN SECOND 5
NOT IN THIRD 5
NOT IN SECOND 6
NOT IN THIRD 6


为什么说NOT IN SECOND 6NOT IN THIRD 5

有什么建议吗?提前致谢。

最佳答案

您可以尝试将.isin~一起使用以过滤dataframes。要与第二个进行比较,您可以使用master[~master.ID.isin(second.ID)]和类似的作为第三个:

cmp_master_second, cmp_master_third = master[~master.ID.isin(second.ID)],  master[~master.ID.isin(third.ID)]

print(cmp_master_second)
print('\n-------- Seperate dataframes -----------\n')
print(cmp_master_third)


结果:

    Name
ID
4   Josh
5   Nate

-------- Seperate dataframes -----------

     Name
ID
6   Sandy

关于python - 遍历不同的数据框,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/50959624/

10-11 23:09
查看更多