Description
Create Pivot Table Easily.
Description
Pivot easily by specifying rows, columns, values and split.
README.md
pivotea
The goal of pivotea is to make pivot table easily by specifying rows, columns, values and split.
Installation
You can install the development version from GitHub with:
# install.packages("remotes")
remotes::install_github("matutosi/pivotea")
You can also install from CRAN:
install.packages("pivotea")
Example
You can use pivot() to make a pivot table easily.
library(pivotea)
library(dplyr)
library(ggplot2)
hogwarts |>
pivot(row = "hour", col = "wday", value = c("subject", "teacher", "room"), split = c("house", "grade"))
#> $Automatic.6
#> # A tibble: 7 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 Automatic 6 1 Muggle Studies_Burbage_NA <NA> Arit… Tran… Divi…
#> 2 Automatic 6 2 DADA_DADA Teacher_NA <NA> Rune… <NA> Herb…
#> 3 Automatic 6 3 Arithmancy_Vector_NA <NA> <NA> Poti… Rune…
#> 4 Automatic 6 4 Charms_Flitwick_NA Poti… Char… Poti… Care…
#> 5 Automatic 6 5 Care of Magical Creatures_CoMC … Tran… DADA… Mugg… Char…
#> 6 Automatic 6 6 History of Magic_Binns_NA Mugg… Divi… Hist… DADA…
#> 7 Automatic 6 7 Runes_Batsheda Babbling_NA Herb… Care… Tran… Arit…
#>
#> $Automatic.7
#> # A tibble: 7 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 Automatic 7 1 Care of Magical Creatures_CoMC … <NA> Rune… Divi… Char…
#> 2 Automatic 7 2 Charms_Flitwick_NA Tran… <NA> <NA> Care…
#> 3 Automatic 7 3 Runes_Batsheda Babbling_NA <NA> Poti… Arit… Arit…
#> 4 Automatic 7 4 Transfiguration_McGonagall_NA Mugg… Poti… DADA… Poti…
#> 5 Automatic 7 5 Herbology_Sprout_NA Arit… Herb… Tran… Mugg…
#> 6 Automatic 7 6 <NA> Hist… Care… Char… Rune…
#> 7 Automatic 7 7 DADA_DADA Teacher_NA Divi… DADA… Mugg… Hist…
#>
#> $G.1
#> # A tibble: 4 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 G 1 1 DADA_DADA Teacher_NA Transfiguration_McGo… <NA> <NA> <NA>
#> 2 G 1 2 Herbology_Sprout_NA History of Magic_Bin… Herb… Flyi… <NA>
#> 3 G 1 6 <NA> <NA> Poti… Tran… Char…
#> 4 G 1 7 <NA> Charms_Flitwick_NA Poti… Hist… <NA>
#>
#> $G.2
#> # A tibble: 5 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 G 2 1 Transfiguration_McGonagall_NA History of … <NA> Hist… <NA>
#> 2 G 2 2 <NA> DADA_DADA T… Poti… Herb… Poti…
#> 3 G 2 3 Herbology_Sprout_NA DADA_DADA T… Tran… Herb… Poti…
#> 4 G 2 6 <NA> <NA> Char… DADA… <NA>
#> 5 G 2 7 Charms_Flitwick_NA <NA> <NA> <NA> Tran…
#>
#> $G.3
#> # A tibble: 10 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 G 3 1 Runes_Batsheda Babbling_3_E2 DADA_DADA T… <NA> Care… Herb…
#> 2 G 3 1 Divination_Div Teacher_3_E2 <NA> <NA> <NA> <NA>
#> 3 G 3 2 Potions_Snape_NA Care of Mag… Hist… DADA… Hist…
#> 4 G 3 3 Potions_Snape_NA Care of Mag… Char… DADA… Tran…
#> 5 G 3 5 Charms_Flitwick_NA <NA> Poti… <NA> Rune…
#> 6 G 3 5 <NA> <NA> <NA> <NA> Divi…
#> 7 G 3 6 Herbology_Sprout_NA Transfigura… Herb… Arit… Arit…
#> 8 G 3 6 <NA> <NA> <NA> Mugg… <NA>
#> 9 G 3 7 Arithmancy_Vector_3_E1 Transfigura… Rune… Care… Char…
#> 10 G 3 7 Muggle Studies_Burbage_3_E1 <NA> Divi… <NA> <NA>
#>
#> $G.4
#> # A tibble: 11 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 G 4 1 Herbology_Sprout_NA Poti… <NA> Poti… DADA…
#> 2 G 4 2 <NA> <NA> Arit… Char… <NA>
#> 3 G 4 2 <NA> <NA> Mugg… <NA> <NA>
#> 4 G 4 3 Charms_Flitwick_NA Char… Arit… Rune… Hist…
#> 5 G 4 3 <NA> <NA> <NA> Divi… <NA>
#> 6 G 4 4 Arithmancy_Vector_4_E1 DADA… Herb… Rune… Herb…
#> 7 G 4 4 Muggle Studies_Burbage_4_E1 <NA> <NA> Divi… <NA>
#> 8 G 4 5 Transfiguration_McGonagall_NA Care… Hist… Care… Tran…
#> 9 G 4 6 Runes_Batsheda Babbling_4_E2 <NA> <NA> <NA> <NA>
#> 10 G 4 6 Divination_Div Teacher_4_E2 <NA> <NA> <NA> <NA>
#> 11 G 4 7 Care of Magical Creatures_CoMC tea… <NA> Tran… Poti… DADA…
#>
#> $G.5
#> # A tibble: 10 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 G 5 1 History of Magic_Binns_NA Rune… Hist… Arit… <NA>
#> 2 G 5 1 <NA> Divi… <NA> Mugg… <NA>
#> 3 G 5 2 <NA> Arit… Care… <NA> Tran…
#> 4 G 5 2 <NA> Mugg… <NA> <NA> <NA>
#> 5 G 5 3 <NA> Herb… DADA… Char… <NA>
#> 6 G 5 4 Potions_Snape_NA Herb… DADA… Herb… Rune…
#> 7 G 5 4 <NA> <NA> <NA> <NA> Divi…
#> 8 G 5 5 DADA_DADA Teacher_NA Char… Tran… Rune… Poti…
#> 9 G 5 6 Care of Magical Creatures_CoMC tea… Char… Tran… <NA> Poti…
#> 10 G 5 7 History of Magic_Binns_NA <NA> <NA> Arit… Care…
#>
#> $H.1
#> # A tibble: 4 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 H 1 1 Potions_Snape_NA Transfiguration_McGon… <NA> <NA> <NA>
#> 2 H 1 2 Herbology_Sprout_NA Charms_Flitwick_NA Herb… <NA> Flyi…
#> 3 H 1 6 <NA> <NA> DADA… Tran… Hist…
#> 4 H 1 7 Potions_Snape_NA History of Magic_Binn… <NA> Char… <NA>
#>
#> $H.2
#> # A tibble: 5 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 H 2 1 Transfiguration_McGonagall_NA Charms_Flit… Poti… Char… <NA>
#> 2 H 2 2 History of Magic_Binns_NA <NA> DADA… Herb… <NA>
#> 3 H 2 3 Herbology_Sprout_NA <NA> Tran… Herb… DADA…
#> 4 H 2 6 DADA_DADA Teacher_NA Potions_Sna… Hist… <NA> <NA>
#> 5 H 2 7 <NA> Potions_Sna… <NA> <NA> Tran…
#>
#> $H.3
#> # A tibble: 10 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 H 3 1 Charms_Flitwick_NA <NA> <NA> DADA… Herb…
#> 2 H 3 2 Care of Magical Creatures_CoMC tea… Poti… Char… Poti… Char…
#> 3 H 3 3 Care of Magical Creatures_CoMC tea… Poti… Rune… Care… Tran…
#> 4 H 3 3 <NA> <NA> Divi… <NA> <NA>
#> 5 H 3 5 Runes_Batsheda Babbling_3_E2 DADA… Care… <NA> Hist…
#> 6 H 3 5 Divination_Div Teacher_3_E2 <NA> <NA> <NA> <NA>
#> 7 H 3 6 Herbology_Sprout_NA Tran… Herb… Arit… Arit…
#> 8 H 3 6 <NA> <NA> <NA> Mugg… <NA>
#> 9 H 3 7 Arithmancy_Vector_3_E1 Tran… Hist… DADA… Rune…
#> 10 H 3 7 Muggle Studies_Burbage_3_E1 <NA> <NA> <NA> Divi…
#>
#> $H.4
#> # A tibble: 10 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 H 4 1 Herbology_Sprout_NA <NA> Care… <NA> Care…
#> 2 H 4 2 <NA> Runes_Bats… Arit… Rune… DADA…
#> 3 H 4 2 <NA> Divination… Mugg… Divi… <NA>
#> 4 H 4 3 History of Magic_Binns_NA Runes_Bats… Arit… <NA> Char…
#> 5 H 4 3 <NA> Divination… <NA> <NA> <NA>
#> 6 H 4 4 Arithmancy_Vector_4_E1 Care of Ma… Herb… Hist… Herb…
#> 7 H 4 4 Muggle Studies_Burbage_4_E1 <NA> <NA> <NA> <NA>
#> 8 H 4 5 Transfiguration_McGonagall_NA Potions_Sn… Char… Poti… Tran…
#> 9 H 4 6 Charms_Flitwick_NA DADA_DADA … <NA> Poti… <NA>
#> 10 H 4 7 <NA> DADA_DADA … Tran… <NA> <NA>
#>
#> $H.5
#> # A tibble: 9 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 H 5 1 <NA> <NA> Char… Arit… Rune…
#> 2 H 5 1 <NA> <NA> <NA> Mugg… <NA>
#> 3 H 5 2 <NA> Arithmancy_Ve… <NA> Hist… Tran…
#> 4 H 5 2 <NA> Muggle Studie… <NA> <NA> <NA>
#> 5 H 5 3 DADA_DADA Teacher_NA Herbology_Spr… Care… Hist… Divi…
#> 6 H 5 4 DADA_DADA Teacher_NA Herbology_Spr… Care… Herb… Char…
#> 7 H 5 5 Potions_Snape_NA History of Ma… Tran… <NA> DADA…
#> 8 H 5 6 Potions_Snape_NA Runes_Batshed… Tran… <NA> Care…
#> 9 H 5 7 Divination_Div Teacher_5_E2 Runes_Batshed… Char… Arit… Poti…
#>
#> $R.1
#> # A tibble: 4 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 R 1 1 Potions_Snape_NA Herbology_Sprout_NA <NA> Herb… Tran…
#> 2 R 1 2 <NA> History of Magic_Binns_NA Tran… <NA> Flyi…
#> 3 R 1 6 <NA> <NA> DADA… <NA> Char…
#> 4 R 1 7 Potions_Snape_NA Charms_Flitwick_NA <NA> Hist… <NA>
#>
#> $R.2
#> # A tibble: 5 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 R 2 1 <NA> History of … Poti… Hist… <NA>
#> 2 R 2 2 <NA> <NA> DADA… Tran… <NA>
#> 3 R 2 3 Transfiguration_McGonagall_NA <NA> <NA> Tran… DADA…
#> 4 R 2 6 DADA_DADA Teacher_NA Potions_Sna… Char… <NA> Herb…
#> 5 R 2 7 Charms_Flitwick_NA Potions_Sna… Herb… <NA> Herb…
#>
#> $R.3
#> # A tibble: 10 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 R 3 1 Runes_Batsheda Babbling_3_E2 <NA> Tran… DADA… Arit…
#> 2 R 3 1 Divination_Div Teacher_3_E2 <NA> <NA> <NA> Mugg…
#> 3 R 3 2 Care of Magical Creatures_CoMC tea… Poti… Hist… Poti… Hist…
#> 4 R 3 3 Care of Magical Creatures_CoMC tea… Poti… Char… Care… Herb…
#> 5 R 3 5 Charms_Flitwick_NA DADA… Care… Herb… Rune…
#> 6 R 3 5 <NA> <NA> <NA> <NA> Divi…
#> 7 R 3 6 Arithmancy_Vector_3_E1 Herb… <NA> <NA> Tran…
#> 8 R 3 6 Muggle Studies_Burbage_3_E1 <NA> <NA> <NA> <NA>
#> 9 R 3 7 Transfiguration_McGonagall_NA Arit… Rune… DADA… Char…
#> 10 R 3 7 <NA> <NA> Divi… <NA> <NA>
#>
#> $R.4
#> # A tibble: 12 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 R 4 1 <NA> <NA> Care… <NA> Care…
#> 2 R 4 2 Transfiguration_McGonagall_NA <NA> <NA> Char… DADA…
#> 3 R 4 3 Charms_Flitwick_NA Charms_Fli… Herb… Rune… Hist…
#> 4 R 4 3 <NA> <NA> <NA> Divi… <NA>
#> 5 R 4 4 Herbology_Sprout_NA Care of Ma… Tran… Rune… Tran…
#> 6 R 4 4 <NA> <NA> <NA> Divi… <NA>
#> 7 R 4 5 Arithmancy_Vector_4_E1 Potions_Sn… Hist… Poti… Herb…
#> 8 R 4 5 Muggle Studies_Burbage_4_E1 <NA> <NA> <NA> <NA>
#> 9 R 4 6 Runes_Batsheda Babbling_4_E2 DADA_DADA … Arit… Poti… <NA>
#> 10 R 4 6 Divination_Div Teacher_4_E2 <NA> <NA> <NA> <NA>
#> 11 R 4 7 <NA> DADA_DADA … Arit… <NA> <NA>
#> 12 R 4 7 <NA> <NA> Mugg… <NA> <NA>
#>
#> $R.5
#> # A tibble: 11 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 R 5 1 History of Magic_Binns_NA Runes_Batsheda… Hist… <NA> <NA>
#> 2 R 5 1 <NA> Divination_Div… <NA> <NA> <NA>
#> 3 R 5 2 Arithmancy_Vector_5_E1 Herbology_Spro… <NA> <NA> Arit…
#> 4 R 5 2 <NA> <NA> <NA> <NA> Mugg…
#> 5 R 5 3 DADA_DADA Teacher_NA Transfiguratio… Care… Char… <NA>
#> 6 R 5 4 DADA_DADA Teacher_NA Transfiguratio… Care… Tran… Rune…
#> 7 R 5 4 <NA> <NA> <NA> <NA> Divi…
#> 8 R 5 5 Potions_Snape_NA Charms_Flitwic… Arit… Rune… DADA…
#> 9 R 5 5 <NA> <NA> Mugg… <NA> <NA>
#> 10 R 5 6 Potions_Snape_NA Charms_Flitwic… <NA> Herb… Care…
#> 11 R 5 7 History of Magic_Binns_NA <NA> <NA> Herb… Poti…
#>
#> $S.1
#> # A tibble: 4 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 S 1 1 DADA_DADA Teacher_NA Herbology_Sprout_NA <NA> Herb… Tran…
#> 2 S 1 2 <NA> Charms_Flitwick_NA Tran… Flyi… <NA>
#> 3 S 1 6 <NA> <NA> Poti… <NA> Hist…
#> 4 S 1 7 <NA> History of Magic_Bin… Poti… Char… <NA>
#>
#> $S.2
#> # A tibble: 5 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 S 2 1 <NA> Charms_Flit… <NA> Char… <NA>
#> 2 S 2 2 History of Magic_Binns_NA DADA_DADA T… Poti… Tran… Poti…
#> 3 S 2 3 Transfiguration_McGonagall_NA DADA_DADA T… <NA> Tran… Poti…
#> 4 S 2 6 <NA> <NA> Hist… DADA… Herb…
#> 5 S 2 7 <NA> <NA> Herb… <NA> Herb…
#>
#> $S.3
#> # A tibble: 11 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 S 3 1 Charms_Flitwick_NA DADA_DADA … Tran… Care… Arit…
#> 2 S 3 1 <NA> <NA> <NA> <NA> Mugg…
#> 3 S 3 2 Potions_Snape_NA Care of Ma… Char… DADA… Char…
#> 4 S 3 3 Potions_Snape_NA Care of Ma… Rune… DADA… Herb…
#> 5 S 3 3 <NA> <NA> Divi… <NA> <NA>
#> 6 S 3 5 Runes_Batsheda Babbling_3_E2 <NA> Poti… Herb… Hist…
#> 7 S 3 5 Divination_Div Teacher_3_E2 <NA> <NA> <NA> <NA>
#> 8 S 3 6 Arithmancy_Vector_3_E1 Herbology_… <NA> <NA> Tran…
#> 9 S 3 6 Muggle Studies_Burbage_3_E1 <NA> <NA> <NA> <NA>
#> 10 S 3 7 Transfiguration_McGonagall_NA Arithmancy… Hist… Care… Rune…
#> 11 S 3 7 <NA> <NA> <NA> <NA> Divi…
#>
#> $S.4
#> # A tibble: 11 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 S 4 1 <NA> Poti… <NA> Poti… DADA…
#> 2 S 4 2 Transfiguration_McGonagall_NA Rune… <NA> Rune… <NA>
#> 3 S 4 2 <NA> Divi… <NA> Divi… <NA>
#> 4 S 4 3 History of Magic_Binns_NA Rune… Herb… <NA> Char…
#> 5 S 4 3 <NA> Divi… <NA> <NA> <NA>
#> 6 S 4 4 Herbology_Sprout_NA DADA… Tran… Hist… Tran…
#> 7 S 4 5 Arithmancy_Vector_4_E1 Care… Char… Care… Herb…
#> 8 S 4 5 Muggle Studies_Burbage_4_E1 <NA> <NA> <NA> <NA>
#> 9 S 4 6 Charms_Flitwick_NA <NA> Arit… <NA> <NA>
#> 10 S 4 7 Care of Magical Creatures_CoMC tea… <NA> Arit… Poti… DADA…
#> 11 S 4 7 <NA> <NA> Mugg… <NA> <NA>
#>
#> $S.5
#> # A tibble: 9 × 8
#> house grade hour mon tue wed thu fri
#> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 S 5 1 <NA> <NA> Char… <NA> Rune…
#> 2 S 5 2 Arithmancy_Vector_5_E1 Herb… Care… Hist… Arit…
#> 3 S 5 2 <NA> <NA> <NA> <NA> Mugg…
#> 4 S 5 3 <NA> Tran… DADA… Hist… Divi…
#> 5 S 5 4 Potions_Snape_NA Tran… DADA… Tran… Char…
#> 6 S 5 5 DADA_DADA Teacher_NA Hist… Arit… <NA> Poti…
#> 7 S 5 5 <NA> <NA> Mugg… <NA> <NA>
#> 8 S 5 6 Care of Magical Creatures_CoMC teac… Rune… <NA> Herb… Poti…
#> 9 S 5 7 Divination_Div Teacher_5_E2 Rune… Char… Herb… Care…
starwars |>
pivot(row = "homeworld", col = "species", value = "name", split = "sex")
#> $female
#> # A tibble: 15 × 9
#> sex homeworld Clawdite Human Kaminoan Mirialan Tholothian Togruta `Twi'lek`
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 fema… Alderaan <NA> Leia… <NA> <NA> <NA> <NA> <NA>
#> 2 fema… Chandrila <NA> Mon … <NA> <NA> <NA> <NA> <NA>
#> 3 fema… Coruscant <NA> Joca… <NA> <NA> Adi Gallia <NA> <NA>
#> 4 fema… Kamino <NA> <NA> Taun We <NA> <NA> <NA> <NA>
#> 5 fema… Mirial <NA> <NA> <NA> Luminar… <NA> <NA> <NA>
#> 6 fema… Mirial <NA> <NA> <NA> Barriss… <NA> <NA> <NA>
#> 7 fema… Naboo <NA> Padm… <NA> <NA> <NA> <NA> <NA>
#> 8 fema… Naboo <NA> Dormé <NA> <NA> <NA> <NA> <NA>
#> 9 fema… Ryloth <NA> <NA> <NA> <NA> <NA> <NA> Ayla Sec…
#> 10 fema… Shili <NA> <NA> <NA> <NA> <NA> Shaak … <NA>
#> 11 fema… Tatooine <NA> Beru… <NA> <NA> <NA> <NA> <NA>
#> 12 fema… Tatooine <NA> Shmi… <NA> <NA> <NA> <NA> <NA>
#> 13 fema… Zolan Zam Wes… <NA> <NA> <NA> <NA> <NA> <NA>
#> 14 fema… <NA> <NA> Rey <NA> <NA> <NA> <NA> <NA>
#> 15 fema… <NA> <NA> Capt… <NA> <NA> <NA> <NA> <NA>
#>
#> $hermaphroditic
#> # A tibble: 1 × 3
#> sex homeworld Hutt
#> <chr> <chr> <chr>
#> 1 hermaphroditic Nal Hutta Jabba Desilijic Tiure
#>
#> $male
#> # A tibble: 55 × 33
#> sex homeworld Aleena Besalisk Cerean Chagrian Dug Ewok Geonosian Gungan
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 male Alderaan <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 2 male Alderaan <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 3 male Aleen Min… Ratts… <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 4 male Bespin <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 5 male Cato Neim… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 6 male Cerea <NA> <NA> Ki-Ad… <NA> <NA> <NA> <NA> <NA>
#> 7 male Champala <NA> <NA> <NA> Mas Ame… <NA> <NA> <NA> <NA>
#> 8 male Concord D… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 9 male Corellia <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> 10 male Corellia <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
#> # ℹ 45 more rows
#> # ℹ 23 more variables: Human <chr>, Iktotchi <chr>, Kaleesh <chr>,
#> # Kaminoan <chr>, `Kel Dor` <chr>, `Mon Calamari` <chr>, Muun <chr>,
#> # Nautolan <chr>, Neimodian <chr>, `Pau'an` <chr>, Quermian <chr>,
#> # Rodian <chr>, Skakoan <chr>, Sullustan <chr>, Toong <chr>, Toydarian <chr>,
#> # Trandoshan <chr>, `Twi'lek` <chr>, Vulptereen <chr>, Wookiee <chr>,
#> # Xexto <chr>, `Yoda's species` <chr>, Zabrak <chr>
#>
#> $none
#> # A tibble: 6 × 3
#> sex homeworld Droid
#> <chr> <chr> <chr>
#> 1 none Naboo R2-D2
#> 2 none Tatooine C-3PO
#> 3 none Tatooine R5-D4
#> 4 none <NA> IG-88
#> 5 none <NA> R4-P17
#> 6 none <NA> BB8
msleep |>
pivot(row = "vore", col = "conservation", value = "name") |>
na2empty() |>
print(n = Inf)
#> # A tibble: 33 × 8
#> vore cd domesticated en lc nt vu `NA`
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 "carni" "Pilot whale" "Dog" "Tiger" "Che… "Jag… "Nor… "Slo…
#> 2 "carni" "" "Domestic cat" "" "Lon… "" "Lio… "Bot…
#> 3 "carni" "" "" "" "Gra… "" "Cas… "Gen…
#> 4 "carni" "" "" "" "Thi… "" "Com… "Arc…
#> 5 "carni" "" "" "" "Nor… "" "" "Red…
#> 6 "herbi" "Giraffe" "Cow" "Asian elepha… "Roe… "Mou… "Mon… "Thr…
#> 7 "herbi" "" "Guinea pig" "Golden hamst… "Goa… "Hou… "Afr… "Wes…
#> 8 "herbi" "" "Chinchilla" "" "Tre… "Rou… "Bra… "Vol…
#> 9 "herbi" "" "Horse" "" "Gra… "" "" "Pot…
#> 10 "herbi" "" "Donkey" "" "Mon… "" "" "Cot…
#> 11 "herbi" "" "Rabbit" "" "Deg… "" "" "Eas…
#> 12 "herbi" "" "Sheep" "" "Lab… "" "" ""
#> 13 "herbi" "" "" "" "Arc… "" "" ""
#> 14 "herbi" "" "" "" "Thi… "" "" ""
#> 15 "herbi" "" "" "" "Gol… "" "" ""
#> 16 "insecti" "" "" "Giant armadi… "Big… "" "" "Lit…
#> 17 "insecti" "" "" "" "Eas… "" "" "Sho…
#> 18 "omni" "" "Pig" "" "Gre… "" "" "Owl…
#> 19 "omni" "" "" "" "Gri… "" "" "Afr…
#> 20 "omni" "" "" "" "Sta… "" "" "Gal…
#> 21 "omni" "" "" "" "Les… "" "" "Hum…
#> 22 "omni" "" "" "" "Nor… "" "" "Mac…
#> 23 "omni" "" "" "" "Eur… "" "" "Chi…
#> 24 "omni" "" "" "" "Pat… "" "" "Bab…
#> 25 "omni" "" "" "" "Pot… "" "" "Afr…
#> 26 "omni" "" "" "" "" "" "" "Squ…
#> 27 "omni" "" "" "" "" "" "" "Ten…
#> 28 "omni" "" "" "" "" "" "" "Tre…
#> 29 "" "" "" "" "Des… "" "" "Ves…
#> 30 "" "" "" "" "Roc… "" "" "Dee…
#> 31 "" "" "" "" "" "" "" "Pha…
#> 32 "" "" "" "" "" "" "" "Mol…
#> 33 "" "" "" "" "" "" "" "Mus…
as_tibble(Titanic) |>
pivot(row = "Age", col = c("Sex", "Survived"), value = "n", split = "Class")
#> $`1st`
#> # A tibble: 2 × 6
#> Class Age Female_No Female_Yes Male_No Male_Yes
#> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
#> 1 1st Adult 4 140 118 57
#> 2 1st Child 0 1 0 5
#>
#> $`2nd`
#> # A tibble: 2 × 6
#> Class Age Female_No Female_Yes Male_No Male_Yes
#> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
#> 1 2nd Adult 13 80 154 14
#> 2 2nd Child 0 13 0 11
#>
#> $`3rd`
#> # A tibble: 2 × 6
#> Class Age Female_No Female_Yes Male_No Male_Yes
#> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
#> 1 3rd Adult 89 76 387 75
#> 2 3rd Child 17 14 35 13
#>
#> $Crew
#> # A tibble: 2 × 6
#> Class Age Female_No Female_Yes Male_No Male_Yes
#> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
#> 1 Crew Adult 3 20 670 192
#> 2 Crew Child 0 0 0 0
diamonds |>
pivot(row = "cut", col = "color", value = "price", split = "clarity")
#> $I1
#> # A tibble: 176 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 I1 Fair 5460 2788 2809 2808 2892 2935 3011
#> 2 I1 Fair 5617 3692 3734 4167 2964 3011 4284
#> 3 I1 Fair 15964 1232 4320 4277 2968 3745 5083
#> 4 I1 Fair 2491 1262 584 4849 2999 4368 5240
#> 5 I1 Fair NA 1273 4698 6315 3175 4704 5405
#> 6 I1 Fair NA 1865 5554 6346 3504 5040 5430
#> 7 I1 Fair NA 2036 6532 6377 3765 5074 5607
#> 8 I1 Fair NA 2138 6753 6503 4140 5667 5733
#> 9 I1 Fair NA 2571 7019 6597 4145 5696 5859
#> 10 I1 Fair NA NA 613 6817 4648 5750 6289
#> # ℹ 166 more rows
#>
#> $IF
#> # A tibble: 362 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 IF Fair 1208 NA 2861 1127 NA NA NA
#> 2 IF Fair 1440 NA 3205 1849 NA NA NA
#> 3 IF Fair 2211 NA 1166 NA NA NA NA
#> 4 IF Fair NA NA 2144 NA NA NA NA
#> 5 IF Good 3378 597 2980 3304 6703 3669 5361
#> 6 IF Good 3509 6804 3393 3583 13248 3734 6299
#> 7 IF Good 15081 612 9451 5771 1440 631 827
#> 8 IF Good 15928 813 9660 5855 2404 886 1061
#> 9 IF Good 16406 912 9867 8973 NA 945 2053
#> 10 IF Good 17499 1052 633 13998 NA NA NA
#> # ℹ 352 more rows
#>
#> $SI1
#> # A tibble: 1,828 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 SI1 Fair 3382 2885 2838 2782 2854 2804 2812
#> 2 SI1 Fair 3689 3332 2882 2841 2873 2856 2949
#> 3 SI1 Fair 3730 3407 2971 2964 3024 2873 3027
#> 4 SI1 Fair 3751 3508 3117 2993 3057 2875 3154
#> 5 SI1 Fair 3812 3696 3160 3052 3145 2912 3175
#> 6 SI1 Fair 3855 3743 3197 3145 3180 3280 3427
#> 7 SI1 Fair 3945 3891 3323 3250 3278 3337 3780
#> 8 SI1 Fair 4118 579 3326 3299 3282 3584 4123
#> 9 SI1 Fair 4252 4106 3387 3304 3285 3892 4147
#> 10 SI1 Fair 4276 4140 3437 3358 3387 3920 4838
#> # ℹ 1,818 more rows
#>
#> $SI2
#> # A tibble: 1,494 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 SI2 Fair 2848 2757 2759 2834 2763 2811 2789
#> 2 SI2 Fair 2885 2797 2815 2856 2777 2884 2992
#> 3 SI2 Fair 2974 2815 2867 2858 2818 2948 3119
#> 4 SI2 Fair 3003 2855 2958 2942 2823 3054 3149
#> 5 SI2 Fair 3079 2862 2964 3027 2825 3084 3199
#> 6 SI2 Fair 3205 2930 2996 3104 2846 3290 3246
#> 7 SI2 Fair 3304 2948 3062 3142 2856 3348 3302
#> 8 SI2 Fair 3384 2982 3146 3172 2875 3530 3403
#> 9 SI2 Fair 3473 3011 3170 3173 2883 3669 3984
#> 10 SI2 Fair 3634 3084 3210 3332 2912 3802 4056
#> # ℹ 1,484 more rows
#>
#> $VS1
#> # A tibble: 1,355 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 VS1 Fair 3047 2964 2859 2800 3500 3387 2875
#> 2 VS1 Fair 563 3276 2879 2998 3676 3763 2964
#> 3 VS1 Fair 7083 4770 3002 3756 3924 3801 3080
#> 4 VS1 Fair 1166 7392 3031 3806 4044 3951 7139
#> 5 VS1 Fair 2747 640 3039 4455 4368 4263 7186
#> 6 VS1 Fair NA 15584 3750 4630 4455 4281 7819
#> 7 VS1 Fair NA 361 4183 4864 4732 4328 9314
#> 8 VS1 Fair NA 371 593 4892 5062 6727 13399
#> 9 VS1 Fair NA 799 4984 5487 5242 11322 14402
#> 10 VS1 Fair NA 1778 5833 5633 5460 12244 14750
#> # ℹ 1,345 more rows
#>
#> $VS2
#> # A tibble: 1,526 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 VS2 Fair 2858 337 2762 3418 3226 2921 2811
#> 2 VS2 Fair 3077 2902 2805 4032 3375 3033 2815
#> 3 VS2 Fair 3931 2940 3172 4072 3538 3166 2854
#> 4 VS2 Fair 4107 3875 3750 4309 3593 3215 3190
#> 5 VS2 Fair 4277 4057 3837 4435 3658 3246 3422
#> 6 VS2 Fair 4439 4125 3931 4480 3697 3258 3443
#> 7 VS2 Fair 4765 581 3992 4838 3725 3265 3886
#> 8 VS2 Fair 592 4480 4229 4860 3733 3597 3980
#> 9 VS2 Fair 5078 4525 4312 4887 3819 4553 416
#> 10 VS2 Fair 5797 4550 4474 5161 4166 4695 5846
#> # ℹ 1,516 more rows
#>
#> $VVS1
#> # A tibble: 578 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 VVS1 Fair 10752 2805 7960 2797 4115 4194 1691
#> 2 VVS1 Fair 875 8529 12648 3062 NA NA NA
#> 3 VVS1 Fair 1792 1012 740 790 NA NA NA
#> 4 VVS1 Fair NA NA 1011 NA NA NA NA
#> 5 VVS1 Fair NA NA 1040 NA NA NA NA
#> 6 VVS1 Good 4198 554 3018 2899 2877 571 4633
#> 7 VVS1 Good 4274 2990 3206 3072 3096 3741 NA
#> 8 VVS1 Good 4407 575 564 3188 4381 3972 NA
#> 9 VVS1 Good 5029 586 3310 3225 4763 4114 NA
#> 10 VVS1 Good 8239 597 3536 3380 4847 4187 NA
#> # ℹ 568 more rows
#>
#> $VVS2
#> # A tibble: 885 × 9
#> clarity cut D E F G H I J
#> <ord> <ord> <int> <int> <int> <int> <int> <int> <int>
#> 1 VVS2 Fair 3296 3813 3920 2959 4312 3074 2998
#> 2 VVS2 Fair 4040 586 4368 3323 4355 3288 NA
#> 3 VVS2 Fair 8716 5430 6863 4534 5171 7303 NA
#> 4 VVS2 Fair 10562 5551 16364 4928 7476 1401 NA
#> 5 VVS2 Fair 772 7553 693 6736 922 2117 NA
#> 6 VVS2 Fair 997 7918 743 629 1227 2131 NA
#> 7 VVS2 Fair 1011 738 757 13553 2500 2292 NA
#> 8 VVS2 Fair 1089 945 1902 369 2608 2351 NA
#> 9 VVS2 Fair 1980 1069 2088 819 2699 NA NA
#> 10 VVS2 Fair NA 1705 2484 833 2717 NA NA
#> # ℹ 875 more rows
Citation
Toshikazu Matsumura (2023) pivotea. Create Pivot Table Easily. https://github.com/matutosi/pivotea/.