How to extract data from pandas dataframe with multiple values?

Question

I have a pandas dataframe containing data and a python list which contains ids. I want to extract data from the pandas dataframe which matches with the values of list.

ids = ['SW00003062', 'SW00003063', 'SW00003067', 'SW00003072'] Dataframe is this:

Pandas dataframe

Could you provide your data as a pd.Dataframe so we can test our solution thanks — DataSciRookie, May 09 '22 at 04:52

score 0 · Answer 1 · answered May 09 '22 at 04:59

0

You can use isin

out = df[df['id'].isin(ids)]

answered May 09 '22 at 04:59

Ynjxsjmh

16,448
3
17
42

How to extract data from pandas dataframe with multiple values?

1 Answers1