Hello,
I'm attempting to read information from an XML into a data frame in R using
the "XML" package. I am unable to get the data into a data frame as I would
like. I have some sample code below.
*XML Code:*
Header...
Data I want in a data frame:
<data>
<row BRAND="GMC" NUM="1" YEAR="1999" VALUE="10000" />
<row BRAND="FORD" NUM="1" YEAR="2000" VALUE="12000" />
<row BRAND="GMC" NUM="1" YEAR="2001" VALUE="12500" />
<row BRAND="FORD" NUM="1" YEAR="2002" VALUE="13000" />
<row BRAND="GMC" NUM="1" YEAR="2003" VALUE="14000" />
<row BRAND="FORD" NUM="1" YEAR="2004" VALUE="17000" />
<row BRAND="GMC" NUM="1" YEAR="2005" VALUE="15000" />
<row BRAND="GMC" NUM="1" YEAR="1967" VALUE="PRICLESS" />
<row BRAND="FORD" NUM="1" YEAR="2007" VALUE="17500" />
<row BRAND="GMC" NUM="1" YEAR="2008" VALUE="22000" />
</data>
*R Code:*
doc< -xmlInternalTreeParse ("Sample2.xml")
top <- xmlRoot (doc)
xmlName (top)
names (top)
art <- top [["row"]]
art
**
*Output:*
> art<row BRAND="GMC" NUM="1" YEAR="1999" VALUE="10000"/>
This is where I am having difficulties. I am unable to "access" additional
rows; ( i.e. <row BRAND="GMC" NUM="1" YEAR="1967" VALUE="PRICLESS" /> )
and I am unable to access the individual entries to actually create the
data frame. The data frame I would like is as follows:
BRAND NUM YEAR VALUE
GMC 1 1999 10000
FORD 2 2000 12000
GMC 1 2001 12500
etc........
Any help or suggestions would be appreciated. Conversly, my eventual goal
would be to take a data frame and write it into an XML in the previously
shown format.
Thank you
AG
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
