Filling missing dates in a grouped time series – a tidyverse-way?

by

tidyr has some great tools for these sorts of problems. Take a look at complete.

library(dplyr)
library(tidyr)
library(lubridate)

want <- df.missing %>% 
  ungroup() %>%
  complete(nesting(d1, d2), date = seq(min(date), max(date), by = "day"))

want %>% filter(d1 == "A" & d2 == 5) 

#> # A tibble: 10 x 5
#>        d1    d2       date         v1        v2
#>    <fctr> <dbl>     <date>      <dbl>     <dbl>
#>  1      A     5 2017-01-01         NA        NA
#>  2      A     5 2017-01-02 0.21879954 0.1335497
#>  3      A     5 2017-01-03 0.32977018 0.9802127
#>  4      A     5 2017-01-04 0.23902573 0.1206089
#>  5      A     5 2017-01-05 0.19617465 0.7378315
#>  6      A     5 2017-01-06 0.13373890 0.9493668
#>  7      A     5 2017-01-07 0.48613541 0.3392834
#>  8      A     5 2017-01-08 0.35698708 0.3696965
#>  9      A     5 2017-01-09 0.08498474 0.8354756
#> 10      A     5 2017-01-10         NA        NA

More Related Contents:

  1. Replace values greater than zero with 1 in r
  2. combine two data frames with all posible combinations
  3. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  4. Canonical tidyverse method to update some values of a vector from a look-up table
  5. Error with select function from dplyr
  6. Mutate multiple variable to create multiple new variables
  7. Create sequential counter that restarts on a condition within panel data groups [duplicate]
  8. mutate with case_when and contains
  9. Add row in each group using dplyr and add_row()
  10. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  11. How to get summary statistics by group
  12. Is there a dplyr equivalent to data.table::rleid?
  13. Replace NA with previous or next value, by group, using dplyr
  14. Filter rows which contain a certain string
  15. Basic lag in R vector/dataframe
  16. Rolling mean (moving average) by group/id with dplyr
  17. Pass a vector of variable names to arrange() in dplyr
  18. R – add column that counts sequentially within groups but repeats for duplicates
  19. Means multiple columns by multiple groups [duplicate]
  20. How to use map from purrr with dplyr::mutate to create multiple new columns based on column pairs
  21. Conditional cumsum with reset
  22. How to speed up subset by groups
  23. Number of significant digits in dplyr summarise
  24. Calculate group mean while excluding current observation using dplyr
  25. dplyr mutate rowwise max of range of columns
  26. Spreading a two column data frame with tidyr
  27. R dplyr rowwise mean or min and other methods?
  28. How to pass column name as argument to function for dplyr verbs?
  29. How to use data.table within functions and loops?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment