I created a table from a data source using
tbl(). I need to add a column including
1:nrow() to my dataset and tried different methods but I didn’t succeed. My code is as below:
nrow_df1 <- df1 %>% summarise(n = n()) %>% pull(n) df1 <- df1 %>% mutate(ID = 1:nrow_df1, step = 1)
It doesn’t add column ID to my dataset and only adds column step.
as.data.frame(), it works but so slow.
Do you have any ideas? thanks in advance
I found the answer. It is to use
as.numeric is also needed to convert the output from integer64 to numeric:
df1 <- df1 %>% mutate(ID = as.numeric(row_number(a column)), step = 1)