The “iden” column should contain the individual number for each member of the group

Question

if petal. width is o.1 then my new column value should be 1 :n number like wise it has ti print for every unique values

`data=iris
data=data[order(data$Petal.Width),]
count=1
data$iden<-with(data,(data$Petal.Width))
for (i in 1:length(data)) {
if(data$Petal.Width[i] == data$Petal.Width[i]){
 count=count+1 }}`

its showing like 1,2,3,4,5,6,7, to 121 but i need 1:n number for particular group — shariff sayile, Dec 12 '19 at 05:48
You are showing a subset of the data. Please check my output — akrun, Dec 12 '19 at 06:22
thanks @akrun but i have a another problem based on the same dataset — shariff sayile, Dec 12 '19 at 06:43
same @akrun now instead of printing the seq it should be print like if 0.1 means it should be 1 if 0.2 it should be 2 if 0.3 it should be 3 — shariff sayile, Dec 12 '19 at 06:46
That would be my earlier solution i..e `with(data, match(Petal.Width, unique(Petal.Width)))` — akrun, Dec 12 '19 at 06:47

akrun · Accepted Answer · 2019-12-12T06:03:41.533

0

We can create the sequence with ave from base R

data$Seq <- with(data, ave(seq_along(Petal.Width), Petal.Width, FUN = seq_along))

Or using data.table

library(data.table)
data$Seq <- rowid(data$Petal.Width)

Or with dplyr

library(dplyr)
data %>%
     group_by(Petal.Width) %>%
     mutate(Seq = row_number())

edited Dec 12 '19 at 06:03

answered Dec 12 '19 at 05:43

akrun

874,273
37
540
662

The “iden” column should contain the individual number for each member of the group

1 Answers1