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


[Up] [Top]

Documentation for package ‘expss’ version 0.11.6

Help Pages

A C D E F G H I K L M N O P Q R S T U V W X misc

-- A --

add_columns Add columns to data.frame.
add_labelled_class Set or get variable label
add_rows Add rows to data.frame/matrix/table
add_rows.data.frame Add rows to data.frame/matrix/table
add_sig_labels Mark significant differences between columns in the table
add_val_lab Set or get value labels
add_val_lab<- Set or get value labels
all_in_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
all_in_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
and Criteria functions
any_in_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
any_in_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
apply_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
apply_col_if Count/sum/average/other functions on values that meet a criterion
apply_dictionary Write labelled data to file or export file to SPSS syntax.
apply_labels Set variable labels/value labels on variables in the data.frame
apply_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
apply_row_if Count/sum/average/other functions on values that meet a criterion
as.category Convert dichotomy data.frame/matrix to data.frame with category encoding
as.criterion Criteria functions
as.datatable_widget Create an HTML table widget for usage with Shiny
as.datatable_widget.etable Create an HTML table widget for usage with Shiny
as.datatable_widget.with_caption Create an HTML table widget for usage with Shiny
as.dichotomy Convert variable (possibly multiple choice question) to data.frame/matrix of dummy variables.
as.etable Convert data.frame/matrix to object of class 'etable'
as.labelled Recode vector into numeric vector with value labels
as.sheet Make data.frame without conversion to factors and without fixing names
as_hux.etable Convert table to huxtable
as_huxtable.etable Convert table to huxtable
as_is Repeats the same transformations on a specified set of variables/values
autonum Set or get value labels

-- C --

calc Modify data.frame/modify subset of the data.frame
calculate Modify data.frame/modify subset of the data.frame
calc_cro Cross tabulation with support of labels, weights and multiple response variables.
calc_cro_cases Cross tabulation with support of labels, weights and multiple response variables.
calc_cro_cpct Cross tabulation with support of labels, weights and multiple response variables.
calc_cro_cpct_responses Cross tabulation with support of labels, weights and multiple response variables.
calc_cro_fun Cross-tabulation with custom summary function.
calc_cro_fun_df Cross-tabulation with custom summary function.
calc_cro_mean Cross-tabulation with custom summary function.
calc_cro_mean_sd_n Cross-tabulation with custom summary function.
calc_cro_median Cross-tabulation with custom summary function.
calc_cro_pearson Cross-tabulation with custom summary function.
calc_cro_rpct Cross tabulation with support of labels, weights and multiple response variables.
calc_cro_spearman Cross-tabulation with custom summary function.
calc_cro_sum Cross-tabulation with custom summary function.
calc_cro_tpct Cross tabulation with support of labels, weights and multiple response variables.
cell_chisq Mark significant differences between columns in the table
combine_functions Cross-tabulation with custom summary function.
compare_means Calculate significance (p-values) of differences between proportions/means
compare_proportions Calculate significance (p-values) of differences between proportions/means
compute Modify data.frame/modify subset of the data.frame
contains Criteria functions
copy Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
count_col_if Count/sum/average/other functions on values that meet a criterion
count_if Count/sum/average/other functions on values that meet a criterion
count_row_if Count/sum/average/other functions on values that meet a criterion
create_dictionary Write labelled data to file or export file to SPSS syntax.
criteria Criteria functions
cro Cross tabulation with support of labels, weights and multiple response variables.
cross_cases Cross tabulation with support of labels, weights and multiple response variables.
cross_cpct Cross tabulation with support of labels, weights and multiple response variables.
cross_cpct_responses Cross tabulation with support of labels, weights and multiple response variables.
cross_fun Cross-tabulation with custom summary function.
cross_fun_df Cross-tabulation with custom summary function.
cross_mean Cross-tabulation with custom summary function.
cross_mean_sd_n Cross-tabulation with custom summary function.
cross_median Cross-tabulation with custom summary function.
cross_pearson Cross-tabulation with custom summary function.
cross_rpct Cross tabulation with support of labels, weights and multiple response variables.
cross_spearman Cross-tabulation with custom summary function.
cross_sum Cross-tabulation with custom summary function.
cross_tpct Cross tabulation with support of labels, weights and multiple response variables.
cro_cases Cross tabulation with support of labels, weights and multiple response variables.
cro_cpct Cross tabulation with support of labels, weights and multiple response variables.
cro_cpct_responses Cross tabulation with support of labels, weights and multiple response variables.
cro_fun Cross-tabulation with custom summary function.
cro_fun_df Cross-tabulation with custom summary function.
cro_mean Cross-tabulation with custom summary function.
cro_mean_sd_n Cross-tabulation with custom summary function.
cro_median Cross-tabulation with custom summary function.
cro_pearson Cross-tabulation with custom summary function.
cro_rpct Cross tabulation with support of labels, weights and multiple response variables.
cro_spearman Cross-tabulation with custom summary function.
cro_sum Cross-tabulation with custom summary function.
cro_tpct Cross tabulation with support of labels, weights and multiple response variables.

