Travel Agency Database (2018)
Analyzed Airbnb and weather forecast data for nine cities though the U.S. Used Python and Pandas to combine CSV files and API data into an SQLite database.
Missouri Commuter Analysis (2018)
Analyzed Census data on commute types per county in Missouri. Used Python and Pandas to extract and transform the data and Matplotlib and Google Maps API to visualize our analysis.
Underground Music Database (2019, Ongoing)
Analyzed data scraped from an underground music blog.
Travel Agency Database
Languages/Tools: Python, Pandas, SQLAlchemy, SQLite Co-Creator/Developer: Dec. 2018 Combines Airbnb and forecast data to inform travelers of weather and Airbnb availability by price for nine U.S. cities
Missouri Commute-Type Analysis
Languages/Tools: Python, Pandas, Matplotlib, Google Maps API Team Lead/Developer: Nov. 2018 While solo vehicle transportation is by far the most popular method to commute, we found significantly more people carpool and walk to work in non-metropolitan counties.
Underground Music Database
Languages/Tools: Python, SQLAlchemy, SQLite, BeautifulSoup Creator/Developer: 2019 (Ongoing) By analyzing the count and connections of underground electronic genres, I hope to create a fuller understanding of modern music genres.