How to plot binary data via a dotplot?

Question

I have a dataset that includes presence absence of a variable based on hour and day. I'd like to plot presence (i.e., just "Y") by hour and day with day on the x and hour on the y axis. I'm just not good at this stuff and it's giving me trouble. See example data:

df <- data.frame("day"= c(1, 1, 1, 2, 2, 2, 3, 3, 3),"hour" = c(1, 2, 3, 1, 2, 2, 1, 2, 3),"a" = c("Y", "Y", "N", "N", "N", "Y", "N", "N", "Y"), "b" = c("N", "N", "Y", "N", "Y", "Y", "Y", "Y", "Y"))

Would love any suggestions.

Ronak Shah · Accepted Answer · 2021-05-01 11:36:43Z

1

You can try this approach :

Get the data in long format, filter only 'Y' values and plot scatterplot.

library(tidyverse)

df %>%
  pivot_longer(cols = a:b) %>%
  filter(value == 'Y') %>%
  mutate(across(c(day, hour), factor)) %>%
  ggplot() + aes(day, hour, color = name) + geom_point()

answered May 1, 2021 at 11:36

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

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

2 Comments

brc Over a year ago

This worked really well. If you only wanted to plot one column (just "a") and you filter for "Y" then it drops extralimital hour values so the y-axis no longer has all 24 hours. Any suggestions for correcting this?

Ronak Shah Over a year ago

You can use scale_y_continuous /scale_y_discrete. Something like this stackoverflow.com/questions/41917761/… might work

Collectives™ on Stack Overflow

How to plot binary data via a dotplot?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related