Home > front end >  Merge different dataset
Merge different dataset

Time:05-06

I have a question, I need to merge two different dataset in one but they have a different class. How I can I do? rbind doesn't work, ideas?

nycounties <- rgdal::readOGR("https://raw.githubusercontent.com/openpolis/geojson-italy/master/geojson/limits_IT_provinces.geojson")

city <- c("Novara", "Milano","Torino","Bari")
dimension <- c("150000", "5000000","30000","460000")
df <- cbind(city, dimension)
 
total <- rbind(nycounties,df)

CodePudding user response:

Are you looking for something like this?

nycounties@data = data.frame(nycounties@data,
                             df[match(nycounties@data[, "prov_name"],
                                      df[, "city"]),])

Output

nycounties@data[!is.na(nycounties@data$dimension),]

   prov_name prov_istat_code_num prov_acr  reg_name reg_istat_code reg_istat_code_num prov_istat_code   city dimension
0     Torino                   1       TO  Piemonte             01                  1             001 Torino     30000
2     Novara                   3       NO  Piemonte             01                  1             003 Novara    150000
12    Milano                  15       MI Lombardia             03                  3             015 Milano   5000000
81      Bari                  72       BA    Puglia             16                 16             072   Bari    460000
  • Related