Replace NA in column with value in adjacent column

by

It didn’t work because status was a factor. When you mix factor with numeric then numeric is the least restrictive. By forcing status to be character you get the results you’re after and the column is now a character vector:

TEST$UNIT[is.na(TEST$UNIT)] <- as.character(TEST$STATUS[is.na(TEST$UNIT)])

##        UNIT   STATUS TERMINATED      START       STOP
## 1    ACTIVE   ACTIVE 1999-07-06 2007-04-23 2008-12-05
## 2  INACTIVE INACTIVE 2008-12-05 2008-12-06 4712-12-31
## 3       200   ACTIVE 2000-08-18 2004-06-01 2007-01-31
## 4       200   ACTIVE 2000-08-18 2007-02-01 2008-04-18
## 5       200 INACTIVE 2000-08-18 2008-04-19 2010-11-28
## 6       200   ACTIVE 2008-08-18 2010-11-29 2010-12-29
## 7       200 INACTIVE 2008-08-18 2010-12-30 4712-12-31
## 8       300   ACTIVE 2006-09-19 2007-10-29 2008-02-04
## 9       300   ACTIVE 2006-09-19 2008-02-05 2008-06-29
## 10      300   ACTIVE 2006-09-19 2008-06-30 2009-02-06
## 11      300 INACTIVE 1999-03-15 2009-02-07 4712-12-31

More Related Contents:

  1. How do I replace NA values with zeros in an R dataframe?
  2. How to replace NA values in a table for selected columns
  3. Coalesce two string columns with alternating missing values to one
  4. Randomly insert NAs into dataframe proportionaly
  5. Replace a value NA with the value from another column in R
  6. Replace in a factor column
  7. Select NA in a data.table in R
  8. Replace all NA with FALSE in selected columns in R
  9. Include levels of zero count in result of table()
  10. Insert rows for missing dates/times
  11. Replace NA with previous or next value, by group, using dplyr
  12. Replacing character values with NA in a data frame
  13. Collapsing rows where some are all NA, others are disjoint with some NAs
  14. Replace missing values with column mean
  15. How to delete rows from a dataframe that contain n*NA
  16. Subset of rows containing NA (missing) values in a chosen column of a data frame
  17. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  18. Remove all text before colon
  19. How to avoid warning when introducing NAs by coercion
  20. How to replace NaN value with zero in a huge data frame?
  21. Combine column to remove NA’s
  22. Remove columns from dataframe where some of values are NA
  23. in R, use gsub to remove all punctuation except period
  24. Replace missing values (NA) with blank (empty string)
  25. Convert NA into a factor level
  26. Select last non-NA value in a row, by row
  27. Why does NaN^0 == 1
  28. How to replace empty string with NA in R dataframe?
  29. Count number of non-NA values by group
  30. How can I count the number of NAs per group?

Leave a Comment