Skip to content

Emissions data of the Dow 30

I collected the greenhouse gas (GHG) emissions from the 30 companies in the Dow Jones Industrial Average in order to analyze which companies are emitting the most GHGs.

I also included emissions data from all world organizations in order to see how the top American emitters compare to other countries' top emitters.

First, here is a brief primer on the different 'scopes' of emissions: Scope 1: considered direct emissions by a company. These emissions are the result of a company's primary operations. As an example, a delivery company counts emissions from vehicles' exhaust during all deliveries.

Scope 2: considered indirect emissions by a company. These emissions are the result of a company's purchased electricity to operate buildings and operations. As an example, a company's office spaces must count the emissions from the electricity, natural gas or whatever power was generated to operate their facilities.

Scope 3: considered indirect emissions by a company. These emissions are the result of a company's supply chain operations. As an example, a gas & oil refining company must count the emissions used "upstream" in its supply chain, which would be the oil drilling. The company must also count the emissions used "downstream" which would be the exhaust from all end users of the refined oil, such as car drivers.

Also, for measurements, the Dow companies' emissions are reported in metric tons of carbon dioxide equivalents (CO2e). And the world entities' are reported in millions of metric tonnes of CO2e.

!pip install dash
import plotly.express as px
import plotly.graph_objects as go
import dash
from dash import dcc, html
import numpy as np
import pandas as pd

dow = pd.read_excel('dow30_emissions.xlsx', sheet_name='Sheet1')
world = pd.read_csv('emissions_low_granularity.csv')
Hidden output

I'll start by cleaning the data.

dow.info()
dow.head()
dow = dow.fillna('NR')
dow.loc[dow['company'] == 'Amgen', 'scope2'] = 0
dow['scope1+2'] = dow['scope1'] + dow['scope2']
dow.info()
dow
dow_hilow = dow.sort_values(by='scope1+2', ascending=False)
dow_lowhi = dow.sort_values(by='scope1+2')
dow_hilow

Top emitters of Scope 1 & 2

This graph added the companies' scope 1 and 2 emissions together and provided a bar graph to visualize the results. Chevron is clearly the top emitter, which makes sense since it is an oil and gas company.

# Ensure 'scope1+2' is treated as numeric for color mapping
dow_lowhi['scope1+2'] = pd.to_numeric(dow_lowhi['scope1+2'], errors='coerce')

fig1 = px.bar(dow_lowhi, x='scope1+2', y='company', orientation='h', 
              title='Total Scope 1 & 2 Emissions per company', 
              color='scope1+2', 
              color_continuous_scale='redor', 
              width=800, height=800)
fig1.update_xaxes(title_text='Scope 1 & 2 Emissions')
fig1.update_yaxes(title_text='')
fig1.show()
scope3_reported = dow[dow['scope3'] != 'NR'].sort_values(by='scope3')
scope3_reported

Top emitters of Scope 3

Scope 3 emissions are difficult to track for companies, and a few didn't report them. I removed the 3 companies that did not report it. Again, Chevron had by far the most emissions, almost twice the number of second place. Caterpillar was second, which makes sense because they sell heavy machinery and are forced to count all the emissions from those end users.

scope3_reported['scope3'] = pd.to_numeric(scope3_reported['scope3'], errors='coerce')

fig2 = px.bar(scope3_reported, x=scope3_reported['scope3'], y=scope3_reported['company'], 
              title='Scope 3 Emissions per company', orientation='h', color='scope3',
              color_continuous_scale='redor', width=800, height=800)
fig2.update_xaxes(title_text='Scope 3 Emissions')
fig2.update_yaxes(title_text='')
fig2.show()
world.info()
world.head()
world.columns = ['year', 'company', 'type', 'emissions']
world.head()
world_2022 = world[world['year'] == 2022].sort_values('emissions', ascending=False)
world_2022

Top 20 Global GHG Emitters

Interesting to note that the top 11 world emitters are state-owned organizations. And as you can see, China's Coal company is number one by a wide margin, producing over 14% of the earth's GHG emissions in 2022.

‌
‌
‌