Last chance! 50% off unlimited learning
Sale ends in
Perform targeted text transformation with a function
text_transform(data, locations, fn)
A table object that is created using the gt()
function.
The cell or set of cells to be associated with the text
transformation. Only the cells_body()
, cells_stub()
, and
cells_column_labels()
helper functions can be used here. We can enclose
several of these calls within a list()
if we wish to make the
transformation happen at different locations.
The function to use for text transformation.
An object of class gt_tbl
.
3-12
Other Format Data:
data_color()
,
fmt_bytes()
,
fmt_currency()
,
fmt_datetime()
,
fmt_date()
,
fmt_markdown()
,
fmt_missing()
,
fmt_number()
,
fmt_passthrough()
,
fmt_percent()
,
fmt_scientific()
,
fmt_time()
,
fmt()
# NOT RUN {
# Use `exibble` to create a gt table;
# transform the formatted text in the
# `num` and `currency` columns using
# a function within `text_transform()`,
# where `x` is a formatted vector of
# column values
tab_1 <-
exibble %>%
dplyr::select(num, char, currency) %>%
dplyr::slice(1:4) %>%
gt() %>%
fmt_number(columns = num) %>%
fmt_currency(columns = currency) %>%
text_transform(
locations = cells_body(
columns = num
),
fn = function(x) {
paste0(
x, " (",
dplyr::case_when(
x > 20 ~ "large",
x <= 20 ~ "small"),
")")
}
)
# }
Run the code above in your browser using DataLab