Section<- xml_attr(xml_find_first(nodes, './/section'), 'name') #parse the requested information out of each node Read the data in, parse out the desired attributes and nodes and assemble into a data frame. This is a pretty straight forward problem. I prefer to use the xml2 library over the xml library. Parsing XML file with known structure and repeating elements I found this answer fairly helpful, but it still can't seem to unpack my data. Section|Speaker|Speaker Type| Speaker Name|BodyĪddress|0 |President | Honest Abe |Four score and seven years ago My files look as follows (*****second line edited): Īnd I would like to end up with a dataframe that links some of the info in the two sections, something like I think the problem is the plist format, because some of the other answers that I've tried to apply don't work on these files.

I'm new to working with xml, and I have some speech xml files that I'm trying to flatten into dataframes in R, but I can't get them to be read using some of the standard functions in the XML package. How can I get the script to ignore the extras (or maybe what is the right search term to incorporate them?) Thanks!!! Sorry, edited with one more little nuance! I had simplified my raw file a little too much in the example I provided, so while your solution works beautifully as-is, what if there are a few extra things thrown into the second line? Those seem to throw off the xml_find_all(page, '//event'), since now it can't find that node.

Error parsing plist file iatkos l2