Generate Row number to the dataframe in R

To Generate Row number to the dataframe in R we will be using seq.int() function.  Seq.int() function along with nrow() is used to generate row number to the dataframe in R. We can also use row_number() function to generate row index. We will also focus on generating row numbers by group with an example.

  • Create Row number or Row index of the dataframe in R using seq.int() function
  • Generate row number of the Dataframe using row_number() and also by 1:n()
  • Generate row numbers by group with an example in R

Let’s first create the dataframe

#### Create dataframe 
my_basket = data.frame(ITEM_GROUP = c("Fruit","Fruit","Fruit","Fruit","Fruit","Vegetable","Vegetable","Vegetable","Vegetable","Dairy","Dairy","Dairy","Dairy","Dairy"), 
                       ITEM_NAME = c("Apple","Banana","Orange","Mango","Papaya","Carrot","Potato","Brinjal","Raddish","Milk","Curd","Cheese","Milk","Paneer"),
                       Price = c(100,80,80,90,65,70,60,70,25,60,40,35,50,120),
                       MRP = c(101,85,85,96,67,73,65,71,33,64,45,36,54,123))
my_basket

so the dataframe my_basket will be

Generate row number in R 11

 

 

Generate Row number or Row index to the dataframe using seq.int():

Row number is generated and stored in a column using seq.int() function

#### Generate row number or row index using seq.int() function
my_basket$row_num <- seq.int(nrow(my_basket)) 
my_basket

so the resultant dataframe with row number or row index generated  will be

Generate row number in R 12

 

 

Generate Row number or Row index to the dataframe using row_number():

Row number is generated and stored in a column using row_number() function. row_number() of the dplyr package is used along with mutate function in order to generate the row number as follows

#### Generate row number or row index using row_number() function

library(dplyr)
mutate(my_basket, id = row_number())

so the resultant dataframe with row number or row index generated  and stored in the name of id

Generate row number in R 13

 

 

Generate Row number or Row index to the dataframe using 1:n():

Row number is generated and stored in a column using 1:n() function. 1:n() of the dplyr package is used along with mutate function in order to generate the row number as follows

#### Generate row number or row index using 1:n()

library(dplyr)
my_basket %>% mutate(row_number= 1:n())

so the resultant dataframe with row number or row index generated  and stored in the name of row_number

Generate row number in R 14

 

 

Generate Row number of the dataframe by group

Row number is generated and stored in a column using 1:n() function. 1:n() of the dplyr package also used to generate the row number by group by using group_by() function.  In below example the row numbers are generated by is “ITEM_GROUP”.  “ITEM_GROUP” is passed as an argument to the group_by() function.

#### Generate row number by group

library(dplyr)
My_data <- my_basket %>%
  group_by(ITEM_GROUP) %>%
  mutate(row_number_bygroup = 1:n())

so the resultant dataframe with row numbers generated and grouped by  “ITEM_GROUP” group column is shown

Generate row number in R 15