How to convert xml data to data frame in R -



How to convert xml data to data frame in R -

hello guys, need load xml file info frame in r. xml format shown below. how acheive same?

<?xml version="1.0" encoding="utf-8"?><posts> <row id="1" posttypeid="1" acceptedanswerid="17" creationdate="2010-07-26t19:14:18.907" score="6"/></posts>

i tried below code....it not give desired output. expecting tabular output column names , values listed below.

library(xml) xml.url ="test.xml" xmlfile = xmltreeparse(xml.url) class(xmlfile) xmltop=xmlroot(xmlfile) print(xmltop)[1:2] plantcat <- xmlsapply(xmltop, function(x) xmlsapply(x, xmlvalue)) plantcat_df <- data.frame(t(plantcat))

xml.text <- '<?xml version="1.0" encoding="utf-8"?> <posts> <row id="1" posttypeid="1" acceptedanswerid="17" creationdate="2010-07-26t19:14:18.907" score="6"/> <row id="2" posttypeid="1" acceptedanswerid="17" creationdate="2010-07-26t19:14:18.907" score="6"/> <row id="3" posttypeid="1" acceptedanswerid="17" creationdate="2010-07-26t19:14:18.907" score="6"/> <row id="4" posttypeid="1" acceptedanswerid="17" creationdate="2010-07-26t19:14:18.907" score="6"/> </posts>' library(xml) xml <- xmlparse(xml.text) result <- as.data.frame(t(xmlsapply(xml["/posts/row"],xmlattrs)), stringsasfactors=false) # id posttypeid acceptedanswerid creationdate score # 1 1 1 17 2010-07-26t19:14:18.907 6 # 2 2 1 17 2010-07-26t19:14:18.907 6 # 3 3 1 17 2010-07-26t19:14:18.907 6 # 4 4 1 17 2010-07-26t19:14:18.907 6

this bit trickier usual because info in attributes, not nodes (the nodes empty), can't utilize xlmtodataframe(...) unfortunately.

all info above still character, still need convert columns whatever class appropriate.

xml r xml-parsing

-

Comments

Post a Comment

Popular posts from this blog

maven fortify plugin : Unable to load build session with ID XXXXX .. See log file for more details -

maven fortify plugin : Unable to load build session with ID XXXXX .. See log file for more details - i took refrence : generating fortify study in maven but invoking : mvn sca:scan throws below error : unable load build session id xxxxx .. see log file more details. [error] error invoking sourceanalyzer. exit code: 1. verify project settings , sca installation. i tried looking around various posts , no luck. could please advise. directly running "mvn sca:scan" not work. next needs executed before "mvn sca:scan"" mvn sca:translate plugins fortify sca
Read more

c# - Primavera WebServices does not return any data -

c# - Primavera WebServices does not return any data - i using primavera webservices (version 6.2.1) read info primavera database (sqlserver 2008r2) in winform application (c#). utilize http cookie container authentication mode. before moved database new server able login , read info primavera database when moved db (using backup , restore), can still login db primavera webservices homecoming null request. this code login: authenticationservice authservice = new authenticationservice( ); authservice.cookiecontainer = new system.net.cookiecontainer( ); authservice.url = _p6wsauthenticationservice; login loginobj = new login( ); loginobj.username = pv_username; loginobj.password = pv_password; loginobj.databaseinstanceid = 1; loginobj.databaseinstanceidspecified = true; loginobj.verbosefaults = true; loginobj.verbosefaultsspecified = true; loginresponse loginreturn = authservice.login( loginobj ); readdatabaseinstancesresponsedatabaseinstance[] rea...
Read more

android - Display emoji panel with genymotion - keyboard/touch input? -

android - Display emoji panel with genymotion - keyboard/touch input? - i seek no luck open panel emoji icons cannot find if possible on genymotion (?) input keyboard. regards go settings->language , input->current keyboard turn on "show input method" switch. this cause keyboard appear on screen when input text, way android works on device doesn't have hardware keyboard. can utilize input emoji. if there's improve way, or way, don't know it. android android-emulator avd genymotion emoji
Read more