Try this: library(zoo) library(chron)
my.url <- "http://www.federalreserve.gov/releases/h15/data/Business_day/H15_ED_M1.txt" z <- read.zoo(my.url, skip = 8, header = TRUE, sep = ",", na.strings = "ND", strip.white = TRUE, FUN = as.chron) plot(z[1:50,]) # or to plot with NAs interpolated plot(na.approx(z[1:50,])) See the three zoo vignettes: vignette(package = "zoo") vignette("zoo") # etc. and for more on dates see R News 4/1. On Thu, Mar 26, 2009 at 6:58 AM, gug <guygr...@netvigator.com> wrote: > > Hello, > > First of all, I'm new to R and I don't have anyone who already knows the > language to ask for tips, so please excuse my ignorance. > > I'm trying to download data direct from the Federal Reserve statistics > website and graph it, using the following: > > #This downloads the data from the Fed website > download.file("http://www.federalreserve.gov/releases/h15/data/Business_day/H15_ED_M1.txt","Eurodollar_deposits1M.dat") > > #This reads that data into a table > data_download=read.table("Eurodollar_deposits1M.dat",skip=8,sep=",",head=T) > > #This is attempting to get R to read the date column, which is in > "mm/dd/yyyy" format > #I have restricted it to the first 50 data points (to keep it simple) > date_vec = as.Date(data_download[1:50,1],"%m/%d/%y") > > #This reads the values again for just the first 50 data points > eurodollar_vec = data_download[1:50,2] > > #This plots the date and data values. > plot(date_vec,eurodollar_vec) > > > A few issues with the output from this: > > 1) The date_vec data ends up looking like this "2019-01-04" - for some > reason all year 2019, irrespective of the actual year (e.g. 1971, 1972). > Any suggestions as to where I am going wrong? > > 2) The chart ends up as a scatter diagram, not surprisingly. I initially > tried to use the ts.plot() function but when I did, I found that it doesn't > use the date column in the data as the x axis. Is there a way of creating a > time series that uses the date column, or alternatively, how would I turn > these two columns (date & value) into a line graph? > > 3) The y-axis output should be from about 4.5 to about 8.5, but the y-axis > shows as being about 430-670. There also seems to be a line of points > across the top which are all of the same value - as though anything above > about 670 gets charted as 670. > > > I'm sorry for this being a "what am I doing wrong" post, but I have looked > through the manuals without success, and I am new enough to R that I don't > have a feel for ways round these sorts of problems. Any suggestions would > be greatly appreciated. Thanks. > -- > View this message in context: > http://www.nabble.com/Getting-started%2C-tp22719735p22719735.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. > ______________________________________________ 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.