[R] (simple) xml into data.frame and reverse

[stefan.d...@gmail.com]

Hello,
I  am trying to convert a simple data.frame (it will always be a few
equally long variables) into the XML format (which I don't understand
too well but need as input for another program) and reverse the
operation (from XML back into data.frame).
I found some code which does the first and it works good enough for me
(see below). Is there an easy way to reverse the operation? My XML
files are nothing fancy (no child nodes or anything, at least as far
as I can see.


### data.frame
data<- as.data.frame(cbind(c(0 ,1 ),c(  500 ,  300),c(200, 400)))
names(data)<-c("age","0","1")

### converts data.frame into XML
xml <- xmlTree()
xml$addTag("populationsize", close=FALSE)
for (i in 1:nrow(data)) {
xml$addTag("size", close=FALSE)
for (j in names(data)) {
xml$addTag(j, data[i, j])
}
xml$closeTag()
}
xml$closeTag()

# view the result
cat(saveXML(xml))

I put below also an example of how my data looks like.
Thanks for any advice!
Best and have a great day,
Stefan




APPENDIX
XML-file
--



 
   0
   0
   500
 
 
   0
   1
   300
 
 
   1
   0
   200
 
 
   1
   1
   400
 


-
DATAFRAME

age0 1
0  500   300
1  200   400

__
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.

Re: [R] (simple) xml into data.frame and reverse

[stefan.d...@gmail.com]

Hi Duncan,
thanks for the advice and the link. I just realized there is a mistake
in the code I posted and I currently don't have the time to correct
it. So I can not try your function (yet). But I will do so in the next
few days and tell you if it doesnt work.
Thanks again and best,
Stefan

On Wed, Jul 15, 2009 at 2:37 PM, Duncan Temple
Lang wrote:
>
> Thanks Dieter. It should have been
>
>   http://www.omegahat.org/RSXML/xmlToDataFrame.R
>
> as it is an R file.
>
>  Thanks
>   D.
>
> Dieter Menne wrote:
>>
>>
>> Duncan Temple Lang wrote:
>>>
>>>
>>> I wrote some relatively general functions, but hastily written functions
>>> to read this sort of data. You can find them attached or at
>>>
>>>   http://www.omegahat.org/RSXML/xmlToDataFrame.xml
>>>
>>>
>>
>> Looks like that's the wrong link. I also did not find it mentioned in the
>> parent page.
>>
>> Dieter
>>
>>
>
> __
> 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.
>

__
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.

[R] Reading a SpreadsheetML / XMLNS into R xmlns="urn:schemas-microsoft-com:office:spreadsheet

[stefan.d...@gmail.com]

Hello,
I use a software that outputs the data in a form/dialect(?) of xml (I
think its called "SpreadsheetML", see below for an excerpt). It allows
(admittedly) easy import of such files into Excel. I would like,
however, to import it directly into R. I am familiar how to do that
with standard xml-files (mostly thanks to Duncan Temple Lang's help).
But I haven't found the right command yet to do it with this kind of
data in R. I would figure it couldn't be to difficult as it is
designed to hold the data in separate sheets that contain a single
table.

Any hint appreciated.
Have a great weekend!
Best,
Stefan



http://www.w3.org/TR/REC-html40";>
 
  12.00
 
 
  10005
  10005
  120
  135
  False
  False
 
 
  
   
   
   
   
   
   
  
 


 
  
   

[... omission...]

 
  
   False
   False
  
 


__
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.