
On Jan 29, 2013, at 9:03 AM, Anika Masters wrote:

>
> If I want to add names utilizing the information within the file, is  
> there a "good" way to do so?
> e.g."transactionAmounts_transactionShares_value" might be one name  
> I'd like the data to have.
>
>  mylist$nonDerivativeTable[[1]][5]
>

 > mylist <- xmlToList(myxml)
 > names(mylist$nonDerivativeTable)
[1] "nonDerivativeTransaction" "nonDerivativeTransaction"
[3] "nonDerivativeTransaction" "nonDerivativeTransaction"
[5] "nonDerivativeTransaction"


 > names(mylist$nonDerivativeTable) <- paste( names(mylist 
$nonDerivativeTable), 1:length(mylist$nonDerivativeTable), sep="_")

 > names(mylist$nonDerivativeTable)
[1] "nonDerivativeTransaction_1" "nonDerivativeTransaction_2"
[3] "nonDerivativeTransaction_3" "nonDerivativeTransaction_4"
[5] "nonDerivativeTransaction_5"
>
>
> On Tue, Jan 29, 2013 at 3:42 AM, David Winsemius <dwinsemius@comcast.net 
> > wrote:
>
> On Jan 28, 2013, at 9:00 PM, Anika Masters wrote:
>
> I am a relatively new user to R, and I am trying to learn more about
> converting data in an XML document into "2-dimensional format" such  
> as a
> table or array.  I might eventually wish to export this data into a
> relational database such as SQL, and/or to work with this data  
> within the R
> package.
>
> My sample XML document is located at "
> http://www.sec.gov/Archives/edgar/data/743988/000124636013000561/form.xml 
> "
>
> I have successfully import the XML document and then converted the XML
> document to a list.
>
> I am "stuck" trying to convert the document into a "2-dimenional"  
> table or
> dataframe.
>
> What is a "good" way to convert the XML document to a 2-dimensional  
> table
> or data.frame?  Ideally, I'd like a table with 1 row for each XML  
> document,
> and unique fieldnames.  If fieldnames repeat, I'd like the names to be
> numbered sequentially
>
> e.g.
> $nonDerivativeTable$nonDerivativeTransaction$transactionAmounts 
> $transactionPricePerShare$value_1
> $nonDerivativeTable$nonDerivativeTransaction$transactionAmounts 
> $transactionPricePerShare$value_2
> $nonDerivativeTable$nonDerivativeTransaction$transactionAmounts 
> $transactionPricePerShare$value_3
>
>
>
> It might help if you picked a different example. At the moment the  
> tree you are working with has no names of that sublist:
>
> > names(mylist$nonDerivativeTable)
> NULL
>
> (Most of your other calls throw errors.)
>
>
> -- 
> David.
> etc
>
>
>
>
> myxml = xmlParse("
> http://www.sec.gov/Archives/edgar/data/743988/000124636013000561/form.xml 
> ")
> mylist <- xmlToList(mydoc)
> mydf <- xmlToDataFrame(mydoc)
> mydf2 <- data.frame(mylist)
> mytable <- as.table(mylist)
> mydf2 <- data.frame(mydoc)
> mytable <- as.table(mydoc)
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>
> David Winsemius, MD
> Alameda, CA, USA
>
>

David Winsemius, MD
Alameda, CA, USA


	[[alternative HTML version deleted]]

