How to implement coalesce efficiently in R

by

On my machine, using Reduce gets a 5x performance improvement:

coalesce2 <- function(...) {
  Reduce(function(x, y) {
    i <- which(is.na(x))
    x[i] <- y[i]
    x},
  list(...))
}

> microbenchmark(coalesce(a,b,c),coalesce2(a,b,c))
Unit: microseconds
               expr    min       lq   median       uq     max neval
  coalesce(a, b, c) 97.669 100.7950 102.0120 103.0505 243.438   100
 coalesce2(a, b, c) 19.601  21.4055  22.8835  23.8315  45.419   100

More Related Contents:

  1. combine rows in data frame containing NA to make complete row
  2. Merge rows in a dataframe where the rows are disjoint and contain NAs
  3. How to collapse many records into one while removing NA values
  4. Read fixed width text file
  5. Draw a circle with ggplot2
  6. Extract year from date
  7. Replace X-axis with own values
  8. Select multiple columns in data.table by their numeric indices
  9. How to sort letters in a string?
  10. floating point issue in R? [duplicate]
  11. R list of lists to data.frame
  12. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  13. Euclidean distance of two vectors
  14. How to merge and sum two data frames
  15. find neighbouring elements of a matrix in R
  16. dplyr mutate rowwise max of range of columns
  17. Using dynamic column names in `data.table`
  18. Splitting a data frame into equal parts
  19. How to draw a nice arrow in ggplot2
  20. Deploying R shiny app as a standalone application [closed]
  21. Getting a function name as a string
  22. How to calculate number of days between two dates in R
  23. How to convert dd/mm/yy to yyyy-mm-dd in R
  24. Connect stack bar charts with multiple groups with lines or segments using ggplot 2
  25. How do I close unused connections after read_html in R
  26. different colors for each bar in stacked bar graph – base graphics
  27. consolidating data frames in R
  28. Text-mining with the tm-package – word stemming
  29. Adding percentage labels on pie chart in R
  30. show multiple plots from ggplot on one page in r

Leave a Comment