Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]

by

We can use tidyverse. After grouping by ‘start_end’, ‘id’, create a sequence column ‘ind’ , then spread from ‘long’ to ‘wide’ format

library(dplyr)
library(tidyr)
df %>%
   group_by(start_end, id) %>%
   mutate(ind = row_number()) %>%
   spread(start_end, date) %>% 
   select(start, end)
#     id      start        end
#* <int>     <fctr>     <fctr>
#1     2 1994-05-01 1996-11-04
#2     4 1979-07-18         NA
#3     5 2005-02-01 2009-09-17
#4     5 2010-10-01 2012-10-06

Or using tidyr_1.0.0

chop(df, date) %>%
     spread(start_end, date) %>%
     unnest(c(start, end))

More Related Contents:

  1. combine two data frames with all posible combinations
  2. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  3. Replace values greater than zero with 1 in r
  4. Gather multiple sets of columns
  5. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  6. Combine Multiple Columns Into Tidy Data [duplicate]
  7. R spreading multiple columns with tidyr [duplicate]
  8. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  9. Using spread with duplicate identifiers for rows
  10. Proper idiom for adding zero count rows in tidyr/dplyr
  11. Add NAs to make all list elements equal length
  12. Means multiple columns by multiple groups [duplicate]
  13. Reshape from long to wide and create columns with binary value
  14. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  15. Filling missing dates in a grouped time series – a tidyverse-way?
  16. data.table equivalent of tidyr::complete()
  17. Canonical tidyverse method to update some values of a vector from a look-up table
  18. Spreading a two column data frame with tidyr
  19. Error with select function from dplyr
  20. Mutate multiple variable to create multiple new variables
  21. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  22. mutate with case_when and contains
  23. Add row in each group using dplyr and add_row()
  24. pivot_longer into multiple columns
  25. Unlisting columns by groups
  26. Extract a dplyr tbl column as a vector
  27. Sum across multiple columns with dplyr
  28. dplyr: nonstandard column names (white space, punctuation, starts with numbers)
  29. ignore NA in dplyr row sum
  30. mutate function is not updating

Leave a Comment