合并不同的数据集

发布于 2025-01-25 21:52:25 字数 391 浏览 4 评论 0原文

我有一个问题，我需要合并两个不同的数据集，但它们有不同的类别。我该怎么做？ rbind行不通，想法？

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)

原文

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)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烦人精 2025-02-01 21:52:25

您在寻找这样的东西吗？

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

输出

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

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

回复收藏 0 原文

~没有更多了~