[R] Trouble with reading xml in R
dklerke at hotmail.com
Tue Apr 30 18:12:17 CEST 2013
Hi I have been trying for days now to read the contents of this xml file into
R. I tried the simpler solution xmlToDataFrame, which worked on another
file, but somehow it doesn't work for this file.
I have tried different other solutions, but I just can't seem to get it
doc <- xmlRoot(xmlTreeParse(url))
art <- doc[] [["DeliveryDay"]]
fields <- xmlApply(art[]), names)
> "TimeStepID.text" "Purchase.Price" "Purchase.Volume" "Sell.Price"
So I want the result to be a 2 data.frames which looks like this (of course
for the sell data.fram it would say sell)
TimeStepID Purchase.Price Purchase.Volume
1 3000 13000
1 2900 13400
24 2000 12333
How is this possible?
Also an extra question. My filename is called something like (a new file
The first part after the "AU" is the current date, this I can generate
automacticly but I can't generate the last since its the date, time, minute
and second of the time the data was uploaded from another party to their ftp
- where I'm getting the data.
Is there anyway to get R to find the right file, when I can only generate
part of the file?
More information about the R-help