04pallav
9/11/2017 - 10:27 PM

filter in dataframe

filter in dataframe

Using & operator, don't forget to wrap the sub-statements with ()
df[(df[Gender]=='Male') & (df[Year]==2014)]

# notice use of ix and the syntax to filter and fill values for Complaint column 
#very prone to mistake in this

intersectCMPM.ix[((intersectCMPM['Case Record Type']=='Question - Issue - Feedback') & (intersectCMPM['Type']=='Possible Osseofailure')),'Complaint Type']='Complaint'