jquery DataTable conditional formating in R

Question

I'd like to implement a conditional formating. E.g.

library(DT)

datatable(mtcars, options = list(
  fnRowCallback = JS(
    "function ( row, data, index ) {",
    "if ( data[3] > 130 ) {",
        "$(data[3]).css('background-color', '#078DC6');",
      "}",
    "else {",
    "$(data[3]).css('background-color', '#FFDE00');",
      "}",
    "}")))

Here I want to change background of rows in terms of disp column.How to upgrade this? Right now this code does not change backgorund of rows at all.

@Fergoso It is some specific solution of R package implementing datables.More here.rstudio.github.io/DT/options.html — Nicolabo
– Nicolabo, Commented Mar 27, 2015 at 22:51

NicE · Accepted Answer · 2015-03-28 08:36:33Z

1

The css need to be applied to the row, not the data, so you can try something like this:

library(DT)
datatable(mtcars, options = list(
  fnRowCallback = JS(
    "function ( row, data, index ) {",
    "if ( data[2] > 130 ) {",
    "$(row).css('background-color', '#078DC6');",
    "}",
    "else {",
    "$(row).css('background-color', '#FFDE00');",
    "}",
    "}")))

Also, array indexes start at 0 in JS.

answered Mar 28, 2015 at 8:36

NicE

21.5k3 gold badges56 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jquery DataTable conditional formating in R

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related