Conditional Formatting in Data Frames

Apply and visualize conditional formatting to data frames in R. It renders a data frame with cells formatted according to criteria defined by rules, using a syntax similar to 'ggplot2'. The table is printed either opening a web browser or within the 'RStudio' viewer if available. The conditional formatting rules allow to highlight cells matching a condition or add a gradient background to a given column. This package supports both 'HTML' and 'LaTeX' outputs in 'knitr' reports, and exporting to an 'xlsx' file.


Sergio Oller 2016-06-27

condformat renders a data frame in which cells in columns are formatted according to several rules or criteria.

Checkout the code and browse it at http://github.com/zeehio/condformat.

If you want to use the PDF output you will need the xcolor LaTeX package. Either use the full texlive distribution, or install latex-xcolor on Debian and derivatives.

  • From CRAN:

    install.packages("condformat")
    
  • To install the latest development version:

    devtools::install_github("zeehio/condformat")
    

The example is properly formatted at http://zeehio.github.io/condformat.

data(iris)
library(condformat)
condformat(iris[c(1:5,70:75, 120:125),]) +
  rule_fill_discrete(Species) + 
  rule_fill_discrete(Sepal.Width, Sepal.Length,
                     expression = Sepal.Width > Sepal.Length - 2.25,
                     colours = c("TRUE" = "#7D00FF")) + 
  rule_fill_gradient2(Petal.Length)
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

News

  • Excel export support with condformat2excel
  • PDF support: Export table to LaTeX using knitr.
  • Fix examples for full compatibility with dplyr 0.5.0
  • First CRAN submission
  • Add theme_htmlTable to pass custom formatting options to htmlTable.
  • Improve knitr compatibility
  • Change to a ggplot-like syntax

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("condformat")

0.5.0 by Sergio Oller Moreno, 3 months ago


http://github.com/zeehio/condformat


Report a bug at http://github.com/zeehio/condformat/issues


Browse source code at https://github.com/cran/condformat


Authors: Sergio Oller Moreno [aut, cph, cre]


Documentation:   PDF Manual  


BSD_3_clause + file LICENSE license


Imports htmlTable, scales, dplyr, lazyeval, knitr, rmarkdown, gplots, utils

Suggests shiny, testthat, xlsx, rJava


See at CRAN