Pandas drop row with multiple columns

Question

I request your kind assistance in dropping a row from a csv using Pandas using two filters.

import pandas as pd

moving = pd.read_csv('C:/Users/Salesdata.csv')
df = pd.DataFrame(moving)

df = df[df['Last Name, First Name'] != 'Reid, Mark and Connie' & df['Actual Sale Date'] == 3/8/2015]

df.to_csv('improvedcsv.csv', index=False)

My data:

Last Name, First Name                      Actual Sale Date
Bugs, Rabbit and Bunny                         12/11/2015
Reid, Mark and Connie                           3/8/2015
Cortese, Robert and Laura                       10/15/2014
Reid, Mark and Connie                           2/28/2015

I need to delete the Reid, Mark and Connie with the 3/8/2015. When I run the above drop column snippet the new csv returns NO data, only the column headings. How to fix this, please help Pythoners.

Answer 1

You need to put quotation marks around 3/8/2015 and change the logic a bit to filter out all those that are not equal to the condition your are filtering. You also need parentheses around each condition.

df[~((df['Last Name, First Name'] == 'Reid, Mark and Connie') & 
    (df['Actual Sale Date'] == '3/8/2015'))]