I have attendance data from an online event where each row contains an email address, a join time, and a leave time. Some attendees have multiple rows since they joined, left, and then re-joined the meeting (sometimes several times). There were approximately 200 attendees over the course of the ~90 minute event. I want to create a visualization that shows when attendees joined and left over the course of the whole event. I'm thinking a graph where each attendee's join and leave times are plotted so that each attendee has a single line. I don't know where to begin and am hoping for any recommendations. Thanks! Here's a sample of what my data looks like:
structure(list(Email= c("email1@gmail.com", "email2@gmail.com", "email2@gmail.com",
"email3@gmail.com","email3@gmail.com"), Join.Time = structure(c(as.POSIXct("2020-12-09 13:04:00"),
as.POSIXct("2020-12-09 13:20:00"), as.POSIXct("2020-12-09 13:30:00"),as.POSIXct("2020-12-09 13:07:00"),
as.POSIXct("2020-12-09 13:29:00")), class = c("POSIXct", "POSIXt"),tzone = "America/New_York"),
Leave.Time = structure(c(as.POSIXct("2020-12-09 13:25:00"), as.POSIXct("2020-12-09 13:22:00"),
as.POSIXct("2020-12-09 14:01:00"), as.POSIXct("2020-12-09 13:29:00"), as.POSIXct("2020-12-09 14:33:00")),
class = c("POSIXct", "POSIXt"), tzone = "America/New_York")),.Names = c("Email", "Join.Time", "Leave.Time"),
row.names = c(NA, -5L), class = "data.frame")