# Replace the missing value of column in R

To replace the missing value of the column in R we use different methods like replacing missing value with zero, with average and median etc. In this tutorial we will be looking on how to

• Replace the missing value of the column in R with 0 (zero)
• Replace missing value of the column with mean
• Replace missing value of the column with median

Let’s first create the dataframe.

```df1 = data.frame(State = c('Arizona AZ','Georgia GG', 'Newyork NY','Indiana IN','Florida FL'),
Score=c(62,47,55,74,31))
df1
```

So the dataframe will be #### Replace missing value of the column with zero (0):

Replace missing value of Mathematics_score column with zero

```### replace missing value with zero

df1\$Mathematics_score[is.na(df1\$Mathematics_score)] <- 0
```

so the resultant dataframe will be #### Replace missing value of the column with mean:

Replace missing value of Mathematics_score column with mean

```### replace missing value of column with mean

df1\$Mathematics_score[is.na(df1\$Mathematics_score)] <- mean(df1\$Mathematics_score,na.rm = TRUE)
```

so the resultant dataframe will be #### Replace missing value of the column with median:

Replace missing value of Mathematics_score column with median

```### replace missing value of column with median

df1\$Mathematics_score[is.na(df1\$Mathematics_score)]<- median(df1\$Mathematics_score,na.rm = TRUE)
```

so the resultant dataframe will be ## Author

• With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.