[R] Convert date to integer

[thoeb]

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.
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). 

-
Tamara Hoebinger
University of Vienna
-- 
View this message in context: 
http://www.nabble.com/Convert-date-to-integer-tp22800457p22800457.html
Sent from the R help mailing list archive at Nabble.com.

__
R-help@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.

Re: [R] Convert date to integer

[Dieter Menne]

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

__
R-help@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.