filter one dataframe by another

Solutions on MaxInterview for filter one dataframe by another by the best coders in the world

Search
showing results for - "filter one dataframe by another"
Antonio
03 Nov 2019
1df1 = pd.DataFrame({'c': ['A', 'A', 'B', 'C', 'C'],
2                    'k': [1, 2, 2, 2, 2],
3                    'l': ['a', 'b', 'a', 'a', 'd']})
4df2 = pd.DataFrame({'c': ['A', 'C'],
5                    'l': ['b', 'a']})
6keys = list(df2.columns.values)
7i1 = df1.set_index(keys).index
8i2 = df2.set_index(keys).index
9df1[~i1.isin(i2)]
source
similar questions
pandas divide one column by anotherpython combine side by side dataframesdataframe from another dataframepandas filter columns with inupdate dataframe based on value from another dataframepandas filter by dictionaryhow to filter pandas dataframe column with multiple valuesselect 2 cols from dataframe python pandaspandas isin another dataframe columnfilter data in a dataframe python on a if condition of a value 3c 2f3filter dataframe multiple conditionspandas series filter by indexslice dataframe pandas based on conditionfind rows in dataframe from another dataframe pythonfilter by row contains pandasselect rows with multiple conditions pandas querypandas slicing from one column to anotherremoving rows dataframe not in another dataframe using two columnshow to combine delete rows based on condition on another dataframepandas two conditions filterfilter dataframe with listjoins with another dataframedataframe from two seriesfilter dataframe by two columnspandas select rows by multiple conditionshow to slicing dataframe using two conditionsfilter dataframe with a list of index
queries leading to this page
pandas select rows by another dataframefiltering a dataframe from another dataframe pandasfilter dataframe with another dataframe pythonfilter specific rows in pandas based on valuesdf filter by another dfpandas use one dataframe to filter anotherpandas filter df by another dffilter dataframe by another dataframe pandasfiltering only speciic values from a dataframe to another dataframe in pandasmake df from another df rows with valuepandas filter dataframe by another dataframe based on conditionhow to filter a dataframe based on another dataframepandas filter columns from another dataframefilter dataframe by another dataframe pythonpandas filter dataframe from another dataframer filter dataframe by another dataframefilter a dataframe by another dataframefilter dataframe using values from anotherfilter one dataframe by another 5c 27s columnsfilter dataframe from another pandasfilter dataframe based on another dataframepandas filter 1 df by anotherfilter one dataframe by anotherfiltering df values on the basis of another variablefilter columns based on 2 values from the another column pandasfilter dataframe by another pandasr filter one dataframe by anotherfilter dataframe by contentsfilter one dataframe by another