CODEWITHSUNDEEP
r
David Kružlík
David Kružlík

Reputation: 83

How can I rename value from one column?

The value is there 500 times and the name of the value is composed of many different characters.

Data.frame like this:

head(df)
# Job                                                               Opinion
# Superskilled worker/skilled worker - who has at least 5 workers   No
# Manager                                                           Yes                                                          
# Officer                                                           No                                                            
# Superskilled worker/skilled worker - who has at least 5 workers   Yes
# Superskilled worker/skilled worker - who has at least 5 workers   Yes
# Manager                                                           Yes
# Officer                                                           Yes
# Manager                                                           No
# Superskilled worker/skilled worker - who has at least 5 workers   No

I want to rename "Superskilled worker/skilled worker - who has at least 5 workers" to "Skilled worker".

Upvotes: 0

Views: 68

Answers (2)

Daniel O
Daniel O

Reputation: 4358

option 1

df$Job <- sub("Superskilled worker///skilled worker - who has at least 5 workers","Skilled worker",df$Job)

option 2 

df$Job[df$Job=="Superskilled worker/skilled worker - who has at least 5 workers"] <- "Skilled worker"

Upvotes: 1

Darren Tsai
Darren Tsai

Reputation: 35554

You can use sub().

df$Job <- sub(".*(skilled worker).*", "\\1", df$Job)

Upvotes: 0

Related Questions