expss: expss: Tables with Labels and Some Useful Functions from...

expssR Documentation

expss: Tables with Labels and Some Useful Functions from Spreadsheets and SPSS Statistics

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, cross_fun, cross_cpct

SPSS

  • RECODE recode

  • COUNT count_row_if

  • VARIABLE LABELS var_lab

  • VALUE LABELS val_lab

  • ANY any_in_row

  • FREQUENCIES fre

  • CROSSTABS cro

  • CUSTOM TABLES tables


expss documentation built on July 26, 2023, 5:23 p.m.