pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”

by

Create a unique identifier row for each name and then use pivot_wider

library(dplyr)

d %>%
  group_by(name) %>%
  mutate(row = row_number()) %>%
  tidyr::pivot_wider(names_from = name, values_from = val) %>%
  select(-row)

# A tibble: 51 x 4
#   time          x1 `C Farolillo` `Plaza Eliptica`
#   <date>     <dbl>         <dbl>            <dbl>
# 1 2016-04-20  51.5             7               32
# 2 2016-04-21  56.3             3               25
# 3 2016-04-22  56.3             7               31
# 4 2016-04-23  57.9            13               34
# 5 2016-04-24  58.7             7               26
# 6 2016-04-25  59.0             9               33
# 7 2016-04-26  64.5            20               35
# 8 2016-04-27  61.9            19               43
# 9 2016-04-28  60.3             4               22
#10 2016-04-29  59.4             5               22
# … with 41 more rows

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. Gather multiple sets of columns
  3. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  4. Complete dataframe with missing combinations of values
  5. How can I spread repeated measures of multiple variables into wide format?
  6. Combine Multiple Columns Into Tidy Data [duplicate]
  7. R spreading multiple columns with tidyr [duplicate]
  8. Reshape multiple values at once
  9. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  10. Spread with data.frame/tibble with duplicate identifiers
  11. Using spread with duplicate identifiers for rows
  12. Proper idiom for adding zero count rows in tidyr/dplyr
  13. How to spread columns with duplicate identifiers?
  14. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  15. Add NAs to make all list elements equal length
  16. Reshape from long to wide and create columns with binary value
  17. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  18. How to complete missing factor levels in data frame?
  19. combine two data frames with all posible combinations
  20. Tidyr how to spread into count of occurrence [duplicate]
  21. tidyverse pivot_longer several sets of columns, but avoid intermediate mutate_wider steps [duplicate]
  22. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  23. data.table equivalent of tidyr::complete()
  24. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  25. Spreading a two column data frame with tidyr
  26. pivot_longer with multiple classes causes error (“No common type”)
  27. How do I scrape / automatically download PDF files from a document search web interface in R?
  28. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  29. How to transpose a dataframe in tidyverse?
  30. Unlisting columns by groups

Leave a Comment