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: ???? <1248283536 at qq.com>
To: r-help <r-help at r-project.org>
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]]
______________________________________________
R-help at 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.