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.

Functions

\%a\% Man page
.add_rows Man page
\%add_rows\% Man page
add_rows Man page
add_rows.data.frame Man page
.add_val_lab Man page
add_val_lab Man page
add_val_lab<- Man page
all_in_col Man page
all_in_row Man page
any_in_col Man page
any_in_row Man page
apply_col Man page
apply_col_if Man page
apply_row Man page
apply_row_if Man page
as.dtfrm Man page
as.labelled Man page
category Man page
category_df Man page
compute Man page
.compute Man page
copy Man page
count_col_if Man page
count_if Man page
count_row_if Man page
criteria Man page
cro Man page
.cro Man page
.cro_cpct Man page
cro_cpct Man page
.cro_fun Man page
cro_fun Man page
.cro_fun_df Man page
cro_fun_df Man page
.cro_mean Man page
cro_mean Man page
.cro_median Man page
cro_median Man page
.cro_rpct Man page
cro_rpct Man page
.cro_sum Man page
cro_sum Man page
.cro_tpct Man page
cro_tpct Man page
\%d\% Man page
default_dataset Man page
dichotomy Man page
dichotomy1 Man page
dichotomy1_df Man page
dichotomy_df Man page
.do_if Man page
dtfrm Man page
.dtfrm Man page
dummy Man page
dummy_df Man page
\%e\% Man page
eq Man page
except Man page
.except Man page
\%except\% Man page
expss Man page
expss-package Man page
f Man page
fixed Man page
fre Man page
.fre Man page
from Man page
ge Man page
gt Man page
gte Man page
hi Man page
\%i\% Man page
\%if_na\% Man page
if_na Man page
if_na<- Man page
ifs Man page
.if_val Man page
if_val Man page
if_val<- Man page
\%in_col\% Man page
index_col Man page
index_row Man page
info Man page
\%in_row\% Man page
keep Man page
.keep Man page
\%keep\% Man page
le Man page
lo Man page
lst Man page
.lst Man page
lt Man page
lte Man page
make_labels Man page
match_col Man page
match_row Man page
max_col Man page
max_col_if Man page
max_if Man page
max_row Man page
max_row_if Man page
mean_col Man page
mean_col_if Man page
mean_if Man page
mean_row Man page
mean_row_if Man page
median_col Man page
median_col_if Man page
median_if Man page
median_row Man page
median_row_if Man page
\%merge\% Man page
merge.simple_table Man page
min_col Man page
min_col_if Man page
min_if Man page
min_row Man page
min_row_if Man page
ml_autonum Man page
ml_left Man page
ml_right Man page
modify Man page
.modify Man page
\%modify\% Man page
.modify_if Man page
modify_if Man page
n2l Man page
\%na_if\% Man page
na_if Man page
na_if<- Man page
names2labels Man page
\%n_d\% Man page
ne Man page
neq Man page
\%n_i\% Man page
not_na Man page
other Man page
perl Man page
product_test Man page
prop Man page
prop_col Man page
prop_row Man page
qc Man page
\%r\% Man page
read_labelled_csv Man page
read_spss Man page
read_spss_to_list Man page
.recode Man page
ref Man page
ref<- Man page
regex Man page
sd_col Man page
sd_col_if Man page
sd_if Man page
sd_row Man page
sd_row_if Man page
.set Man page
.set_val_lab Man page
set_val_lab Man page
.set_var_lab Man page
set_var_lab Man page
.sort_asc Man page
\%sort_asc\% Man page
sort_asc Man page
sort_asc<- Man page
.sort_desc Man page
\%sort_desc\% Man page
sort_desc Man page
sort_desc<- Man page
subst Man page
sum_col Man page
sum_col_if Man page
sum_if Man page
sum_row Man page
sum_row_if Man page
thru Man page
\%thru\% Man page
to Man page
\%to\% Man page
\%to_list\% Man page
\%u\% Man page
unlab Man page
unvl Man page
unvr Man page
v2l Man page
.val_lab Man page
val_lab Man page
val_lab<- Man page
values2labels Man page
.var_lab Man page
var_lab Man page
var_lab<- Man page
vars Man page
vars_list Man page
vars_pattern Man page
vars_pattern_list Man page
vars_range Man page
vars_range_list Man page
vectors Man page
vlookup Man page
vlookup_df Man page
where Man page
.where Man page
\%where\% Man page
.with Man page
write_labelled_csv Man page
write_labelled_spss Man page
write_labels Man page
write_labels_spss Man page

Files

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.

Please suggest features or report bugs with the GitHub issue tracker.

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