Hello!
I have a data set similar to the data set "monthly" in the example below:
monthly<-data.frame(month=c(20090301,20090401,20090501,20100301,20100401,20090301,20090401,20090501,20100301,20100401),monthly.value=c(100,200,300,101,201,10,20,30,11,21),market=c("Market
A","Market A", "Market A","Market A", "Market A","Market B", "Market
B","Market B","Market B", "Market B"))
monthly$month<-as.character(monthly$month)
monthly$month<-as.Date(monthly$month,"%Y%m%d")
(monthly)
str(monthly)
I am trying to use read.zoo - like in 3 lines below:
library(zoo)
z <- read.zoo(monthly, split = "market")
(z)
With the artificially produced data set above, it works just fine.
However, with my data it gives me an error:
OrigData<-read.csv("OrigData.csv")
OrigData$Month<-as.character(OrigData$Month)
OrigData$Month<-as.Date(OrigData$Month,"%m/%d/%y")
str(OrigData)
### The result of str(OrigData) is:
'data.frame': 440 obs. of 3 variables:
$ Brand : Factor w/ 11 levels "aBrand","bBrand",..:
Month :Class 'Date' num [1:440] 13514 13545 13573 13604,...
Value: int NA NA NA 100 100 100 100 100 100 99
Then I try:
z <- read.zoo(OrigData, split = "Brand")
And get the error:
Error in read.zoo(OrigData, split = "Brand") :
index has 440 bad entries at data rows: 1 2 3 4 5 6 7 8 9 10 11 12 13
But the structure of my OrigData is exactly the same as of monthly. OK
- OrigData always has a few NAs in "Value" coming first - but that's
consistent for all brands.
Any idea what might be wrong?
Thanks a lot!
Just in case -attaching the actual file.
Dimitri
______________________________________________
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.
