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