Learn R Programming

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

expss (version 0.8.8)

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

9,257

Version

0.8.8

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

November 11th, 2018

Functions in expss (0.8.8)

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

as.datatable_widget

Create an HTML table widget for usage with Shiny

Recode vector into numeric vector with value labels

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

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

Aggregate dataset by grouping variable(s).

drop_empty_rows

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

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

Criteria functions

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

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

compare_proportions

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

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

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

Cross-tabulation with custom summary function.

default_dataset

Get or set reference to default dataset. Experimental feature.

Replace certain values with NA

Experimental functions for operations with default dataset

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

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

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

Add rows to data.frame/matrix/table

Objects exported from other packages

htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks

Provides variables description for dataset

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

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

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

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

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

Auxiliary functions to pass arguments to function by reference

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

Options for controlling behavior of the package

Create multiple response set/multiple dichotomy set from variables

Data from product test of chocolate confectionary

Compute nested variable(-s) from several variables

tab_significance_options

Mark significant differences between columns of the table

Sort data.frames/matrices/vectors

Set or get variable label

Prepend values/variable names to value/variable labels

Compute proportions from numeric vector/matrix/data.frame

Add caption to the table

Create vector of characters from unquoted strings (variable names)

Set or get value labels

text_to_columns

Make data.frame from text

Drop variable label and value labels

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

Read an SPSS Data File

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

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

Functions for custom tables construction

Partially (inside blocks) sort tables/data.frames

Convert labelled variable to factor

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

Look up values in dictionary.

Merge two tables/data.frames

Write tables and other objects to an xlsx file with formatting

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

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

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

Function over grouping variables (window function)

Compute various weighted statistics