Hi Rui, Thanks for your prompt reply.
However unfortunately I see that the correct information is not getting fetched. Here I have tried another page: Link <- ' http://www.cmegroup.com/trading/energy/natural-gas/natural-gas_quotes_globex_options.html?optionExpiration=K4#optionProductId=1352&strikeRange=Active ' readHTMLTable((Link), which = 2, header = TRUE, na.strings = "-") I am not getting right data which is there in the site. Any additional adjustment I need to do? Thanks and regards, On Tue, Apr 22, 2014 at 10:34 PM, Rui Barradas <ruipbarra...@sapo.pt> wrote: > Hello, > > I've just noticed that na.strings is not needed and will not be used by > readHTMLTable. I was with the false impression that the dots argument was > to pass other arguments to read.table, but it's not, they're passed to > as.data.frame, that doesn't use na.strings. > > Rui Barradas > > Em 22-04-2014 17:38, Rui Barradas escreveu: > >> Hello, >> >> Have you tried which=2? >> >> dat <- readHTMLTable(readLines(Link), which = 2, header = TRUE, >> na.strings = "-") >> >> dat[, 3:15] <- lapply(dat[, 3:15], function(x) sub("([[:digit:]]) [ab]", >> "\\1", x)) >> dat[, 3:15] <- lapply(dat[, 3:15], function(x)as.numeric(as. >> character(x))) >> >> str(dat) >> >> >> Hope this helps, >> >> Rui Barradas >> >> Em 22-04-2014 16:30, Christofer Bogaso escreveu: >> >>> Hi Rui, >>> >>> Sorry to late reply. Thanks for your pointer. >>> >>> However using this method, I am having difficulty to download related >>> data from same site. >>> >>> I need to download data from: >>> >>> >>> 'http://www.cmegroup.com/trading/energy/natural-gas/ >>> natural-gas_quotes_globex_options.html?optionExpiration= >>> K4#optionProductId=1352' >>> >>> >>> So I tried following: >>> >>> library(XML) >>> Link <- >>> 'http://www.cmegroup.com/trading/energy/natural-gas/ >>> natural-gas_quotes_globex_options.html?optionExpiration= >>> K4#optionProductId=1352' >>> >>> readHTMLTable(readLines(Link), which = 1, header = TRUE, na.strings = >>> "-") >>> >>> Unfortunately I didnot get what I wanted. >>> >>> Can you (or someone) please help me on this? >>> >>> Thanks for your time. >>> >>> >>> On Wed, Apr 9, 2014 at 1:34 AM, Rui Barradas <ruipbarra...@sapo.pt >>> <mailto:ruipbarra...@sapo.pt>> wrote: >>> >>> Hello, >>> >>> Try the following. >>> >>> library(XML) >>> URL <- >>> >>> "http://www.cmegroup.com/__trading/interest-rates/stir/__ >>> eurodollar_quotes_openOutcry.__html >>> >>> >>> <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 >>> >>> >>> <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 >>> >>> >>> <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@r-project.org <mailto:R-help@r-project.org> mailing list >>> https://stat.ethz.ch/mailman/__listinfo/r-help >>> <https://stat.ethz.ch/mailman/listinfo/r-help> >>> PLEASE do read the posting guide >>> http://www.R-project.org/__posting-guide.html >>> <http://www.R-project.org/posting-guide.html> >>> and provide commented, minimal, self-contained, reproducible >>> code. >>> >>> >>> >> ______________________________________________ >> R-help@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. >> > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
