Skip to content
Back to formatted view

Raw Message

Message-ID: <loom.20090331T094141-328@post.gmane.org>
Date: 2009-03-31T09:45:00Z
From: Dieter Menne
Subject: Convert date to integer

thoeb <t.hoebinger <at> gmail.com> writes:

> Hello, I have a dataframe containing dates, times and other parameters. The
> times have the format "h:m", e.g. 13:00 or 5:30, R classes them as factors.

Probably you have read in the data from a file with read.table; check
stringsAsFactors in the docs to avoid the conversion from the beginning.


> I want to change the times to integers e.g. 13:00 -> 1300. I tried to use
> "chron" to create a chronological object, but it didn't work for the times
> (yust for the dates). 
> 
If that's all (no NA?) a simple replace might work

df = data.frame(tstr=c("13:00","5:30"))
df$tint = as.integer(gsub(":","",as.character(df$tstr)))


Dieter