R help - Dec 2009 - Problem in reading data

In my Excel file, I have data in following format :

Feb-07	38.49
Mar-07	39.95
Apr-07	37.47
May-07	35.77
Jun-07	32.96
Jul-07	33.27

I tried to copy this data as a time series using following code :

library(zoo)
dat <- read.zoo(file="clipboard", format="%m-%y")

However getting following error :

Error in read.zoo(file = "clipboard", format = "%m-%y") : 
  index has bad entries at data rows: 1 2 3 4 5 6

Can anyone please guide me what is the right way to do that?

Thanks,

-- 
View this message in context:
http://n4.nabble.com/Problem-in-reading-data-tp932386p932386.html
Sent from the R help mailing list archive at Nabble.com.

Specify that your input is of class yearmon (as opposed to Date class) and
also correct the format specification as per the percent codes in ?strptime

library(zoo)
z <- read.zoo("clipboard", FUN = as.yearmon, format =
"%b-%y")



On Tue, Dec 1, 2009 at 12:55 PM, Megh <megh700004@yahoo.com> wrote:
>
> In my Excel file, I have data in following format :
>
> Feb-07  38.49
> Mar-07  39.95
> Apr-07  37.47
> May-07  35.77
> Jun-07  32.96
> Jul-07  33.27
>
> I tried to copy this data as a time series using following code :
>
> library(zoo)
> dat <- read.zoo(file="clipboard", format="%m-%y")
>
> However getting following error :
>
> Error in read.zoo(file = "clipboard", format = "%m-%y")
:
>  index has bad entries at data rows: 1 2 3 4 5 6
>
> Can anyone please guide me what is the right way to do that?
>
> Thanks,
>
> --
> View this message in context:
> http://n4.nabble.com/Problem-in-reading-data-tp932386p932386.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.
>
	[[alternative HTML version deleted]]