Re: [R] Problem in reading data

2009-12-01 Thread Gabor Grothendieck
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 wrote: > > In my Excel file,

[R] Problem in reading data

2009-12-01 Thread Megh
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 err

Re: [R] problem in reading data

2009-05-01 Thread tedzzx
Dear jholtman, The problem is that in this case, it seems that the blank is not replaced by NA according to the information I quote. It is replaced by blank. I have try: which(is.na(a$V4)), but get NA. I want to delete the rows that have different format from others. jholtman wrote: > > In som

Re: [R] problem in reading data

2009-04-30 Thread jim holtman
In some cases the missing values have been replaced by NAs so you can look for those. On Thu, Apr 30, 2009 at 9:28 AM, tedzzx wrote: > > Dear R users > I am runing into a problem in reading data in R > This is the error information > > a<-read.table("tt_mb_200409.txt",as.is=T) > Error in scan(fi

Re: [R] problem in reading data

2009-04-30 Thread Dimitri Liakhovitski
What kind of .txt file is it? If it's a tab-delimited file, try read.delim("tt_mb_200409.txt") Dimitri On Thu, Apr 30, 2009 at 9:28 AM, tedzzx wrote: > > Dear R users > I am runing into a problem in reading data in R > This is the error information > > a<-read.table("tt_mb_200409.txt",as.is=T) >

[R] problem in reading data

2009-04-30 Thread tedzzx
Dear R users I am runing into a problem in reading data in R This is the error information a<-read.table("tt_mb_200409.txt",as.is=T) Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 1653997 did not have 5 elements It seams that some lines don't have equal var