some more issues


df1[(df1['EMPLOYEE CODE'] != 'NaN')]
TypeError: invalid type comparison
here by invalid type what it means

one question is that when we pass csv file or some file in read object - pd.read_csv(file_name), how it be stored in that object
is internal type defines for columns like if any col contains only date then it mark full col as date ?
if my col contains random type of data then can i not make mixed search treating col as string

Some observation are 

if in csv any cell blank it represnt as NaN
if any cell contain NA then also it represnt as NaN

cell contain actual value NA and it represent as NaN
I used like - df1[df1['Candidate - Status'] == 'NA']
but output not come from any of these

1 Answer(s)


Can you share some sample data?