condformat prints a data frame with cells formatted
according to several rules or criteria. It is integrated with the
RStudio Viewer or a web browser, and it supports knitr and
rmarkdown outputs using both HTML and PDF ($\LaTeX$) output formats. Other formats are
not supported, although patches to enable them are welcome.
Its syntax should be familiar to ggplot users, with tidy
evaluation.
condformat(a_data_frame) %>% # A data frame to print
rule_fill_discrete(ColumnA) %>% # Add formatting rules to the data frame
rule_fill_gradient(ColumnB)data(iris)
library(condformat)
condformat(iris[c(1:5,70:75, 120:125),]) %>%
rule_fill_discrete(Species) %>%
rule_fill_discrete(c(Sepal.Width, Sepal.Length),
expression = Sepal.Width > Sepal.Length - 2.25,
colours = c("TRUE" = "#7D00FF")) %>%
rule_fill_gradient2(Petal.Length) %>%
rule_text_bold(Sepal.Length, Species == "setosa") %>%
rule_text_color(Sepal.Length, ifelse(Species == "setosa", "yellow", "")) %>%
rule_fill_bar(Petal.Width, limits = c(0, NA))| Sepal.Length | Sepal.Width | Petal.Length | Petal.Width | Species | |
|---|---|---|---|---|---|
| 1 | 5.1 | 3.5 | 1.4 | 0.2 | setosa |
| 2 | 4.9 | 3.0 | 1.4 | 0.2 | setosa |
| 3 | 4.7 | 3.2 | 1.3 | 0.2 | setosa |
| 4 | 4.6 | 3.1 | 1.5 | 0.2 | setosa |
| 5 | 5.0 | 3.6 | 1.4 | 0.2 | setosa |
| 6 | 5.6 | 2.5 | 3.9 | 1.1 | versicolor |
| 7 | 5.9 | 3.2 | 4.8 | 1.8 | versicolor |
| 8 | 6.1 | 2.8 | 4.0 | 1.3 | versicolor |
| 9 | 6.3 | 2.5 | 4.9 | 1.5 | versicolor |
| 10 | 6.1 | 2.8 | 4.7 | 1.2 | versicolor |
| 11 | 6.4 | 2.9 | 4.3 | 1.3 | versicolor |
| 12 | 6.0 | 2.2 | 5.0 | 1.5 | virginica |
| 13 | 6.9 | 3.2 | 5.7 | 2.3 | virginica |
| 14 | 5.6 | 2.8 | 4.9 | 2.0 | virginica |
| 15 | 7.7 | 2.8 | 6.7 | 2.0 | virginica |
| 16 | 6.3 | 2.7 | 4.9 | 1.8 | virginica |
| 17 | 6.7 | 3.3 | 5.7 | 2.1 | virginica |