Pivot data from wide to long
Turning a wide table to its longer form. It takes multiple columns and collapses into key-value pairs.
longer_dt(.data, ..., name = "name", value = "value", na.rm = FALSE)
.data |
A data.frame |
... |
Pattern for unchanged group or unquoted names. Pattern can accept
regular expression to match column names. It can recieve what |
name |
Name for the measured variable names column. The default name is 'name'. |
value |
Name for the molten data values column(s). The default name is 'value'. |
na.rm |
If |
A data.table
## Example 1:
stocks = data.frame(
time = as.Date('2009-01-01') + 0:9,
X = rnorm(10, 0, 1),
Y = rnorm(10, 0, 2),
Z = rnorm(10, 0, 4)
)
stocks
stocks %>%
longer_dt(time)
stocks %>%
longer_dt("ti")
# Example 2:
library(tidyr)
billboard %>%
longer_dt(
-"wk",
name = "week",
value = "rank",
na.rm = TRUE
)
# or use:
billboard %>%
longer_dt(
artist,track,date.entered,
name = "week",
value = "rank",
na.rm = TRUE
)
# or use:
billboard %>%
longer_dt(
1:3,
name = "week",
value = "rank",
na.rm = TRUE
)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.