Daily ride counts
A useful way to tabulate and visualize cab rides is by looking at the number of rides according to the calendar day. In this exercise, you'll compute this summary and examine how daily ridership varies by time and the day of week.
The tx data set is preloaded for you.
This exercise is part of the course
Visualizing Big Data with Trelliscope in R
Exercise instructions
- Create a daily summary, grouping by the date of pickup (
pickup_date) and counting the number of rides, calling the new variablen_rides. Recall that dplyr'sn()function provides a count of how many observations are in each group. - Plot the result using ggplot2's
geom_line(), withpickup_dateon the x-axis andn_rideson the y-axis.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
library(dplyr)
library(ggplot2)
# Summarize the number of taxi rides by pickup day
daily_count <- tx %>%
group_by(___) %>%
summarise(n_rides = ___)
# Create a line plot
ggplot(daily_count, aes(___, ___)) +
___