Python, Data Frame Analysis and Creating Dash

Project info:

There are two csv files: “Stop_time” and “STOPSFREQ”

From the Stop_time” create a column (TOD) based on arrival time to show time of day of

operation as describe below:

 Time between 6 am to 10 am as “Morning Peak”

 Time between 10 am to 16 pm as “Day Time”

 Time between 16 to 20 as “Afternoon Peak”

 Time between 20 to 6 am as “Nighttime”

Then, five columns need to be added to the “STOPSFREQ” dataframe as follows:

1. Frequency_of_Opr: should be calculated by counting “stop_sequence” for each “Stop-

id” from “Stop_time” data. For example for stop_id=1, the frequency is 117.

2. The next 4 columns are Morning Peak, Day Time, Afternoon Peak, and Nighttime, in

which each row show the number of operations for each stop id. (I want to see, for

example how many morning peak, daytime, … operations the stop id 3 had.

Finally, provide a dash to plot heat map from the “STOPSFREQ” dataframe, in which I should be

able to see heat map of stop locations based on frequencies and time of day operations (please

add features as you see fits to the dash, such as different heat map representations (colors, size),

zooming option, split map control for two types of maps (street view and satellite view), etc.).

If there was any confusion, please let me know.