remove rows with entries pandas code example
Example 1: pandas how to delete a row
>>> df
A B C D
0 0 1 2 3
1 4 5 6 7
2 8 9 10 11
Drop a row by index
df.drop([0, 1])
A B C D
2 8 9 10 11
Drop columns
df.drop(columns=['B', 'C'])
A D
0 0 3
1 4 7
2 8 11
Example 2: 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