Learn R Programming

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

expss (version 0.8.6)

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.6

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

January 24th, 2018

Functions in expss (0.8.6)

compare_proportions

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

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

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

Create an HTML table widget for usage with Shiny
as.labelled

Recode vector into numeric vector with value labels
by_groups

Aggregate dataset by grouping variable(s).
as.dichotomy

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

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

Add rows to data.frame/matrix/table
apply_labels

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

Experimental functions for operations with default dataset
expss

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

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
expss.options

Options for contolling behaviour of the package
fctr

Convert labelled variable to factor
htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks
if_na

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

Read an SPSS Data File
reexports

Objects exported from other packages
criteria

Criteria functions
cro

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

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

Provides variables description for dataset
prop

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

Create vector of characters from unquoted strings (variable names)
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 rows or columns
ref

Auxiliary functions to pass arguments to function by reference
sum_row

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

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

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

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

Look up values in dictionary.
mrset

Create multiple response set/multiple dichotomy set from variables
na_if

Replace certain values with NA
var_lab

Set or get variable label
vars

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

Merge two tables/data.frames
modify

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

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

Functions for custom tables construction
unlab

Drop variable label and value labels
w_mean

Compute various weighted statistics
where

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

Compute nested variable(-s) from several variables
tab_significance_options

Mark significant differences between columns of the table
sort_asc

Sort data.frames/matrices/vectors
window_fun

Function over grouping variables (window function)
write_labels

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

Cross-tabulation with custom summary function.
default_dataset

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

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

Make data.frame from text
prepend_values

Prepend values/variable names to value/variable labels
product_test

Data from product test of chocolate confectionary
split_labels

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

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

Set or get value labels
values2labels

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