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 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.

The dataset is of the form
# 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>

Column

Chart A

Description of Data

  1. Line : Route number
  2. Segment : Link between two stops
  3. Length : Length of the segment (KMs)
  4. Time : Time taken to traverse the segment (Minutes)
  5. Speed : Speed of travel on the segment (Kmph)
  6. Load Factor: Ratio of Load to Capacity of the segment
  7. Volume : The Volumne of Passengers on the segment
  8. Stop : The numeric identifier of the stop at the start of the segment
  9. Boarding : The number of passengers boarding at the stop
  10. Alighting : The number of passengers alighting at the stop
  11. Seat Probability : Probability of boarding the bus

Number of Routes: 21

Number of Stops on the Network: 455

Number of segments on the Network: 870

Total Ridership in Peak Hour: 24628

Column

Chart B

Chart C

***

Column

Chart D

The busiest route is 8R

The least busiest route is 14R

Chart E

The busiest stop is 60043

The least busiest stop is 1118