ds_auto_freq_table creates multiple one way tables by creating
a frequency table for each categorical variable in a data frame.
ds_auto_cross_table creates multiple two way tables by creating a cross
table for each unique pair of categorical variables in a data frame.
Details
ds_auto_freq_table is a extension of the ds_freq_table
function. It creates a frequency table for each categorical variable in the
dataframe. ds_auto_cross_table is a extension of the ds_cross_table
function. It creates a two way table for each unique pair of categorical
variables in the dataframe.
Deprecated Functions
ds_oway_tables() and ds_tway_tables() have been deprecated.
Instead use ds_auto_freq_table() and ds_auto_cross_table().
Examples
# frequency table for all columns
ds_auto_freq_table(mtcarz)
#> Variable: cyl
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 4 11 11 34.38 34.38
#> -----------------------------------------------------------------------
#> 6 7 18 21.88 56.25
#> -----------------------------------------------------------------------
#> 8 14 32 43.75 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
#> Variable: vs
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 0 18 18 56.25 56.25
#> -----------------------------------------------------------------------
#> 1 14 32 43.75 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
#> Variable: am
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 0 19 19 59.38 59.38
#> -----------------------------------------------------------------------
#> 1 13 32 40.62 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
#> Variable: gear
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 3 15 15 46.88 46.88
#> -----------------------------------------------------------------------
#> 4 12 27 37.5 84.38
#> -----------------------------------------------------------------------
#> 5 5 32 15.62 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
#> Variable: carb
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 1 7 7 21.88 21.88
#> -----------------------------------------------------------------------
#> 2 10 17 31.25 53.12
#> -----------------------------------------------------------------------
#> 3 3 20 9.38 62.5
#> -----------------------------------------------------------------------
#> 4 10 30 31.25 93.75
#> -----------------------------------------------------------------------
#> 6 1 31 3.12 96.88
#> -----------------------------------------------------------------------
#> 8 1 32 3.12 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
# frequency table for multiple columns
ds_auto_freq_table(mtcarz, cyl, gear)
#> Variable: cyl
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 4 11 11 34.38 34.38
#> -----------------------------------------------------------------------
#> 6 7 18 21.88 56.25
#> -----------------------------------------------------------------------
#> 8 14 32 43.75 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
#> Variable: gear
#> -----------------------------------------------------------------------
#> Levels Frequency Cum Frequency Percent Cum Percent
#> -----------------------------------------------------------------------
#> 3 15 15 46.88 46.88
#> -----------------------------------------------------------------------
#> 4 12 27 37.5 84.38
#> -----------------------------------------------------------------------
#> 5 5 32 15.62 100
#> -----------------------------------------------------------------------
#> Total 32 - 100.00 -
#> -----------------------------------------------------------------------
#>
# cross table for all columns
ds_auto_cross_table(mtcarz)
#> Cell Contents
#> |---------------|
#> | Frequency |
#> | Percent |
#> | Row Pct |
#> | Col Pct |
#> |---------------|
#>
#> Total Observations: 32
#>
#> cyl vs vs
#> -------------------------------------------------------------
#> | | vs |
#> -------------------------------------------------------------
#> | cyl | 0 | 1 | Row Total |
#> -------------------------------------------------------------
#> | 4 | 1 | 10 | 11 |
#> | | 0.031 | 0.312 | |
#> | | 0.09 | 0.91 | 0.34 |
#> | | 0.06 | 0.71 | |
#> -------------------------------------------------------------
#> | 6 | 3 | 4 | 7 |
#> | | 0.094 | 0.125 | |
#> | | 0.43 | 0.57 | 0.22 |
#> | | 0.17 | 0.29 | |
#> -------------------------------------------------------------
#> | 8 | 14 | 0 | 14 |
#> | | 0.438 | 0 | |
#> | | 1 | 0 | 0.44 |
#> | | 0.78 | 0 | |
#> -------------------------------------------------------------
#> | Column Total | 18 | 14 | 32 |
#> | | 0.563 | 0.437 | |
#> -------------------------------------------------------------
#>
#>
#> cyl vs am
#> -------------------------------------------------------------
#> | | am |
#> -------------------------------------------------------------
#> | cyl | 0 | 1 | Row Total |
#> -------------------------------------------------------------
#> | 4 | 3 | 8 | 11 |
#> | | 0.094 | 0.25 | |
#> | | 0.27 | 0.73 | 0.34 |
#> | | 0.16 | 0.62 | |
#> -------------------------------------------------------------
#> | 6 | 4 | 3 | 7 |
#> | | 0.125 | 0.094 | |
#> | | 0.57 | 0.43 | 0.22 |
#> | | 0.21 | 0.23 | |
#> -------------------------------------------------------------
#> | 8 | 12 | 2 | 14 |
#> | | 0.375 | 0.062 | |
#> | | 0.86 | 0.14 | 0.44 |
#> | | 0.63 | 0.15 | |
#> -------------------------------------------------------------
#> | Column Total | 19 | 13 | 32 |
#> | | 0.594 | 0.406 | |
#> -------------------------------------------------------------
#>
#>
#> cyl vs gear
#> ----------------------------------------------------------------------------
#> | | gear |
#> ----------------------------------------------------------------------------
#> | cyl | 3 | 4 | 5 | Row Total |
#> ----------------------------------------------------------------------------
#> | 4 | 1 | 8 | 2 | 11 |
#> | | 0.031 | 0.25 | 0.062 | |
#> | | 0.09 | 0.73 | 0.18 | 0.34 |
#> | | 0.07 | 0.67 | 0.4 | |
#> ----------------------------------------------------------------------------
#> | 6 | 2 | 4 | 1 | 7 |
#> | | 0.062 | 0.125 | 0.031 | |
#> | | 0.29 | 0.57 | 0.14 | 0.22 |
#> | | 0.13 | 0.33 | 0.2 | |
#> ----------------------------------------------------------------------------
#> | 8 | 12 | 0 | 2 | 14 |
#> | | 0.375 | 0 | 0.062 | |
#> | | 0.86 | 0 | 0.14 | 0.44 |
#> | | 0.8 | 0 | 0.4 | |
#> ----------------------------------------------------------------------------
#> | Column Total | 15 | 12 | 5 | 32 |
#> | | 0.468 | 0.375 | 0.155 | |
#> ----------------------------------------------------------------------------
#>
#>
#> cyl vs carb
#> -------------------------------------------------------------------------------------------------------------------------
#> | | carb |
#> -------------------------------------------------------------------------------------------------------------------------
#> | cyl | 1 | 2 | 3 | 4 | 6 | 8 | Row Total |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 4 | 5 | 6 | 0 | 0 | 0 | 0 | 11 |
#> | | 0.156 | 0.188 | 0 | 0 | 0 | 0 | |
#> | | 0.45 | 0.55 | 0 | 0 | 0 | 0 | 0.34 |
#> | | 0.71 | 0.6 | 0 | 0 | 0 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 6 | 2 | 0 | 0 | 4 | 1 | 0 | 7 |
#> | | 0.062 | 0 | 0 | 0.125 | 0.031 | 0 | |
#> | | 0.29 | 0 | 0 | 0.57 | 0.14 | 0 | 0.22 |
#> | | 0.29 | 0 | 0 | 0.4 | 1 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 8 | 0 | 4 | 3 | 6 | 0 | 1 | 14 |
#> | | 0 | 0.125 | 0.094 | 0.188 | 0 | 0.031 | |
#> | | 0 | 0.29 | 0.21 | 0.43 | 0 | 0.07 | 0.44 |
#> | | 0 | 0.4 | 1 | 0.6 | 0 | 1 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | Column Total | 7 | 10 | 3 | 10 | 1 | 1 | 32 |
#> | | 0.218 | 0.313 | 0.094 | 0.313 | 0.031 | 0.031 | |
#> -------------------------------------------------------------------------------------------------------------------------
#>
#>
#> vs vs am
#> -------------------------------------------------------------
#> | | am |
#> -------------------------------------------------------------
#> | vs | 0 | 1 | Row Total |
#> -------------------------------------------------------------
#> | 0 | 12 | 6 | 18 |
#> | | 0.375 | 0.188 | |
#> | | 0.67 | 0.33 | 0.56 |
#> | | 0.63 | 0.46 | |
#> -------------------------------------------------------------
#> | 1 | 7 | 7 | 14 |
#> | | 0.219 | 0.219 | |
#> | | 0.5 | 0.5 | 0.44 |
#> | | 0.37 | 0.54 | |
#> -------------------------------------------------------------
#> | Column Total | 19 | 13 | 32 |
#> | | 0.594 | 0.407 | |
#> -------------------------------------------------------------
#>
#>
#> vs vs gear
#> ----------------------------------------------------------------------------
#> | | gear |
#> ----------------------------------------------------------------------------
#> | vs | 3 | 4 | 5 | Row Total |
#> ----------------------------------------------------------------------------
#> | 0 | 12 | 2 | 4 | 18 |
#> | | 0.375 | 0.062 | 0.125 | |
#> | | 0.67 | 0.11 | 0.22 | 0.56 |
#> | | 0.8 | 0.17 | 0.8 | |
#> ----------------------------------------------------------------------------
#> | 1 | 3 | 10 | 1 | 14 |
#> | | 0.094 | 0.312 | 0.031 | |
#> | | 0.21 | 0.71 | 0.07 | 0.44 |
#> | | 0.2 | 0.83 | 0.2 | |
#> ----------------------------------------------------------------------------
#> | Column Total | 15 | 12 | 5 | 32 |
#> | | 0.469 | 0.374 | 0.156 | |
#> ----------------------------------------------------------------------------
#>
#>
#> vs vs carb
#> -------------------------------------------------------------------------------------------------------------------------
#> | | carb |
#> -------------------------------------------------------------------------------------------------------------------------
#> | vs | 1 | 2 | 3 | 4 | 6 | 8 | Row Total |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 0 | 0 | 5 | 3 | 8 | 1 | 1 | 18 |
#> | | 0 | 0.156 | 0.094 | 0.25 | 0.031 | 0.031 | |
#> | | 0 | 0.28 | 0.17 | 0.44 | 0.06 | 0.06 | 0.56 |
#> | | 0 | 0.5 | 1 | 0.8 | 1 | 1 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 1 | 7 | 5 | 0 | 2 | 0 | 0 | 14 |
#> | | 0.219 | 0.156 | 0 | 0.062 | 0 | 0 | |
#> | | 0.5 | 0.36 | 0 | 0.14 | 0 | 0 | 0.44 |
#> | | 1 | 0.5 | 0 | 0.2 | 0 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | Column Total | 7 | 10 | 3 | 10 | 1 | 1 | 32 |
#> | | 0.219 | 0.312 | 0.094 | 0.312 | 0.031 | 0.031 | |
#> -------------------------------------------------------------------------------------------------------------------------
#>
#>
#> am vs gear
#> ----------------------------------------------------------------------------
#> | | gear |
#> ----------------------------------------------------------------------------
#> | am | 3 | 4 | 5 | Row Total |
#> ----------------------------------------------------------------------------
#> | 0 | 15 | 4 | 0 | 19 |
#> | | 0.469 | 0.125 | 0 | |
#> | | 0.79 | 0.21 | 0 | 0.59 |
#> | | 1 | 0.33 | 0 | |
#> ----------------------------------------------------------------------------
#> | 1 | 0 | 8 | 5 | 13 |
#> | | 0 | 0.25 | 0.156 | |
#> | | 0 | 0.62 | 0.38 | 0.41 |
#> | | 0 | 0.67 | 1 | |
#> ----------------------------------------------------------------------------
#> | Column Total | 15 | 12 | 5 | 32 |
#> | | 0.469 | 0.375 | 0.156 | |
#> ----------------------------------------------------------------------------
#>
#>
#> am vs carb
#> -------------------------------------------------------------------------------------------------------------------------
#> | | carb |
#> -------------------------------------------------------------------------------------------------------------------------
#> | am | 1 | 2 | 3 | 4 | 6 | 8 | Row Total |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 0 | 3 | 6 | 3 | 7 | 0 | 0 | 19 |
#> | | 0.094 | 0.188 | 0.094 | 0.219 | 0 | 0 | |
#> | | 0.16 | 0.32 | 0.16 | 0.37 | 0 | 0 | 0.6 |
#> | | 0.43 | 0.6 | 1 | 0.7 | 0 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 1 | 4 | 4 | 0 | 3 | 1 | 1 | 13 |
#> | | 0.125 | 0.125 | 0 | 0.094 | 0.031 | 0.031 | |
#> | | 0.31 | 0.31 | 0 | 0.23 | 0.08 | 0.08 | 0.41 |
#> | | 0.57 | 0.4 | 0 | 0.3 | 1 | 1 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | Column Total | 7 | 10 | 3 | 10 | 1 | 1 | 32 |
#> | | 0.219 | 0.313 | 0.094 | 0.313 | 0.031 | 0.031 | |
#> -------------------------------------------------------------------------------------------------------------------------
#>
#>
#> gear vs carb
#> -------------------------------------------------------------------------------------------------------------------------
#> | | carb |
#> -------------------------------------------------------------------------------------------------------------------------
#> | gear | 1 | 2 | 3 | 4 | 6 | 8 | Row Total |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 3 | 3 | 4 | 3 | 5 | 0 | 0 | 15 |
#> | | 0.094 | 0.125 | 0.094 | 0.156 | 0 | 0 | |
#> | | 0.2 | 0.27 | 0.2 | 0.33 | 0 | 0 | 0.47 |
#> | | 0.43 | 0.4 | 1 | 0.5 | 0 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 4 | 4 | 4 | 0 | 4 | 0 | 0 | 12 |
#> | | 0.125 | 0.125 | 0 | 0.125 | 0 | 0 | |
#> | | 0.33 | 0.33 | 0 | 0.33 | 0 | 0 | 0.38 |
#> | | 0.57 | 0.4 | 0 | 0.4 | 0 | 0 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | 5 | 0 | 2 | 0 | 1 | 1 | 1 | 5 |
#> | | 0 | 0.062 | 0 | 0.031 | 0.031 | 0.031 | |
#> | | 0 | 0.4 | 0 | 0.2 | 0.2 | 0.2 | 0.16 |
#> | | 0 | 0.2 | 0 | 0.1 | 1 | 1 | |
#> -------------------------------------------------------------------------------------------------------------------------
#> | Column Total | 7 | 10 | 3 | 10 | 1 | 1 | 32 |
#> | | 0.219 | 0.312 | 0.094 | 0.312 | 0.031 | 0.031 | |
#> -------------------------------------------------------------------------------------------------------------------------
#>
#>
# cross table for multiple columns
ds_auto_cross_table(mtcarz, cyl, gear, am)
#> Cell Contents
#> |---------------|
#> | Frequency |
#> | Percent |
#> | Row Pct |
#> | Col Pct |
#> |---------------|
#>
#> Total Observations: 32
#>
#> cyl vs gear
#> ----------------------------------------------------------------------------
#> | | gear |
#> ----------------------------------------------------------------------------
#> | cyl | 3 | 4 | 5 | Row Total |
#> ----------------------------------------------------------------------------
#> | 4 | 1 | 8 | 2 | 11 |
#> | | 0.031 | 0.25 | 0.062 | |
#> | | 0.09 | 0.73 | 0.18 | 0.34 |
#> | | 0.07 | 0.67 | 0.4 | |
#> ----------------------------------------------------------------------------
#> | 6 | 2 | 4 | 1 | 7 |
#> | | 0.062 | 0.125 | 0.031 | |
#> | | 0.29 | 0.57 | 0.14 | 0.22 |
#> | | 0.13 | 0.33 | 0.2 | |
#> ----------------------------------------------------------------------------
#> | 8 | 12 | 0 | 2 | 14 |
#> | | 0.375 | 0 | 0.062 | |
#> | | 0.86 | 0 | 0.14 | 0.44 |
#> | | 0.8 | 0 | 0.4 | |
#> ----------------------------------------------------------------------------
#> | Column Total | 15 | 12 | 5 | 32 |
#> | | 0.468 | 0.375 | 0.155 | |
#> ----------------------------------------------------------------------------
#>
#>
#> cyl vs am
#> -------------------------------------------------------------
#> | | am |
#> -------------------------------------------------------------
#> | cyl | 0 | 1 | Row Total |
#> -------------------------------------------------------------
#> | 4 | 3 | 8 | 11 |
#> | | 0.094 | 0.25 | |
#> | | 0.27 | 0.73 | 0.34 |
#> | | 0.16 | 0.62 | |
#> -------------------------------------------------------------
#> | 6 | 4 | 3 | 7 |
#> | | 0.125 | 0.094 | |
#> | | 0.57 | 0.43 | 0.22 |
#> | | 0.21 | 0.23 | |
#> -------------------------------------------------------------
#> | 8 | 12 | 2 | 14 |
#> | | 0.375 | 0.062 | |
#> | | 0.86 | 0.14 | 0.44 |
#> | | 0.63 | 0.15 | |
#> -------------------------------------------------------------
#> | Column Total | 19 | 13 | 32 |
#> | | 0.594 | 0.406 | |
#> -------------------------------------------------------------
#>
#>
#> gear vs am
#> -------------------------------------------------------------
#> | | am |
#> -------------------------------------------------------------
#> | gear | 0 | 1 | Row Total |
#> -------------------------------------------------------------
#> | 3 | 15 | 0 | 15 |
#> | | 0.469 | 0 | |
#> | | 1 | 0 | 0.47 |
#> | | 0.79 | 0 | |
#> -------------------------------------------------------------
#> | 4 | 4 | 8 | 12 |
#> | | 0.125 | 0.25 | |
#> | | 0.33 | 0.67 | 0.38 |
#> | | 0.21 | 0.62 | |
#> -------------------------------------------------------------
#> | 5 | 0 | 5 | 5 |
#> | | 0 | 0.156 | |
#> | | 0 | 1 | 0.16 |
#> | | 0 | 0.38 | |
#> -------------------------------------------------------------
#> | Column Total | 19 | 13 | 32 |
#> | | 0.594 | 0.406 | |
#> -------------------------------------------------------------
#>
#>