Little help with for loop and pattern matching

[martin.R]

One of your colleagues has already asked this:

How to match patterns between different datasets.

Hi community, I have a task that I need to complete but I couldnt figure it out. Maybe you can help me. So I have a data set which contains places over 50k. dt1 <- data.table (places <- c("place1","place2","place3","place49998","place50000"), zipcodes <- 1:50000 ) I need to categorize this places city by city. Some zip codes are missing so they left as NA they are not that important focus point is places and city names. I didnt have any other datasets so I've created a dataset which includes cities and places like this dt2<- data.table( city1 <- c("place1","place2"), city2 <- c("place3","place4"), city3 <- c("place49998","place50000") ) setnames(dt2,"V1","NY") setnames(dt2,"V2","LA…