Learn R Programming

⚠️There's a newer version (0.11.6) of this package.Take me there.

expss (version 0.10.5)

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

Description

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', 'COMPUTE', 'DO IF', '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.

Copy Link

Version

Install

install.packages('expss')

Monthly Downloads

8,547

Version

0.10.5

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

July 6th, 2020

Functions in expss (0.10.5)

as.datatable_widget

Create an HTML table widget for usage with Shiny

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

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

Recode vector into numeric vector with value labels

compare_proportions

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

Add rows to data.frame/matrix/table

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

Convert variable (possibly multiple choice question) to data.frame/matrix of dummy variables.

as_huxtable.etable

Convert table to huxtable

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

default_dataset

Get or set reference to default dataset. Experimental feature.

Options for controlling behavior of the package

expss: Tables with Labels and Some Useful Functions from Spreadsheets and SPSS Statistics

drop_empty_rows

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

Experimental functions for operations with default dataset

Repeats the same transformations on a specified set of variables/values

Cross-tabulation with custom summary function.

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

Create multiple response set/multiple dichotomy set from variables

Merge two tables/data.frames

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

htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks

Replace values with NA and vice-versa

Prepend values/variable names to value/variable labels

Compute proportions from numeric vector/matrix/data.frame

Add subtotal to a set of categories

Convert labelled variable to factor

Data from product test of chocolate confectionary

Provides variables description for dataset

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

Criteria functions

Simple frequencies with support of labels, weights and multiple response variables.

Auxiliary functions to pass arguments to function by reference

Sort data.frames/matrices/vectors

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

Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.

tab_significance_options

Mark significant differences between columns in the table

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

Set or get value labels

Read an SPSS Data File

Create vector of characters from unquoted strings (variable names)

Partially (inside blocks) sort tables/data.frames

Add caption to the table

Functions for custom tables construction

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

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

Look up values in dictionary.

Function over grouping variables (window function)

Infix operations on vectors - append, diff, intersection, union, replication

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

Compute nested variable(-s) from several variables

Drop variable label and value labels

text_to_columns

Make data.frame from text

write_labelled_csv

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

Set or get variable label

Write tables and other objects to an xlsx file with formatting

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

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

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

Objects exported from other packages

Compute various weighted statistics

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