[R] Time in ggplot2

[Hadley Wickham]

Hi Ottar,

It's a bug in the code that automatically figures out the axis ticks.
I have some code to fix it, but it's waiting for a release of another
package.  In the meantime, you can work around it by specifying where
you want the breaks:

ggplot(data, aes(time, PU) ) +
  geom_line() +
  scale_x_datetime(major = "3 hours")

Hadley

PS.  You can make the code completely reproducible with (e.g.)
load(url("http://master.kvindesland.no/R/failed_data.Rdata"))

On Mon, Jun 21, 2010 at 3:24 PM, Ottar Kvindesland
<ottar.kvindesland at gmail.com> wrote:
> Thanks Hadley for taking the interest here.
>
> The data sets are a bit large and I have placed them available for your
> download on
> http://master.kvindesland.no/R/
> You will find datasets in both Rdata and dput format. It seems that some
> data sets works nicely and others do not even if they come from a very
> similar SQL set. The select clause carries more coloumns in the failing data
> set.
>
> ottar
>
> On 20 June 2010 18:28, Hadley Wickham <hadley at rice.edu> wrote:
>>
>> 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/
>
>



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