expss

'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.

Package computes and displays tables with support for 'SPSS'-style
labels, multiple and nested banners, weights, multiple-response variables
and significance testing. There are facilities for nice output of tables
in 'knitr', 'Shiny', '*.xlsx' files, R and 'Jupyter' notebooks. Methods
for labelled variables add value labels support to base R functions and to
some functions from other packages. Additionally, the package brings
popular data transformation functions from 'SPSS' Statistics and 'Excel':
'RECODE', 'COUNT', 'COUNTIF', 'VLOOKUP' and etc.
These functions are very useful for data processing in marketing research
surveys. Package intended to help people to move data
processing from 'Excel' and 'SPSS' to R.

Gregory Demin

Tables, Labels and Some Useful Functions from Spreadsheets and
'SPSS' Statistics

Sebastian Jeworutzki

Dan Chaltiel

John Williams

Tom Elliott

expss function

<ul>
<li>IF <a href="/link/ifelse?package=expss&version=0.11.4" data-mini-rdoc="expss::ifelse">ifelse</a></li>
<li>AVERAGE mean_row</li>
<li>SUM sum_row</li>
<li>MIN min_row</li>
<li>MAX max_row</li>
<li>VLOOKUP vlookup</li>
<li>COUNTIF count_if</li>
<li>AVERAGEIF mean_row_if</li>
<li>SUMIF sum_row_if</li>
<li>MINIF min_row_if</li>
<li>MAXIF max_row_if</li>
<li>IFS ifs</li>
<li>IFNA if_na</li>
<li>MATCH match_row</li>
<li>INDEX index_row</li>
<li>PIVOT TABLES tables, cross_fun, cross_cpct</li>
</ul>

Excel

<ul>
<li>RECODE recode</li>
<li>COUNT count_row_if</li>
<li>VARIABLE LABELS var_lab</li>
<li>VALUE LABELS val_lab</li>
<li>ANY any_in_row</li>
<li>FREQUENCIES fre</li>
<li>CROSSTABS cro</li>
<li>CUSTOM TABLES tables</li>
</ul>

SPSS

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

<ul>
<li>IF <a href='https://rdrr.io/r/base/ifelse.html'>ifelse</a></li>
<li>AVERAGE mean_row</li>
<li>SUM sum_row</li>
<li>MIN min_row</li>
<li>MAX max_row</li>
<li>VLOOKUP vlookup</li>
<li>COUNTIF count_if</li>
<li>AVERAGEIF mean_row_if</li>
<li>SUMIF sum_row_if</li>
<li>MINIF min_row_if</li>
<li>MAXIF max_row_if</li>
<li>IFS ifs</li>
<li>IFNA if_na</li>
<li>MATCH match_row</li>
<li>INDEX index_row</li>
<li>PIVOT TABLES tables, cross_fun, cross_cpct</li>
</ul>

<ul>
<li>RECODE recode</li>
<li>COUNT count_row_if</li>
<li>VARIABLE LABELS var_lab</li>
<li>VALUE LABELS val_lab</li>
<li>ANY any_in_row</li>
<li>FREQUENCIES fre</li>
<li>CROSSTABS cro</li>
<li>CUSTOM TABLES tables</li>
</ul>

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

Description

Arguments

Excel

SPSS