Hope you could help me. I am new to python and pandas, so please bear with me. I am trying to find the common word between three data frames and I am using Jupiter Notebook.
Just for example:
df1=
A
dog
cat
cow
duck
snake
df2=
A
pig
snail
bird
dog
df3=
A
eagle
dog
snail
monkey
There is only one column in all data frames that is A. I would like to find
- the common word among all columns
- the words that are unique to their own columns and not in common.
Example:
duck is unique to df1, snail is unique to df2 and monkey is unique to df3.
I am using the below code to some use but not getting what I want straightforward,
df1[df1['A'].isin(df2['A']) & (df2['A']) & (df3['A'])]
Kindly let me know where I am going wrong. Cheers
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…