creating conditional formated tables for html in R using knitr

Question

I want to get my data.frame from shown as a html table, using java script dataTables for a nicer look. I want to use knitr for translating the data.frame from R into html. I know, there is the function kable to construct such a table. But there i dont know, maybe it is not possible, how to define, that some cell has, e.g., the background coloured red, another one yellow. Can this be done. The problem is, for using the javascript dataTables, I need an id for the html table I created with knitr...

junkka · Accepted Answer · 2014-06-07 13:52:17Z

1

It is possible to add a id to a html table with kable through the table.attr param.

kable(head(cars), format = 'html', table.attr = 'id="foo"')

and then in JavaScript

$(document).ready(function() {
  $('#foo').dataTable();
} );

To directly create a dataTable from a data.frame use dTable from the rCharts package.

dTable(cars)

edited Jun 7, 2014 at 13:52

answered Jun 6, 2014 at 16:33

junkka

5537 silver badges11 bronze badges

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

1 Comment

stephan mc Over a year ago

Og course. Unfortunately my question was not how to assign the id, i wanted to know, if there is a possibility to say, that a special cell should be in red or so. If I can use dtable therefore, ok. But I liked the shaped of the tables js datatables. Thank nevertheless thanks for your answer

Collectives™ on Stack Overflow

creating conditional formated tables for html in R using knitr

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related