Tables, Labels and Some Useful Functions from Spreadsheets and 'SPSS' Statistics
Overview
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.
- fix CRAN checks
From NEWS in the release
Install
Health
NOTER code for possible problemsr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-devel-windows-x86_64
Found calls to structure() using deprecated special names: expss/tests/testthat/test_category.R (.Names: 4) expss/tests/testthat/test_cro_fun_extended.R (.Names: 1) expss/tests/testthat/test_dichotomy.R (.Dim: 69, .Dimnames: 68, .Names: 17) expss/tests/testthat/test_drop_empty.R (.Names: 1) expss/tests/testthat/test_labels.R (.Names: 3) expss/tests/testthat/test_nest.R (.Names: 18) '.Names' should be changed to 'names'. '.Dim' should be changed to 'dim'. '.Dimnames' should be changed to 'dimnames'.
- NOTE8 OK, 5 NOTENow
- NOTE11 OK, 2 NOTE2026-07-16
- OK14 OK2026-03-10
Documentation
- Help pages
- 61 (1 internal)
- Examples that run
- 82%46 run in a plain check · 10 never run
- Exported functions with examples
- 95%
- Documented parameters
- 98%
- Return-value docs
- 95%
- Help pages citing references
- 0%
Downloads
Repository
- PRs merged (all time)
- 100%
- Median days to close, 50 most recently updated closed issues
- 10
- Median days to close, 50 most recently updated closed PRs
- 0
Stars over time
Forks over time
Releases over time
Issues over time
PRs over time
7 development-tooling and community-health practices detected across 5 families in the upstream repository
Checks run against github.com/gdemin/expss on 2026-10-18.
The R CMD check workflow runs on Windows, and on R-devel
GitHub Pages site last deployed 2025-10-15
Show all practicesHide 1 practice
Dependencies
Installing expss adds 38 packages (22 with compiled code, 38 MB of source tarballs). Heaviest: stringi 11 MB, data.table 5.7 MB, bslib 5.6 MB.
Code & Tests
Datasets
People & History
Pick two releases to compare their code metrics.
- RR 4.6.0 released · 2026-04-24
- 0.11.7Latest
- RR 4.5.0 released · 2025-04-11
- RR 4.4.0 released · 2024-04-24
- 0.11.6
- RR 4.3.0 released · 2023-04-21
- 0.11.42022-11-05 · diff ↗
- 0.11.22022-10-16 · diff ↗
- RR 4.2.0 released · 2022-04-22
- 0.11.12022-01-07 · diff ↗ ·
removed 95 exports
%$%, %<>%, %>%, %add_rows%, %calc%, %calculate%, %merge%, %use_labels%, ref<-, .add_columns, .add_rows, .apply_labels, .calc, .calculate, .compute, .cro, .cro_cases, .cro_cpct, .cro_fun, .cro_fun_df, .cro_mean, .cro_mean_sd_n, .cro_median, .cro_rpct, .cro_sum, .cro_tpct, .do_if, .do_repeat, .except, .fre and 65 moreadded 15 exports
cross_cases, cross_cpct, cross_cpct_responses, cross_fun, cross_fun_df, cross_mean, cross_mean_sd_n, cross_median, cross_pearson, cross_rpct, cross_spearman, cross_sum, cross_tpct, has, weight_by - RR 4.1.0 released · 2021-05-18
- 0.10.7
- 0.10.62020-07-26 · diff ↗ ·
removed 8 exports
%between%, %chin%, %inrange%, %like%, getNumericRounding, set2key, set2keyv, setNumericRounding - 0.10.52020-07-06 · diff ↗
- RR 4.0.0 released · 2020-04-24
- 0.10.22020-03-25 · diff ↗ ·
removed 6 exports
.apply_val_labs, .apply_var_labs, apply_val_labs, apply_var_labs, split_separate, substadded 5 exports
hide, tab_caption, unhide, when, xl_write_file
Show 19 earlier eventsHide 19 earlier events
- 0.10.12019-11-27 · diff ↗ ·
added 6 exports
as_huxtable.etable, expss_fre_stat_lab, expss_output_huxtable, caption<-.etable, as_hux.etable, caption.etable - 0.9.12019-08-25 · diff ↗
- 0.9.02019-07-01 · diff ↗ ·
removed 1 export
by_groupsadded 35 exports
rec<-, and, apply_dictionary, contains, create_dictionary, equals, from_to, greater, greater_or_equal, has_label, is_max, is_min, less, less_or_equal, net, not, not_equals, old_read_labelled_csv, old_write_labelled_csv, or, read_labelled_fst, read_labelled_xlsx, rec, subtotal, tab_net_cells, tab_net_cols, tab_net_rows, tab_subtotal_cells, tab_subtotal_cols, tab_subtotal_rows and 5 more - RR 3.6.0 released · 2019-04-26
- 0.8.112019-04-15 · diff ↗ ·
added 9 exports
..t, cell_chisq, mdset_t, mrset_t, name_dots, qe, significance_cell_chisq, tab_last_sig_cell_chisq, text_expand - 0.8.10
- 0.8.82018-11-11 · diff ↗ ·
removed 12 exports
.dtfrm, .lst, as.dtfrm, dcast, dtfrm, from_text, from_text_csv, from_text_csv2, from_text_tab, from_text_tab2, lst, meltadded 13 exports
add_labelled_class, expss_enable_value_labels_support_extreme, get_caption, is.with_caption, knit_print.with_caption, repr_html.with_caption, set_caption, text_to_columns, text_to_columns_csv, text_to_columns_csv2, text_to_columns_tab, text_to_columns_tab2, xl_write - 0.8.72018-06-14 · diff ↗ ·
removed 1 export
datatableadded 58 exports
%between%, %chin%, %inrange%, %like%, ..f, ..p, .cro_cases, .cro_mean_sd_n, CJ, SJ, between, chgroup, chmatch, chorder, dcast, expss_fix_encoding_off, expss_fix_encoding_on, fintersect, foverlaps, frank, frankv, fsetdiff, fsetequal, fsort, funion, getDTthreads, getNumericRounding, haskey, indices, inrange and 28 more - RR 3.5.0 released · 2018-04-23
- 0.8.62018-01-24 · diff ↗ ·
removed 3 exports
dataTableAjax, dataTableOutput, renderDataTableadded 3 exports
.add_columns, add_columns, as.datatable_widget - 0.8.4
- 0.8.32017-11-07 · diff ↗ ·
added 34 exports
%$%, %<>%, %>%, %has%, as.data.table, calc_cro, calc_cro_cases, calc_cro_cpct, calc_cro_cpct_responses, calc_cro_fun, calc_cro_fun_df, calc_cro_mean, calc_cro_mean_sd_n, calc_cro_median, calc_cro_pearson, calc_cro_rpct, calc_cro_spearman, calc_cro_sum, calc_cro_tpct, data.table, dataTableAjax, dataTableOutput, fread, fwrite, htmlTable, htmlTableWidget, htmlTableWidgetOutput, interactiveTable, is.data.table, renderDataTable and 4 more - 0.8.22017-09-26 · diff ↗ ·
removed 1 export
.setadded 8 exports
.sheet, as.sheet, from_text, from_text_csv, from_text_csv2, from_text_tab, from_text_tab2, sheet - 0.8.12017-08-10 · diff ↗ ·
removed 25 exports
%by_groups%, %compute%, %except%, %in_col%, %in_row%, %keep%, %modify%, %sort_asc%, %sort_desc%, %where%, sort_asc<-, sort_desc<-, .add_val_lab, .internal_to_, .into_helper_, .set_val_lab, .set_var_lab, .with, ml_autonum, ml_left, ml_right, vars_pattern, vars_pattern_list, vars_range, vars_range_listadded 54 exports
%mis_val%, %use_labels%, mis_val<-, .., add_sig_labels, as.etable, as_is, compare_means, compare_proportions, cro_mean_sd_n, drop_all_labels, drop_val_labs, drop_var_labs, expss_digits, expss_disable_value_labels_support, expss_enable_value_labels_support, expss_output_commented, expss_output_default, expss_output_raw, expss_output_rnotebook, expss_output_viewer, get_expss_digits, indirect, indirect_list, is.etable, make_subheadings, mis_val, prepend_all, prepend_names, prepend_values and 24 more - RR 3.4.0 released · 2017-04-21
- 0.7.12017-04-10 · diff ↗ ·
removed 8 exports
category, category_df, dichotomy, dichotomy1, dichotomy1_df, dichotomy_df, dummy_df, fadded 114 exports
%by_groups%, %calc%, %calculate%, %col_in%, %compute%, %into%, %nest%, %row_in%, recode<-, .apply_labels, .apply_val_labs, .apply_var_labs, .calc, .calculate, .do_repeat, .internal_to_, .into_helper_, apply_labels, apply_val_labs, apply_var_labs, as.category, as.criterion, as.dichotomy, autonum, by_groups, calc, calculate, combine_functions, compute, cro_cases and 84 more - 0.5.52016-10-19 · diff ↗ ·
removed 1 export
.filteradded 41 exports
%add_rows%, %except%, %if_na%, %keep%, %merge%, %modify%, %n_d%, %n_i%, %na_if%, %sort_asc%, %sort_desc%, %where%, sort_asc<-, sort_desc<-, .add_rows, .dtfrm, .except, .keep, .lst, .sort_asc, .sort_desc, .where, add_rows, as.labelled, copy, except, from, ge, keep, le and 11 more - 0.5.12016-07-07
- RR 3.3.0 released · 2016-05-03
Package metadata
- First published
- 2016-07-07
- Total releases
- 24 / 10 yrs
- License
- GPL (>= 2) OSI
- Minimum R
- ≥ 3.6.0
- Bundled data
- 1.7 KB / 1 file
- Download size
- 4.8 MB
Cite
Cite this package
Run in R for the authors' preferred citation:
citation("expss")This package has no citation file, so citation() returns this entry built from DESCRIPTION.
Cite the R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
From data release v2026-10-21, which the citation names so these numbers can be found later. More on citing and the projects behind them.