INTRODUCTION - This code reads the dataset from an EMME Model made during the course of 3rd Semester Studio. Then Cleans it, Analyses it and publishes it on a dashboard.
The dataset is of the formThe dataset contains boarding and alighting of passengers for multiple routes at each of the stops in the Ahmedabad Janmarg BRTS Network. It also contains the volume of passengers on the route on each segment between the stops.
# A tibble: 1,611 × 11
Line Segment Length `Time(min)` Speed `Load Factor` Volume Stop Boarding
<chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <chr> <dbl>
1 1 65011-601… 0.12 0.36 19 0.11 50 65011 50
2 1 60147-650… 0.34 1.02 20 0.3 133 60147 84
3 1 65010-601… 0.27 0.81 20 0.3 133 65010 0
4 1 60146-650… 0.97 2.92 20 0.35 156 60146 22
5 1 65009-600… 0.14 0.43 20 0.35 156 65009 0
6 1 60097-600… 0.76 2.28 20 0.43 192 60097 37
7 1 60096-600… 1.44 4.34 20 0.5 227 60096 34
8 1 60095-650… 0.72 2.16 20 0.62 281 60095 61
9 1 65008-600… 0.57 1.73 20 0.62 281 65008 0
10 1 60092-600… 1.28 3.85 20 0.64 288 60092 40
# ℹ 1,601 more rows
# ℹ 2 more variables: Alighting <dbl>, `Seat Probability` <dbl>
Description of Data
Number of Routes: 21
Number of Stops on the Network: 455
Number of segments on the Network: 870
Total Ridership in Peak Hour: 24628
***
The busiest route is 8R
The least busiest route is 14R
The busiest stop is 60043
The least busiest stop is 1118