I would like to compare two columns and find common value sets in each column, then output the rows with the common values.
Let's say I have a dataframe with:
no.(col1) | Username (col2) | Referral(col3) | email(col4)
0 | john | mike | email0@email.com
1 | peter | paul | email1@email.com
2 | joan | patricia | email2@email.com
3 | mike | john | email3@email.com
The output would be "0 | john | mike | email0@email.com
" and "3 | mike | john | email3@email.com
" because they have the same values in col2
and col3
respectively.