which_any_date(), andguess_date_format(),as_any_date() now handleswhole NA column
Handle grouped tibbles inget_duplicated_cols()
Bug inas_any_integer() has been correctedhttps://github.com/GuiFabre/fabR/issues/20
deprecated usage of summarizehttps://github.com/GuiFabre/fabR/issues/22
allowfile_index_create() to read one fileonly.
inbookdown_template(), hide anchor when mouse overand better CSS for titles and sections.
default behavior ofread_excel_allsheets() is tokeep file in a list when being read.
as_any_date() handleslubridate::ym andlubridate::my. Still, some ambiguous formats are notdetected (“19 July” returns 2019-07-01)https://github.com/GuiFabre/fabR/issues/15
enhance performance ofget_duplicated_cols() andget_duplicated_rows().
The functionget_all_na_rows() had a bug when acolumn was named “test”, that has been fixed.https://github.com/GuiFabre/fabR/issues/13
The functionget_duplicated_rows() had a bug when atibble had only one column, that has been fixed.https://github.com/GuiFabre/fabR/issues/14
The date functionsas_any_date(),as_any_date(),as_any_date(), have a defaultformat setting which is yyyy-mm-dd. Also if there is ambiguity, but 100% match, the first format will be used as the format for the wholecolumn.https://github.com/GuiFabre/fabR/issues/12
The functionread_any_csv() can handle 3 types ofCSV (coma separator, semi column separator and a mix of columnscontaining both), which works better. The function also handles (apriori) the latin1 encoding Still experimental.https://github.com/GuiFabre/fabR/issues/10https://github.com/GuiFabre/fabR/issues/9
as_any_integer() which allows to coerce a vectorcompatible to integer. Text, boolean and numerics which are homogeneousto integers.To avoid confusion with help(function), the functionfabR_help() has been renamedfabR_website().
start.Addition ofNEWS.md for the development version use“(development version)”.
Some improvements in the documentation of the package has beenmade.
read_excel_allsheets() The function has a newparameter which allows the user to keep the ouput as a list or as atibble when there is only one tab in the input excel file.
get_xxx() functions to navigate in tibble have beenmodified to exclude index dependancy and be more coherente to eachother.
New Imports: xfun, lifecycle
No longer in Imports: ggplot2, plotly, DT
bookdown_template() replaces the deprecated functionbookdown_template() to improve stability (no moredependency of a github repo) and open new possibilities. Such as:
bookdown_render() which renders a Rmd collection offiles into a docs/index.html website.
bookdown_open() Which allows to open adocs/index.html document when the bookdown is rendered
This separation into 3 functions will allow future developments, suchas render as a ppt or pdf.
Due to another package development (seemadshapR),all functions plot_xxx() and summary_xxx() have been deprecated in favorofvariable_visualize)
This package is a collection of wrapper functions used in datapipelines.
This is still a work in progress, so please let me know if you used afunction before and is not working any longer.
file_index_create(),file_index_read(),file_index_search()
These functions allows to create, read and search into a tibblelisting files in a specified folder (recursively) with file path nameand other useful metadata. This index can be used to quickly find filesin the environment. The index also generates script to read files as Robjects into the environment. Names for R objects are generatedautomatically from file names (R objects are not created at this stepbut the command line is generated and stored in the column to_eval,ready to be evaluated and generate R objects).
collect_roxygen() is a helper function that can read astructured documentation of a package and turn it into a tibble.
add_index() adds a extra column in a tibble which isindex of observations.
as_any_boolean()Create or test for objects of type “logical”, and the basic logicalconstants. This function is a wrapper of the function base::as.logical()and evaluates if the object to be coerced can be interpreted as aboolean. Any object : NA, NA_integer, NA_Date_, (…), 0, 0L, F, FALSE,false, FaLsE, (…), 1, 1L,T, TRUE, true, TrUe, (…), will be converted asNA, FALSE and TRUE. Any other other will return an error.
as_any_date(),which_any_date(),guess_any_date()These function takes a character string or a vector. This vectorevaluates one observation after the other, and casts the best matchingdate format for each of them (independently). The best matching formatis tested across seven different formats provided by the lubridatelibrary. The user can specify the wanted matching format.
as_any_symbol()Create or test for objects of type “symbol”.
silently_run() allows to generate code avoidingsuppressMessages, suppressWarnings, try and tryCatch.
parceval() reads and evaluate a string character asa code and runs it.
message_on_prompt() allows to run text to prompt inthe console.
fabR_help() Call the help center for fulldocumentationmake_name_list() Generate a name for an element in alist. This function is targeted for functions creations which handlelists.
get_path_list() Function that recursively go througha list object and store in a tibble the path of each element in thelist. The paths can be after that edited and accessed usingparceval() for example.
These helper functions evaluate content of a column to extract whatthey are supposed to extract for all observations.
get_all_na_cols(),get_all_na_rows(),get_duplicated_cols(),get_duplicated_rows(),get_unique_value_cols()
read_csv_any_formats() The csv file is read twice todetect the number of lines to use in attributing the column type(‘guess_max’ parameter of read_csv). This avoids common errors whenreading csv files.
read_excel_allsheets() The Excel file is read andthe values are placed in a list of tibbles, with each sheet in aseparate element in the list. If the Excel file has only one sheet, theoutput is a single tibble.
write_excel_allsheets() Write all Excel sheets usingxlsx::write.xlsx() recursively.
plot_bar(),plot_box(),plot_date(),plot_density(),plot_histogram(),plot_main_word(),plot_pie_valid_value(),summary_category(),summary_numerical(),summary_text()
These functions draw a plot or create datatable of the values of acolumn. Missing values can be given as input to non-valid and validvalues separately, or grouped by another column. The output can beeditable (using plotly library) or static (using ggplot2 library). TheR-code is also editable for coding recycling purpose.
template_visual_report() is a helper function creates atemplate for the visual report bookdown. This template is taken from thefollowing link:https://github.com/jtr13/bookdown-template/archive/refs/heads/master.zipfolder.
The plot_xxx() and summary_xxx() functions can be used to generatecode in R chunks.