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