CODE EXAMPLE FOR PYTHON

pandas read excel nan

#To assign all nan a np.nan value
data = pd.read_excel(r'File_Path', na_values= 'NAN')