Learn R Programming

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

expss (version 0.8.11)

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

9,257

Version

0.8.11

License

GPL (>= 2)

Maintainer

Gregory Demin

Last Published

April 15th, 2019

Functions in expss (0.8.11)

info

Provides variables description for dataset
cro

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

Cross-tabulation with custom summary function.
if_val

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

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

Experimental functions for operations with default dataset
prepend_values

Prepend values/variable names to value/variable labels
count_if

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

Add rows to data.frame/matrix/table
apply_labels

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

Criteria functions
product_test

Data from product test of chocolate confectionary
expss

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

Options for controlling behavior of the package
sort_asc

Sort data.frames/matrices/vectors
default_dataset

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

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

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

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

Merge two tables/data.frames
match_row

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

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

Set or get value labels
htmlTable.etable

Outputting HTML tables in RStudio viewer/R Notebooks
mrset

Create multiple response set/multiple dichotomy set from variables
values2labels

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

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

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

Auxiliary functions to pass arguments to function by reference
set_caption

Add caption to the table
fctr

Convert labelled variable to factor
fre

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

Compute nested variable(-s) from several variables
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
text_to_columns

Make data.frame from text
vectors

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

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

Drop variable label and value labels
na_if

Replace certain values with NA
tables

Functions for custom tables construction
vlookup

Look up values in dictionary.
window_fun

Function over grouping variables (window function)
write_labels

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

Bug workaround
split_labels

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

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

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

Set or get variable label
vars

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

Mark significant differences between columns in the table
w_mean

Compute various weighted statistics
where

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

Write tables and other objects to an xlsx file with formatting
compare_proportions

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

Modify data.frame/modify subset of the data.frame
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'