I have a data frame in with data as follows
Col1 Col2
20 NA
25 NA
15 NA
NA 10
NA 15
and so on... I am looking to reshape it as follows
Col1 Col2
20 10
25 10
15 10
15 10
15 15
Basically to forward or backward fill NA values with the first occurring non NA value. I tried a variation of Carry last Factor observation forward and backward in group of rows in R, but was unable to get it to work... Thanks in advance!
Forward filling and backward filling are two approaches to fill missing values. Forward filling means fill missing values with previous data. Backward filling means fill missing values with next data point.
First of all, create a data frame. Then, use rep function along with cbind function to repeat column values in the matrix by values in another column.
Rotating or transposing R objects You can rotate the data. frame so that the rows become the columns and the columns become the rows. That is, you transpose the rows and columns. You simply use the t() command.
We can do this with na.locf
from zoo
library(zoo)
na.locf(na.locf(df1), fromLast = TRUE)
# Col1 Col2
#1 20 10
#2 25 10
#3 15 10
#4 15 10
#5 15 15
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With