I amended this line of code msk = [isinstance(row, float) for row in df['latitude'].tolist()] to msk = df['latitude'].isnull().tolist() which essentially identifies those rows that have NaN values in the latitude column that I wanted to update. Thank you for the advice from @Anerdw.