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', 'COMPUTE', 'DO IF', '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

expss function

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

Excel

<ul>
<li>COMPUTE <a rd-options="" href="/link/compute?package=expss&version=0.10.5" data-mini-rdoc="expss::compute">compute</a></li>
<li>RECODE <a rd-options="" href="/link/recode?package=expss&version=0.10.5" data-mini-rdoc="expss::recode">recode</a></li>
<li>COUNT <a rd-options="" href="/link/count_row_if?package=expss&version=0.10.5" data-mini-rdoc="expss::count_row_if">count_row_if</a></li>
<li>DO IF <a rd-options="" href="/link/do_if?package=expss&version=0.10.5" data-mini-rdoc="expss::do_if">do_if</a></li>
<li>DO REPEAT <a rd-options="" href="/link/do_repeat?package=expss&version=0.10.5" data-mini-rdoc="expss::do_repeat">do_repeat</a></li>
<li>VARIABLE LABELS <a rd-options="" href="/link/var_lab?package=expss&version=0.10.5" data-mini-rdoc="expss::var_lab">var_lab</a></li>
<li>VALUE LABELS <a rd-options="" href="/link/val_lab?package=expss&version=0.10.5" data-mini-rdoc="expss::val_lab">val_lab</a></li>
<li>ANY <a rd-options="" href="/link/any_in_row?package=expss&version=0.10.5" data-mini-rdoc="expss::any_in_row">any_in_row</a></li>
<li>FREQUENCIES <a rd-options="" href="/link/fre?package=expss&version=0.10.5" data-mini-rdoc="expss::fre">fre</a></li>
<li>CROSSTABS <a rd-options="" href="/link/cro?package=expss&version=0.10.5" data-mini-rdoc="expss::cro">cro</a></li>
<li>CUSTOM TABLES <a rd-options="" href="/link/tables?package=expss&version=0.10.5" data-mini-rdoc="expss::tables">tables</a></li>
</ul>

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

Description

Arguments

Excel

SPSS