发布于 2014-02-15 06:45:37
没有办法绕过它-您需要了解XML和XPath才能在R中使用它。假设您了解,那么在浏览器中查看文档以了解其结构。然后,这应该会让您开始使用XML包。
library(XML)
xml <- xmlParse("http://data.mcc.gov/raw/xml/MCC_HN.xml")
org <- xpathApply(xml,"//iati-activity/reporting-org",xmlValue)
id <- xpathApply(xml,"//iati-activity/iati-identifier",xmlValue)
title <- xpathApply(xml,"//iati-activity/title",xmlValue)
desc.1 <- xpathApply(xml,"//iati-activity/description[@type='1']",xmlValue)
desc.2 <- xpathApply(xml,"//iati-activity/description[@type='2']",xmlValue)
status <- xpathApply(xml,"//iati-activity/activity-status",xmlValue)
start.planned <- xpathApply(xml,"//iati-activity/activity-date[@type='start-planned']",xmlValue)
start.actual <- xpathApply(xml,"//iati-activity/activity-date[@type='start-actual']",xmlValue)
end.planned <- xpathApply(xml,"//iati-activity/activity-date[@type='end-planned']",xmlValue)
end.actual <- xpathApply(xml,"//iati-activity/activity-date[@type='end-actual']",xmlValue)
df <- data.frame(cbind(org,id, title, status,
start.planned, start.actual, end.planned, end.actual,
desc.1, desc.2))请阅读关于我在上面使用过的函数的文档,例如xmlParse(...)、xpathApply(...)和xmlValue(...),以弄清楚代码在做什么。
注意: XML包中有一个函数xmlToDataFrame(...)。文档的问题在于有多个元素具有相同的标记名(例如:description和activity-date),这些元素使用type=属性来消除歧义。xmlToDataFrame(...)不知道如何处理这一点,所以你需要以一种艰难的方式来处理它……
发布于 2014-02-15 07:04:11
不太清楚您想要对数据做什么,但我们在这里得到了它
xml = xmlParse("http://data.mcc.gov/raw/xml/MCC_HN.xml")然后查询所有“事务”记录的结果并将它们放入一个数据框中
df <- xmlToDataFrame(xml["//transaction"])使用
> dim(df)
[1] 730 11
> head(df, 2)
aid-type
1
2
description
1 Commitment: Honduras-614G Fund-Not Applicable-Not Applicable-2011-04-01
2 Disbursement: Honduras-614G Fund-Not Applicable-Not Applicable-2011-04-01
disbursement-channel finance-code flow-type provider-org
1 Millennium Challenge Corporation
2 Millennium Challenge Corporation
receiver-org tied-status transaction-date transaction-type value
1 Honduras 2011-04-01 COMMITMENT 274380.75
2 Honduras 2011-04-01 DISBURSEMENT 0.00也许您想提取与'aid-type‘关联的属性并将其添加到数据框中;使用XPath来完成此操作
df$`aid-type-code` <- as.character(xml["//aid-type/@code"])https://stackoverflow.com/questions/21790059
复制相似问题