Skip to content
Analyzing Industry Carbon Emissions
  • AI Chat
  • Code
  • Report
  • Photo by Maxim Tolchinskiy on Unsplash

    Greenhouse gas emissions attributable to products—from food to sneakers to appliances—make up more than 75% of global emissions. -The Carbon Catalogue

    Our data, which is publicly availably on nature.com, contains product carbon footprints (PCFs) for various companies. PCFs are the greenhouse gas emissions attributable to a given product, measured in CO2 (carbon dioxide equivalent).

    This data is stored in a PostgreSQL database containing one table, prouduct_emissions, which looks at PCFs by product as well as the stage of production these emissions occured in. Here's a snapshot of what product_emissions contains in each column:

    product_emissions

    fielddata_type
    idVARCHAR
    yearINT
    product_nameVARCHAR
    companyVARCHAR
    countryVARCHAR
    industry_groupVARCHAR
    weight_kgNUMERIC
    carbon_footprint_pcfNUMERIC
    upstream_percent_total_pcfVARCHAR
    operations_percent_total_pcfVARCHAR
    downstream_percent_total_pcfVARCHAR

    You'll use this data to examine the carbon footprint of each industry in the dataset!

    Unknown integration
    DataFrameavailable as
    df
    variable
    -- Start coding here... 
    SELECT *
    FROM product_emissions;
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    DataFrameavailable as
    df
    variable
    SELECt MAX(year)
    FROM product_emissions;
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    DataFrameavailable as
    df
    variable
    /*SELECT each industry, number of companies in each industry and total carbon product footprint for each industry*/
    
    SELECT 
        industry_group, 
        COUNT(*) AS count_industry, 
        ROUND(SUM(carbon_footprint_pcf),1) AS total_industry_footprint
    FROM product_emissions
    WHERE year = 2017
    GROUP BY industry_group
    ORDER BY total_industry_footprint DESC;
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.