expss: Some Useful Functions from Spreadsheets and 'SPSS' Statistics

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.

AuthorGregory Demin
Date of publication2016-10-19 00:39:24
MaintainerGregory Demin <gdemin@gmail.com>
LicenseGPL (>= 2)
Version0.5.5
https://github.com/gdemin/expss

View on CRAN

Man pages

add_rows: Add rows to data.frame/matrix/table

as.labelled: Recode vector into integer vector with value labels

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

compute: Experimental functions for operations with default dataset

count_if: Count/sum/average/other functions on values that meet a...

criteria: Criteria functions

default_dataset: Get or set reference to default dataset. Experimental...

dichotomy: Convert variable (possibly multiple choice question) to...

dtfrm: Make data.frame without conversion to factors and without...

expss: expss: Some Useful Functions from Spreadsheets and SPSS...

f: Convert labelled variable to factor

fre: Simple frequencies and crosstabs with support of labels,...

if_na: Replace NA values in vector/data.frame/matrix/list with...

if_val: Change, rearrange or consolidate the values of an...

info: Provides variables description for dataset

keep: Keep or drop elements by name/criteria in...

match_row: Match finds value in rows or columns/index returns value by...

merge.simple_table: Merge two tables/data.frames

modify: Modify data.frame/conditionally modify data.frame

na_if: Replace certain values with NA

names2labels: Replace data.frame/list names with corresponding variables...

product_test: Data from product test of chocolate confectionary

prop: Compute proportions from numeric vector/matrix/data.frame

