#Full Website here: https://raquelcastromonte.github.io/
- Cyclistic Bike Program Analysis
- RootedIn: A Wellness Company Data Analysis
- Eviction: An Insight on NYC Evictions Between 2018 - 2022
- Incorporating Chlorophyll-a Levels into a Model of Gizzard Shad in the Upper Mississippi River
- Rent Inequality in NYC
My Tableau
Report | Cyclistic Bike Program Analysis
Project Completion Date: February 13, 2023
- Used python to create visuals and simple statistics on the customer base of Cyclistic's Bike Program.
- Goal was to understand the different behaviors between casual users and annual members of the bike program in Chicago.
- Submitted recommendations to influence casual users to switch to annual members.
GIS Layouts | PLSC 2200 Intro to GIS
Project Completion Date: December 8, 2022
Our final project for COOP Fall 2022 was a client project. Our client RootedIn wanted to analyze their insights on their social media and website traffic. There were 16 total members divided into four subteams: Site Traffic and User Engagement using Google Analytics1, Facebook and Instagram Analysis, Email Analysis, Tiktok Analysis.
1 Team consists of Raquel Castromonte, Elizabeth Tum, Alexandra Reyes, Andre Cunalata.
- Examined company’s site traffic and audience engagement using Google Ads, Google Analytics, SEO, and spreadsheets functions.
- Created an action plan that includes quality keywords for more organic traffic, seasonal sale codes for audience retention, and site sign-up forms that will increase site conversions by 25%.
- Organized campaign data using pivot tables and dashboards on PowerBI.
Report | “Eviction: An Insight on NYC Evictions Between 2018 - 2022”
Project Completion Date: October 13, 2022
As a COOP aprentice, my team and I explored the public New York City Eviction Data. Link to our project repository here.
Collaborators: Raquel Castromonte, Elizabeth Tum, Alexandra Reyes, Andre Cunalata.
- Cleaned New York City’s public dataset on evictions using SQL and Excel to ease data analysis.
- Produced data visualizations that mapped evictions by neighborhoods, boroughs, and by demographics such as race and age in Python (matplotlib).
- Read NYC eviction laws to explain correlations of neighborhood composition, evictions over time, and eviction moratorium due to COVID-19.
Poster | “Incorporating Chlorophyll-a Levels into a Model of Gizzard Shad in the Upper Mississippi River”
Project Completion Date: August 4, 2021
This project was performed at the University of Wisconsin - La Crosse as a McNair Scholar and NSF Undergraduate Researcher. View abstract here.
Collaborators:
- James Peirce, University of Wisconsin - La Crosse; River Studies Center, La Crosse, WI
- Gregory Sandland, University of Wisconsin - La Crosse; River Studies Center, La Crosse, WI
- Worked on an integral projection model (IPM) to visualize a fish species' future population demographics at equilibrium.
- Implement a food quality parameter on the model to further describe population dynamics.
- Worked as a team to extract parametric data from papers, graphs, and long-term open-source databases.
- Engaged in virtual and in-person conferences presenting my research as a poster or oral presentation.
Report | “Rent Inequality in NYC”
This project was performed for INFO 2950: Introduction to Data Science with Professor Matthew Wilkens in spring 2021. View project repository here. Project Completion Date: May 12, 2021
Collaborators: Raquel Castromonte, Caitlyn Johnson, Alex Kim, Dana Gong [all are undergraduate students at Cornell University during the spring of 2021]
- Analyzed housing crisis in New York City as a team to investigate relationship between rent burden and racial minority status across all boroughs.
- Supplied my team an OLS model on the relationship between percent rent burden and percent minority of each borough.
- Retrieved, organized, and cleaned open-source data on rent instability in NYC using SQL, R, Python.