How to use specific conditions in dataFrame.loc in pandas python?

Question

I have a pandas Dataframe and i only want to select the rows if the 'code' is available in my set. I am currently trying this:

country_codes = set(set(dle['Code']) & set(dgdp['Code']))
dgdp.loc[dgdp['Code'].str in country_codes]

or

dgdp.loc[dgdp['Code'] in country_codes]

On the second one I get the problem TypeError: 'Series' objects are mutable, thus they cannot be hashed and in the first one I get KeyError: False.

How can I get the info for the codes that I want?

ESGQuant90 · Accepted Answer · 2022-01-20 18:18:15Z

1

try: dgdp.loc[dgdp['Code'].isin(country_codes)]

answered Jan 20, 2022 at 18:18

ESGQuant90

263 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1