Convert row names into first column

Question

I have a data frame like this    df               VALUE              ABS CALL DETECTION P-VALUE         1007 s at  957 729231881542   P        0 00486279317241156      1053 at    320 632701283368   P        0 0313356324173416       117 at     429 842323161046   P        0 0170004527476119       121 at     2395 7364289242    P        0 0114473584876183       1255 g at  116 493632746934   A        0 39799368200131         1294 at    739 927122116896   A        0 0668649772942343     I want to convert the row names into the first column  Currently I use something  like this to make row names as the first column     d  lt - df   names  lt - rownames d    rownames d   lt - NULL   data  lt - cbind names d    Is there a single line to do this

User · Answer

A one line option is     df names  lt - rownames df

User · Answer

Or by using DBIs sqlRownamesToColumn library DBI  sqlRownamesToColumn df

User · Answer

Or you can use dplyr s add rownames which does the same thing as David s answer   library dplyr  df  lt - tibble  rownames to column df   VALUE     UPDATE  mid-2016     incorporated to the above   old function called add rownames   has been deprecated and is being replaced by tibble  rownames to column    same functions  but Hadley refactored dplyr a bit

User · Answer

Moved my comment into an answer per suggestion above   You don t need extra packages  here s a one-liner    d  lt - cbind rownames d   data frame d  row names NULL

User · Answer

You can both remove row names and convert them to a column by reference  without reallocating memory using - gt   using setDT and its keep rownames   TRUE argument from the data table package  library data table  setDT df  keep rownames   TRUE         rn     VALUE  ABS CALL DETECTION     P VALUE   1   1 1007 s at  957 7292         P 0 004862793   2   2   1053 at  320 6327         P 0 031335632   3   3    117 at  429 8423         P 0 017000453   4   4    121 at 2395 7364         P 0 011447358   5   5 1255 g at  116 4936         A 0 397993682   6   6   1294 at  739 9271         A 0 066864977   As mentioned by  snoram  you can give the new column any name you want  e g  setDT df  keep rownames    newname   would add  newname  as the rows column

User · Answer

Alternatively  you can create a new dataframe  or overwrite the current one  as the example below  so you do not need to use of any external package  However this way may not be efficient with huge dataframes   df  lt - data frame names   row names df   df

User · Answer

dplyr  as data frame df  rownames    your row name   will give you even simpler result

[r] Convert row names into first column

Examples related to r

Examples related to dataframe

Examples related to col

Examples related to rowname