Question

我有文件显示,格式时标象25/03/2011 9:1 5 p.m.。

如何将这一案文同以下几类时间段相提并论:strptime或 code 。 POSIXct ?

Here is what almost works:

> as.POSIXct("25/03/2011 9:15:00", format="%d/%m/%Y %I:%M:%S", tz="UTC")
[1] "2011-03-25 09:15:00 UTC"

Here is what is not working, but I d like to have working:

> as.POSIXct("25/03/2011 9:15:00 p.m.", format="%d/%m/%Y %I:%M:%S %p", tz="UTC")
[1] NA

I m using R version 2.13.2 (2011-09-30) on MS Windows. My working locale is "C":

Sys.setlocale("LC_TIME", "C")

Answer 1

看来,AM/PM指标可能不包括校准。在删除图解之后询问:

td <- "25/03/2011 9:15:00 p.m."
tdClean <- gsub("(.)\.?[Mm]\.?","\1m",td)
as.POSIXct(tdClean, format="%d/%m/%Y %I:%M:%S %p", tz="UTC")
# [1] "2011-03-25 21:15:00 UTC"

Answer 2

就在这一点上,因为你可以使用<条码>指示/编码>一揽子方案。

library(stringr)
data$date2 <- str_sub(data$date, end = -4) 
# this removes the punctuation but holds onto the A/P values
data$date2 <- str_c(data$date2,  m ) 
# adds the required m

友情链接