[R] R help!

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Thu May 3 06:52:17 CEST 2012


Hard to say.. your example is not reproducible. (Study the Posting Guide mentioned at the end of every message on this list.)

A stab in the dark might be that z$dt is a factor and needs to be converted to character first. Use the str function to study your data.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Alex Roth <alexsroth1 at gmail.com> wrote:

>Hello there, I was wondering if you could help me with a quick R issue.
>
>I have a data set where one of the columns has both date and time in
>it, e.g. "12/31/11 23:45" in one cell. I want to use R to split this
>column into two new columns: date and time.
>
>One of the problems with splitting here is that when the dates go into
>single digits there are no 0's in front of months January-September
>(e.g., January is represented by 1 as opposed to 01), so every entry
>is a different length. Therefore, splitting by the space is the only
>option, I think.
>
>Here's the coding I've developed thus far:
>
>z$dt <- z$Date                    #time and date is all under z$Date
>foo <- strsplit(" ", z$dt)         #attempted split based on the space
>
>And then if that were to work, I would proceed use the coding:
>
>foo2 <- matrix(unlist(foo), ncol = 2, byrow=TRUE)
>z$Date <- foo[ ,1]
>z$Time <- foo[ ,2]
>
>However, foo <- strsplit(" ", z$dt) isn't working. Do you know what
>the problem is? If you could respond soon, that would be greatly
>appreciated!
>
>Thanks so much!
>Alex
>
>______________________________________________
>R-help at 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.



More information about the R-help mailing list