Coalesce two string columns with alternating missing values to one

by

You may try pmax

df$c <- pmax(df$a, df$b)
df
#       a    b     c
# 1   dog <NA>   dog
# 2 mouse <NA> mouse
# 3  <NA>  cat   cat
# 4  bird <NA>  bird

…or ifelse:

df$c <- ifelse(is.na(df$a), df$b, df$a)

For more general solutions in cases with more than two columns, you find several ways to implement coalesce in R here.

More Related Contents:

  1. How do I replace NA values with zeros in an R dataframe?
  2. Replace NA in column with value in adjacent column
  3. Randomly insert NAs into dataframe proportionaly
  4. Select NA in a data.table in R
  5. Replace all NA with FALSE in selected columns in R
  6. Include levels of zero count in result of table()
  7. Insert rows for missing dates/times
  8. Replace NA with previous or next value, by group, using dplyr
  9. Replacing character values with NA in a data frame
  10. Collapsing rows where some are all NA, others are disjoint with some NAs
  11. How to replace NA values in a table for selected columns
  12. Replace missing values with column mean
  13. How to delete rows from a dataframe that contain n*NA
  14. Subset of rows containing NA (missing) values in a chosen column of a data frame
  15. How to avoid warning when introducing NAs by coercion
  16. Combine column to remove NA’s
  17. Remove columns from dataframe where some of values are NA
  18. How to subset data in R without losing NA rows?
  19. How to delete columns that contain ONLY NAs?
  20. Replace missing values (NA) with blank (empty string)
  21. Convert NA into a factor level
  22. Select last non-NA value in a row, by row
  23. Why does NaN^0 == 1
  24. Replace in a factor column
  25. Counting non NAs in a data frame; getting answer as a vector
  26. R: replacing NAs in a data.frame with values in the same position in another dataframe
  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. Count number of non-NA values by group
  30. Add a box for the NA values to the ggplot legend for a continuous map

Leave a Comment