The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

tsg

CRAN status R-CMD-check

The tsg (Table and Summary Generator) package provides functions for generating publication-ready frequency tables and cross-tabulations from data frames. Tables can be exported to Excel (XLSX), HTML, PDF, and Word (DOCX) formats with extensive styling options via a unified facade system.

Installation

install.packages("tsg")

Excel output works out of the box. The other formats need packages that are not installed with tsg; write_html(), write_pdf(), write_docx() and write_gsheet() offer to install them the first time you use them, or install them yourself:

install.packages("gt")                       # HTML
install.packages(c("gt", "webshot2"))        # PDF (plus qpdf to combine tables into one file)
install.packages(c("officer", "flextable"))  # Word
install.packages("googledrive")              # Google Sheets

Basic usage

library(tsg)

# Frequency table
generate_frequency(person_record, sex)

# Cross-tabulation
generate_crosstab(person_record, marital_status, sex)

# Summary statistics of numeric variables
generate_summary(person_record, age)

Output formats

tbl <- person_record |>
  generate_crosstab(marital_status, sex)

# Excel
write_xlsx(tbl, "table.xlsx")

# HTML
write_html(tbl, "table.html")

# PDF
write_pdf(tbl, "table.pdf")   # requires webshot2

# Word
write_docx(tbl, "table.docx")

# Google Sheets
write_gsheet(tbl, "Marital status by sex")   # requires googledrive

Styling with facades

The facade system controls table appearance uniformly across all output formats:

person_record |>
  generate_frequency(sex) |>
  add_facade(
    header.fgFill = "#003366",
    header.fontColour = "#FFFFFF",
    header.textDecoration = "bold",
    body.fontSize = 11,
    table.lastRowBold = TRUE
  ) |>
  write_xlsx("styled.xlsx")

Built-in facades are "default", "yolo", "apa", "booktabs", "striped", "gridded", "minimal", "financial", "nyt", "jama", "dark", "pastel" and "census":

write_xlsx(tbl, "booktabs.xlsx", facade = "booktabs")

More examples in the vignettes.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.