Thanks again for your help.  I was sniffing around this solution forever,
but that did it cleanly and without any problems.



On Thu, Feb 17, 2011 at 10:21 PM, <Bill.Venables@csiro.au> wrote:

> The solution is probably to make the data-time columns POSIXct:
>
> > x <- read.table(textConnection("
> + ID     event.date.time
> + 1     '2009-07-23 00:20:00'
> + 2     '2009-08-18 16:25:00'
> + 3     '2009-08-13 08:30:00'
> + "), header = TRUE)
> > y <- read.table(textConnection("
> + ID     event.date.time
> + 4     '2009-08-25 10:25:00'
> + 5     '2009-08-10 06:20:00'
> + 6     '2009-10-09 08:20:00'
> + "), header = TRUE)
> > closeAllConnections()
> >
> > x <- within(x,
> + event.date.time <- as.POSIXct(as.character(event.date.time),
> + format = "%Y-%m-%d %H:%M:%S"))
> > y <- within(y,
> + event.date.time <- as.POSIXct(as.character(event.date.time),
> + format = "%Y-%m-%d %H:%M:%S"))
> > z <- rbind(x, y)
> > z
>  ID     event.date.time
> 1  1 2009-07-23 00:20:00
> 2  2 2009-08-18 16:25:00
> 3  3 2009-08-13 08:30:00
> 4  4 2009-08-25 10:25:00
> 5  5 2009-08-10 06:20:00
> 6  6 2009-10-09 08:20:00
> >
>
> No problems.
>
> -----Original Message-----
> From: r-help-bounces@r-project.org [mailto:r-help-bounces@r-project.org]
> On Behalf Of Andrew Anglemyer
> Sent: Friday, 18 February 2011 3:54 PM
> To: r-help@r-project.org
> Subject: [R] problem with rbind when data frame contains an date-time
> variable "POSIXt" "POSIXlt"
>
> I'm trying to rbind two data frames, both with the same columns names.  One
> of the columns is a variable with date-time and this variable is causing
> the
> rbind to fail--giving the error
> "Error in names(value[[jj]])[ri] <- nm :  'names' attribute [7568] must be
> the same length as the vector [9]"
>
> Is there a way to stack or rbind these two data frames even with this
> extended date-time variable?  The class of event.date.time in each data
> frame is POSIXt POSIXlt.
> x
> ID     event.date.time
> 1     2009-07-23 00:20:00
> 2     2009-08-18 16:25:00
> 3     2009-08-13 08:30:00
>
> y
> ID     event.date.time
> 4     2009-08-25 10:25:00
> 5     2009-08-10 06:20:00
> 6     2009-10-09 08:20:00
>
> I would like to get
>
> z
> ID     event.date.time
> 1     2009-07-23 00:20:00
> 2     2009-08-18 16:25:00
> 3     2009-08-13 08:30:00
> 4     2009-08-25 10:25:00
> 5     2009-08-10 06:20:00
> 6     2009-10-09 08:20:00
>
> I've looked at stripping the dates and times, but it would be really
> helpful
> for my purposes to keep the extended variable date-time variable (have to
> eventually get 24 hours from baseline.date.time).
>
> thanks for any and all help!
> Andy
>
>         [[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.
>

	[[alternative HTML version deleted]]

