Correlation Between CO2 Emission Levels and US Stock Market

• 

  Diagnostic Plot

Inspiration

• Increase in Greenhouse Gas Emissions
• Inflation
• Rising Stock Prices in the US Stock Market

What it does

Finds a correlation between Carbon Dioxide Emission levels from USA, China and the US Stock Market Indexes

How we built it

1. Queried Data from Snowflake into CSV Files
2. Loaded data into Pandas dataframes
3. Filtered environment data for US, China
4. Joined Stock Price, company and symbol tables from database
5. Visualized the CO2 Emission Levels and US Stock Market Indexes data over years
6. Built a Linear Regression model with 60% R-square score to find the correlation between the two variables
7. Predicted US Stock Market Index based on Carbon Dioxide emissions from China and USA

Challenges we ran into

1. Understanding and using the snowflake platform
2. Merging different tables from the database
3. Handling large volume of data

Accomplishments that we're proud of

1. Finding a correlation between Carbon Dioxide Emission levels from USA, China and the US Stock Market Indexes
2. Working on and learning about new platforms like Snowflake
3. Learning more about data wrangling

What we learned

1. Operating Snowflake Platform
2. Implementing Machine Learning algorithms
3. Data Wrangling

What's next for Correlation Between CO2 Emission Levels and US Stock Market

1. Further Analysis: finding more such correlations between environmental activities and the US Stock Markets

Built With

• excel
• python
• r
• snowflake
• sql