Posts

Multiple filtering pandas columns based on values in another column

Image
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? python pandas ...

Juventus FC

Image
Juventus FC Iuventus PS Nomen totum Juventus Football Club Iuventus Pediludii Societas Nomina altera Albi-nigri (Italice Bianconeri ) Senex domina (Italice Vecchia signora ) Instituta 1897 Domus Iuventutis Stadium Taurini, in Pedemontio, Italia Capacitas 40.200 Dominus Andreas Agnelli Procurator Maximilianus Hilarem Liga Serie A 2012-13 Serie A, primum Juventus FC , vel modo Juventus Football Club (Latine Iuventus Consociatio Pediludii ) societas est pediludii Italiae Augustae Taurinorum. Condita est anno 1897. In prima categoria Italici pediludii, Serie A , ludit; Italicae disputationis undetriginta (anno 2013) et Europae disputationis bis victor fuit. Post plures suspectiones anno 2006 scandalum factum est, Italice Calciopoli appellatum: Iuventutis (et aliarum turmarum) rectores leges pediludii violabant ut certamina facilius vincerent. Quam ob rem poenà Iuventuti ultimorum duorum campionatuum victoriae ablata...