Assignment W7 - Working with XML and JSON in R

DATA-607, Spring 2019

When the files were first imported, the shape of the data frames were not consistent. In one case, it appeared as a list without attribute names. By tweaking the source file structures and doing some transformations with dplyr I was able to standardize their structure as shown below.

The source files can be found on github

XML

xmldf <- xmlToDataFrame("Books.xml", stringsAsFactors = FALSE)  
(xmldf)

HTML

htmldf <- 
  read_html("Books.html") %>%         
  html_nodes("table") %>%
    .[[1]] %>%        
  html_table(trim = TRUE, header = TRUE) %>% 
  as.data.frame()

(htmldf)

JSON

jsondf <- fromJSON("Books.json") %>% 
  remove_rownames()

(jsondf)