Crosstables for descriptive analyses. See documentation at https://danchaltiel.github.io/crosstable/ and browse code at https://github.com/DanChaltiel/crosstable.
clean_names_with_labels() which clean the names of
the dataframe but keeps the old names as labels. Obviously inspired by
{janitor}.n_col, n_row, and
n_tot available for percent_pattern. Also,
every variable has now its counterpart with the _na suffix
which accounts for missing values. For instance, one can now write: crosstable(mtcars2, cyl, percent_pattern="{p_col} ({n}/{n_col}) [95%CI: {p_col_inf}; {p_col_sup}]")
crosstable(mtcars2, cyl, percent_pattern="{p_col_na} ({n}/{n_col_na}) [95%CI: {p_col_inf}; {p_col_sup}]")percent_pattern can now be a list of characters with
names body, total_row, total_col,
and total_all to also control the pattern in other parts of
the crosstable than the body.crosstable_options() does not need the “crosstable_”
prefix anymore, so the autocomplete is less clumsy. Options with the
prefix will still work though.
crosstable_options(reset=TRUE) is deprecated in favor of
the new crosstable_reset_options().crosstable_test_args() and
crosstable_effect_args() now have arguments to easily
control the non-default parameters.which abs(log10(x))>4. This can be controlled using
options, e.g. crosstable_options(scientific_log=5).body_add_crosstable(allow_break=FALSE) or using
crosstable_options(). This is the pendant of
keepnext in officer/flextable.body_add_crosstable(max_cols=25), which
limits the size of crosstables in Word documents. This prevents very
large tables to be wrongly included.peek() is now usable on non-crosstable objects as well.
as_flextable() method will be applied on the object if
available, otherwise flextable() will be applied.import_labels() when
data_label doesn’t have the right columns.rename_dataframe_with_labels() is now deprecated in
favor of the better named rename_with_labels().compact() is now deprecated in favor of
ct_compact() to avoid the conflict with
purrr::compact(). It will be removed in the next
version.body_add_crosstable(..., parse=NULL) will now work as
intended .by_header can replace the “value” column if
by has only one stratum, in both as_gt() and
as_flextable() (https://github.com/DanChaltiel/crosstable/issues/9).percent_pattern can now contain functions that start by
“p” (https://github.com/DanChaltiel/crosstable/issues/10).percent_pattern is actually taken into account when
by has one single level (https://github.com/DanChaltiel/crosstable/issues/13).import_labels() now works even if there is a missing
value in the dataframe.body_add_normal(): **bold**,
*italic*, _underlined_, and `code`.keep_id argument in
compact.crosstable(), which enables
as_flextable(compact=TRUE, keep_id=TRUE)as_flextable(header_show_n_pattern) to
change the glue pattern of these group sizes. The default is
{.col} (N={.n}); you can use {.col_key} and
{.col_val} when by has multiple strata.body_add_table_legend() and
body_add_figure_legend() earn an argument
legend_prefix. Useful when set through global options, for
instance to make every table/figure start with the name of the
study.crosstable_options() can handle new options for all
those new features.body_add_normal() (it was only doable through options
before).mtcars2 is now a tibble, with its rownames as a
column named “model”.as_flextable(by_header=FALSE) now removes the group
header (if by has only one stratum).as_flextable(header_show_n) now also works if
by has multiple strata.as_flextable(header_show_n=TRUE) adds group size for
all groups.NA value).body_add_normal() to add an
extra empty paragraph if there was a reference in the text.body_add_normal() can be used
without argument.effect=TRUE when some groups were
present in table() but not in glm() due to
missing values.crosstable_options() and autocompletion. Almost every
argument can now be set using options. See
?crosstable_options for further details.crosstable_peek_options() to see which
crosstable option is currently set.num_digits in crosstable().
It was about time!header_show_n for
as_flextable(), which adds the group size
(N=xx) to the header of the flextable.par_before and
par_after in respectively
body_add_table_legend() and
body_add_figure_legend(), which add an empty paragraph
before/after the legend (for readability).body_replace_text_at_bkms(), to replace several bookmarks
at once.crosstable_options(crosstable_zero_percent=FALSE), which
removes percentages whenever n==0 (as it would always be
0%). I should add it as an argument of crosstable() one
day…crosstable() occurring when one of
funs does not have ellipsis (…) and funs_arg
contains an unused argument.percent_pattern in replacement of
crosstable(margin=x) for better control over proportion
format. Introduces the possibility of displaying confidence intervals
(using Wilson score method) along with proportions.body_add_crosstable_list() to add a list
of crosstables all at once, separated by some customizable titles. Also
works with flextables and plain old dataframes.crosstable_padding_v for
as_flextable() to manage vertical padding. Also available
as the global option crosstable_padding_v.crosstable_{arg} for almost all
arguments. See ?crosstable_options for more details.as_flextable() occurring when
showNA=TRUE (header row was disappearing)format_fixed() to return a numeric value (“Error: Can’t
combine ..1$value ..2$value
by when it is
a factormaster to mainby! You can now write
crosstable(mtcars, c(mpg, gear), by=c(am, vs)) %>% as_flextable().generate_autofit_macro() which creates a file that should
then be imported into MS Word.body_add_crosstable() gains a padding_v
argument to control the vertical padding of all rows.body_add_title() and body_add_xxx_legend)
gain a glue functionality. You can now write
body_add_title("The iris dataset (nrow={nrow(iris)})", 1).as_workbook() can now take a named list of crosstables,
that will be considered as sheets.percent in
format_fixed(percent=TRUE/FALSE) to easily format
percentages.style is deprecated in
body_add_table_legend() and
body_add_image_legend() in favor of
name_format.effect calculations that
were done by column instead of rows. That might change some outputs but
not their meaning.body_add_normal() now removes duplicated spaces
(squish) in its input by default. Use squish=FALSE to
override.docx_bookmarks2() gains a target
parameter.effect calculation now takes into account the reference
level (first level of a factor).body_add_crosstable() rightly takes
body_fontsize and header_fontsize into
account.burglr::burgle() to avoid
dependency: nortest::ad.test() and
DescTools::CochranArmitageTest().testthat (https://github.com/DanChaltiel/crosstable/pull/3).funs, especially with
multiple combinations of named and unnamed functions, including lambda
or anonymoussimplify=FALSE in get_label() to get a
list instead of a vector?crosstable_options for the comprehensive list.apply_labels() (inspired by
expss’s), copy_label_from() and
rename_dataframe_with_labels()as_workbook() to export a crosstable as a
formatted openxlsx Excel workbook, for copypasting
purpose.peek() to open a crosstable in a temporary Word
document, as copy-pasting in RStudio’s viewer is very limited.<NA> (missing).funs was not found if
declared in another environment.body_add_figure_legend() and
body_add_table_legend().bookmark argument to set a reference, then write
"\\@ref(my_bkm)" inside body_add_normal() to
call it.body_add_list() and
body_add_list_item(). These will unfortunately not work
with the default officer template.officer
functions:docx_bookmarks2(), which list bookmarks found in the
header and footer as wellbody_add_img2(), and body_add_gg2(), which
win a units=c("in", "cm", "mm") argumentwrite_and_open(), an alternative to
print() for documents, which tries to open it right
away....) use in crosstable() has
been deprecated for a more “tidy” syntax. Write
crosstable(mtcars2, c(disp, vs)) instead of
crosstable(mtcars2, disp, vs). Ellipsis will be defunct in
future v1.0.crosstable(.vars=) has been renamed to
crosstable(cols=).moystd() has been renamed to
meansd().body_add_glued() has been superseded by
body_add_normal(), which inherits all functionalities and
more.gt tables (with
as_gt()) for those who like them better than
flextablesofficer: added
body_add_figure_legend() and fontsize options
for body_add_crosstable()save_labels() to ease working with
dplyrmeanCI() an additional summary function to use in
crosstable()’s funs argumentDate variablesmoystd() to meansd()Date variables. Format
can be specified in funs_arg with the
date_format key.format_fixed(), rounding with the right number of
decimals (including zeros)import_labels(), which apply labels taken from a
source dataframe (name, label) to another dataframemargin="none" option, to remove percentages and
keep only countscross_to_flextable() (ctf()) was
deprecated and renamed as_flextable() (#207)compact()biostat2
package.