Python Question
Pandas drop row with multiple columns
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.
Recommended for you: Get network issues from WhatsUp Gold. Not end users.
Answer Source
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'))]
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download