CODEWITHSUNDEEP
rpaste
elyraz
elyraz

Reputation: 473

Paste inside dataframe - R

In the dataset of InsectSprays there are 72 rows of 6 different sprays and I want to create another column inside this data.frame that will be the paste product of the spary code with its consecutive number (e.g., A_1…A_12, B_1…B_12,…).

I tried with the script below and how can I proceed. 

data(InsectSprays)
df <- InsectSprays[1:2] 
paste(rownames(df$spray), 1:nrow(df), sep="_")

Upvotes: 1

Views: 51

Answers (1)

akrun
akrun

Reputation: 886988

We can use ave to create the sequence column

df$New <- with(df, paste(spray, ave(seq_along(spray), spray, FUN = seq_along), sep="_"))

Upvotes: 1

Related Questions