user5161995
Reputation:
Find and remove rows in 1 data frame that do not exist in another using python pandas
I have 2 csv files of different length. I need to find and remove the rows in one file that do not exist in the other file. Is there an easy way to do this, other than looping through the 2nd file n times?
Upvotes: 0
Views: 41
Answers (1)
BENY
Reputation: 323226
Assuming you load your csv file into df1, and df2
df1[df1.apply(tuple,1).isin(df2.apply(tuple,1))]
Upvotes: 1
Related Questions
- Removing rows from dataframe that occurs in another dataframe
- Check if row in dataframe exists in another dataframe and remove from both
- compare two dataframe by specific column and return the rows not exist in another
- Pandas delete rows in a dataframe that are not in another dataframe
- Remove rows from one data-frame that exist in another
- Python pandas data frame remove row where index name DOES NOT occurs in other data frame
- Finding rows which aren't in two dataframes
- Python pandas- Remove all elements of one dataframe that aren't included in another
- How to remove rows from a dataframe based on their column values existence in another df?
- Python Pandas - Remove values from first dataframe if not in second dataframe