fillna not working in pandas for a specific column

Question

i asigned TEMPERATURE column of NaN value to be zero but not working properly all other columns working properly but this is not senter image description here

expecting to be temperature column nan values to be 0 but not working enter image description here

Please edit the question and and provide a useful, descriptive text for the links. — Quirin F. Schroll, Apr 29 '23 at 14:45

score 0 · Answer 1 · answered Apr 29 '23 at 07:46

You set the value for the "TEMPERATURE" key (column in DataFrame) in as string '0' instead of numeric value 0. The following will fill the np.NaN values in the "TEMPERATURE" column with 0:

new1 = hf.fillna({"TEMPERATURE": 0, "WIND SPEED": 0, "EVENT": "no event"})

fillna not working in pandas for a specific column

1 Answers1