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

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]]

