groupby ID in a dataframe1 then use isin function in the grouped by data frame, with another dataframe2, and output a data frame as well

Asked Apr 16 '22 at 17:35

Active Apr 16 '22 at 17:44

Viewed 21 times

I have two data frames:

first one is this :

which has 3 columns (ID , Name, Salary)

and the seconed data frame is this:

which has 2 columns (ID , Name)

I want to groupby ID in the first data frame (def1) after that I want to check if this ID (isin) the other data frame (def2), if it's NOT then I want to remove it. noting that the last output I need it to be as data frame as well, which is this:

how can I do this?

edited Apr 16 '22 at 17:44

Chris

12,661
3
20
33

asked Apr 16 '22 at 17:35

sunshine

1

Welcome to SO. Please don't post pictures of your data. Copy/Paste the data into the question and format it as a table. – Chris Apr 16 '22 at 17:42
would `df.merge(df2['ID'])` be sufficient? – Chris Apr 16 '22 at 17:48
I am sorry this is my first question to ask, so I am not used to the right way/format of questions. Thank you for advising me :). – sunshine Apr 16 '22 at 19:11
No, I need to do the groupby first to get mu desire output – sunshine Apr 16 '22 at 19:12
you can indeed `merge` on ID+Name, or set them as index and slice – mozway Apr 16 '22 at 19:57

groupby ID in a dataframe1 then use isin function in the grouped by data frame, with another dataframe2, and output a data frame as well

0 Answers0