Selecting Rows that only match the column values in another data frame in Python [duplicate]

Question

I have a data frame:

>df_idbank.dtypes

DATASET                   object
IDBANK                    object
KEY                       object
FREQ                      object
INDICATEUR                object
CORRECTION_label_en       object

Etc.

I have another data frame:

>df_INDICATORS
    Label                                               IDBANK
0   Summary indicator of overall economic situatio...   1586891
1   Business climate summary indicator - SA series      1586890
2   Trend of expected activity - Overall - SA series    1586916
3   Trend of expected activity - Building structur...   1586885
4   Trend of expected activity - Finishings - SA s...   1586886

This would give a set of values pertaining to only values matching IDBANK =="001586891" from df_idbank data frame.

df_idbank = df_idbank.loc[(df_idbank.FREQ == "M") & (df_idbank.CORRECTION_label_en == "Seasonal adjusted") & (df_idbank.IDBANK =="001586891") ]

How do I select all the values matching IDBANK column in df_INDICATORS?

Kirill Kondratenko · Accepted Answer · 2023-11-07 12:14:17Z

1

You can use .isin():

df_idbank = df_idbank.loc[
    (df_idbank.FREQ == "M") & 
    (df_idbank.CORRECTION_label_en == "Seasonal adjusted") & 
    (df_idbank.IDBANK.isin(df_INDICATORS.IDBANK)) ]

answered Nov 7, 2023 at 12:14

Kirill Kondratenko

3772 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Selecting Rows that only match the column values in another data frame in Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related