Hi, Try this: dat1<-read.table(text=" weekly.returns 2010-1-4 -0.015933327 2010-1-11 -0.015042868 2010-1-18 0.005350297 2010-1-25 -0.049324703 2010-2-1 -0.052674121 ",sep="",header=TRUE) dat2<-data.frame(date=row.names(dat1),weekly.returns=dat1[1]) row.names(dat2)<-1:nrow(dat2) class(dat2$date) #[1] "factor"
#if date column needed to be formatted to date class dat2$date<-as.Date(dat2$date, format="%Y-%m-%d") dat2 date weekly.returns 1 2010-01-04 -0.015933327 2 2010-01-11 -0.015042868 3 2010-01-18 0.005350297 4 2010-01-25 -0.049324703 5 2010-02-01 -0.052674121 class(dat2$date) #[1] "Date" A.K. ----- Original Message ----- From: 水静流深 <[email protected]> To: r-help <[email protected]> Cc: Sent: Wednesday, July 11, 2012 1:35 AM Subject: [R] how to create the data frame there is a data frame £¬x weekly.returns 2010-1-4 -0.015933327 2010-1-11 -0.015042868 2010-1-18 0.005350297 2010-1-25 -0.049324703 2010-2-1 -0.052674121 when i input colnames(data)[1] <- 'date' it becomes date 2010-1-4 -0.015933327 2010-1-11 -0.015042868 2010-1-18 0.005350297 2010-1-25 -0.049324703 2010-2-1 -0.052674121 how can i change ti into: date weekly.returns 1 2010-1-4 -0.015933327 2 2010-1-11 -0.015042868 3 2010-1-18 0.005350297 4 2010-1-25 -0.049324703 5 2010-2-1 -0.052674121 [[alternative HTML version deleted]] ______________________________________________ [email protected] 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. ______________________________________________ [email protected] 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.
