Bangladesh bus data processing complete

Last Friday I finally wrapped up the data processing for my Fulbright research. The hundreds of hours I put in riding buses in Dhaka, Bangladesh did not end my project there. Processing the data by entering it into my main spreadsheet and database was the next step before I start my analysis. Having this step complete is a big milestone.

The overcrowded bus data has taken a long time to move through. The first step required me to listen to the recordings I had of what occurred at the hundreds of bus stops (I had over 1400 left to process upon returning to the United States). On this listen I recorded on a piece of paper the boardings, alights, and bus movements that occurred. A second relisten allowed me to time each bus stop and get the time points of each board and alight. I then entered this time data into my spreadsheet. Once a full route’s of bus stops were recorded in this fashion, I could enter the route’s information, including how crowded the bus got and how far it stopped from the curb, into my database.

Below is a typical scene of a bus boarding. Shown here is the #6 Motijheel-Banani bus at its northbound Shat Rasta stop in the south end of Tejgaon, Dhaka.

Boarding #6 Motijheel-Banani

One Response to “Bangladesh bus data processing complete”

  1. Saket Says:

    awesome. way to go man, your dedication is astonishing.

    can this data be released to the public?

Leave a Reply