Replace single occurrence of a string value in numeric variable - Python Pandas

Asked Jan 29 '19 at 11:25

Active Jan 29 '19 at 11:50

Viewed 30 times

I have a numeric variable (stored as object) where one single value is "NA", how could I replace this with a zero? Thanks!

df['Var_A'].loc[28:35]

28     2.99
29     7.81
30     "NA"
31    13.55
32     8.25
33      6.2
34     8.77
35     2.67
Name: Var_A, dtype: object

edited Jan 29 '19 at 11:50

asked Jan 29 '19 at 11:25

Metal99

2

`df['Var_A'].replace("NA", 0)` – yatu Jan 29 '19 at 11:26
Use `df['Var_A'].replace("NA", 0).astype(float)` or `pd.to_numeric(df['Var_A'], errors='coerce')` – jezrael Jan 29 '19 at 11:27
thanks guys, I tried both but the "NA" is still there – Metal99 Jan 29 '19 at 11:45
you missed the assignment part. Use like this. df['Var_A'] = df['Var_A'].replace("NA", 0) – solver149 Jan 29 '19 at 12:28

0 Answers0