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 | email@example.com 1 | peter | paul | firstname.lastname@example.org 2 | joan | patricia | email@example.com 3 | mike | john | firstname.lastname@example.org
The output would be "
0 | john | mike | email@example.com" and "
3 | mike | john | firstname.lastname@example.org" because they have the same values in