Thanks!


On Fri, Apr 12, 2013 at 3:30 PM, arun <smartpink111@yahoo.com> wrote:

>
>
>
>
> ----- Forwarded Message -----
> From: arun <smartpink111@yahoo.com>
> To: Ye Lin <yelin@lbl.gov>
> Cc:
> Sent: Friday, April 12, 2013 6:25 PM
> Subject: Re: [R] split date and time
>
>
>
> Hi Ye,
>
> Is this okay?
>
> dat2<-cbind(dat1[,-2],do.call(rbind,strsplit(dat1[,2],"
> ")),stringsAsFactors=FALSE)
>  dat2
> #  Number Value        1    2
> #1      1     1 1/1/2013 0:00
> #2      2     2 1/1/2013 0:01
> #3      3     3 1/1/2013 0:03
>  colnames(dat2)[3:4]<- c("Date","Time")
>  dat2
> #  Number Value     Date Time
> #1      1     1 1/1/2013 0:00
> #2      2     2 1/1/2013 0:01
> #3      3     3 1/1/2013 0:03
> str(dat2)
> #'data.frame':    3 obs. of  4 variables:
>  #$ Number: int  1 2 3
>  #$ Value : int  1 2 3
>  #$ Date  : chr  "1/1/2013" "1/1/2013" "1/1/2013"
>  #$ Time  : chr  "0:00" "0:01" "0:03"
>
>
>
> ________________________________
> From: Ye Lin <yelin@lbl.gov>
> To: arun <smartpink111@yahoo.com>
> Sent: Friday, April 12, 2013 6:16 PM
> Subject: Re: [R] split date and time
>
>
>
>
>
> What if I have many columns, for example I have 50 columns in dat1, and
> say the "TimeStamp" column is the 10th, anyway to do that instead of
> listing all the other columns when building dat2?
>
>
> Thanks!
>
>
>
>
>
> On Fri, Apr 12, 2013 at 3:08 PM, arun <smartpink111@yahoo.com> wrote:
>
> Hi,
> >dat1<- read.table(text="
> >Number,TimeStamp,Value
> >1,1/1/2013 0:00,1
> >2,1/1/2013 0:01,2
> >3,1/1/2013 0:03,3
> >",sep=",",header=TRUE,stringsAsFactors=FALSE)
> >dat2<-data.frame(Number=dat1[,1],do.call(rbind,strsplit(dat1[,2]," ")),
> Value=dat1[,3])
> > names(dat2)[2:3]<- c("Date","Time")
> > dat2
> >#  Number     Date Time Value
> >#1      1 1/1/2013 0:00     1
> >#2      2 1/1/2013 0:01     2
> >#3      3 1/1/2013 0:03     3
> >A.K.
> >
> >
> >
> >
> >
> >----- Original Message -----
> >From: Ye Lin <yelin@lbl.gov>
> >To: R help <r-help@r-project.org>
> >Cc:
> >Sent: Friday, April 12, 2013 5:49 PM
> >Subject: [R] split date and time
> >
> >Hi R experts,
> >
> >For example I have a dataset looks like this:
> >
> >
> >Number   TimeStamp   Value
> >1              1/1/2013 0:00 1
> >2 1/1/2013 0:01 2
> >3 1/1/2013 0:03 3
> >
> >How can I split the "TimeStamp" Column into two and return a new table
> like
> >this:
> >
> >Number   Date           Time   Value
> >1               1/1/2013 0:00 1
> >2 1/1/2013 0:01 2
> >3 1/1/2013 0:03 3
> >
> >Thank!
> >
> >    [[alternative HTML version deleted]]
> >
> >______________________________________________
> >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.
> >
> >
>
>
> ______________________________________________
> 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.
>

	[[alternative HTML version deleted]]

