How to replace zero with first non-zero occurring at the next position in an R data frame column?

To replace zero with first non-zero occurring at the next position in an R data frame column, we can follow the below steps −

First of all, create a data frame.
Then, use na.locf function of zoo package to replace zero with first non-zero occurring at the next position in the data frame column.

Create the data frame

Let's create a data frame as shown below −

> x<-sample(0:5,20,replace=TRUE)
> df<-data.frame(x)
> df

On executing, the above script generates the below output(this output will vary on your system due to randomization) −

Using na.locf function of zoo package to replace zero with first non-zero occurring at the next position in column x of df −

> library(zoo)
> df$x<-na.locf(with(df,ifelse(x==0,NA_real_,x)),fromLast=TRUE)
> df

Updated on 13-Aug-2021 10:13:42