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.

tabbitR

Weighted crosstabulation tables exported to Excel.

Overview

tabbitR automates the production of large sets of weighted crosstabulation tables and exports them directly to Excel. It is designed for situations where analysts need many tables at once:

• multiple outcome variables
• multiple breakdown (explanatory) variables
• weighted percentages
• unweighted counts
• transparent treatment of missing values.

This is a common and time-consuming task in survey research, monitoring and evaluation work, and exploratory data analysis. Doing it manually is slow, repetitive, and error-prone.

tabbitR solves this by generating a full and consistent set of tables in a single command. For each outcome by breakdown pair, it writes:

• a weighted percentage table
• a matching unweighted N table
• clearly labelled reporting of missing values
• light formatting (headers, borders, bold labels) using {openxlsx}.

User options control:

• number of decimal places
• row vs.column percentages
• whether to show overall % columns or total rows
• how missing responses should be reported
• whether to create one sheet per breakdown variable.

Installation

You can install the development version of tabbitR from GitHub with pak:

install.packages("pak")
pak::pak("smmcandrew/tabbitR")

or with remotes:

remotes::install_github("smmcandrew/tabbitR")

Example

Below is a minimal example using toy data.

library(tabbitR)

df <- data.frame(
  outcome = factor(c("A", "B", "A", NA, "C", NA)),
  sex     = factor(c("Male", "Male", "Female", "Female", "Prefer not to say", "Male")),
  weight  = c(1, 2, 1, 1, 0.75, 3)
)

tabbit_excel(
  data        = df,
  vars        = "outcome",
  breakdown   = "sex",
  wtvar       = "weight",
  file        = "example_output.xlsx",
  decimals    = 2
)

This will create an Excel workbook with a weighted percentage table and unweighted N table for each frequency or breakdown, automatically formatted and labelled.

Development notes

This README is generated from README.Rmd. Use:

devtools::build_readme()

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.