[R] example - export a data frame to an XML file

zubin binabina at bellsouth.net
Mon Sep 29 14:05:15 CEST 2008


Duncan, thanks for the note - the schema looks like this - is this what 
your asking for?

<document>
 <row>
  <date>2007-02-01</date >
  <UYG_Open>71.32</UYG_Open >
  <UYG_High>71.34</UYG_High >
  <UYG_Low>71.32</UYG_Low >
  <UYG_Close>71.34</UYG_Close >
  <UYG_Volume>200</UYG_Volume >
  <UYG_Adjusted>69.23</UYG_Adjusted >
 </row>
 <row>
  <date>2007-02-02</date >
  <UYG_Open>72.2</UYG_Open >
  <UYG_High>72.2</UYG_High >
  <UYG_Low>72.2</UYG_Low >
  <UYG_Close>72.2</UYG_Close >
  <UYG_Volume>200</UYG_Volume >
  <UYG_Adjusted>70.06</UYG_Adjusted >
 </row>
</document>

Duncan Temple Lang wrote:
> Hi Zubin.
>
>
>   The first thing is to send us a link to the schema that the
> other application expects. That would give us a "one-to-one"
> mapping; otherwise, data.frame to arbitrary XML is to vague.
>
>   Currently, there is nothing in the XML package that would
> be able to take an XML schema and write an R object to such a
> structure. However, I am in the process of creating an XMLSchema
> package which can read XML schema and make the description available to
> R so that we can read data from an XML file corresponding to that schema
> and this could be adapted in some ways to automate the creation of
> XML from an R object (under certain assumptions).
>
>  So please send us all a link to the XML schema.
>
>   D.
>
>
> zubin wrote:
>> In need of exporting an XML file from R, I scrub some data in R and 
>> push the data into another application requiring XML.  The data set 
>> is a very straightforward data frame of stock prices- see below.  I 
>> know the package XML is the one to use, but need an example or some 
>> direction on where to start.  I know we need to define the schema - 
>> can this be done in the R XML package?
>>>
>>> "date","UYG.Open","UYG.High","UYG.Low","UYG.Close","UYG.Volume","UYG.Adjusted" 
>>>
>>> "2007-02-01",71.32,71.34,71.32,71.34,200,69.23
>>> "2007-02-02",72.2,72.2,72.2,72.2,200,70.06
>>> "2007-02-05",71.76,71.76,71.76,71.76,5100,69.63
>>> "2007-02-06",72.85,72.85,72.85,72.85,3800,70.69
>>> "2007-02-07",72.85,72.85,72.85,72.85,0,70.69
>>>
>>>
>>>
>>>
>>
>> ______________________________________________
>> R-help at 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.
>



More information about the R-help mailing list