Modified iris dataset so:
every column is labelled (using label attribute)
Species column is considered as factor
See iris for more informations on the original "Edgar Anderson's Iris Data" dataset.
iris2A data frame with 150 observations on 5 variables with labels.
library(dplyr)
iris2 = iris %>%
expss::apply_labels( #I also could have used [import_labels] or even `labelled::set_variable_labels()`
Species = "Specie",
Sepal.Length = "Length of Sepal",
Sepal.Width = "Width of Sepal",
Petal.Length = "Length of Petal",
Petal.Width = "Width of Petal"
) %>%
as_tibble()library(crosstable)
ct=crosstable(iris2, by=Species)
ct
#> # A tibble: 16 × 6
#> .id label variable setosa versicolor virginica
#> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 Sepal.Length Length of Sepal Min / Max 4.3 / 5.8 4.9 / 7.0 4.9 / 7.9
#> 2 Sepal.Length Length of Sepal Med [IQR] 5.0 [4.8;5.2] 5.9 [5.6;6.3] 6.5 [6.2…
#> 3 Sepal.Length Length of Sepal Mean (std) 5.0 (0.4) 5.9 (0.5) 6.6 (0.6)
#> 4 Sepal.Length Length of Sepal N (NA) 50 (0) 50 (0) 50 (0)
#> 5 Sepal.Width Width of Sepal Min / Max 2.3 / 4.4 2.0 / 3.4 2.2 / 3.8
#> 6 Sepal.Width Width of Sepal Med [IQR] 3.4 [3.2;3.7] 2.8 [2.5;3.0] 3.0 [2.8…
#> 7 Sepal.Width Width of Sepal Mean (std) 3.4 (0.4) 2.8 (0.3) 3.0 (0.3)
#> 8 Sepal.Width Width of Sepal N (NA) 50 (0) 50 (0) 50 (0)
#> 9 Petal.Length Length of Petal Min / Max 1.0 / 1.9 3.0 / 5.1 4.5 / 6.9
#> 10 Petal.Length Length of Petal Med [IQR] 1.5 [1.4;1.6] 4.3 [4.0;4.6] 5.5 [5.1…
#> 11 Petal.Length Length of Petal Mean (std) 1.5 (0.2) 4.3 (0.5) 5.6 (0.6)
#> 12 Petal.Length Length of Petal N (NA) 50 (0) 50 (0) 50 (0)
#> 13 Petal.Width Width of Petal Min / Max 0.1 / 0.6 1.0 / 1.8 1.4 / 2.5
#> 14 Petal.Width Width of Petal Med [IQR] 0.2 [0.2;0.3] 1.3 [1.2;1.5] 2.0 [1.8…
#> 15 Petal.Width Width of Petal Mean (std) 0.2 (0.1) 1.3 (0.2) 2.0 (0.3)
#> 16 Petal.Width Width of Petal N (NA) 50 (0) 50 (0) 50 (0)
as_flextable(ct)
label
variable
Specie
setosa
versicolor
virginica
Length of Sepal
Min / Max
4.3 / 5.8
4.9 / 7.0
4.9 / 7.9
Med [IQR]
5.0 [4.8;5.2]
5.9 [5.6;6.3]
6.5 [6.2;6.9]
Mean (std)
5.0 (0.4)
5.9 (0.5)
6.6 (0.6)
N (NA)
50 (0)
50 (0)
50 (0)
Width of Sepal
Min / Max
2.3 / 4.4
2.0 / 3.4
2.2 / 3.8
Med [IQR]
3.4 [3.2;3.7]
2.8 [2.5;3.0]
3.0 [2.8;3.2]
Mean (std)
3.4 (0.4)
2.8 (0.3)
3.0 (0.3)
N (NA)
50 (0)
50 (0)
50 (0)
Length of Petal
Min / Max
1.0 / 1.9
3.0 / 5.1
4.5 / 6.9
Med [IQR]
1.5 [1.4;1.6]
4.3 [4.0;4.6]
5.5 [5.1;5.9]
Mean (std)
1.5 (0.2)
4.3 (0.5)
5.6 (0.6)
N (NA)
50 (0)
50 (0)
50 (0)
Width of Petal
Min / Max
0.1 / 0.6
1.0 / 1.8
1.4 / 2.5
Med [IQR]
0.2 [0.2;0.3]
1.3 [1.2;1.5]
2.0 [1.8;2.3]
Mean (std)
0.2 (0.1)
1.3 (0.2)
2.0 (0.3)
N (NA)
50 (0)
50 (0)
50 (0)