as_any_date() handles lubridate::ym and lubridate::my. Still,
some ambiguous formats are not detected (“19 July” returns 2019-07-01)
https://github.com/GuiFabre/fabR/issues/15
enhance performance of get_duplicated_cols() and
get_duplicated_rows().
The function get_all_na_rows() had a bug when a column was named
“test”, that has been fixed.
https://github.com/GuiFabre/fabR/issues/13
The function get_duplicated_rows() had a bug when a tibble had only
one column, that has been fixed.
https://github.com/GuiFabre/fabR/issues/14
The date functions as_any_date(), as_any_date(), as_any_date(),
have a default format 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 whole column.
https://github.com/GuiFabre/fabR/issues/12
The function read_any_csv() can handle 3 types of CSV (coma
separator, semi column separator and a mix of columns containing
both), which works better. The function also handles (a priori) the
latin1 encoding Still experimental.
https://github.com/GuiFabre/fabR/issues/10
https://github.com/GuiFabre/fabR/issues/9
as_any_integer() which allows to coerce a vector compatible to
integer. Text, boolean and numerics which are homogeneous to integers.To avoid confusion with help(function), the function fabR_help() has
been renamed fabR_website().
start.Addition of NEWS.md for the development version use “(development
version)”.
Some improvements in the documentation of the package has been made.
read_excel_allsheets() The function has a new parameter which allows
the user to keep the ouput as a list or as a tibble when there is only
one tab in the input excel file.
get_xxx() functions to navigate in tibble have been modified to
exclude index dependancy and be more coherente to each other.
New Imports: xfun, lifecycle
No longer in Imports: ggplot2, plotly, DT
bookdown_template() replaces the deprecated function
bookdown_template() to improve stability (no more dependency of a
github repo) and open new possibilities. Such as:
bookdown_render() which renders a Rmd collection of files into a
docs/index.html website.
bookdown_open() Which allows to open a docs/index.html document when
the bookdown is rendered
This separation into 3 functions will allow future developments, such as render as a ppt or pdf.
Due to another package development (see madshapR), all functions plot_xxx() and summary_xxx() have been deprecated in favor of variable_visualize)
This package is a collection of wrapper functions used in data pipelines.
This is still a work in progress, so please let me know if you used a function 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 tibble listing files in a specified folder (recursively) with file path name and other useful metadata. This index can be used to quickly find files in the environment. The index also generates script to read files as R objects into the environment. Names for R objects are generated automatically from file names (R objects are not created at this step but 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 a structured
documentation of a package and turn it into a tibble.
add_index() adds a extra column in a tibble which is index of
observations.
as_any_boolean()Create or test for objects of type “logical”, and the basic logical constants. This function is a wrapper of the function base::as.logical() and evaluates if the object to be coerced can be interpreted as a boolean. Any object : NA, NA_integer, NA_Date_, (…), 0, 0L, F, FALSE, false, FaLsE, (…), 1, 1L,T, TRUE, true, TrUe, (…), will be converted as NA, 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 vector evaluates one observation after the other, and casts the best matching date format for each of them (independently). The best matching format is tested across seven different formats provided by the lubridate library. 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 avoiding suppressMessages,
suppressWarnings, try and tryCatch.
parceval() reads and evaluate a string character as a code and runs
it.
message_on_prompt() allows to run text to prompt in the console.
fabR_help() Call the help center for full documentationmake_name_list() Generate a name for an element in a list. This
function is targeted for functions creations which handle lists.
get_path_list() Function that recursively go through a list object
and store in a tibble the path of each element in the list. The paths
can be after that edited and accessed using parceval() for example.
These helper functions evaluate content of a column to extract what they 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 to detect the
number of lines to use in attributing the column type (‘guess_max’
parameter of read_csv). This avoids common errors when reading csv
files.
read_excel_allsheets() The Excel file is read and the values are
placed in a list of tibbles, with each sheet in a separate element in
the list. If the Excel file has only one sheet, the output is a single
tibble.
write_excel_allsheets() Write all Excel sheets using
xlsx::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 a column. Missing values can be given as input to non-valid and valid values separately, or grouped by another column. The output can be editable (using plotly library) or static (using ggplot2 library). The R-code is also editable for coding recycling purpose.
template_visual_report() is a helper function creates a template for
the visual report bookdown. This template is taken from the following
link:
https://github.com/jtr13/bookdown-template/archive/refs/heads/master.zip
folder.
The plot_xxx() and summary_xxx() functions can be used to generate code in R chunks.