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)
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
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'))]