Merge two columns to a value range columnSource:
cols_merge_range() function is a specialized variant of the
cols_merge() function. It operates by taking a two columns that constitute
a range of values (
col_end) and merges them into a single
column. What results is a column containing both values separated by a long
12.0 — 20.0). The column specified in
col_end is dropped from
the output table.
A table object that is created using the
A column that contains values for the start of the range.
A column that contains values for the end of the range.
The separator text that indicates the values are ranged. The default value of
"--"indicates that an en dash will be used for the range separator. Using
"---"will be taken to mean that an em dash should be used. Should you want these special symbols to be taken literally, they can be supplied within the base
An option to automatically hide the column specified as
col_end. Any columns with their state changed to hidden will behave the same as before, they just won't be displayed in the finalized table.
This function could be somewhat replicated using
cols_merge_range() employs the following specialized operations for
col_end) result in a display of only
col_begin) result in a display of only the
col_beginvalues only for the merged column (this is the converse of the previous)
NAs both in
col_endresult in missing values for the merged column
NA values in the
col_begin column following the merge
operation can be easily formatted using the
Separate calls of
sub_missing() can be used for the
col_end columns for finer control of the replacement values.
This function is part of a set of four column-merging functions. The other
two are the general
cols_merge() function and the specialized
cols_merge_n_pct() functions. These functions
operate similarly, where the non-target columns can be optionally hidden from
the output table through the
gtcars to create a gt table, keeping only the
mpg_h columns. Merge the
"mpg*" columns together as a single range
column (which is labeled as MPG, in italics) using the
gtcars %>% dplyr::select(model, starts_with("mpg")) %>% dplyr::slice(1:8) %>% gt() %>% cols_merge_range( col_begin = mpg_c, col_end = mpg_h ) %>% cols_label(mpg_c = md("*MPG*"))