Trying to change 174.0 to NaN. Am I missing something obvious? Finding the index of the value in the overall dataframe is too complicated, so I narrowed it down to Well L15. Is this not allowd?
input: df[df['Well']=='L15'].iloc[4,6]
output: 174.0
input: df[df['Well']=='L15'].iloc[4,6] = np.nan
input: df[df['Well']=='L15'].iloc[4,6]
output: 174.0
I expect this to give me NaN at the end, not 174.0. Thank you!