Learn R Programming

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

expss (version 0.8.7)

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', R notebooks, 'Shiny' and 'Jupyter' notebooks. 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.7

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

June 14th, 2018

Functions in expss (0.8.7)

experimental

Experimental functions for operations with default dataset
qc

Create vector of characters from unquoted strings (variable names)
criteria

Criteria functions
cro

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

Compute proportions from numeric vector/matrix/data.frame
default_dataset

Get or set reference to default dataset. Experimental feature.
info

Provides variables description for dataset
match_row

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

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

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

Data from product test of chocolate confectionary
cro_fun

Cross-tabulation with custom summary function.
expss

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

Prepend values/variable names to value/variable labels
sum_row

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

Convert labelled variable to factor
mrset

Create multiple response set/multiple dichotomy set from variables
if_na

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

Outputting HTML tables in RStudio viewer/R Notebooks
fre

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

Merge two tables/data.frames
modify

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

Partially (inside blocks) sort tables/data.frames
val_lab

Set or get value labels
values2labels

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

Sort data.frames/matrices/vectors
na_if

Replace certain values with NA
tab_significance_options

Mark significant differences between columns of the table
names2labels

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

Function over grouping variables (window function)
read_spss

Read an SPSS Data File
from_text

Make data.frame from text
ref

Auxiliary functions to pass arguments to function by reference
nest

Compute nested variable(-s) from several variables
reexports

Objects exported from other packages
tables

Functions for custom tables construction
write_labels

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

Drop variable label and value labels
split_by

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

Compute various weighted statistics
sheet

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

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

Set or get variable label
split_labels

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

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

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

Look up values in dictionary.
apply_labels

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

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

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

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

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

Create an HTML table widget for usage with Shiny
add_rows

Add rows to data.frame/matrix/table
by_groups

Aggregate dataset by grouping variable(s).
count_if

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

Recode vector into numeric vector with value labels
drop_empty_rows

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

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

Options for controlling behavior of the package