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 <dwinsem...@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]] ______________________________________________ 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.
