Re: [R] Time in ggplot2

From: Hadley Wickham <hadley_at_rice.edu>
Date: Sun, 20 Jun 2010 17:28:27 -0500

Hi Ottar,

It's impossible to tell what the problem is without a reproducible example (http://gist.github.com/270442)

Hadley

On Sun, Jun 20, 2010 at 4:38 PM, Ottar Kvindesland <ottar.kvindesland_at_gmail.com> wrote:
> I have a problem that puzzles me a bit today. When loading off data from a
> database and plotting using ggplot2, I wish to present data as a time series
> with time of day. The code is text-book like as shown below:
>
> # Fetch data
> con <- dbConnect(dbDriver("MySQL"), user="user", password = "pwd",
> dbname="db")
> data <- dbGetQuery(con, "select PU, DateTime from rep;")
> data$time <- as.POSIXct(data$DateTime)
> attach(data)
>
> # Plot Data
> p <- ggplot(data, aes(x=time, colour=PU ) ) +
> ylim( c(0, max(PU)) ) +
> geom_line( aes(x=time, PU ) )
>
> p
>
> It starts plotting and terminates before anything is drawn on the canvas.
> The error message on the terminal is:
>
> Error in seq.int(0, to - from, by) : 'to' must be finite
>
> The DateTime coloumn in MySQL is of type datetime Is it a bug or a feature?
>
>
>
> Thanks
>
> ottar
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>

-- 
Assistant Professor / Dobelman Family Junior Chair
Department of Statistics / Rice University
http://had.co.nz/

______________________________________________
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.
Received on Sun 20 Jun 2010 - 22:32:59 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 21 Jun 2010 - 20:40:43 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive