Learn R Programming

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

expss (version 0.5.1)

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

10,894

Version

0.5.1

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Maintainer

Gregory Demin

Last Published

July 7th, 2016

Functions in expss (0.5.1)

expss

expss: Some Useful Functions from Spreadsheets and SPSS Statistics
dichotomy

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

Criteria functions
default_dataset

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

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

Experimental functions for operations with default dataset
count_if

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

Convert labelled variable to factor
fre

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

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

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

Provides variables description for dataset
names2labels

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

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

Read an SPSS Data File
if_na

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

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

Modify data.frame/conditionally modify data.frame
na_if

Replace certain values with NA
product_test

Data from product test of chocolate confectionary
ref

Auxiliary functions to pass arguments to function by reference
val_lab

Set or get value labels
write_labels

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

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

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

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

Drop variable label and value labels
vlookup

Look up values in dictionary.
vectors

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

Set or get variable label