Combine column to remove NA’s

by

A dplyr::coalesce based solution could be as:

data %>% mutate(mycol = coalesce(x,y,z)) %>%
         select(a, mycol)
#   a mycol
# 1 A     1
# 2 B     2
# 3 C     3
# 4 D     4
# 5 E     5

Data

data <- data.frame('a' = c('A','B','C','D','E'),
                 'x' = c(1,2,NA,NA,NA),
                 'y' = c(NA,NA,3,NA,NA),
                 'z' = c(NA,NA,NA,4,5))

More Related Contents:

  1. How to delete rows from a dataframe that contain n*NA
  2. Simultaneously merge multiple data.frames in a list
  3. Left join using data.table
  4. Replacing character values with NA in a data frame
  5. Merging a lot of data.frames [duplicate]
  6. Replace NA in column with value in adjacent column
  7. Merge two data frames while keeping the original row order
  8. Coalesce two string columns with alternating missing values to one
  9. Merge unequal dataframes and replace missing rows with 0
  10. aggregate methods treat missing values (NA) differently
  11. Use merge() to update a data frame with values from a second data frame
  12. How to subset data in R without losing NA rows?
  13. How to delete columns that contain ONLY NAs?
  14. Combine/merge lists by elements names
  15. Randomly insert NAs into dataframe proportionaly
  16. Dealing with TRUE, FALSE, NA and NaN
  17. Merge data frames based on rownames in R
  18. Replace a value NA with the value from another column in R
  19. Merging two columns into one in R [duplicate]
  20. Counting non NAs in a data frame; getting answer as a vector
  21. Merge error : negative length vectors are not allowed
  22. Creating (and Accessing) a Sparse Matrix with NA default entries
  23. Identify records in data frame A not contained in data frame B [closed]
  24. Efficiently merging two data frames on a non-trivial criteria
  25. R: replacing NAs in a data.frame with values in the same position in another dataframe
  26. Merge dataframes, different lengths
  27. Move NAs to the end of each column in a data frame
  28. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  29. Add a box for the NA values to the ggplot legend for a continuous map
  30. Data.frame Merge and Selection of values which are common in 2 Data.frames

Leave a Comment