Plotting Variable over Date:Time Issue in ggplot

Question

I am trying to plot "breaks" counts that occur on a specific day over time. But get issues since the "Time" variable is in a date:time format and the graph fails to generate.

ggplot(df, aes(y = `Breaks`, x = `Date`)) +
  geom_histogram(bins = 100, binwidth = 1, colour = "white", fill = "#1380A1")

example data:

structure(list(Date = structure(c(1544107050, 1544100120, 1540557866, 
1540558168, 1544100123, 1544100135, 1545299546, 1545299518, 1545822865, 
1545822864, 1545822866, 1545822875, 1546016246, 1546016252, 1546016263
), class = c("POSIXct", "POSIXt"), tzone = "UTC"), Breaks = c(NA, 
NA, 2, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA)), row.names = c(NA, 
15L), class = "data.frame")

What is the expected output of your data? Also, your code does not match your data (is the variable Break the same as the variable Breaks?). Furthermore, is there something missing after the last +? — Roman
– Roman, Commented Apr 23, 2019 at 16:25
Possible duplicate of Understanding dates and plotting a histogram with ggplot2 in R — divibisan
– divibisan, Commented Apr 23, 2019 at 16:26
I corrected the errors in the question. And the graph should be "Breaks" on the Y-axis and "Time" on the X-Axis. It should should a line graph/histogram of how many "Breaks" occur on a specific day. — Koolakuf_DR
– Koolakuf_DR, Commented Apr 23, 2019 at 16:28
@divibisan that question is counting the dates as a numeric. Mine is adding a 2nd variable over time — Koolakuf_DR
– Koolakuf_DR, Commented Apr 23, 2019 at 16:39
Maybe look up what a histogram is? It's very different from a line plot. It doesn't take a y variable at all. And it uses bars, not lines. Perhaps you want a barplot, one bar per day, with the height of the bar being the number of non-missing Breaks values? Or maybe you want the height of the bar to be the sum of non-missing Breaks values? Or something else? — Gregor Thomas
– Gregor Thomas, Commented Apr 23, 2019 at 16:41

Jon Spring · Accepted Answer · 2019-04-23 19:19:51Z

2

library(tidyverse)
df %>% 
  mutate(Date = as.Date(Date)) %>%
  count(Date, wt = Breaks) %>%
  ggplot(aes(Date, n)) +
  geom_col(colour = "white", fill = "#1380A1")

(Not sure I'm understanding the comment about "But I need the missing values in the graph that represent (o) essentially." Should zeros be represented visually somehow? BTW, the part through the count(Date = ... line produces this -- is that what you meant by capturing the missing values?)

# A tibble: 5 x 2
  Date           n
  <date>     <dbl>
1 2018-10-26     2
2 2018-12-06     0
3 2018-12-20     0
4 2018-12-26     0
5 2018-12-28     1

edited Apr 23, 2019 at 19:19

answered Apr 23, 2019 at 17:40

Jon Spring

70k4 gold badges42 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Koolakuf_DR Over a year ago

Exactly what I needed. Thank you

Collectives™ on Stack Overflow

Plotting Variable over Date:Time Issue in ggplot

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related