Check If Single Cell Value Is NaN In Pandas
Answer : Try this: import pandas as pd import numpy as np from pandas import * >>> L = [4, nan ,6] >>> df = Series(L) >>> df 0 4 1 NaN 2 6 >>> if(pd.isnull(df[1])): print "Found" Found >>> if(np.isnan(df[1])): print "Found" Found STEP 1.) df[df.isnull().any(1)] ----> Will give you dataframe with rows and column, if any value there is nan. STEP 2.) this will give you location in dataframe where exactly value is nan. then you could do if(**df.iloc[loc_row,loc_colum]==np.nan**): print"your code here" You can use "isnull" with "at" to check a specific value in a dataframe. For example: import pandas as pd import numpy as np df = pd.DataFrame([[np.nan, 2], [1, 3], [4, 6]], columns=['A', 'B']) Yeilds: A B 0 NaN 2 1 1.0 3 2 4.0 6 To check the values: pd.isnull(df.at[0,'A']) -> True pd.isnu...