Filtering dataframe based on another dataframe

Question

I have a data frame which has information on 1000 stocks (open, close, high , low, volume, company name, ticker symbol etc.) and I have another dataframe which just has one column of ticker symbols and this second dataframe has fewer rows than 1000 rows in the first dataframe. Now, I want only those rows in the first dataframe for which the ticker symbol is available in the second dataframe. How can this be done using pandas ? In my case, I have small dataframes. But I would also like to know how this operation can be scaled up. So, please suggest efficient way as well.

Thanks

Shubham Periwal · Accepted Answer · 2021-10-02 06:25:21Z

2

You can use .isin() to filter to the list of tickers available in df2.

df1_filtered = df1[df1['ticker'].isin(df2['ticker'].tolist())]

answered Oct 2, 2021 at 6:25

Shubham Periwal

2,2582 gold badges10 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Filtering dataframe based on another dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related