-- D --

do_if Modify data.frame/modify subset of the data.frame
do_repeat Repeats the same transformations on a specified set of variables/values
drop_all_labels Drop variable label and value labels
drop_c Drop empty (with all NA's) rows/columns from data.frame/table
drop_empty_columns Drop empty (with all NA's) rows/columns from data.frame/table
drop_empty_rows Drop empty (with all NA's) rows/columns from data.frame/table
drop_r Drop empty (with all NA's) rows/columns from data.frame/table
drop_rc Drop empty (with all NA's) rows/columns from data.frame/table
drop_unused_labels Set or get value labels
drop_val_labs Set or get value labels
drop_var_labs Set or get variable label
dummy Convert variable (possibly multiple choice question) to data.frame/matrix of dummy variables.
dummy1 Convert variable (possibly multiple choice question) to data.frame/matrix of dummy variables.

-- E --

eq Criteria functions
equals Criteria functions
except Keep or drop elements by name/criteria in data.frame/matrix
expss expss: Tables with Labels and Some Useful Functions from Spreadsheets and SPSS Statistics
expss.options Options for controlling behavior of the package
expss_digits Options for controlling behavior of the package
expss_disable_value_labels_support Options for controlling behavior of the package
expss_enable_value_labels_support Options for controlling behavior of the package
expss_enable_value_labels_support_extreme Options for controlling behavior of the package
expss_fix_encoding_off Options for controlling behavior of the package
expss_fix_encoding_on Options for controlling behavior of the package
expss_fre_stat_lab Options for controlling behavior of the package
expss_output_commented Options for controlling behavior of the package
expss_output_default Options for controlling behavior of the package
expss_output_huxtable Options for controlling behavior of the package
expss_output_raw Options for controlling behavior of the package
expss_output_rnotebook Options for controlling behavior of the package
expss_output_viewer Options for controlling behavior of the package
expss_round_half_to_even Options for controlling behavior of the package

-- F --

fctr Convert labelled variable to factor
fixed Criteria functions
fre Simple frequencies with support of labels, weights and multiple response variables.
from Criteria functions
from_to Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.

-- G --

ge Criteria functions
get_caption Add caption to the table
get_expss_digits Options for controlling behavior of the package
get_expss_rounding Options for controlling behavior of the package
greater Criteria functions
greater_or_equal Criteria functions
gt Criteria functions
gte Criteria functions

-- H --

has Count/sum/average/other functions on values that meet a criterion
has_label Criteria functions
hi Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
hide Add subtotal to a set of categories
htmlTable.etable Outputting HTML tables in RStudio viewer/R Notebooks
htmlTable.list Outputting HTML tables in RStudio viewer/R Notebooks
htmlTable.with_caption Outputting HTML tables in RStudio viewer/R Notebooks

-- I --

ifs Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
if_na Replace values with NA and vice-versa
if_na<- Replace values with NA and vice-versa
if_val Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
if_val<- Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
index_col Match finds value in rows or columns/index returns value by index from rows or columns
index_row Match finds value in rows or columns/index returns value by index from rows or columns
indirect Get variables/range of variables by name/by pattern.
indirect_list Get variables/range of variables by name/by pattern.
info Provides variables description for dataset
is.category Convert dichotomy data.frame/matrix to data.frame with category encoding
is.criterion Criteria functions
is.dichotomy Convert variable (possibly multiple choice question) to data.frame/matrix of dummy variables.
is.etable Convert data.frame/matrix to object of class 'etable'
is.labelled Recode vector into numeric vector with value labels
is.with_caption Add caption to the table
is_max Criteria functions
is_min Criteria functions
is_na Criteria functions
items Criteria functions

-- K --

keep Keep or drop elements by name/criteria in data.frame/matrix
knit_print.etable Outputting HTML tables in RStudio viewer/R Notebooks
knit_print.with_caption Outputting HTML tables in RStudio viewer/R Notebooks

-- L --

lab_num Set or get value labels
le Criteria functions
less Criteria functions
less_or_equal Criteria functions
like Criteria functions
lo Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
lt Criteria functions
lte Criteria functions

-- M --

make_labels Set or get value labels
make_subheadings Split character vector to matrix/split columns in data.frame
match_col Match finds value in rows or columns/index returns value by index from rows or columns
match_row Match finds value in rows or columns/index returns value by index from rows or columns
max_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
max_col_if Count/sum/average/other functions on values that meet a criterion
max_if Count/sum/average/other functions on values that meet a criterion
max_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
max_row_if Count/sum/average/other functions on values that meet a criterion
mdset Create multiple response set/multiple dichotomy set from variables
mdset_f Create multiple response set/multiple dichotomy set from variables
mdset_p Create multiple response set/multiple dichotomy set from variables
mdset_t Create multiple response set/multiple dichotomy set from variables
mean_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
mean_col_if Count/sum/average/other functions on values that meet a criterion
mean_if Count/sum/average/other functions on values that meet a criterion
mean_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
mean_row_if Count/sum/average/other functions on values that meet a criterion
median_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
median_col_if Count/sum/average/other functions on values that meet a criterion
median_if Count/sum/average/other functions on values that meet a criterion
median_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
median_row_if Count/sum/average/other functions on values that meet a criterion
merge.etable Merge two tables/data.frames
min_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
min_col_if Count/sum/average/other functions on values that meet a criterion
min_if Count/sum/average/other functions on values that meet a criterion
min_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
min_row_if Count/sum/average/other functions on values that meet a criterion
mis_val Replace values with NA and vice-versa
mis_val<- Replace values with NA and vice-versa
modify Modify data.frame/modify subset of the data.frame
modify_if Modify data.frame/modify subset of the data.frame
mrset Create multiple response set/multiple dichotomy set from variables
mrset_f Create multiple response set/multiple dichotomy set from variables
mrset_p Create multiple response set/multiple dichotomy set from variables
mrset_t Create multiple response set/multiple dichotomy set from variables

-- N --

n2l Replace data.frame/list names with corresponding variables labels.
names2labels Replace data.frame/list names with corresponding variables labels.
name_dots Bug workaround
na_if Replace values with NA and vice-versa
na_if<- Replace values with NA and vice-versa
ne Criteria functions
neq Criteria functions
nest Compute nested variable(-s) from several variables
net Add subtotal to a set of categories
not Criteria functions
not_equals Criteria functions
not_na Criteria functions
num_lab Set or get value labels
n_diff Infix operations on vectors - append, diff, intersection, union, replication
n_intersect Infix operations on vectors - append, diff, intersection, union, replication

-- O --

old_read_labelled_csv Write labelled data to file or export file to SPSS syntax.
old_write_labelled_csv Write labelled data to file or export file to SPSS syntax.
or Criteria functions
other Criteria functions

-- P --

perl Criteria functions
prepend_all Prepend values/variable names to value/variable labels
prepend_names Prepend values/variable names to value/variable labels
prepend_values Prepend values/variable names to value/variable labels
product_test Data from product test of chocolate confectionary
prop Compute proportions from numeric vector/matrix/data.frame
prop_col Compute proportions from numeric vector/matrix/data.frame
prop_row Compute proportions from numeric vector/matrix/data.frame

-- Q --

qc Create vector of characters from unquoted strings (variable names)
qe Create vector of characters from unquoted strings (variable names)

-- R --

read_labelled_csv Write labelled data to file or export file to SPSS syntax.
read_labelled_csv2 Write labelled data to file or export file to SPSS syntax.
read_labelled_fst Write labelled data to file or export file to SPSS syntax.
read_labelled_tab Write labelled data to file or export file to SPSS syntax.
read_labelled_tab2 Write labelled data to file or export file to SPSS syntax.
read_labelled_xlsx Write labelled data to file or export file to SPSS syntax.
read_spss Read an SPSS Data File
read_spss_to_list Read an SPSS Data File
rec Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
rec<- Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
recode Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
recode<- Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
regex Criteria functions
repr_html.etable Outputting HTML tables in RStudio viewer/R Notebooks
repr_html.with_caption Outputting HTML tables in RStudio viewer/R Notebooks
repr_text.etable Outputting HTML tables in RStudio viewer/R Notebooks
repr_text.with_caption Outputting HTML tables in RStudio viewer/R Notebooks

-- S --

sd_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
sd_col_if Count/sum/average/other functions on values that meet a criterion
sd_if Count/sum/average/other functions on values that meet a criterion
sd_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
sd_row_if Count/sum/average/other functions on values that meet a criterion
set_caption Add caption to the table
set_val_lab Set or get value labels
set_var_lab Set or get variable label
sheet Make data.frame without conversion to factors and without fixing names
significance Mark significant differences between columns in the table
significance_cases Mark significant differences between columns in the table
significance_cell_chisq Mark significant differences between columns in the table
significance_cpct Mark significant differences between columns in the table
significance_means Mark significant differences between columns in the table
sort_asc Sort data.frames/matrices/vectors
sort_desc Sort data.frames/matrices/vectors
split_by Splits data.frame into list of data.frames that can be analyzed separately
split_columns Split character vector to matrix/split columns in data.frame
split_labels Split character vector to matrix/split columns in data.frame
split_off Splits data.frame into list of data.frames that can be analyzed separately
split_table_to_df Split character vector to matrix/split columns in data.frame
subtotal Add subtotal to a set of categories
sum_col Compute sum/mean/sd/median/max/min/custom function on rows/columns
sum_col_if Count/sum/average/other functions on values that meet a criterion
sum_if Count/sum/average/other functions on values that meet a criterion
sum_row Compute sum/mean/sd/median/max/min/custom function on rows/columns
sum_row_if Count/sum/average/other functions on values that meet a criterion

-- T --

tables Functions for custom tables construction
tab_caption Functions for custom tables construction
tab_cells Functions for custom tables construction
tab_cols Functions for custom tables construction
tab_last_add_sig_labels Mark significant differences between columns in the table
tab_last_hstack Functions for custom tables construction
tab_last_round Mark significant differences between columns in the table
tab_last_sig_cases Mark significant differences between columns in the table
tab_last_sig_cell_chisq Mark significant differences between columns in the table
tab_last_sig_cpct Mark significant differences between columns in the table
tab_last_sig_means Mark significant differences between columns in the table
tab_last_vstack Functions for custom tables construction
tab_mis_val Functions for custom tables construction
tab_net_cells Add subtotal to a set of categories
tab_net_cols Add subtotal to a set of categories
tab_net_rows Add subtotal to a set of categories
tab_pivot Functions for custom tables construction
tab_prepend_all Prepend values/variable names to value/variable labels
tab_prepend_names Prepend values/variable names to value/variable labels
tab_prepend_values Prepend values/variable names to value/variable labels
tab_rows Functions for custom tables construction
tab_row_label Functions for custom tables construction
tab_significance_options Mark significant differences between columns in the table
tab_sort_asc Partially (inside blocks) sort tables/data.frames
tab_sort_desc Partially (inside blocks) sort tables/data.frames
tab_stat_cases Functions for custom tables construction
tab_stat_cpct Functions for custom tables construction
tab_stat_cpct_responses Functions for custom tables construction
tab_stat_fun Functions for custom tables construction
tab_stat_fun_df Functions for custom tables construction
tab_stat_max Functions for custom tables construction
tab_stat_mean Functions for custom tables construction
tab_stat_mean_sd_n Functions for custom tables construction
tab_stat_median Functions for custom tables construction
tab_stat_min Functions for custom tables construction
tab_stat_rpct Functions for custom tables construction
tab_stat_sd Functions for custom tables construction
tab_stat_se Functions for custom tables construction
tab_stat_sum Functions for custom tables construction
tab_stat_tpct Functions for custom tables construction
tab_stat_unweighted_valid_n Functions for custom tables construction
tab_stat_valid_n Functions for custom tables construction
tab_subgroup Functions for custom tables construction
tab_subtotal_cells Add subtotal to a set of categories
tab_subtotal_cols Add subtotal to a set of categories
tab_subtotal_rows Add subtotal to a set of categories
tab_total_label Functions for custom tables construction
tab_total_row_position Functions for custom tables construction
tab_total_statistic Functions for custom tables construction
tab_transpose Functions for custom tables construction
tab_weight Functions for custom tables construction
text_to_columns Make data.frame from text
text_to_columns_csv Make data.frame from text
text_to_columns_csv2 Make data.frame from text
text_to_columns_tab Make data.frame from text
text_to_columns_tab2 Make data.frame from text
thru Criteria functions
to Criteria functions
total Cross tabulation with support of labels, weights and multiple response variables.

-- U --

unhide Add subtotal to a set of categories
unlab Drop variable label and value labels
unvl Set or get value labels
unvr Set or get variable label
unweighted_valid_n Compute various weighted statistics
use_labels Modify data.frame/modify subset of the data.frame

-- V --

v2l Replace vector/matrix/data.frame/list values with corresponding value labels.
valid Replace values with NA and vice-versa
valid_n Compute various weighted statistics
values2labels Replace vector/matrix/data.frame/list values with corresponding value labels.
value_col_if Match finds value in rows or columns/index returns value by index from rows or columns
value_row_if Match finds value in rows or columns/index returns value by index from rows or columns
val_lab Set or get value labels
val_lab<- Set or get value labels
vars Get variables/range of variables by name/by pattern.
vars_list Get variables/range of variables by name/by pattern.
var_lab Set or get variable label
var_lab<- Set or get variable label
vectors Infix operations on vectors - append, diff, intersection, union, replication
v_diff Infix operations on vectors - append, diff, intersection, union, replication
v_intersect Infix operations on vectors - append, diff, intersection, union, replication
v_union Infix operations on vectors - append, diff, intersection, union, replication
v_xor Infix operations on vectors - append, diff, intersection, union, replication

-- W --

weight_by Create dataset according to its frequency weights
when Criteria functions
where Subset (filter) data.frames/matrices/vectors/lists
window_fun Function over grouping variables (window function)
write_labelled_csv Write labelled data to file or export file to SPSS syntax.
write_labelled_csv2 Write labelled data to file or export file to SPSS syntax.
write_labelled_fst Write labelled data to file or export file to SPSS syntax.
write_labelled_spss Write labelled data to file or export file to SPSS syntax.
write_labelled_tab Write labelled data to file or export file to SPSS syntax.
write_labelled_tab2 Write labelled data to file or export file to SPSS syntax.
write_labelled_xlsx Write labelled data to file or export file to SPSS syntax.
write_labels Write labelled data to file or export file to SPSS syntax.
write_labels_spss Write labelled data to file or export file to SPSS syntax.
w_cor Compute various weighted statistics
w_cov Compute various weighted statistics
w_mad Compute various weighted statistics
w_max Compute various weighted statistics
w_mean Compute various weighted statistics
w_median Compute various weighted statistics
w_min Compute various weighted statistics
w_n Compute various weighted statistics
w_pearson Compute various weighted statistics
w_sd Compute various weighted statistics
w_se Compute various weighted statistics
w_spearman Compute various weighted statistics
w_sum Compute various weighted statistics
w_var Compute various weighted statistics

-- X --

xl_write Write tables and other objects to an xlsx file with formatting
xl_write.default Write tables and other objects to an xlsx file with formatting
xl_write.etable Write tables and other objects to an xlsx file with formatting
xl_write.list Write tables and other objects to an xlsx file with formatting
xl_write.with_caption Write tables and other objects to an xlsx file with formatting
xl_write_file Write tables and other objects to an xlsx file with formatting

-- misc --

%a% Infix operations on vectors - append, diff, intersection, union, replication
%col_in% Count/sum/average/other functions on values that meet a criterion
%d% Infix operations on vectors - append, diff, intersection, union, replication
%e% Infix operations on vectors - append, diff, intersection, union, replication
%has% Count/sum/average/other functions on values that meet a criterion
%i% Infix operations on vectors - append, diff, intersection, union, replication
%if_na% Replace values with NA and vice-versa
%into% Change, rearrange or consolidate the values of an existing or new variable. Inspired by the RECODE command from SPSS.
%mis_val% Replace values with NA and vice-versa
%na_if% Replace values with NA and vice-versa
%nest% Compute nested variable(-s) from several variables
%n_d% Infix operations on vectors - append, diff, intersection, union, replication
%n_i% Infix operations on vectors - append, diff, intersection, union, replication
%r% Infix operations on vectors - append, diff, intersection, union, replication
%row_in% Count/sum/average/other functions on values that meet a criterion
%thru% Criteria functions
%to% Get variables/range of variables by name/by pattern.
%to_list% Get variables/range of variables by name/by pattern.
%u% Infix operations on vectors - append, diff, intersection, union, replication
.. Get variables/range of variables by name/by pattern.
..f Get variables/range of variables by name/by pattern.
..p Get variables/range of variables by name/by pattern.
..t Get variables/range of variables by name/by pattern.