An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120502/fa1949c1/attachment.pl>
factor conversion to date/time
4 messages · marjolein post, R. Michael Weylandt, Duncan Murdoch +1 more
Please don't triple post. Michael
On Wed, May 2, 2012 at 8:08 AM, marjolein post <mayo_jojo at hotmail.com> wrote:
Hi, I've been trying to convert numbers from an online temperature database into dates and time that R recognizes. I've tried as.Date, as.POSIXlt and strptime ?the problem is that the database has put a T between the numbers and R will not accept any conversions. currently it sees the date as a factor with the format ?as 1981-01-02T08:00I would like to keep only the year and month, but my primary focus is to get R to recognize it as a date. Thank you for your help. cheers,Marjolein ? ? ? ?[[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.
On 02/05/2012 8:08 AM, marjolein post wrote:
Hi, I've been trying to convert numbers from an online temperature database into dates and time that R recognizes. I've tried as.Date, as.POSIXlt and strptime the problem is that the database has put a T between the numbers and R will not accept any conversions. currently it sees the date as a factor with the format as 1981-01-02T08:00I would like to keep only the year and month, but my primary focus is to get R to recognize it as a date.
To stop the conversion to factors, use argument stringsAsFactors=FALSE when you read the file, or even better, options(stringsAsFactors=FALSE) for a global change. To convert a string, specify the format (following the instructions in ?strptime): x <- "1981-01-02T08:00I" strptime(x, format="%Y-%m-%dT%H:%MI") Duncan Murdoch
Try something like this. Convert the vector to character and grab the first 10 characters then convert to a date.
aa <- as.factor("1981-01-02T08:00I")
aa <- as.character(aa)
aa <- substr(aa, 1, 10)
class(b)
John Kane
Kingston ON Canada
-----Original Message----- From: mayo_jojo at hotmail.com Sent: Wed, 2 May 2012 14:08:26 +0200 To: r-help at r-project.org Subject: [R] factor conversion to date/time Hi, I've been trying to convert numbers from an online temperature database into dates and time that R recognizes. I've tried as.Date, as.POSIXlt and strptime the problem is that the database has put a T between the numbers and R will not accept any conversions. currently it sees the date as a factor with the format as 1981-01-02T08:00I would like to keep only the year and month, but my primary focus is to get R to recognize it as a date. Thank you for your help. cheers,Marjolein [[alternative HTML version deleted]]
____________________________________________________________ FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family! Visit http://www.inbox.com/photosharing to find out more!