[R] as.date not reading Hour/Minute am/pm Data

arun smartpink111 at yahoo.com
Mon Apr 15 16:11:40 CEST 2013



Hi,
Try:
x<- c("2/26/13 11:59 PM", "2/25/13 10:25 AM")
strptime(x,"%m/%d/%y %I:%M %p")
#[1] "2013-02-26 23:59:00" "2013-02-25 10:25:00"

#or
library(lubridate)
parse_date_time(x,"%m/%d/%y %I:%M %p")
# 2 parsed with %m/%d/%y %I:%M %p
#[1] "2013-02-26 23:59:00 UTC" "2013-02-25 10:25:00 UTC"
A.K.


>I'm a newbie to R but not programming.   
>
>I've researched online and through this forum and am unsure of 
why I'm not getting a as.date object to only store a limited amount of 
data.  The date >is in the format of: 2/26/13 11:59 PM in a .csv file 
with over 5000 data points.  My as.date function reads: 
>
>> gld <- read.csv("c:/data/gbpdata.csv", stringsAsFactors=F) 
>> gld_dates <- as.Date(gld[,1], format="%m/%d/%y %H:%M %p") 
>> gld_dates: 
>
>[36775] "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" "2013-04-03" 
>
>What am I doing wrong?  Thanks in advance for your replies.



More information about the R-help mailing list