How do I reassign specific values within a column of a data frame?

userlYz61 0
Viewed 35

I have a data frame, and one of the columns is a mislabeled continent value called americas. I want to reassign all values with United States and Canada as North America, and Every other value labeled as Americas to be reassigned as South America.

for (i in g2$country){
   if (i == "United States") {
       g2$continent == 'North America"
   }
}
r
2 Answers
g2 <- g2 |>
  mutate("new" = ifelse(country %in% c("United States","Canada"),"North America","South America"))

If there are more labels in your country variable, you should add another ifelse() instead of "South America".

Aaron Philipp0

If you want to work in a tidyverse frame, you could use case_when:

g2 %>%
  mutate(continent = case_when(
              country %in% c("United States", "Canada", "Mexico") ~ "North America",
              TRUE ~ "South America")
         )

(that TRUE ~ "South America" is how case_when handles ELSE logic.)

A more generalized solution (if you have lots more than 2 continent labels) would be to build a dictionary tibble continent_lookup with columns for country and continent and then join that with your current g2 tibble.

Jared Brewer0
Related