Exclude row names from R Shiny renderTable

Question

I am using the renderTable function from the R Shiny package and it is returning a table with row names. Ideally I want a table to be displayed with only two columns, one for 'Month' and one for 'Value'. The output I currently get includes the row names. I have tried a few things to exclude row names but was unsuccessful. Any thoughts?

output$valueTable <- renderTable({
if(input$table_view == TRUE){
  data.frame(Month = Month(), Value = valueData()[,"Value"])
}  
})

`renderTable` has a `...` which passes options to `xtable`. `xtable` has an `include.rownames` options. Try using `include.rownames = FALSE` as an option in `renderTable` — jdharrison, Dec 19 '13 at 01:38

score 35 · Answer 1 · edited Jan 02 '14 at 10:54

35

this instruction is working for me

output$summaryTable <- renderTable({
       df()$donnees         
    }, 
    include.rownames=FALSE)

edited Jan 02 '14 at 10:54

Rohan Kandwal

9,112
8
74
107

answered Jan 02 '14 at 10:33

Hazem HASAN

1,598
2
21
38

score 5 · Answer 2 · answered Jun 10 '14 at 07:04

5

Into your init code, put

options(xtable.include.rownames=F)
options(xtable.include.colnames=F)

this will disable it for all tables in your app.

answered Jun 10 '14 at 07:04

userJT

11,486
20
77
88

score 0 · Answer 3 · answered Dec 18 '13 at 22:14

0

I think you need to include row.names=NULL inside your data.frame call.

data.frame(Month = Month(), Value = valueData()[,"Value"], row.names=NULL)

If you already have a data frame(df), then you could do: row.names(myDF) <- NULL

answered Dec 18 '13 at 22:14

Dev Patel

292
1
5
12

I have added row.names=NULL and it had no impact on the shiny output. – rrbest Dec 18 '13 at 22:23
@rrbest I haven't tried it with shiny but it worked for me with my regular code. I think to write some test code for shiny would take some effort. Is it possible if you can paste your code/snippet for both ui.R and server.R. – Dev Patel Dec 18 '13 at 23:08

score 0 · Answer 4 · edited Feb 13 '19 at 13:58

0

This will work

output$valueTable <- renderTable({
   if(input$table_view == TRUE){
      data.frame(Month = Month(), Value = valueData()[,"Value"])
   }  
}, rownames = FALSE)

edited Feb 13 '19 at 13:58

T.V.

793
12
33

answered Feb 13 '19 at 11:05

Bulbul Yadav

1
1

please explain your answere. – MrMaavin Feb 13 '19 at 11:27
if you are writing "rownames = FALSE" with renderTable, It's simply means that you don't want the name of rows in you output. you can also avoide column names to just by adding " colnames = FALSE" – Bulbul Yadav Feb 14 '19 at 07:00
Maybe add the explanation to your answer. – MrMaavin Feb 14 '19 at 07:01

Exclude row names from R Shiny renderTable

4 Answers4

Linked