Replacing blank cells with condition from the same column in R

Asked Jun 22 '16 at 07:35

Active Mar 28 '17 at 04:36

Viewed 32 times

I have this data frame where all variables are factors:

V1            V2
Standard     Tom
             Matt
             John
Community    Steve
             Randy
Age          Robert
Engine       Arthur
Support      Amanda
             Cindy
             Bill
Team         Becky
             Sandra
             Kent

What I would like to do is to replace the missing values with the value above the same column. Maybe a function to fill the blanks from the first column based upon the same values from the same column.

I guess it's better to show an example:

V1            V2
Standard     Tom
Standard     Matt
Standard     John
Community    Steve
Community    Randy
Age          Robert
Engine       Arthur
Support      Amanda
Support      Cindy
Support      Bill
Team         Becky
Team         Sandra
Team         Kent

This is only a part of the data.frame because it has more than 1,000 rows and basically the same pattern is presented in the first column.

Is there a way to make it reproducible?

edited Mar 28 '17 at 04:36

asked Jun 22 '16 at 07:35

user44049

4

See `zoo::na.locf()` – zx8754 Jun 22 '16 at 07:39
3

First assign `NA` to `V1` as `df1$V1[ df1$V1 == "" ] <- NA` then follow solutions on duplicated post. – zx8754 Jun 22 '16 at 07:43

Replacing blank cells with condition from the same column in R

0 Answers0