▶
Projects
▶
In [1]:
# CTA Underutilized Routes Analysis
CTA Underutilized Routes Analysis
Analyzed CTA bus ridership through the lens of post-COVID recovery, identifying which routes had bounced back and which remained significantly underutilized. Used Python and Chicago's open data portal to quantify the gaps, visualized findings in Tableau, and wrote up service reallocation recommendations as a policy brief.
▶
In [2]:
# Second Spin
Second Spin
A music blog powered by a Python pipeline pulling data from the Last.fm and Spotify APIs, with song recommendations generated using cosine similarity. Frontend built from scratch in HTML/CSS/JS, no frameworks.
S&P 500 R&D Spending Analysis
Analyzed R&D spending patterns across 251 S&P 500 companies using SEC 10-K filing data from 2012 to 2015. Built a MySQL database with a normalized schema, an ETL pipeline in Python, and seven analytical queries to compare R&D intensity against revenue growth and profit margins. Found that IT and Healthcare dominated R&D investment at 10-11% of revenue, while higher spending showed no consistent correlation with better margins.
IT and Healthcare both spent around 10-11% of revenue on R&D. Every other sector was under 1%. IT total R&D grew from $70B to $81B between 2013 and 2015; Healthcare went from $46B to $54B. Higher spending did not guarantee better margins. Companies at 10%+ R&D intensity showed wide margin variance, with many near breakeven. Low R&D companies grew revenue faster on average (16% vs 13%), though that is likely a sector composition effect rather than a real tradeoff.