NEWS

---

expss 0.11.6 (2023-07-15)

• add 'as_spss' argument to 'significance_cpct' for more SPSS-compatible results (issue #100)
• add rounding option (issue #100)
• fix bug with duplicated columns labels in tab_pivot(stat_position = 'inside_columns') (issue #102)

expss 0.11.4 (2022-11-05)

• fix disastrous bug which prevent package installation for R version before 4.2 (many thanks to Tom Elliott)

expss 0.11.2 (2022-10-16)

• fix for new R version

expss 0.11.1 (2022-01-07)

• add 'weight_by' - function for "brute force" frequency weighting
• 'read_spss' now exposes 'use_missings' argument from foreign::read.spss
• 'apply_labels' now can accept list with variable and value labels
• 'calc_cro_*'s are renamed to more clear 'cross_'s
• 'compute', 'do_if', 'where' and 'calc' are deprecated in favor of the 'maditr' package. 'maditr' is thin layer above fastest data manipulation package 'data.table'

expss 0.10.7 (2020-11-15)

• fix compatibility with SPSS in 'w_median' function (issue #72)
• fix bug with incorrect labelling some cases in 'recode' (issue #73)
• 'default_dataset' functionality is deprecated
• 'apply_labels' now respects data.table (and assign labels by reference for data.table)
• 'not', 'or', 'and', 'when' now respects criteria functions

expss 0.10.6 (2020-07-26)

• fix for new data.table version (issue #67). Thanks to John Williams.
• fix dplyr behaviour (issues #65, #68)

expss 0.10.5 (2020-07-06)

• add argument 'default' for 'var_lab' function (issue #60). Thanks to Dan Chaltiel
• fixes for new versions of R, htmlTable, huxtable

expss 0.10.3

• very minor fix: revert back default method for 'set_caption'

expss 0.10.2 (2020-03-25)

• fixes for R4.0
• new vignette with examples
• add functions 'hide' and 'unhide' for selective hiding and showing categories in 'net' and 'subtotal'
• now logical don't have special meaning in the 'recode'. If you use this functionality than use 'when' instead. recode(y, x>5 ~ 1) need to be replaced with recode(y, when(x>5) ~ 1).
• add 'xl_write_file' for quick export tables to Excel file
• Add 'tab_caption' - alias for 'set_caption'

expss 0.10.1 (2019-11-27)

• output to PDF, Word via huxtable package (thanks to Sebastian Jeworutzki). See 'as_hux' and 'expss_output_huxtable'.
• bugfixes

expss 0.9.1 (2019-08-25)

• fix vignette for new 'reformulate'
• fix recode for list recodings. Now c(1, 5 %thru% 99) ~ 999 works properly.
• 'subtotal' and 'net' produce consistent ordering of subototal items (thanks Roberto Gilsaura for extensive testing)
• 'subtotal' and 'net' allow overlapping categories

expss 0.9.0 (2019-07-01)

• add 'subtotal' and 'net' functions. See '?net'.
• 'recode' now can recode value labels to keep them consistent with values (see argument 'with_labels')
• add alias 'rec' to recode with argument 'with_labels = TRUE' by default
• now you can assign new labels in 'recode' ("TOP" = 4:5 ~ 5)
• improve 'recode' performance
• simplify 'recode' behavior. Now RHS and LHS part in the recoding formula should be single column object. However, you can still recode entire data.frame or list.
• improve preformance of 'sum_row', 'mean_row', 'median_row' and etc.
• change labelled 'csv' format. Now labels are stored in the same file as data. Labels are located in the commented lines at the begining of the file. Inspite of changing format, 'read_labelled_csv' should detect and read the old format automatically.
• add new functions: 'read_labelled_xlsx' and 'write_labelled_xlsx'. Now you can save and restore labelled data to Excel file. Labels are stored on the separate sheet.
• add new functions: 'read_labelled_fst' and 'write_labelled_fst' for storing data in the 'fst' format (https://www.fstpackage.org/). With this format you can read and write a huge amount of labelled data very quickly.
• Small bugfixes.

expss 0.8.11 (2019-04-15)

• UPDATE IS REQUIRED. fixes for R>=3.6 and data.table >=1.12.2.
• now htmlTable respects 'align' argument (Issue #20)
• fix 'add_labelled_class' for 'haven' 2.0
• improve SPSS syntax in 'write_labelled_spss'
• add new significance test - 'significance_cell_chisq'/'tab_last_sig_cell_chisq'. Idea by Roberto Gilsaura.
• now 'significance_cases' has new argument 'correct' for Yates' correction. By default it is TRUE
• add 'qe' function for making list of expressions
• ..$ selector now supports arbitrary expression
• fix bug in 'cro_mean_sd_n with incorrect weighted valid n in some cases
• Numerous small bugfixes

expss 0.8.10 (2018-12-11)

• 'nest' - more consistent behaviour for 'a %nest% list(x, y, z)'
• 'split_off' now respects data.table and etable classes
• 'xl_write' supports functions in 'additional_cells_formats' argument

expss 0.8.8 (2018-11-11)

• add '*.xlsx' export for tables via 'openxlsx' package. See ?xl_write
• add 'set_caption' function and support for it in 'htmlTable', 'as.datatable_widget' and *.xlsx export
• add function 'expss_enable_value_labels_support_extreme'
• small bugfixes and performance improvement
• 'from_text' renamed to 'text_to_columns'
• 'by_groups' is deprecated now. Use 'take' from 'maditr' instead.
• 'dtfrm'/'as.dtfrm' are finally removed. Use 'sheet'/'as.sheet' instead
• 'lst'/'.lst' are removed

expss 0.8.7 (2018-06-14)

• fix long-standing bug with broken html rendering in knitr (issue #6)
• add '..p' and '..f' - perl regular expression/fixed pattern selectors. Also 'mrset_p', 'mrset_f', 'mdset_p', 'mdset_f' are provided.
• add ..data shortcut for entire data.frame in 'use_labels'
• fix awful bug with incorrect nesting multiple response on multiple response ('nest' function)
• more exports from data.table
• fix 'add_columns' for data.table
• fix 'do_if' for data.table
• fix 'w_cor' - now diag elements always equal to one
• add 'split_by' - alias for 'split_separate'

expss 0.8.6 (2018-01-24)

• fix tests for systems with no long doubles support
• new arguments and small improvements in 'write_labelled_csv'/'write_labelled_sps'
• minor fixes
• change 'vlookup'/'vlookup_df' behavior - now it also matches on NA
• 'datatable' is deprecated. Use as.datatable_widget instead.
• move DT and htmltools dependencies from Imports to Suggests
• new function 'add_columns' which is inspired by MATCH FILES (Add variables...) from SPSS Statistics

expss 0.8.4 (2017-12-10)

• compatibility with new version of htmlTable package
• minor fixes

expss 0.8.3 (2017-11-06)

• add 'calc_cro_*' functions family
• minor fixes
• compatibility with new version of 'testthat' package

expss 0.8.2 (2017-09-26)

• fix bug with single column "mrset"
• fix bug with significance tests on tables with complex headers
• add uboxing possibilities for ..[] (..[] = list/data.frame will create separate variables from that list/data.frame)
• add 'text_to_columns' for creation data.frame from text lines
• improve performance of 'cro_*'
• remove deprecated function ".set"

expss 0.8.1 (2017-08-10)

• add significance testing (see ?significance)
• add support for table output for Jupyter notebooks
• add 'use_labels' function for experimental support variable labels in base R functions and third party packages (see ?use_labels)
• increase table functions performance
• increase 'as.dichotomy'/'dummy' performance
• increase 'vlookup'/'vlookup_df' performance
• numerous bugfixes
• now 'keep'/'except'/'by_groups' operate with NSE. For standard evaluation just surround you variable with round brackets
• add print options 'commented' for printing tables to console with '#'
• add functions 'split_separate'/'split_off'
• add 'prepend_names'/'prepend_labels' - issue #2
• add 'indirect'/'indirect_list' - aliases for 'vars'/'vars_list'
• add 'mis_val' - alias for 'na_if'
• add 'unsafe' argument for *_fun/*_fun_df.
• add '..' object for parameter substitution inside 'compute' and etc. Usage: '..$param_name'. For details: ?..
• improve 'lst' function
• '.set'/'set' inside 'compute' and etc. are deprecated. Use '%into%' instead.
• expansion of variables in backticks inside 'vars'/'vars_list'/'%into%' is removed. Use explicit 'subst' instead
• infix/assignment versions removed: '%modify%', '%compute%', '%sort_asc%', '%sort_desc%', '%keep%', '%except%', '%where%', '%by_groups%'

expss 0.7.1 (2017-04-09)

• make value labels support in the base R and other packages (via 'factor' for class 'labelled')
• radically improved performace for 'cro_*' and 'fre_*' due to 'data.table' under the hood
• multiple/nested banners/variables suppport in 'cro_*'
• add 'datatable' for tables representation in Shiny
• add 'htmlTables' for tables representation in RStudio viewer and for knitting to html
• add methods for 'where' for vectors/matrices/lists
• less cryptic message about bad number of rows in 'modify'/'modify_if'
• .N now is preferable to .n inside 'modify' and etc.
• Functions for default dataset now invisibly return modified default dataset
• Fix logical arguments in boolean operations for criteria functions
• '%in_row%'/'%in_col%' are deprecated. Use '%row_in%'/'%col_in%' instead.
• NULL argument for criterion is removed. Use 'not_na' instead.
• remove 'default' argument in 'ifs'. Use TRUE ~ default_value instead.
• add usual vectors functions additionally to infix versions.
• add 'do_repeat' function
• add functions for weighted statistics - 'w_mean', 'w_median', 'w_cor' and etc.
• add 'nest' function for creation nested tables.
• remove 'category', 'category_df' - use 'as.category' instead
• remove 'dichotomy', 'dichotomy1' - use 'dummy', 'dummy1' instead
• remove 'dichotomy_df', 'dichotomy_df1' - use 'as.dichotomy' instead
• remove labelled matrix support
• bugfixes

expss 0.5.5 (2016-10-19)

• numerous bugfixes
• change behavior of ‘if_val()' - now it dowsn’t copies old values by default. There are 'other' and 'copy' instead of dots.
• add '%n_i%', '%n_d%' - names intersection and diffs
• add 'add_rows' function
• add 'keep' and 'except' functions for selecting/dropping columns in data.frames
• add 'where' for filtering dataset
• add 'sort_asc' and 'sort_desc' functions for sorting data.frames

expss 0.5.1 (2016-07-07)

• initial release