How to exclude cumulative and total proportions from tables generated with `freq` function in R?

Question

I'm using the freq function from the summarytools package to create frequency tables in RStudio.

It doesn't seem possible to turn off the cumulative and total percentage columns in the tables. For example:

library(summarytools)
data(mtcars)
view(freq(mtcars$cyl, totals=FALSE, cumul=FALSE))

still produces a table containing duplicate cumulative and total percentage columns. All I need is a table with the variable values, count #, and percentage.

I've tried resetting the global options with st_options(freq.cumul = FALSE, freq.totals = FALSE) but receive an error message:

Error in st_options(freq.cumul = FALSE, freq.totals = FALSE) : 
  unused arguments (freq.cumul = FALSE, freq.totals = FALSE)

UPDATE

Finally figured it out - I wasn't using enough arguments in the freq function. The following code produces a decent frequency table:

cyl_freq <- freq(mtcars$cyl, report.nas = FALSE, totals=FALSE, cumul=FALSE, style = "rmarkdown", headings = FALSE);
view(cyl_freq)

and if you need to create a bunch of tables across multiple columnsmultiple_:

multiple_freq <- lapply(mtcars[c(2,8:11)], function(x) freq(x, report.nas = FALSE, totals=FALSE, cumul=FALSE, headings = FALSE));
view(multiple_freq)

@Matt Still doesn't work - but does assigning the `freq` output to `df` work for you? — RobertF, Jul 01 '19 at 16:52
`view(freq(mtcars$cyl, totals = FALSE, cumul = FALSE))` works for me. — Matt, Jul 01 '19 at 17:03
@Matt Yea `freq` is a function in the `summarytools` package. Hmm interesting that it works for you but not me. — RobertF, Jul 01 '19 at 17:06

Matt · Answer 1 · 2019-07-01T17:57:31.377

1

This isn't using the summarytools package, but I think this may be what you're looking for.

frtable <- table(mtcars$cyl)

percent <- prop.table(frtable)

dt <- cbind(frtable , percent) %>% set_colnames(c("Count", "Percent"))

DT::datatable(dt) %>% DT::formatPercentage('percent')

edited Jul 01 '19 at 17:57

answered Jul 01 '19 at 17:45

Matt

2,947
1
9
21

This a step in the right direction, is there a way to view `dt` as a table? – RobertF Jul 01 '19 at 19:07
Not sure what you mean exactly, you can use `View(dt)` to see it in Rstudio, or simply `dt` to view interactively. – Matt Jul 01 '19 at 19:17
Thanks for your help! I just discovered a simple solution - I wasn't using enough arguments in the `freq` function. – RobertF Jul 01 '19 at 19:41

score 1 · Answer 2 · answered Dec 10 '20 at 13:32

Seems you found how to make it work... Just as a tip, you can skip the lapply part. So this should work as expected:

library(summarytools)
freq(mtcars[c(2,8:11)], 
     report.nas=FALSE, totals=FALSE, cumul=FALSE, headings=FALSE)

There was an issue where the cumul argument didn't register when doing this in versions prior to 0.9.8, but it's fixed. Version 0.9.8 will be on CRAN any day now, but you can always install the latest version from GitHub with remotes::install_github("dcomtois/summarytools")

How to exclude cumulative and total proportions from tables generated with `freq` function in R?

2 Answers2