Re: [R] Merging daily and weekly data

Hi Oystein, Maybe this is what you are looking for: Keyword: merge() -- table1<-read.table("daily.data") table2<-read.table("weekly.data") (maybe you need to create a new common coloumn for daily and weekly data set. For

Re: [R] Merging daily and weekly data

On Mon, Apr 14, 2008 at 6:09 AM, Øystein Myrland <[EMAIL PROTECTED]> wrote: > Dear R-help group, > > I have a dataset with daily closing prices from a stock exchange (consecutive > 5 trading days) from a firm trading a specific commodity. The date variable > looks like: > > quote_date > 20080411

Re: [R] Merging daily and weekly data

Here is one way to get the 'week': > x <- as.character(seq(20080401, 20080430)) > # get the week > cbind(x, format(as.Date(x, "%Y%m%d"), "%W")) x [1,] "20080401" "13" [2,] "20080402" "13" [3,] "20080403" "13" [4,] "20080404" "13" [5,] "20080405" "13" [6,] "20080406" "13" [7,] "2008040

[R] Merging daily and weekly data

Dear R-help group, I have a dataset with daily closing prices from a stock exchange (consecutive 5 trading days) from a firm trading a specific commodity. The date variable looks like: quote_date 20080411 With the format; mmdd. Moreover, I have another data set with a (average) weekly pri