Project

First project from Metis Fall 2018 Bootcamp (Project Benson) with Dana Lindquist, Jason Salazer-Adamso Leo Liu & Spencer Tollefson

Flow of Data Analysis

Presentation
Station_to_company_scoring.ipynb - Notebook with EDA of relating stations, companies, turnstiles, and calculating a score for determining which station is close to which company.
find_schedule.ipynb - Test the funcationality of find_scheddule.py and output the schedule ready to be delivered
HeatmapWork.ipynb - Output of heatmaps used for presentation
NYC_map.ipynb - plots outline of Manhattan with dots with geographic location points

find_schedule - Generates a schedule for stations listed in the df_top.csv, which indicates when volunteers should be at these stations
merge_station_company - Function to merge MTA station master data with Grace Hopper company master data and calculate distance between station to company.
read_mta_stations - reads MTA masterlist of station coordinates into pandas DataFrame. Cleans formatting slightly.
read_mta_turnstile - Reads the MTA turnstile data from http://web.mta.info/developers/turnstile.html for a given date range and creates a data frame.
read_tech_companies - takes 'tech_companies.csv' and enters into pandas DataFrame
top_stations - Calculates the top station/company pairs based on a column in a merge station_company data frame.
create_station_heatmap - This function inputs a Name of a MTA station and a DataFrame with complete, clean MTA turnstile count data. It outputs two heatmaps - one for Entries and one for Exits - that shows the highest conentrated passenger throughput by time of day (morning, midday, evening) and day of week.

from geopy.distance import geodesic - Library to calculate the distance between to points with Lat/Long coordinates
from mpl_toolkits.basemap import Basemap - Library to plot maps and points on the maps

Name		Name	Last commit message	Last commit date
Latest commit History 97 Commits
data		data
.gitignore		.gitignore
HeatmapWork.ipynb		HeatmapWork.ipynb
LICENSE		LICENSE
NYC_map.ipynb		NYC_map.ipynb
README.md		README.md
Station_to_company_scoring.ipynb		Station_to_company_scoring.ipynb
Toucans_Presentation.pdf		Toucans_Presentation.pdf
create_station_heatmap.py		create_station_heatmap.py
find_schedule.ipynb		find_schedule.ipynb
find_schedule.py		find_schedule.py
merge_station_company.py		merge_station_company.py
read_mta_stations.py		read_mta_stations.py
read_mta_turnstile.py		read_mta_turnstile.py
read_tech_compaines.py		read_tech_compaines.py
top_stations.py		top_stations.py