Christofer Bogaso
2014-Apr-08 19:40 UTC
[R] Need to download this data... can someone help?
Hi again, I am looking some way to download this data: http://www.cmegroup.com/trading/interest-rates/stir/eurodollar_quotes_openOutcry.html So far I have tried following code: library(XML) data <- xmlParse(" http://www.cmegroup.com/trading/interest-rates/stir/eurodollar_quotes_openOutcry.html ") However not be able to get in right way. Really appreciate if someone point me on right approach. Thanks for your time. [[alternative HTML version deleted]]
Hello, Try the following. library(XML) URL <- "http://www.cmegroup.com/trading/interest-rates/stir/eurodollar_quotes_openOutcry.html" dat <- readHTMLTable(readLines(URL), which=1, header=TRUE, na.strings = "-") str(dat) dat[4:10] <- lapply(dat[4:10], function(x) as.numeric(as.character(x))) head(dat) Hope this helps, Rui Barradas Em 08-04-2014 20:40, Christofer Bogaso escreveu:> Hi again, > > I am looking some way to download this data: > > http://www.cmegroup.com/trading/interest-rates/stir/eurodollar_quotes_openOutcry.html > > So far I have tried following code: > > library(XML) > data <- xmlParse(" > http://www.cmegroup.com/trading/interest-rates/stir/eurodollar_quotes_openOutcry.html > ") > > However not be able to get in right way. > > Really appreciate if someone point me on right approach. > > Thanks for your time. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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. >