How can I read and parse the contents of a webpage in R
Asked Answered
H

3

17

I'd like to read the contents of a URL (e.q., http://www.haaretz.com/) in R. I am wondering how I can do it

Hypodermis answered 4/12, 2009 at 4:18 Comment(0)
P
36

Not really sure how you want to process that page, because it's really messy. As we re-learned in this famous stackoverflow question, it's not a good idea to do regex on html, so you will definitely want to parse this with the XML package.

Here's an example to get you started:

require(RCurl)
require(XML)
webpage <- getURL("http://www.haaretz.com/")
webpage <- readLines(tc <- textConnection(webpage)); close(tc)
pagetree <- htmlTreeParse(webpage, error=function(...){}, useInternalNodes = TRUE)
# parse the tree by tables
x <- xpathSApply(pagetree, "//*/table", xmlValue)  
# do some clean up with regular expressions
x <- unlist(strsplit(x, "\n"))
x <- gsub("\t","",x)
x <- sub("^[[:space:]]*(.*?)[[:space:]]*$", "\\1", x, perl=TRUE)
x <- x[!(x %in% c("", "|"))]

This results in a character vector of mostly just webpage text (along with some javascript):

> head(x)
[1] "Subscribe to Print Edition"              "Fri., December 04, 2009 Kislev 17, 5770" "Israel Time: 16:48 (EST+7)"           
[4] "  Make Haaretz your homepage"          "/*check the search form*/"               "function chkSearch()" 
Pathetic answered 4/12, 2009 at 14:38 Comment(1)
OOOhhhhh wow ... I am scrapping a dynamic website and I did everything in the past 7-8 hours and was not able to do it - This one worked for me. Life saviorTherein
C
4

Your best bet may be the XML package -- see for example this previous question.

Consentient answered 4/12, 2009 at 4:29 Comment(1)
But how can get rid of the html tags properly. I know I can write a RegEx expression but is there any package that make the coding less dramatic!Hypodermis
P
2

I know you asked for R. But maybe python+beautifullsoup is the way forward here? Then do your analysis with R you have scraped the screen with beautifullsoup?

Premer answered 4/12, 2009 at 16:14 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.