Hfrxdjt

Why didn't Héctor fade away after this character died in the movie Coco?

Difficulty understanding group delay concept

Norwegian Refugee travel document

What kind of footwear is suitable for walking in micro gravity environment?

Does convergence of polynomials imply that of its coefficients?

Extraneous elements in "Europe countries" list

How do researchers send unsolicited emails asking for feedback on their works?

Is there any common country to visit for uk and schengen visa?

Why doesn't the fusion process of the sun speed up?

Why do I have a large white artefact on the rendered image?

Why does Surtur say that Thor is Asgard's doom?

Do I need to convey a moral for each of my blog post?

How to test the sharpness of a knife?

Is "inadequate referencing" a euphemism for plagiarism?

What is the difference between something being completely legal and being completely decriminalized?

Determine voltage drop over 10G resistors with cheap multimeter

Exit shell with shortcut (not typing exit) that closes session properly

Writing in a Christian voice

Would this string work as string?

Asserting that Atheism and Theism are both faith based positions

Is a square zero matrix positive semidefinite?

Nested Dynamic SOQL Query

What is it called when someone votes for an option that's not their first choice?

UK Tourist Visa- Enquiry

Multiple filtering pandas columns based on values in another column

Creating new columns by iterating over rows in pandas dataframePandas - Get feature values which appear in two distinct dataframesPandas Query Optimization On Multiple Columnshow many rows have values from the same columns pandasExport pandas to dictionary by combining multiple row valuesCombine Pandas DataFrames with year columnsSpearmanr on two pandas dataframesShould I use pandas get_dummies and create additional columns or use my own encoding code that keeps 1 column?Merging common Columns values in two DataFrame PandasAggregate values of same name pandas dataframe columns to single column

0

$begingroup$

I have a pandas dataframe df1 :

Now, I want to filter the rows in df1 based on unique combinations of (Campaign, Merchant) from another dataframe, df2, which look like this :

What I tried is using .isin, with a code similar to the one below:
df1.loc[df1['Campaign'].isin(df2['Campaign']) & (df1['Merchant'].isin(df2['Merchant']))]

The problem here is that the conditions are independent eg : I want to check if (A,1) from df2 is in df1, but with the above condition, since I am checking all the list, not row by row, it would return all rows in df1 where Campaign column is A OR Merchant column is 1.

Do you have any suggestion for this multiple pandas filtering?

pandas

share|improve this question

asked 2 hours ago

Remus RaphaelRemus Raphael

112

$endgroup$

add a comment | 

0

$begingroup$

I have a pandas dataframe df1 :

Now, I want to filter the rows in df1 based on unique combinations of (Campaign, Merchant) from another dataframe, df2, which look like this :

What I tried is using .isin, with a code similar to the one below:
df1.loc[df1['Campaign'].isin(df2['Campaign']) & (df1['Merchant'].isin(df2['Merchant']))]

The problem here is that the conditions are independent eg : I want to check if (A,1) from df2 is in df1, but with the above condition, since I am checking all the list, not row by row, it would return all rows in df1 where Campaign column is A OR Merchant column is 1.

Do you have any suggestion for this multiple pandas filtering?

pandas

share|improve this question

asked 2 hours ago

Remus RaphaelRemus Raphael

112

$endgroup$

add a comment | 

$begingroup$

I have a pandas dataframe df1 :

Now, I want to filter the rows in df1 based on unique combinations of (Campaign, Merchant) from another dataframe, df2, which look like this :

What I tried is using .isin, with a code similar to the one below:
df1.loc[df1['Campaign'].isin(df2['Campaign']) & (df1['Merchant'].isin(df2['Merchant']))]

The problem here is that the conditions are independent eg : I want to check if (A,1) from df2 is in df1, but with the above condition, since I am checking all the list, not row by row, it would return all rows in df1 where Campaign column is A OR Merchant column is 1.

Do you have any suggestion for this multiple pandas filtering?

pandas

share|improve this question

asked 2 hours ago

Remus RaphaelRemus Raphael

112

$endgroup$

share|improve this question

asked 2 hours ago

Remus RaphaelRemus Raphael

112

share|improve this question

asked 2 hours ago

Remus RaphaelRemus Raphael

112

asked 2 hours ago

Remus RaphaelRemus Raphael

112

asked 2 hours ago

Remus RaphaelRemus Raphael

112