How to fill missing values of data in dataframe using other values in same column in R

Asked Apr 21 '19 at 14:06

Active Apr 21 '19 at 14:13

Viewed 13 times

I have a dataframe which looks like

Name  Value
Car1  Station
Car1  NA
Car1  NA 
Car1  Station
Car2  Hatchback
Car2  NA

Now, I want to fill the NA values in the Value column with the non NA value of the same Name variable. So, the resulting dataframe should look like

Name  Value
Car1  Station
Car1  Station
Car1  Station 
Car1  Station
Car2  Hatchback
Car2  Hatchback

Does anyone know how to do it without looping through the entire dataframe?

asked Apr 21 '19 at 14:06

Activation

very efficient solution with tidyr: df %>% group_by(Name) %>% fill(Value) – Omry Atia Apr 21 '19 at 15:22

How to fill missing values of data in dataframe using other values in same column in R

0 Answers0