Using Google’s NYC Taxi data in BigQuery, produce the following plots. Match the styling of each plot (axes, legends, titles, etc.). Check out Google’s sample queries, but note that page links to the taxi data split by year rather than the combined data.
Outliers were omitted.
Outliers were omitted and the horizontal scale was truncated.
Plots 5 & 6
Show begin/end of each trip in the morning/evening commute hours across days Mon-Fri. Limit the latitude/longitude values to just 3 digits after the decimal point, and compute the number of trips from the same pickup/dropoff lat/lon. Show a circle at the end of the trip (dropoff lat/lon) and sized according to the number of trips with that same pickup/dropoff. Drop records with counts less than 50. Use an alpha=0.05 for the lines and alpha=0.5 for the circles. Limit the plot to the “Midtown Manhattan” map at zoom level 14. See the ggplot cookbook for help plotting on maps.