expss0.11.7 package

Tables, Labels and Some Useful Functions from Spreadsheets and 'SPSS' Statistics

add_columns

Add columns to data.frame.

add_rows

Add rows to data.frame/matrix/table

apply_labels

Set variable labels/value labels on variables in the data.frame

as_huxtable

Convert table to huxtable

as.category

Convert dichotomy data.frame/matrix to data.frame with category encodi...

as.datatable_widget

Create an HTML table widget for usage with Shiny

as.dichotomy

Convert variable (possibly multiple choice question) to data.frame/mat...

as.etable

Convert data.frame/matrix to object of class 'etable'

as.labelled

Recode vector into numeric vector with value labels

compare_proportions

Calculate significance (p-values) of differences between proportions/m...

compute

Modify data.frame/modify subset of the data.frame

count_if

Count/sum/average/other functions on values that meet a criterion

criteria

Criteria functions

cross_cases

Cross tabulation with support of labels, weights and multiple response...

cross_fun

Cross-tabulation with custom summary function.

do_repeat

Repeats the same transformations on a specified set of variables/value...

drop_empty_rows

Drop empty (with all NA's) rows/columns from data.frame/table

expss.options

Options for controlling behavior of the package

expss

expss: Tables with Labels and Some Useful Functions from Spreadsheets ...

fctr

Convert labelled variable to factor

fre

Simple frequencies with support of labels, weights and multiple respon...

htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks

if_na

Replace values with NA and vice-versa

info

Provides variables description for dataset

keep

Keep or drop elements by name/criteria in data.frame/matrix

match_row

Match finds value in rows or columns/index returns value by index from...

merge.etable

Merge two tables/data.frames

mrset

Create multiple response set/multiple dichotomy set from variables

name_dots

Bug workaround

names2labels

Replace data.frame/list names with corresponding variables labels.

nest

Compute nested variable(-s) from several variables

net

Add subtotal to a set of categories

prepend_values

Prepend values/variable names to value/variable labels

prop

Compute proportions from numeric vector/matrix/data.frame

qc

Create vector of characters from unquoted strings (variable names)

read_spss

Read an SPSS Data File

recode

Change, rearrange or consolidate the values of an existing or new vari...

reexports

Objects exported from other packages

set_caption

Add caption to the table

sheet

Make data.frame without conversion to factors and without fixing names

significance

Mark significant differences between columns in the table

sort_asc

Sort data.frames/matrices/vectors

split_by

Splits data.frame into list of data.frames that can be analyzed separa...

split_labels

Split character vector to matrix/split columns in data.frame

sum_row

Compute sum/mean/sd/median/max/min/custom function on rows/columns

tab_sort_asc

Partially (inside blocks) sort tables/data.frames

tables

Functions for custom tables construction

text_to_columns

Make data.frame from text

unlab

Drop variable label and value labels

val_lab

Set or get value labels

values2labels

Replace vector/matrix/data.frame/list values with corresponding value ...

var_lab

Set or get variable label

vars

Get variables/range of variables by name/by pattern.

vectors

Infix operations on vectors - append, diff, intersection, union, repli...

w_mean

Compute various weighted statistics

weight_by

Create dataset according to its frequency weights

where

Subset (filter) data.frames/matrices/vectors/lists

window_fun

Function over grouping variables (window function)

write_labelled_csv

Write labelled data to file or export file to SPSS syntax.

xl_write

Write tables and other objects to an xlsx file with formatting

Package computes and displays tables with support for 'SPSS'-style labels, multiple and nested banners, weights, multiple-response variables and significance testing. There are facilities for nice output of tables in 'knitr', 'Shiny', '*.xlsx' files, R and 'Jupyter' notebooks. Methods for labelled variables add value labels support to base R functions and to some functions from other packages. Additionally, the package brings popular data transformation functions from 'SPSS' Statistics and 'Excel': 'RECODE', 'COUNT', 'COUNTIF', 'VLOOKUP' and etc. These functions are very useful for data processing in marketing research surveys. Package intended to help people to move data processing from 'Excel' and 'SPSS' to R.

  • Maintainer: Gregory Demin
  • License: GPL (>= 2)
  • Last published: 2025-10-15