Re: [R] Parsing XML File

2015-10-13 Thread Lorenzo Isella
Dear Jim, Thanks for your reply. What you did is 100% what I need -- I now have a data frame with the relevant data and I can take up from there. Regards Lorenzo On Sun, Oct 11, 2015 at 03:54:10PM -0400, jim holtman wrote: Not sure exactly what you want since you did not show an expected output

Re: [R] Parsing XML File

2015-10-11 Thread jim holtman
Not sure exactly what you want since you did not show an expected output, but this will extract the attributes from AccVal in the structure: > # > library(XML) > > xmlfile=xmlParse("/temp/account.xml") > > class(xmlfile) #"XMLI

[R] Parsing XML File

2015-10-11 Thread Lorenzo Isella
Dear All, I am struggling with the parsing of the xml file you can find at https://www.dropbox.com/s/i4ld5qa26hwrhj7/account.xml?dl=0 Essentially, I would like to be able to convert it to a data.frame to manipulate it in R and detect all the attributes of an account for which unrealizedPNL goes

Re: [R] Parsing XML file to data frame

2014-05-06 Thread David Winsemius
On May 5, 2014, at 11:42 AM, Timothy W. Cook wrote: > I didn't find an attached XML file. Maybe the list removes attachments? The list does not remove all attachments, It removes ones that are not among the listed acceptable formats. XML is not among the list of acceptable formats. If it had b

Re: [R] Parsing XML file to data frame

2014-05-06 Thread starcraz
Tim - the file is a hyperlink at the beginning of the message called 'sample.xml' or here's the hyperlink http://r.789695.n4.nabble.com/file/n4689883/sample.xml -- View this message in context: http://r.789695.n4.nabble.com/Parsing-XML-file-to-data-frame-tp4689883p4690021.html Sent from the R h

Re: [R] Parsing XML file to data frame

2014-05-05 Thread Timothy W. Cook
I didn't find an attached XML file. Maybe the list removes attachments? You might try posting to StackOverflow.com if this is the case. On Fri, May 2, 2014 at 2:17 PM, starcraz wrote: > Hi all - I am trying to parse out the attached XML file into a data frame. > The file is extracted from Had

[R] Parsing XML file to data frame

2014-05-02 Thread starcraz
Hi all - I am trying to parse out the attached XML file into a data frame. The file is extracted from Hadoop File Services (HFS). I am new in using the XML package so need some help in parsing out the data. Below is some code that I explore to get the attribute into a data frame. Any help is apprec