Description

'expss' package implements some popular functions from spreadsheets and SPSS Statistics software. Implementations are not complete copies of their originals. I try to make them consistent with other R functions. See examples in the vignette and in the help.

Excel

• IF ifelse

• AVERAGE mean_row

• SUM sum_row

• MIN min_row

• MAX max_row

• VLOOKUP vlookup

• COUNTIF count_if

• AVERAGEIF mean_row_if

• SUMIF sum_row_if

• MINIF min_row_if

• MAXIF max_row_if

• IFS ifs

• IFNA if_na

• MATCH match_row

• INDEX index_row

• PIVOT TABLES tables, cro_fun, cro

SPSS

• COMPUTE compute

• RECODE recode

• COUNT count_row_if

• DO IF do_if

• DO REPEAT do_repeat

• VARIABLE LABELS var_lab

• VALUE LABELS val_lab

• ANY any_in_row

• FREQUENCIES fre

• CROSSTABS cro

• CUSTOM TABLES tables