How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables

by

You can try : 

tidyr::pivot_longer(df, cols = -ID_IE, 
                    names_to = c('.value', 'grade'), 
                    names_pattern = '(.*)(\\d+)')

# A tibble: 8 x 4
#  ID_IE grade BLS_tchrG ELS_tchrG
#  <dbl> <chr>     <dbl>     <dbl>
#1  2135 2             1         1
#2  2135 7             1         1
#3  2101 2             0         0
#4  2101 7             2         0
#5  2103 2             0         0
#6  2103 7             3         0
#7  2111 2             1         1
#8  2111 7             4         1

data

Tried on this data : 

df <- data.frame(ID_IE = c(2135, 2101, 2103, 2111), BLS_tchrG2 = c(1, 0, 0, 1), 
                 BLS_tchrG7 = 1:4,
                 ELS_tchrG2 = c(1, 0, 0, 1), ELS_tchrG7 = c(1, 0, 0, 1))

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. Reshape multiple values at once
  3. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  4. combine two data frames with all posible combinations
  5. Tidyr how to spread into count of occurrence [duplicate]
  6. R: Reshaping Multiple Columns from Long to Wide
  7. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  8. data.table equivalent of tidyr::complete()
  9. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  10. pivot_longer into multiple columns
  11. Unlisting columns by groups
  12. Gather multiple sets of columns
  13. pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”
  14. Reshaping wide to long with multiple values columns [duplicate]
  15. R spreading multiple columns with tidyr [duplicate]
  16. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  17. Compute mean and standard deviation by group for multiple variables in a data.frame
  18. melt / reshape in excel using VBA?
  19. Proper idiom for adding zero count rows in tidyr/dplyr
  20. Add NAs to make all list elements equal length
  21. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  22. how to pivot/unpivot (cast/melt) data frame? [duplicate]
  23. How to complete missing factor levels in data frame?
  24. Filling missing dates in a grouped time series – a tidyverse-way?
  25. Canonical tidyverse method to update some values of a vector from a look-up table
  26. Spreading a two column data frame with tidyr
  27. how to spread or cast multiple values in r [duplicate]
  28. How to transpose a dataframe in tidyverse?
  29. Add row in each group using dplyr and add_row()
  30. R reshape a vector into multiple columns

Leave a Comment