Change the index number of a dataframe

Question

After I'm done with some manipulation in Dataframe, I got a result dataframe. But the index are not listed properly as below.

                    MsgType/Cxr NoOfMsgs AvgElpsdTime(ms)     161                   AM       86            30.13     171                   CM        1              104     18                    CO       27          1244.81     19                    US       23          1369.61     20                    VK        2              245     21                    VS       11          1273.82     112                  fqa       78          1752.22     24                    SN       78          1752.22 

I would like to get the result as like below.

                    MsgType/Cxr NoOfMsgs AvgElpsdTime(ms)     1                   AM        86            30.13     2                   CM         1              104     3                    CO       27          1244.81     4                    US       23          1369.61     5                    VK        2              245     6                    VS       11          1273.82     7                   fqa       78          1752.22     8                    SN       78          1752.22 

Please guide how I can get this ?

Answer 1

These are the rownames of your dataframe, which by default are 1:nrow(dfr). When you reordered the dataframe, the original rownames are also reordered. To have the rows of the new order listed sequentially, just use:

rownames(dfr) <- 1:nrow(dfr) 

Answer 2

Or, simply

rownames(df) <- NULL 

gives what you want.

> d <- data.frame(x = LETTERS[1:5], y = letters[1:5])[sample(5, 5), ] > d   x y 5 E e 4 D d 3 C c 2 B b 1 A a > rownames(d) <- NULL > d   x y 1 E e 2 D d 3 C c 4 B b 5 A a