
Hi,
I have a problem converting a XML file, via the XML package, to a data.frame.
 
The XML file looks like this:
 
<Transaction>
  <ID value="0044"/>
  <Var1 value="XYZ159"/>
  <Var2 value="_"/>
  <Var3 value="AMR1.0-INT-1005"/>
  <Var4 value="2010-05-25 10:44:16:673"/>
  <Var5 value="1"/>
  <Var6 value="0"/>
</Transaction>
<Transaction>
  <ID value="0046"/>
  <Var1 value="XBC254"/>
  <Var2 value="GLOBAL"/>
  <Var3 value="AMR2.0-INT-9997"/>
  <Var4 value="2010-05-25 11:22:50:803"/>
  <Var5 value="2"/>
  <Var6 value="0"/>
</Transaction>
<Transaction>
  <ID value="unknown"/>
  <Var1 value="HGF358"/>
  <Var2 value="REGION_A"/>
  <Var3 value="AMR2.5-INT-1154"/>
  <Var4 value="2010-05-24 10:08:26:711"/>
  <Var5 value="3"/>
  <Var6 value="0"/>
</Transaction>
 
I don't usually use XML files, but I have searched for an answer for quite a while. I have tried "xmlToDataFrame" but it demands a structure similar to this:
 
<top>
     <obs>
       <var1>value</var1>
       <var2>value</var2>
       <var3>value</var3>
     </obs>
     <obs>
       <var1>value</var1>
       <var2>value</var2>
       <var3>value</var3>
     </obs>  
</top>
 
The top node "<top>" could in my case maybe be added to the XML file directly (or via a R command?), but the main issue is to use the children structure in my file (which is different compared to the one that can be used with the "xmlToDataFrame"),
<var1 value=""/>
to convert the XML file to a meaningful data.frame with both categorical and quantitative data.
 
 
Any tips or tricks? They are highly appreciated.
 
Thanks,
Magnus
  		 	   		  
_________________________________________________________________
Hotmail: Free, trusted and rich email service.

	[[alternative HTML version deleted]]

