How to make "column 0: rownames" a number starting at 1 like a regular dataset in r?

Question

I have a dataframe with column 0 having the variables:

How do I get this dataframe to have column 0 as the numbered column and the current column 0 to be a "variable" column (which would be column 1)? I have shown an example below:

score 4 · Accepted Answer · answered May 18 '20 at 23:16

4

We can use rownames_to_column from tibble

library(tibble)
df1 <- rownames_to_column(df1, "Variable")

Or using base R

df1$Variable <- row.names(df1)
row.names(df1) <- NULL

answered May 18 '20 at 23:16

akrun

874,273
37
540
662

How to make "column 0: rownames" a number starting at 1 like a regular dataset in r?

1 Answers1