Learn R Programming

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

expss (version 0.8.10)

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

Description

Package provides tabulation functions with support for 'SPSS'-style labels, multiple / nested banners, weights, multiple-response variables and significance testing. There are facilities for nice output of tables in 'knitr', 'Shiny', R and 'Jupyter' notebooks, '*.xlsx' files. Proper methods for labelled variables add value labels support to base R functions and to some functions from other packages. Additionally, the package offers useful functions for data processing in marketing research / social surveys - popular data transformation functions from 'SPSS' Statistics ('RECODE', 'COUNT', 'COMPUTE', 'DO IF', etc.) and 'Excel' ('COUNTIF', 'VLOOKUP', etc.). Package is intended to help people to move data processing from 'Excel'/'SPSS' to R.

Copy Link

Version

Install

install.packages('expss')

Monthly Downloads

10,894

Version

0.8.10

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

December 11th, 2018

Functions in expss (0.8.10)

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

Merge two tables/data.frames

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

Recode vector into numeric vector with value labels

Create vector of characters from unquoted strings (variable names)

Read an SPSS Data File

tab_significance_options

Mark significant differences between columns of the table

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

Sort data.frames/matrices/vectors

as.datatable_widget

Create an HTML table widget for usage with Shiny

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

Criteria functions

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

Set or get variable label

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

Write data with labels to file in R code or in SPSS syntax.

Write tables and other objects to an xlsx file with formatting

htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks

Aggregate dataset by grouping variable(s).

Options for controlling behavior of the package

Add rows to data.frame/matrix/table

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

Cross-tabulation with custom summary function.

Convert labelled variable to factor

Replace certain values with NA

default_dataset

Get or set reference to default dataset. Experimental feature.

Replace NA values in vector/data.frame/matrix/list with supplied value

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

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

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

Provides variables description for dataset

Objects exported from other packages

Data from product test of chocolate confectionary

Add caption to the table

Compute proportions from numeric vector/matrix/data.frame

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

Partially (inside blocks) sort tables/data.frames

Look up values in dictionary.

Compute various weighted statistics

compare_proportions

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

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

Auxiliary functions to pass arguments to function by reference

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

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

Experimental functions for operations with default dataset

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

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

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

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

Function over grouping variables (window function)

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

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

Create multiple response set/multiple dichotomy set from variables

Compute nested variable(-s) from several variables

Prepend values/variable names to value/variable labels

Functions for custom tables construction

text_to_columns

Make data.frame from text

Drop variable label and value labels

Set or get value labels

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

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

drop_empty_rows

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