I am getting problems using read.zoo I have the following data frame> head(anlyNiftyDat[,1:10])TIMESTAMP ACC AMBUJACEM AXISBANK BAJAJ-AUTO BHARTIARTL BHEL BPCL CAIRN CIPLA 1 2010-01-04 00:00:00 913.60 106.10 992.10 1732.05 325.20 2426.10 650.75 285.50 337.55 2 2010-01-05 00:00:00 901.75 105.30 1012.80 1740.05 330.35 2435.40 640.95 295.85 331.50 3 2010-01-06 00:00:00 907.60 105.95 995.80 1713.15 326.85 2426.25 631.30 299.45 344.90 4 2010-01-07 00:00:00 913.35 105.80 1002.85 1683.10 329.40 2409.50 619.05 307.85 342.05 5 2010-01-08 00:00:00 912.15 105.90 1015.95 1655.25 325.05 2424.10 629.55 306.15 341.10 6 2010-01-11 00:00:00 915.15 106.10 1049.40 1669.55 328.95 2396.95 627.90 300.15 342.30> class(anlyNiftyDat)[1] "cast_df" "data.frame">> anlyNiftyDatZoo <- read.zoo(anlyNiftyDat,split=2,check.names=F) > head(anlyNiftyDatZoo[,1:10])X805.45.1 X805.45.2 X805.45.3 X805.45.4 X805.45.5 X805.45.6 X805.45.7 X805.45.8 X805.45.9 X805.45.10 2010-01-04 NA NA NA NA NA NA NA NA NA NA 2010-01-05 NA NA NA NA NA NA NA NA NA NA 2010-01-06 NA NA NA NA NA NA NA NA NA NA 2010-01-07 NA NA NA NA NA NA NA NA NA NA 2010-01-08 NA NA NA NA NA NA NA NA NA NA 2010-01-11 NA NA NA NA NA NA NA NA NA NA Both the column names and values are thrown off.
On Mon, Oct 18, 2010 at 4:24 AM, Santosh Srinivas <santosh.srinivas at gmail.com> wrote:> I am getting problems using read.zoo > > I have the following data frame > >> head(anlyNiftyDat[,1:10]) > ? ? ? ? ? ?TIMESTAMP ? ?ACC AMBUJACEM AXISBANK BAJAJ-AUTO BHARTIARTL > BHEL ? BPCL ?CAIRN ?CIPLA > 1 2010-01-04 00:00:00 913.60 ? ?106.10 ? 992.10 ? ?1732.05 ? ? 325.20 > 2426.10 650.75 285.50 337.55 > 2 2010-01-05 00:00:00 901.75 ? ?105.30 ?1012.80 ? ?1740.05 ? ? 330.35 > 2435.40 640.95 295.85 331.50 > 3 2010-01-06 00:00:00 907.60 ? ?105.95 ? 995.80 ? ?1713.15 ? ? 326.85 > 2426.25 631.30 299.45 344.90 > 4 2010-01-07 00:00:00 913.35 ? ?105.80 ?1002.85 ? ?1683.10 ? ? 329.40 > 2409.50 619.05 307.85 342.05 > 5 2010-01-08 00:00:00 912.15 ? ?105.90 ?1015.95 ? ?1655.25 ? ? 325.05 > 2424.10 629.55 306.15 341.10 > 6 2010-01-11 00:00:00 915.15 ? ?106.10 ?1049.40 ? ?1669.55 ? ? 328.95 > 2396.95 627.90 300.15 342.30 > >> class(anlyNiftyDat) > [1] "cast_df" ? ?"data.frame" >> > >> anlyNiftyDatZoo <- read.zoo(anlyNiftyDat,split=2,check.names=F) >> head(anlyNiftyDatZoo[,1:10]) > ? ? ? ? ? X805.45.1 X805.45.2 X805.45.3 X805.45.4 X805.45.5 X805.45.6 > X805.45.7 X805.45.8 X805.45.9 X805.45.10 > 2010-01-04 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-05 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-06 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-07 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-08 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-11 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > > Both the column names and values are thrown off.There is no reason to think that read.zoo should be able to understand cast_df objects from the reshape package. Use the reshape2 package instead which produces ordinary data frames rather than cast_df objects. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com
Okay ... now I gotcha ... Thanks -----Original Message----- From: Gabor Grothendieck [mailto:ggrothendieck at gmail.com] Sent: 18 October 2010 17:19 To: Santosh Srinivas Cc: r-help at r-project.org Subject: Re: [R] read.zoo issues On Mon, Oct 18, 2010 at 4:24 AM, Santosh Srinivas <santosh.srinivas at gmail.com> wrote:> I am getting problems using read.zoo > > I have the following data frame > >> head(anlyNiftyDat[,1:10]) > ? ? ? ? ? ?TIMESTAMP ? ?ACC AMBUJACEM AXISBANK BAJAJ-AUTO BHARTIARTL > BHEL ? BPCL ?CAIRN ?CIPLA > 1 2010-01-04 00:00:00 913.60 ? ?106.10 ? 992.10 ? ?1732.05 ? ? 325.20 > 2426.10 650.75 285.50 337.55 > 2 2010-01-05 00:00:00 901.75 ? ?105.30 ?1012.80 ? ?1740.05 ? ? 330.35 > 2435.40 640.95 295.85 331.50 > 3 2010-01-06 00:00:00 907.60 ? ?105.95 ? 995.80 ? ?1713.15 ? ? 326.85 > 2426.25 631.30 299.45 344.90 > 4 2010-01-07 00:00:00 913.35 ? ?105.80 ?1002.85 ? ?1683.10 ? ? 329.40 > 2409.50 619.05 307.85 342.05 > 5 2010-01-08 00:00:00 912.15 ? ?105.90 ?1015.95 ? ?1655.25 ? ? 325.05 > 2424.10 629.55 306.15 341.10 > 6 2010-01-11 00:00:00 915.15 ? ?106.10 ?1049.40 ? ?1669.55 ? ? 328.95 > 2396.95 627.90 300.15 342.30 > >> class(anlyNiftyDat) > [1] "cast_df" ? ?"data.frame" >> > >> anlyNiftyDatZoo <- read.zoo(anlyNiftyDat,split=2,check.names=F) >> head(anlyNiftyDatZoo[,1:10]) > ? ? ? ? ? X805.45.1 X805.45.2 X805.45.3 X805.45.4 X805.45.5 X805.45.6 > X805.45.7 X805.45.8 X805.45.9 X805.45.10 > 2010-01-04 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-05 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-06 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-07 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-08 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > 2010-01-11 ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA ? ? ? ?NA > NA ? ? ? ?NA ? ? ? ?NA ? ? ? ? NA > > Both the column names and values are thrown off.There is no reason to think that read.zoo should be able to understand cast_df objects from the reshape package. Use the reshape2 package instead which produces ordinary data frames rather than cast_df objects. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com