Data Visualizations for Urban Traffic Congestion Related to Rideshare Data

Visualization 1: Trip Volume by Time of Day

Understanding Peak Hours

This visualization shows the distribution of rides throughout the day, comparing 2014, before rideshare became prevalent, with 2024, when rideshares are prevalent.highlighting peak hours when traffic congestion is most likely to occur. The data reveals clear patterns of morning and evening rush hours, and differences in overall volume. This data still requires further investigation to reveal causation.

Visualization 2: Trip Distance vs. Fare Analysis

Fare Efficiency Based on Distance

This scatter plot explores the relationship between trip distance and fare amount. The visualization helps identify outliers where fares might be disproportionately high for short distances or unusually low for long distances.

Raw Data Table

ID Type Vehicle ID Pickup Time Dropoff Time PU Location DO Location Distance Fare Tip
113124 fhvhv HV0003 2024-01-17 18:23:03 2024-01-17 18:45:41 256 146 3.740 19.56 0.00
113125 fhvhv HV0003 2024-01-17 18:49:46 2024-01-17 19:04:46 257 25 3.620 23.22 0.00
113126 fhvhv HV0003 2024-01-17 18:08:08 2024-01-17 18:19:49 211 13 1.510 14.48 0.00
113127 fhvhv HV0005 2024-01-17 18:20:33 2024-01-17 18:29:18 97 61 1.710 16.38 0.00
113128 fhvhv HV0003 2024-01-17 18:51:38 2024-01-17 18:57:05 113 211 0.500 10.92 0.00
113129 fhvhv HV0003 2024-01-17 18:50:53 2024-01-17 19:09:49 260 193 2.810 17.73 0.00
113130 fhvhv HV0003 2024-01-17 18:47:20 2024-01-17 18:59:46 181 181 1.640 11.60 0.00
113131 fhvhv HV0003 2024-01-17 18:35:10 2024-01-17 19:04:13 138 243 9.740 34.57 0.00
113132 fhvhv HV0003 2024-01-17 18:11:48 2024-01-17 19:19:11 193 193 15.820 59.75 0.00
113133 fhvhv HV0003 2024-01-17 18:50:46 2024-01-17 19:25:27 241 213 6.630 22.01 0.00
113134 fhvhv HV0003 2024-01-17 18:22:04 2024-01-17 18:38:24 231 148 1.930 32.74 0.00
113135 fhvhv HV0003 2024-01-17 18:18:12 2024-01-17 18:35:18 162 230 0.930 54.08 0.00
113136 fhvhv HV0005 2024-01-17 18:01:17 2024-01-17 18:45:03 112 112 12.399 54.53 0.00
113137 fhvhv HV0003 2024-01-17 18:17:20 2024-01-17 18:41:17 234 68 1.670 25.62 0.00
113138 fhvhv HV0003 2024-01-17 18:23:10 2024-01-17 18:34:18 184 254 2.990 12.59 0.00
113139 fhvhv HV0003 2024-01-17 18:13:10 2024-01-17 18:23:05 155 155 1.740 11.56 5.00
113140 fhvhv HV0003 2024-01-17 18:35:08 2024-01-17 19:45:55 233 265 33.380 141.02 0.00
113141 fhvhv HV0005 2024-01-17 18:02:35 2024-01-17 18:11:50 161 164 1.029 12.76 3.40
113142 fhvhv HV0003 2024-01-17 18:02:14 2024-01-17 18:32:39 53 92 2.490 23.14 0.00
113143 fhvhv HV0003 2024-01-17 18:25:18 2024-01-17 18:35:54 170 229 1.470 13.93 3.00