Sq.Ima
Sq.Ima
Programming language:Python
2021-07-23 18:05:48
0
Q:

remove rows from a dataframe that are present in another dataframe?

meWantToLearn
meWantToLearn
Code: Python
2021-06-05 01:16:24 
df.loc[~((df.Product_Num.isin(df2['Product_Num']))&(df.Price.isin(df2['Price']))),:]
Out[246]: 
    Product_Num     Date  Description  Price
0            10   1-1-18  FruitSnacks   2.99
1            10   1-2-18  FruitSnacks   2.99
4            10  1-10-18  FruitSnacks   2.99
5            45   1-1-18       Apples   2.99
6            45   1-3-18       Apples   2.99
7            45   1-5-18       Apples   2.99
11           45  1-15-18       Apples   2.99
0

Tags

Related

New to Communities?

Join the community