Answers for "remove rows in one df based on column values in another df"

1

delete rows with value in column pandas

df = df[df.line_race != 0]
Posted by: Guest on April-07-2020
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
Posted by: Guest on June-04-2020

Code answers related to "remove rows in one df based on column values in another df"

Python Answers by Framework

Browse Popular Code Answers by Language