(Python) How to do matching between two csv files and return the common elements

Question

These are the tables that I am trying to match: table 1 and table 2

table1 = pd.DataFrame({'Name': ['Patrick', 'Amy', 'Krish', 'Jack']})
table2 = pd.DataFrame({'Name': ['Patrick', 'Patrick', 'Jack', 'Amy', 'Rachel', 'Kim', 'Amy'],
                       'Age': [20,19,19,18, 45, 32, 17],
                       'Number of Job Offer': [1,2,3,4, 5, 6, 8] })

This is the expected outcome: expected outcome

Can anyone please show me how I can get that in Python? Thank you

score 0 · Accepted Answer · answered Apr 13 '21 at 04:05

0

You can use pandas and load up your tables into dataframes then merge them. See here for more information about comparing rows

Should be something along the lines of

common = table1.merge(table2, how = 'inner' ,indicator=False)

answered Apr 13 '21 at 04:05

Ryan Rau

153
1
7

Oh I see. Thanks Ryan – Wu Kris Apr 13 '21 at 07:05
@WuKris, If you feel the answer helped you, you could [accept the answer](http://meta.stackexchange.com/a/5235). – sushanth Apr 24 '21 at 03:40

(Python) How to do matching between two csv files and return the common elements

1 Answers1