Using a simple for loop to match state name with corresponding state number

Question

I web scraped 50 states from a website and added them to my data set under the name "state_name", I need to correspond all the state values 1 with Alabama all state values 2 with Alaska, etc...

FYI it’s __scraped__ not scrapped – DisappointedByUnaccountableMod May 10 '21 at 21:08 — DisappointedByUnaccountableMod, May 10 '21 at 21:08

score 0 · Answer 1 · answered May 10 '21 at 20:53

0

df$state_value = as.factor(df$state_name)

answered May 10 '21 at 20:53

aashish

305
1
7

score 0 · Answer 2 · answered May 10 '21 at 22:12

0

You can try

df$state_value <- as.integer(factor(df$state_name))

or

df$state_value <- match(df$state_name,unique(df$state_name))

answered May 10 '21 at 22:12

ThomasIsCoding

80,151
7
17
65

Using a simple for loop to match state name with corresponding state number

2 Answers2