qc: Create vector of characters from unquoted strings (variable...

read_spss: Read an SPSS Data File

ref: Auxiliary functions to pass arguments to function by...

sort_asc: Sort data.frames/matrices/vectors

sum_row: Compute sum/mean/sd/median/max/min/custom function on...

unlab: Drop variable label and value labels

val_lab: Set or get value labels

values2labels: Replace vector/matrix/data.frame/list values with...

var_lab: Set or get variable label

vars_range: Get range of variables/variables by pattern/by name

vectors: Infix operations on vectors - append, diff, intersection,...

vlookup: Look up values in dictionary.

where: Subsetting Data Frames

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

Files in this package

expss
expss/inst
expss/inst/doc
expss/inst/doc/UsageExamples.html
expss/inst/doc/UsageExamples.Rmd
expss/inst/doc/UsageExamples.R
expss/tests
expss/tests/testthat
expss/tests/testthat/test_methods.R
expss/tests/testthat/test_prop.R
expss/tests/testthat/rds
expss/tests/testthat/rds/cro4r.rds
expss/tests/testthat/rds/cro_fun8.rds
expss/tests/testthat/rds/cro2.rds
expss/tests/testthat/rds/info1.rds
expss/tests/testthat/rds/cro_real4t.rds
expss/tests/testthat/rds/lm_dichotomy_default2.rds
expss/tests/testthat/rds/cro_fun12.rds
expss/tests/testthat/rds/lm_names2labels_1.rds
expss/tests/testthat/rds/cro_fun_df11.rds
expss/tests/testthat/rds/lm_names2labels_2.rds
expss/tests/testthat/rds/cro_real4r.rds
expss/tests/testthat/rds/fre_real2.rds
expss/tests/testthat/rds/cro_fun11.rds
expss/tests/testthat/rds/cro_real6wt.rds
expss/tests/testthat/rds/cro_fun9.rds
expss/tests/testthat/rds/elem_fre3.rds
expss/tests/testthat/rds/category3.rds
expss/tests/testthat/rds/cro_sum3.rds
expss/tests/testthat/rds/elem_fre19.rds
expss/tests/testthat/rds/cro_median2.rds
expss/tests/testthat/rds/add_rows6.rds
expss/tests/testthat/rds/cro_mean_out.txt
expss/tests/testthat/rds/elem_fre14.rds
expss/tests/testthat/rds/elem_fre10.rds
expss/tests/testthat/rds/cro_fun7.rds
expss/tests/testthat/rds/elem_fre8.rds
expss/tests/testthat/rds/data.rds
expss/tests/testthat/rds/cro4t.rds
expss/tests/testthat/rds/info5.rds
expss/tests/testthat/rds/add_rows10.rds
expss/tests/testthat/rds/elem_fre12.rds
expss/tests/testthat/rds/cro_fun15.rds
expss/tests/testthat/rds/cro5.rds
expss/tests/testthat/rds/add_rows6b.rds
expss/tests/testthat/rds/cro_fun14.rds
expss/tests/testthat/rds/elem_fre7.rds
expss/tests/testthat/rds/cro_fun4.rds
expss/tests/testthat/rds/cro_mean3.rds
expss/tests/testthat/rds/elem_fre4.rds
expss/tests/testthat/rds/add_rows1.rds
expss/tests/testthat/rds/cro_median1.rds
expss/tests/testthat/rds/fre_ex1.rds
expss/tests/testthat/rds/category4.rds
expss/tests/testthat/rds/lm_dichotomy_default.rds
expss/tests/testthat/rds/merge12.rds
expss/tests/testthat/rds/merge11.rds
expss/tests/testthat/rds/elem_fre1.rds
expss/tests/testthat/rds/cro_fun2.rds
expss/tests/testthat/rds/add_rows4.rds
expss/tests/testthat/rds/fre_ex5.rds
expss/tests/testthat/rds/cro_real6wr.rds
expss/tests/testthat/rds/cro_real6.rds
expss/tests/testthat/rds/fre_real3w.rds
expss/tests/testthat/rds/category2.rds
expss/tests/testthat/rds/fre2.7.rds
expss/tests/testthat/rds/category1.rds
expss/tests/testthat/rds/add_rows6a.rds
expss/tests/testthat/rds/merge10.rds
expss/tests/testthat/rds/cro_fun3.rds
expss/tests/testthat/rds/cro_fun10.rds
expss/tests/testthat/rds/fre_ex4.rds
expss/tests/testthat/rds/lm_names2labels_3.rds
expss/tests/testthat/rds/info10.rds
expss/tests/testthat/rds/merge8.rds
expss/tests/testthat/rds/fre_ex3.3.rds
expss/tests/testthat/rds/info12.rds
expss/tests/testthat/rds/add_rows3.rds
expss/tests/testthat/rds/fre_out_unrounded.txt
expss/tests/testthat/rds/brands_df_cat2.rds
expss/tests/testthat/rds/cro3.rds
expss/tests/testthat/rds/cro_fun5.rds
expss/tests/testthat/rds/fre_ex2.rds
expss/tests/testthat/rds/fre_ex6.rds
expss/tests/testthat/rds/cro_real1.rds
expss/tests/testthat/rds/merge9.rds
expss/tests/testthat/rds/brands.rds
expss/tests/testthat/rds/cro_real6w.rds
expss/tests/testthat/rds/cro_sum5.rds
expss/tests/testthat/rds/cro_real2w.rds
expss/tests/testthat/rds/fre_out.txt
expss/tests/testthat/rds/cro_mean4.rds
expss/tests/testthat/rds/brands_df_cat.rds
expss/tests/testthat/rds/cro_mean8.rds
expss/tests/testthat/rds/cro_real1w.rds
expss/tests/testthat/rds/info3.rds
expss/tests/testthat/rds/category5.rds
expss/tests/testthat/rds/info13.rds
expss/tests/testthat/rds/info8.rds
expss/tests/testthat/rds/fre2.5.rds
expss/tests/testthat/rds/cro_fun_df1.rds
expss/tests/testthat/rds/add_rows2.rds
expss/tests/testthat/rds/elem_fre11.rds
expss/tests/testthat/rds/fre_ex3.rds
expss/tests/testthat/rds/elem_fre6.rds
expss/tests/testthat/rds/nsk.rds
expss/tests/testthat/rds/cro_mean6.rds
expss/tests/testthat/rds/elem_fre5.rds
expss/tests/testthat/rds/fre_ex3.1.rds
expss/tests/testthat/rds/elem_fre17.rds
expss/tests/testthat/rds/cro_fun_df2.rds
expss/tests/testthat/rds/fre_real2w.rds
expss/tests/testthat/rds/cro_real3.rds
expss/tests/testthat/rds/cro_sum8.rds
expss/tests/testthat/rds/cro_real4w.rds
expss/tests/testthat/rds/cro_real2.rds
expss/tests/testthat/rds/add_rows9.rds
expss/tests/testthat/rds/cro4.rds
expss/tests/testthat/rds/cro_median8.rds
expss/tests/testthat/rds/merge7.rds
expss/tests/testthat/rds/elem_fre9.rds
expss/tests/testthat/rds/elem_fre16.rds
expss/tests/testthat/rds/add_rows5.rds
expss/tests/testthat/rds/cro_fun13.rds
expss/tests/testthat/rds/fre_real1w.rds
expss/tests/testthat/rds/info9.rds
expss/tests/testthat/rds/cro1.rds
expss/tests/testthat/rds/add_rows8.rds
expss/tests/testthat/rds/info2.rds
expss/tests/testthat/rds/brands_df.rds
expss/tests/testthat/rds/elem_fre18.rds
expss/tests/testthat/rds/info6.rds
expss/tests/testthat/rds/elem_fre20.rds
expss/tests/testthat/rds/info4.rds
expss/tests/testthat/rds/fre2.rds
expss/tests/testthat/rds/elem_fre13.rds
expss/tests/testthat/rds/fre_ex3.2.rds
expss/tests/testthat/rds/cro_real3w.rds
expss/tests/testthat/rds/elem_fre2.rds
expss/tests/testthat/rds/fre1.rds
expss/tests/testthat/rds/cro_fun6.rds
expss/tests/testthat/rds/elem_fre15.rds
expss/tests/testthat/rds/cro_sum6.rds
expss/tests/testthat/rds/fre2.6.rds
expss/tests/testthat/rds/cro_fun1.rds
expss/tests/testthat/rds/fre_real1.rds
expss/tests/testthat/rds/add_rows7.rds
expss/tests/testthat/rds/cro_sum1.rds
expss/tests/testthat/rds/cro_mean5.rds
expss/tests/testthat/rds/cro_real4.rds
expss/tests/testthat/rds/cro_mean1.rds
expss/tests/testthat/rds/cro_mean2.rds
expss/tests/testthat/rds/fre_real3.rds
expss/tests/testthat/rds/cro_real5.rds
expss/tests/testthat/rds/cro_sum4.rds
expss/tests/testthat/rds/category2df.rds
expss/tests/testthat/rds/info7.rds
expss/tests/testthat/rds/info11.rds
expss/tests/testthat/rds/cro_real5w.rds
expss/tests/testthat/test_dtfrm.R
expss/tests/testthat/test_sum_if_excel_examples.R
expss/tests/testthat/test_count_if.R
expss/tests/testthat/test_experimental.R
expss/tests/testthat/test_f.R
expss/tests/testthat/test_set.R
expss/tests/testthat/test_dichotomy.R
expss/tests/testthat/test_ref.R
expss/tests/testthat/test_vec_ops.R
expss/tests/testthat/test_sort.R
expss/tests/testthat/test_vlookup.R
expss/tests/testthat/test_keep.R
expss/tests/testthat/test_match.R
expss/tests/testthat/test_if_val.R
expss/tests/testthat/test_names2labels.R
expss/tests/testthat/test_where.R
expss/tests/testthat/test_if_na.R
expss/tests/testthat/test_selectors.R
expss/tests/testthat/test_subst.R
expss/tests/testthat/test_sum.R
expss/tests/testthat/test_mean_if.R
expss/tests/testthat/test_category.R
expss/tests/testthat/test_criteria_functions.R
expss/tests/testthat/test_values2labels.R
expss/tests/testthat/test_labels.R
expss/tests/testthat/test_default_dataset.R
expss/tests/testthat/test_add_rows.R
expss/tests/testthat/test_fre.R
expss/tests/testthat/test_modify.R
expss/tests/testthat/test_info.R
expss/tests/testthat/test_write_labels.R
expss/tests/testthat/test_merge.R
expss/tests/testthat/test_if_val_with_na.R
expss/tests/testthat/test_sum_if.R
expss/tests/testthat/test_na_if.R
expss/NAMESPACE
expss/NEWS
expss/data
expss/data/product_test.RData
expss/R
expss/R/modify.R expss/R/criteria_functions.R expss/R/utils.R expss/R/info.R expss/R/prop.R expss/R/read_spss.R expss/R/write_labels.R expss/R/selectors.R expss/R/category.R expss/R/if_na.R expss/R/dtfrm.R expss/R/count_if.R expss/R/zzz_experimental.R expss/R/product_test.R expss/R/sum.R expss/R/sort.R expss/R/vlookup.R expss/R/S3_methods.R expss/R/expss.R expss/R/names2labels.R expss/R/values2labels.R expss/R/where.R expss/R/if_val.R expss/R/f.R expss/R/labels.R expss/R/fre.R expss/R/keep.R expss/R/ref.R expss/R/merge.R expss/R/add_rows.R expss/R/vec_ops.R expss/R/default_dataset.R expss/R/dichotomy.R expss/R/na_if.R expss/R/match.R expss/R/qc.R
expss/vignettes
expss/vignettes/UsageExamples.Rmd
expss/MD5
expss/build
expss/build/vignette.rds
expss/DESCRIPTION
expss/man
expss/man/prop.Rd expss/man/vectors.Rd expss/man/modify.Rd expss/man/names2labels.Rd expss/man/where.Rd expss/man/write_labels.Rd expss/man/keep.Rd expss/man/default_dataset.Rd expss/man/val_lab.Rd expss/man/vlookup.Rd expss/man/add_rows.Rd expss/man/qc.Rd expss/man/unlab.Rd expss/man/ref.Rd expss/man/read_spss.Rd expss/man/values2labels.Rd expss/man/dtfrm.Rd expss/man/sum_row.Rd expss/man/dichotomy.Rd expss/man/criteria.Rd expss/man/product_test.Rd expss/man/expss.Rd expss/man/compute.Rd expss/man/fre.Rd expss/man/category.Rd expss/man/var_lab.Rd expss/man/merge.simple_table.Rd expss/man/if_na.Rd expss/man/if_val.Rd expss/man/as.labelled.Rd expss/man/sort_asc.Rd expss/man/info.Rd expss/man/count_if.Rd expss/man/vars_range.Rd expss/man/na_if.Rd expss/man/match_row.Rd expss/man/f.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

All documentation is copyright its authors; we didn't write any of that.