Since this is a time series you might want to look at the zoo package: Lines <- "Date Price 09/01/05 365 09/02/05 360 09/03/05 360 09/05/05 370 09/06/05 370 09/08/05 365 09/09/05 365 09/10/05 365 09/12/05 365 09/13/05 360 09/14/05 360 09/15/05 360 "
library(zoo) # replace with # z <- read.zoo("myfile.dat", header = TRUE,format = "%m/%d/%Y") z <- read.zoo(textConnection(Lines), header = TRUE, format = "%m/%d/%Y") plot(z) vignette("zoo") # info on zoo vignette("zoo-quickref") # more info on zoo On 9/20/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote: > This mail is continuation of my previous one. i have some raw data from > Excel which was carried to R: > > data = read.delim(file="clipboard", header=T) > > data > Date Price > 1 09/01/05 365 > 2 09/02/05 360 > 3 09/03/05 360 > 4 09/05/05 370 > 5 09/06/05 370 > 6 09/08/05 365 > 7 09/09/05 365 > 8 09/10/05 365 > 9 09/12/05 365 > 10 09/13/05 360 > 11 09/14/05 360 > 12 09/15/05 360 > > and, using the input from R-help I exctracted day, month, and year, from > "Date" > > year = as.numeric(format(as.Date(data[,1],"%m/%d/%y"),"%Y")) > month = as.numeric(format(as.Date(data[,1],"%m/%d/%y"),"%m")) > day = as.numeric(format(as.Date(data[,1],"%m/%d/%y"),"%d")) > > Now I want to create a date-variable and put it in actual data: > > library(date) > data1 = cbind(mdy.date(month, day, year), data[,-1]) > > data1 > [,1] [,2] > [1,] 16680 365 > [2,] 16681 360 > [3,] 16682 360 > [4,] 16684 370 > [5,] 16685 370 > [6,] 16687 365 > [7,] 16688 365 > [8,] 16689 365 > [9,] 16691 365 > [10,] 16692 360 > [11,] 16693 360 > [12,] 16694 360 > > However this is not that thing what I wanted, first column has been jumbled, > it is not in actual date format. > > Can anyone tell me what should i do here? > > Regards, > > > > > > > On 9/18/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote: > > > > Dear all, > > > > I have a variable 'x' like that: > > > > > x > > [1] "2005-09-01" > > > > Here, 2005 represents year, 09 month and 01 day. > > > > Now I want to create three variables naming: y, m, and d such that: > > > > y = 2005 > > m = 09 > > d = 01 > > > > can anyone tell me how to do that? > > > > Regards, > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. > ______________________________________________ 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.