Pivot a Data/LazyFrame from wide to long
Usage
# S3 method for class 'RPolarsDataFrame'
pivot_longer(
data,
cols,
...,
names_to = "name",
names_prefix = NULL,
values_to = "value"
)
# S3 method for class 'RPolarsLazyFrame'
pivot_longer(
data,
cols,
...,
names_to = "name",
names_prefix = NULL,
values_to = "value"
)Arguments
- data
A Polars Data/LazyFrame
- cols
Columns to pivot into longer format. Can be anything accepted by
dplyr::select().- ...
Not used.
- names_to
The (quoted) name of the column that will contain the column names specified by
cols.- names_prefix
A regular expression used to remove matching text from the start of each variable name.
- values_to
A string specifying the name of the column to create from the data stored in cell values.
Examples
pl_relig_income <- polars::pl$DataFrame(tidyr::relig_income)
#> Warning: Passing a `data.frame` or `RPolarsDataFrame` to `pl$DataFrame()` is deprecated and will be removed in the future. Use `as_polars_df()` instead.
pl_relig_income
#> shape: (18, 11)
#> ┌────────────────────┬───────┬─────────┬─────────┬───┬──────────┬───────────┬───────┬──────────────┐
#> │ religion ┆ <$10k ┆ $10-20k ┆ $20-30k ┆ … ┆ $75-100k ┆ $100-150k ┆ >150k ┆ Don't │
#> │ --- ┆ --- ┆ --- ┆ --- ┆ ┆ --- ┆ --- ┆ --- ┆ know/refused │
#> │ str ┆ f64 ┆ f64 ┆ f64 ┆ ┆ f64 ┆ f64 ┆ f64 ┆ --- │
#> │ ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ f64 │
#> ╞════════════════════╪═══════╪═════════╪═════════╪═══╪══════════╪═══════════╪═══════╪══════════════╡
#> │ Agnostic ┆ 27.0 ┆ 34.0 ┆ 60.0 ┆ … ┆ 122.0 ┆ 109.0 ┆ 84.0 ┆ 96.0 │
#> │ Atheist ┆ 12.0 ┆ 27.0 ┆ 37.0 ┆ … ┆ 73.0 ┆ 59.0 ┆ 74.0 ┆ 76.0 │
#> │ Buddhist ┆ 27.0 ┆ 21.0 ┆ 30.0 ┆ … ┆ 62.0 ┆ 39.0 ┆ 53.0 ┆ 54.0 │
#> │ Catholic ┆ 418.0 ┆ 617.0 ┆ 732.0 ┆ … ┆ 949.0 ┆ 792.0 ┆ 633.0 ┆ 1489.0 │
#> │ Don’t know/refused ┆ 15.0 ┆ 14.0 ┆ 15.0 ┆ … ┆ 21.0 ┆ 17.0 ┆ 18.0 ┆ 116.0 │
#> │ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │
#> │ Orthodox ┆ 13.0 ┆ 17.0 ┆ 23.0 ┆ … ┆ 38.0 ┆ 42.0 ┆ 46.0 ┆ 73.0 │
#> │ Other Christian ┆ 9.0 ┆ 7.0 ┆ 11.0 ┆ … ┆ 18.0 ┆ 14.0 ┆ 12.0 ┆ 18.0 │
#> │ Other Faiths ┆ 20.0 ┆ 33.0 ┆ 40.0 ┆ … ┆ 46.0 ┆ 40.0 ┆ 41.0 ┆ 71.0 │
#> │ Other World ┆ 5.0 ┆ 2.0 ┆ 3.0 ┆ … ┆ 3.0 ┆ 4.0 ┆ 4.0 ┆ 8.0 │
#> │ Religions ┆ ┆ ┆ ┆ ┆ ┆ ┆ ┆ │
#> │ Unaffiliated ┆ 217.0 ┆ 299.0 ┆ 374.0 ┆ … ┆ 407.0 ┆ 321.0 ┆ 258.0 ┆ 597.0 │
#> └────────────────────┴───────┴─────────┴─────────┴───┴──────────┴───────────┴───────┴──────────────┘
pl_relig_income |>
pivot_longer(!religion, names_to = "income", values_to = "count")
#> shape: (180, 3)
#> ┌──────────────┬────────────────────┬───────┐
#> │ religion ┆ income ┆ count │
#> │ --- ┆ --- ┆ --- │
#> │ str ┆ str ┆ f64 │
#> ╞══════════════╪════════════════════╪═══════╡
#> │ Agnostic ┆ <$10k ┆ 27.0 │
#> │ Agnostic ┆ $10-20k ┆ 34.0 │
#> │ Agnostic ┆ $20-30k ┆ 60.0 │
#> │ Agnostic ┆ $30-40k ┆ 81.0 │
#> │ Agnostic ┆ $40-50k ┆ 76.0 │
#> │ … ┆ … ┆ … │
#> │ Unaffiliated ┆ $50-75k ┆ 528.0 │
#> │ Unaffiliated ┆ $75-100k ┆ 407.0 │
#> │ Unaffiliated ┆ $100-150k ┆ 321.0 │
#> │ Unaffiliated ┆ >150k ┆ 258.0 │
#> │ Unaffiliated ┆ Don't know/refused ┆ 597.0 │
#> └──────────────┴────────────────────┴───────┘
pl_billboard <- polars::pl$DataFrame(tidyr::billboard)
#> Warning: Passing a `data.frame` or `RPolarsDataFrame` to `pl$DataFrame()` is deprecated and will be removed in the future. Use `as_polars_df()` instead.
pl_billboard
#> shape: (317, 79)
#> ┌──────────────────┬─────────────────────────┬──────────────┬──────┬───┬──────┬──────┬──────┬──────┐
#> │ artist ┆ track ┆ date.entered ┆ wk1 ┆ … ┆ wk73 ┆ wk74 ┆ wk75 ┆ wk76 │
#> │ --- ┆ --- ┆ --- ┆ --- ┆ ┆ --- ┆ --- ┆ --- ┆ --- │
#> │ str ┆ str ┆ date ┆ f64 ┆ ┆ bool ┆ bool ┆ bool ┆ bool │
#> ╞══════════════════╪═════════════════════════╪══════════════╪══════╪═══╪══════╪══════╪══════╪══════╡
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 87.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ 2Ge+her ┆ The Hardest Part Of ... ┆ 2000-09-02 ┆ 91.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ 3 Doors Down ┆ Kryptonite ┆ 2000-04-08 ┆ 81.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ 3 Doors Down ┆ Loser ┆ 2000-10-21 ┆ 76.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ 504 Boyz ┆ Wobble Wobble ┆ 2000-04-15 ┆ 57.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │
#> │ Yankee Grey ┆ Another Nine Minutes ┆ 2000-04-29 ┆ 86.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ Yearwood, Trisha ┆ Real Live Woman ┆ 2000-04-01 ┆ 85.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ Ying Yang Twins ┆ Whistle While You Tw... ┆ 2000-03-18 ┆ 95.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ Zombie Nation ┆ Kernkraft 400 ┆ 2000-09-02 ┆ 99.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 60.0 ┆ … ┆ null ┆ null ┆ null ┆ null │
#> └──────────────────┴─────────────────────────┴──────────────┴──────┴───┴──────┴──────┴──────┴──────┘
pl_billboard |>
pivot_longer(
cols = starts_with("wk"),
names_to = "week",
names_prefix = "wk",
values_to = "rank",
)
#> shape: (24_092, 5)
#> ┌─────────────────┬─────────────────────────┬──────────────┬──────┬──────┐
#> │ artist ┆ track ┆ date.entered ┆ week ┆ rank │
#> │ --- ┆ --- ┆ --- ┆ --- ┆ --- │
#> │ str ┆ str ┆ date ┆ str ┆ f64 │
#> ╞═════════════════╪═════════════════════════╪══════════════╪══════╪══════╡
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 2 ┆ 82.0 │
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 76 ┆ null │
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 75 ┆ null │
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 74 ┆ null │
#> │ 2 Pac ┆ Baby Don't Cry (Keep... ┆ 2000-02-26 ┆ 73 ┆ null │
#> │ … ┆ … ┆ … ┆ … ┆ … │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 32 ┆ 28.0 │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 56 ┆ null │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 17 ┆ 2.0 │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 3 ┆ 29.0 │
#> │ matchbox twenty ┆ Bent ┆ 2000-04-29 ┆ 76 ┆ null │
#> └─────────────────┴─────────────────────────┴──────────────┴──────┴──────┘