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.

Author
Gregory Demin
Date of publication
2016-10-19 00:39:24
Maintainer
Gregory Demin <gdemin@gmail.com>
License
GPL (>= 2)
Version
0.5.5
URLs

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