expss

expss-package


'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 vignette and in help.


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.

Gregory Demin

Some Useful Functions from Spreadsheets and 'SPSS' Statistics

expss function

 <ul>
<li>IF <a rd-options="base" href="/link/ifelse?package=expss&version=0.5.1&to=base" data-mini-rdoc="base::ifelse">ifelse</a>
</li>
<li>AVERAGE <a rd-options="" href="/link/mean_row?package=expss&version=0.5.1" data-mini-rdoc="expss::mean_row">mean_row</a>
</li>
<li>SUM <a rd-options="" href="/link/sum_row?package=expss&version=0.5.1" data-mini-rdoc="expss::sum_row">sum_row</a>
</li>
<li>MIN <a rd-options="" href="/link/min_row?package=expss&version=0.5.1" data-mini-rdoc="expss::min_row">min_row</a>
</li>
<li>MAX <a rd-options="" href="/link/max_row?package=expss&version=0.5.1" data-mini-rdoc="expss::max_row">max_row</a>
</li>
<li>VLOOKUP <a rd-options="" href="/link/vlookup?package=expss&version=0.5.1" data-mini-rdoc="expss::vlookup">vlookup</a>
</li>
<li>COUNTIF <a rd-options="" href="/link/count_if?package=expss&version=0.5.1" data-mini-rdoc="expss::count_if">count_if</a>
</li>
<li>AVERAGEIF <a rd-options="" href="/link/mean_row_if?package=expss&version=0.5.1" 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.5.1" 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.5.1" 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.5.1" data-mini-rdoc="expss::max_row_if">max_row_if</a>
</li>
<li>IFS <a rd-options="" href="/link/ifs?package=expss&version=0.5.1" data-mini-rdoc="expss::ifs">ifs</a>
</li>
<li>IFNA <a rd-options="" href="/link/if_na?package=expss&version=0.5.1" data-mini-rdoc="expss::if_na">if_na</a>
</li>
<li>MATCH <a rd-options="" href="/link/match_row?package=expss&version=0.5.1" data-mini-rdoc="expss::match_row">match_row</a>
</li>
<li>INDEX <a rd-options="" href="/link/index_row?package=expss&version=0.5.1" data-mini-rdoc="expss::index_row">index_row</a>
</li>
</ul> 

Excel

 <ul>
<li>COMPUTE <a rd-options="" href="/link/modify?package=expss&version=0.5.1" data-mini-rdoc="expss::modify">modify</a>
</li>
<li>DO IF <a rd-options="" href="/link/modify_if?package=expss&version=0.5.1" data-mini-rdoc="expss::modify_if">modify_if</a>
</li>
<li>RECODE <a rd-options="" href="/link/if_val?package=expss&version=0.5.1" data-mini-rdoc="expss::if_val">if_val</a>
</li>
<li>COUNT <a rd-options="" href="/link/count_row_if?package=expss&version=0.5.1" data-mini-rdoc="expss::count_row_if">count_row_if</a>
</li>
<li>VARIABLE LABELS <a rd-options="" href="/link/var_lab?package=expss&version=0.5.1" data-mini-rdoc="expss::var_lab">var_lab</a>
</li>
<li>VALUE LABELS <a rd-options="" href="/link/val_lab?package=expss&version=0.5.1" data-mini-rdoc="expss::val_lab">val_lab</a>
</li>
<li>ANY <a rd-options="" href="/link/any_in_row?package=expss&version=0.5.1" data-mini-rdoc="expss::any_in_row">any_in_row</a>
</li>
<li>FREQUENCIES <a rd-options="" href="/link/fre?package=expss&version=0.5.1" data-mini-rdoc="expss::fre">fre</a>
</li>
<li>CROSSTABS <a rd-options="" href="/link/cro?package=expss&version=0.5.1" data-mini-rdoc="expss::cro">cro</a>
</li>
</ul> 

expss: expss: Some Useful Functions from Spreadsheets and SPSS Statistics

Description

Arguments

Excel

SPSS