Answers for "python dataframe drop the row if contains"

how to reomve certain row from dataframe pandas

# delete 10th, 11th, and 15th row of df, axis = 0 signify rows, inplace=True means changes directly going to apply to df.
df.drop(labels=[10, 11, 15], axis=0, inplace=True)
# or
df = df.drop(labels=10, axis=0)

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

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