An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120804/03087da0/attachment.pl>
DAtes
5 messages · Trying To learn again, arun, Rui Barradas +1 more
Hi,
Try this:
tfr<-read.table(text="
14/12/2000? 15/12/2000? 18/12/2000? 19/12/2000? 20/12/2000? 21/12/2000
22/12/2000? 25/12/2000? 26/12/2000? 27/12/2000? 28/12/2000? 29/12/2000
01/01/2001? 02/01/2001? 03/01/2001? 04/01/2001? 05/01/2001? 08/01/2001
09/01/2001? 10/01/2001? 11/01/2001? 12/01/2001? 15/01/2001? 16/01/2001
17/01/2001? 18/01/2001? 19/01/2001? 22/01/2001? 23/01/2001? 24/01/2001
25/01/2001? 26/01/2001? 29/01/2001? 30/01/2001? 31/01/2001? 01/02/2001
02/02/2001? 05/02/2001? 06/02/2001? 07/02/2001? 08/02/2001? 09/02/2001
12/02/2001? 13/02/2001? 14/02/2001? 15/02/2001? 16/02/2001? 19/02/2001
20/02/2001? 21/02/2001
",sep="",header=FALSE,fill=TRUE,stringsAsFactors=FALSE)
?as.Date(tfr$V1,format="%d/%m/%Y")
[1] "2000-12-14" "2000-12-22" "2001-01-01" "2001-01-09" "2001-01-17"
[6] "2001-01-25" "2001-02-02" "2001-02-12" "2001-02-20"
A.K.
----- Original Message -----
From: Trying To learn again <tryingtolearnagain at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Saturday, August 4, 2012 12:09 PM
Subject: [R] DAtes
Hi all,
I?m trying to convert as a data frame (with format "date") this copied
excel column of dates (exposed below), I have tried to save them in a txt
file
tfr<-read.table("tfra.txt")
tfr<-data.frame(tfr)
I have tried several things, as date, so on, but always error.
And it makes
Error en as.Date.default(tfr, "%m/%d/%y") :
? do not know how to convert 'a' to class "Date"
Can anyone give me a clue or a gide to achieve this final result.
14/12/2000? 15/12/2000? 18/12/2000? 19/12/2000? 20/12/2000? 21/12/2000
22/12/2000? 25/12/2000? 26/12/2000? 27/12/2000? 28/12/2000? 29/12/2000
01/01/2001? 02/01/2001? 03/01/2001? 04/01/2001? 05/01/2001? 08/01/2001
09/01/2001? 10/01/2001? 11/01/2001? 12/01/2001? 15/01/2001? 16/01/2001
17/01/2001? 18/01/2001? 19/01/2001? 22/01/2001? 23/01/2001? 24/01/2001
25/01/2001? 26/01/2001? 29/01/2001? 30/01/2001? 31/01/2001? 01/02/2001
02/02/2001? 05/02/2001? 06/02/2001? 07/02/2001? 08/02/2001? 09/02/2001
12/02/2001? 13/02/2001? 14/02/2001? 15/02/2001? 16/02/2001? 19/02/2001
20/02/2001? 21/02/2001
??? [[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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120804/eba6096b/attachment.pl>
HI,
I guess this will be more appropriate:
tfr<-read.table(text="
14/12/2000? 15/12/2000? 18/12/2000? 19/12/2000? 20/12/2000? 21/12/2000
22/12/2000? 25/12/2000? 26/12/2000? 27/12/2000? 28/12/2000? 29/12/2000
01/01/2001? 02/01/2001? 03/01/2001? 04/01/2001? 05/01/2001? 08/01/2001
09/01/2001? 10/01/2001? 11/01/2001? 12/01/2001? 15/01/2001? 16/01/2001
17/01/2001? 18/01/2001? 19/01/2001? 22/01/2001? 23/01/2001? 24/01/2001
25/01/2001? 26/01/2001? 29/01/2001? 30/01/2001? 31/01/2001? 01/02/2001
02/02/2001? 05/02/2001? 06/02/2001? 07/02/2001? 08/02/2001? 09/02/2001
12/02/2001? 13/02/2001? 14/02/2001? 15/02/2001? 16/02/2001? 19/02/2001
20/02/2001? 21/02/2001
",sep="",header=FALSE,fill=TRUE,stringsAsFactors=FALSE)
tfr1<-data.frame(dates=c(tfr[,1],tfr[,2],tfr[,3],tfr[,4],tfr[,5],tfr[,6]))
tfr2<-tfr1[-c(27,36,45),]
?
head(data.frame(dates=as.Date(tfr2,format="%d/%m/%Y")))
????? dates
1 2000-12-14
2 2000-12-22
3 2001-01-01
4 2001-01-09
5 2001-01-17
6 2001-01-25
# or you can do this:
?tfr1<-as.vector(c(tfr[,1],tfr[,2],tfr[,3],tfr[,4],tfr[,5],tfr[,6]))
?tfr2<-as.data.frame(as.Date(tfr1,format="%d/%m/%Y"))
?colnames(tfr2)<-"dates"
?head(tfr2)
?????? dates
1 2000-12-14
2 2000-12-22
3 2001-01-01
4 2001-01-09
5 2001-01-17
6 2001-01-25
A.K.
----- Original Message -----
From: Trying To learn again <tryingtolearnagain at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Saturday, August 4, 2012 12:09 PM
Subject: [R] DAtes
Hi all,
I?m trying to convert as a data frame (with format "date") this copied
excel column of dates (exposed below), I have tried to save them in a txt
file
tfr<-read.table("tfra.txt")
tfr<-data.frame(tfr)
I have tried several things, as date, so on, but always error.
And it makes
Error en as.Date.default(tfr, "%m/%d/%y") :
? do not know how to convert 'a' to class "Date"
Can anyone give me a clue or a gide to achieve this final result.
14/12/2000? 15/12/2000? 18/12/2000? 19/12/2000? 20/12/2000? 21/12/2000
22/12/2000? 25/12/2000? 26/12/2000? 27/12/2000? 28/12/2000? 29/12/2000
01/01/2001? 02/01/2001? 03/01/2001? 04/01/2001? 05/01/2001? 08/01/2001
09/01/2001? 10/01/2001? 11/01/2001? 12/01/2001? 15/01/2001? 16/01/2001
17/01/2001? 18/01/2001? 19/01/2001? 22/01/2001? 23/01/2001? 24/01/2001
25/01/2001? 26/01/2001? 29/01/2001? 30/01/2001? 31/01/2001? 01/02/2001
02/02/2001? 05/02/2001? 06/02/2001? 07/02/2001? 08/02/2001? 09/02/2001
12/02/2001? 13/02/2001? 14/02/2001? 15/02/2001? 16/02/2001? 19/02/2001
20/02/2001? 21/02/2001
??? [[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.
2 days later
Well, i believe writing correct date format would have served the purpose. Suppose tfr contains Date as column and is a factor by class. tft$Date <- as.Date(as.character(tfr$Date),"%d/%m%Y") should give you the desired output. -- View this message in context: http://r.789695.n4.nabble.com/DAtes-tp4639172p4639366.html Sent from the R help mailing list archive at Nabble.com.