Superfund Sites vs Demographics: Environmental Justice Analysis
● Extracted data from a JSON, including location and descriptions of superfund sites (EPA) and demographics and socioeconomics (Census). Cleaned data, selected columns, and uploaded to SQL.
● Subject Matter Expert and Analyst. Made visualizations and tables in HTML/JS and made presentation.
● Used Python, Pandas, Jupyter Notebook, SQLalchemy, SQL, HTML, JS and d3 on the data.
Superfund Sites vs Demographics: Environmental Justice Analysis
● Used data from the preceding project for novel machine learning analysis giving predictions of presence of superfund sites given Census information. Uploaded the CSV, cleaned data, and selected columns.
● Subject Matter Expert and Analyst. Made images in Tableau, did modeling, and made presentation.
● Used Python, Pandas, Jupyter Notebook, SQLalchemy, SQL, Tableau, JS and ML models on the data.
Carbon Emissions Examined: Relationships with Price, Outdoor Recreation, and Population
● Used multiple regression analyses of carbon emissions data from US states and compared to prices on emissions, outdoor recreation, and population.
● Subject Matter Expert and Analyst. Collected and cleaned data, ran analysis, and wrote conclusions.
● Used Excel and Python Pandas and Matplotlib, analyzing data from EIA, RGGI, Census, and others.
Columbia University Peru Mining 2018 Capstone, Community Partnership
● Team Member. Under faculty supervision, formulated an informed prior consent agreement between mining companies and affected communities with a team of 11 graduate students.