Ever remember the day you have to copy a table from WWW paste it into excel and still have to spend more time fixing it into the format you want, and still can’t do nothing else to it beside looking at an Excel table?
During the past couple days, I have been looking around and saw that they have already incorporate this functionality in R. I also read on R-blogger today http://bit.ly/9UawIE
The process to import the table seems pretty simple. Here’s how.
# URL for the Google Data
tables = readHTMLTable(u)
my.table=tables[] # The first element of the list is empty
xpathApply( htmlTreeParse("http://blabla", useInt=T), "//td", function(x) xmlValue(x))