Removing display of row names from data frame

Question

I am creating a dataframe using this code   df  lt - data frame dbGetQuery con  paste  select   from test       Which results in this       UID      BuildingCode   AccessTime 1   123456   BUILD-1        2014-06-16 07 00 00 2   364952   BUILD-2        2014-06-15 08 00 00 3    95865   BUILD-1        2014-06-06 09 50 00   I am then trying to remove the row names  1  2  3  etc  as suggested here by using this code   rownames df   lt - NULL   But then when I print out df it still displays the row names  Is there a way to not include the row names when creating the data frame  I found a suggestion about row name   FALSE but when I tried it I just got errors  I might have placed it in the wrong place    EDIT  What I want to do is convert the dateframe to a HTML table and I don t want the row name to be present in the table

User · Answer

Recently I had the same problem when using htmlTable() (‘htmlTable’ package) and I found a simpler solution: convert the data frame to a matrix with as.matrix():

htmlTable(as.matrix(df))

And be sure that the rownames are just indices. as.matrix() conservs the same columnames. That's it.

UPDATE

Following the comment of @DMR, I did't notice that htmlTable() has the parameter rnames = FALSE for cases like this. So a better answer would be:

htmlTable(df, rnames = FALSE)

User · Answer

If you want to format your table via kable  you can use row names   F  kable df  row names   F

User · Answer

My answer is intended for comment though but since i havent got enough reputation  i think it will still be relevant as an answer and help some one  I find datatable in library DT robust to handle rownames  and columnames Library DT datatable df  rownames   FALSE     no row names   refer to https   rstudio github io DT  for usage scenarios

User · Answer

Yes I know it is over half a year later and a tad late  BUT  row names df   lt - NULL   does work  For me at least  -   And if you have important information in row names like dates for example  what I do is just     df Dates  lt - as Date row names df     This will add a new column on the end but if you want it at the beginning of your data frame   df  lt - df  c 7 1 2 3 4 5 6         Hope this helps those from Google

User · Answer

You have successfully removed the row names  The print data frame method just shows the row numbers if no row names are present   df1  lt - data frame values   rnorm 3   group   letters 1 3                     row names   paste0  RowName   1 3   print df1               values group  RowName1 -1 469809     a  RowName2 -1 164943     b  RowName3  0 899430     c  rownames df1   lt - NULL print df1        values group  1 -1 469809     a  2 -1 164943     b  3  0 899430     c   You can suppress printing the row names and numbers in print data frame with the argument row names as FALSE   print df1  row names   FALSE        values group   -1 4345829     d    0 2182768     e   -0 2855440     f   Edit  As written in the comments  you want to convert this to HTML  From the xtable and print xtable documentation  you can see that the argument include rownames will do the trick   library  xtable   print xtable df1   type  html   include rownames   FALSE    lt  -- html table generated in R 3 1 0 by xtable 1 7-3 package -- gt    lt  -- Thu Jun 26 12 50 17 2014 -- gt    lt TABLE border 1 gt    lt TR gt   lt TH gt  values  lt  TH gt   lt TH gt  group  lt  TH gt    lt  TR gt    lt TR gt   lt TD align  right  gt  -0 34  lt  TD gt   lt TD gt  a  lt  TD gt   lt  TR gt    lt TR gt   lt TD align  right  gt  -1 04  lt  TD gt   lt TD gt  b  lt  TD gt   lt  TR gt    lt TR gt   lt TD align  right  gt  -0 48  lt  TD gt   lt TD gt  c  lt  TD gt   lt  TR gt    lt  TABLE gt

[r] Removing display of row names from data frame

UPDATE

Examples related to r

Examples related to printing

Examples related to dataframe

Examples related to output-formatting

Examples related to rowname