Checking if string contains character and then assigning that character to another vairbale in R

Asked Oct 06 '22 at 17:21

Active Oct 15 '22 at 08:05

Viewed 33 times

I have a dataframe with a series ID that contains within it a state ID. I also have a vector containing the possible state IDs. Here is a sample:

df <- data.frame(seriesid = c("SMU01000002000000001", "SMU01000002000000001", 
                 "SMU02000002000000001", "SMU04000002000000001", 
                 "SMU04000002000000001", "SMU09000002000000001"))
stateid <- c(1:2, 4:6, 8:13)
stateid[stateid<10] <- paste0('0', stateid[stateid<10])

In the string, the two digits following "SMU" are the state IDs, so what I want to do is use the string paste0("SMU", stateid) to identify which state ID is contained within each series ID and then assign the state ID to a new variable. The final dataframe would look like

df <- data.frame(seriesid, stateid= c("01", "01", "02", "04", "04", "09"))
df

I am fairly new to R, and I realize that iterations of this question have been asked, but I haven't yet found or been able to adapt an answer that works.

edited Oct 15 '22 at 08:05

oguz ismail

asked Oct 06 '22 at 17:21

sstewart

does this help? https://stackoverflow.com/questions/35754058/extracting-part-of-string-by-position-in-r – Jon Spring Oct 06 '22 at 17:26
`substr(df$seriesid, 4, 5)`? – Jon Spring Oct 06 '22 at 17:28
Amazing! So much simpler than what I was trying to do. Thank you! – sstewart Oct 06 '22 at 17:38

Checking if string contains character and then assigning that character to another vairbale in R

0 Answers0