Fill missing dates by group

by

tidyr::complete() fills missing values

add id and date as the columns (...) to expand for

library(tidyverse)

complete(dat, id, date)


# A tibble: 16 x 3
      id date       value
   <dbl> <date>     <dbl>
 1  1.00 2017-01-01  30.0
 2  1.00 2017-02-01  30.0
 3  1.00 2017-03-01  NA  
 4  1.00 2017-04-01  25.0
 5  2.00 2017-01-01  NA  
 6  2.00 2017-02-01  25.0
 7  2.00 2017-03-01  NA  
 8  2.00 2017-04-01  NA  
 9  3.00 2017-01-01  25.0
10  3.00 2017-02-01  25.0
11  3.00 2017-03-01  25.0
12  3.00 2017-04-01  NA  
13  4.00 2017-01-01  20.0
14  4.00 2017-02-01  20.0
15  4.00 2017-03-01  NA  
16  4.00 2017-04-01  20.0

More Related Contents:

  1. Replace NA with previous or next value, by group, using dplyr
  2. Gather multiple sets of columns
  3. How to get summary statistics by group
  4. Replace missing values (NA) with most recent non-NA by group
  5. Is there a dplyr equivalent to data.table::rleid?
  6. Getting the top values by group
  7. Filter rows which contain a certain string
  8. Calculate group mean, sum, or other summary stats. and assign column to original data
  9. Rolling mean (moving average) by group/id with dplyr
  10. Programming with dplyr using string as input
  11. Display / print all rows of a tibble (tbl_df)
  12. Count number of rows by group using dplyr
  13. Pass a vector of variable names to arrange() in dplyr
  14. Efficient way to filter one data frame by ranges in another
  15. Select columns based on string match – dplyr::select
  16. Delete columns/rows with more than x% missing
  17. How to aggregate a dataframe by week?
  18. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  19. Convert NA into a factor level
  20. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  21. dplyr mutate rowwise max of range of columns
  22. dplyr: lead() and lag() wrong when used with group_by()
  23. Reorder rows using custom order
  24. Spreading a two column data frame with tidyr
  25. R dplyr rowwise mean or min and other methods?
  26. R: Using a string as an argument to mutate verb in dplyr
  27. Run a custom function on a data frame in R, by group
  28. Dealing with spaces and “weird” characters in column names with dplyr::rename()
  29. R dplyr join on range of dates [duplicate]
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment