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,
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
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
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
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)
>
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
6 matches
Mail list logo