Learn R Programming

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

expss (version 0.5.5)

Some Useful Functions from Spreadsheets and 'SPSS' Statistics

Description

Package implements several popular functions from Excel ('COUNTIF', 'VLOOKUP', etc.) and 'SPSS' Statistics ('RECODE', 'COUNT', etc.). Also there are functions for basic tables with value labels/variable labels support. Package aimed 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.5.5

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/gdemin/expss

Maintainer

Gregory Demin

Last Published

October 19th, 2016

Functions in expss (0.5.5)

Recode vector into integer vector with value labels

default_dataset

Get or set reference to default dataset. Experimental feature.

expss: Some Useful Functions from Spreadsheets and SPSS Statistics

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

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

Add rows to data.frame/matrix/table

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

Criteria functions

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

Experimental functions for operations with default dataset

Convert labelled variable to factor

Provides variables description for dataset

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

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

Modify data.frame/conditionally modify data.frame

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

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

Replace certain values with NA

merge.simple_table

Merge two tables/data.frames

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

Drop variable label and value labels

Auxiliary functions to pass arguments to function by reference

Compute proportions from numeric vector/matrix/data.frame

Data from product test of chocolate confectionary

Create vector of characters from unquoted strings (variable names)

Set or get value labels

Sort data.frames/matrices/vectors

Read an SPSS Data File

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

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

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

Set or get variable label

Get range of variables/variables by pattern/by name

Subsetting Data Frames

Look up values in dictionary.

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

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