xml - extracting data from xmlNodeSet R -
i have xmlnodeset (xml package, r programming language) , have extract data. how looks:
<drugscores> <drug code="3tc" score="95" levelstanford="5" levelsir="r" /> <drug code="abc" score="110" levelstanford="5" levelsir="r" /> <drug code="atv/r" score="90" levelstanford="5" levelsir="r" /> <drug code="azt" score="140" levelstanford="5" levelsir="r" /> <drug code="d4t" score="150" levelstanford="5" levelsir="r" /> <drug code="ddi" score="135" levelstanford="5" levelsir="r" /> <drug code="drv/r" score="0" levelstanford="1" levelsir="s" /> <drug code="efv" score="100" levelstanford="5" levelsir="r" /> <drug code="etr" score="40" levelstanford="4" levelsir="i" /> <drug code="fpv/r" score="55" levelstanford="4" levelsir="i" /> <drug code="ftc" score="95" levelstanford="5" levelsir="r" /> <drug code="idv/r" score="85" levelstanford="5" levelsir="r" /> <drug code="lpv/r" score="75" levelstanford="5" levelsir="r" /> <drug code="nfv" score="120" levelstanford="5" levelsir="r" /> <drug code="nvp" score="150" levelstanford="5" levelsir="r" /> <drug code="rpv" score="45" levelstanford="4" levelsir="i" /> <drug code="sqv/r" score="105" levelstanford="5" levelsir="r" /> <drug code="tdf" score="85" levelstanford="5" levelsir="r" /> <drug code="tpv/r" score="35" levelstanford="4" levelsir="i" /> </drugscores> i have matrix, dataframe or sth, contains drug code, score, levelstanford, levelsir. can me?
library(rvest) kk<-read_html("yourxml.xml") %>% html_nodes("drug") ss<-do.call(rbind,(lapply(c("code","score","levelstanford","levelsir"),function(i)data.frame(cbind(type=i,values=html_attr(kk,i)))))) head(ss) type values 1 code 3tc 2 code abc 3 code atv/r 4 code azt 5 code d4t 6 code ddi
Comments
Post a Comment