# Assume -9999 is a missing data flag df.replace(-9999, np.NaN) # Alternatively, perform this when creating the dataframe: pd.read_csv("https://www.atmos.albany.edu/products/metarCSV/world_metar_latest.csv", sep='\s+',na_values=['9999.00','-9999.0'])