Color values beyond a threshold in a table in R
If I have the following table for the mtcars dataset:
knitr::kable(mtcars) %>%
kableExtra::kable_styling(c("bordered","condensed"), font_size = 15,full_width = T)
How can I color only the values (not cells) greater than, for example, 5 on that table?
Thanks in advance!
Solution
You can use cell_spec with kable(escape = FALSE) to predefine all cells' colors:
library(dplyr)
library(knitr)
library(kableExtra)
df <- mtcars
df %>%
mutate(across(everything(), ~ cell_spec(.x, color = ifelse(.x > 5, "red", "black")))) %>%
kable(escape = FALSE) %>%
kable_styling(c("bordered","condensed"), font_size = 15, full_width = T)
- Change Y intervals from 25% to 10%
- How to create a Marimekko/Mosaic plot in ggplot2
- Include code that does not run in Rpresentation Markdown
- How can I convert row names into the first column?
- How to add a ggplot2 subtitle with different size and colour?
- ggplot - making an internal pipeline within ggplot from object passed from previous pipeline
- Display bar as whole,value of bar as sum and remove as factor() from hover text
- highchart not rending in rshiny but is working in my directory
- How to listen to checkbox event that has been insert into ui using `insertUI` in Shiny-R
- Creating tooltip for radioGroupButtons while using bslib
- Reducing bootstrap table cell padding when using `bs_theme()`
- Rshiny popup won't appear under different tabs
- When I want to build a big matrix, my code becomes extremely slow. Why?
- Replace NA values in a data frame with the mean values of a variable depending on the rank of another variable
- Reshape data frame by row
- Write ZOO (XTS) object into CSV file by separating index column into two columns
- Pruning / Retrieving Nodes from a Tree Based on Parent / Child / Sibling Relationships
- Replace NA row with non-NA value from previous row and certain column
- Changing Values on the Same Column for Different DataFrames (in R)
- Binned Barplot in R
- Need a way of clumping columns together without trailing NAs and reversing the result
- How to use different parameters based on a vector for each iteration of lapply?
- Fit same model to many datasets in Python
- Why can't I iteratively add ggplot objects to a list?
- Problem with Plotting the dates on x axis for every timepoint in ggplot - and also some weird date conversion things (sidebar)
- Drawing state boundaries in county map in recent version
- How to replace and delete different underscore in a single name row
- Error package arrowR : read_parquet/open_dataset "Couldn't deserialize thrift: TProtocolException: Exceeded size limit"
- somatoChart in r (plot or ggplot)
- Selecting Flat Parts of a Curve