delete rows from a dataframe if they are equals to another dataframes row

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

Source

print (df['S'] != df['T']) 0 False 1 True 2 True 3 True 4 False 5 True 6 True 7 True 8 False dtype: bool df = df[df['S'] != df['T']] print (df) S T W U 1 A B 0 Undirected 2 A C 1 Undirected 3 B A 0 Undirected 5 B C 1 Undirected 6 C A 1 Undirected 7 C B 1 Undirected

Code answers related to "delete rows from a dataframe if they are equals to another dataframes row"

Code answers related to "R"

Browse Popular Code Answers by Language

Answers for "delete rows from a dataframe if they are equals to another dataframes row"

Code answers related to "delete rows from a dataframe if they are equals to another dataframes row"

Code answers related to "R"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us