How can I change this to numeric values, the number refers to the record of the 1.5km running, containing min:sec:one-tenth of seconds
"4:04.86" -> 4:04.86
as.numeric function is not working in this case, I think, its because of ':'
Asked
Active
Viewed 221 times
-4
-
1`4:04.86` is not a number. What is your desired output? – David Arenburg Nov 30 '15 at 21:33
-
See [here](http://stackoverflow.com/questions/7726034/how-r-formats-posixct-with-fractional-seconds) – MichaelChirico Nov 30 '15 at 21:34
-
this is the record of the running, containing minuite second and one tenth of second. When I identify the number by str() it appears as factor – Hung Nov 30 '15 at 21:39
-
please `dput` a sample of your data in the post. – Matthew Plourde Nov 30 '15 at 21:47
2 Answers
6
Here's a way with lubridate that gives the result in seconds.
library(lubridate)
x <- "4:04.86"
period_to_seconds(ms(x))
# [1] 244.9
Matthew Plourde
- 43,932
- 7
- 96
- 113
-
Error in period_to_seconds("4:05.85") : trying to get slot "minute" from an object of a basic class ("character") with no slots – Hung Nov 30 '15 at 21:40
-
-
-
Please read my answer more closely. You need `period_to_seconds(ms("4:05.85"))` – Matthew Plourde Nov 30 '15 at 21:42
-
I don't want that to be returned as 244.9, I just want it to be the exact same number without the quotes – Hung Nov 30 '15 at 21:42
-
5
-
You mean the strings have quotes in them? Are you just looking for `gsub('"', '', x)`? – Matthew Plourde Nov 30 '15 at 21:45
3
Base R can handle this a-okay too, using ?as.difftime:
as.difftime("4:04.86", format="%M:%OS")
#Time difference of 4.081 mins
as.difftime("4:04.86", format="%M:%OS", units="secs")
#Time difference of 244.86 secs
thelatemail
- 91,185
- 12
- 128
- 188