ESG-Integrated Portfolio
Construct an ESG-tilted portfolio on top of the Kaggle ESG & Financial Performance panel — compare ESG vs market-cap weighting and produce a TCFD-style climate summary.
ESG-Integrated Portfolio
Python / R • Step 4
Construct an ESG-tilted portfolio on top of the Kaggle ESG & Financial Performance panel — compare ESG vs market-cap weighting and produce a TCFD-style climate summary.
Learning Objectives
- →Build ESG-tilted weights from ESG_Overall and MarketCap
- →Compare ESG vs conventional portfolio return and carbon intensity
- →Generate a short TCFD-aligned climate risk report
Dataset
View on Kaggle1,000 companies × 11 years — ESG pillar scores + financials (Revenue, MarketCap, GrowthRate, CarbonEmissions).
*bleep* Load the dataset in the browser terminal:
from pyodide.http import open_url
import pandas as pd
df = pd.read_csv(open_url("/datasets/company_esg_financial_dataset.csv"))
print(df.shape)
print(df.columns.tolist()) Running locally? The file inside the Kaggle download is already named company_esg_financial_dataset.csv — drop it into the notebook's working directory and the code above runs unchanged (swap open_url(...) for "company_esg_financial_dataset.csv").
Dataset Columns
CompanyIDCompanyNameIndustryRevenueMarketCapGrowthRateESG_OverallCarbonEmissionsmarket_weightesg_weighttiltCode Language
- Write your solution in the Try It Yourself editor below — matplotlib/seaborn figures and pandas tables render inline.
- Stuck? Expand a section and click ↑ Send to editor to stack its snippet into the editor, notebook-style.
- Hit ▶ Run (or ⌘↵) — once your output matches the expected result, the step is marked solved.
- Use ↺ Reset to restore the starter code at any time.
Try It Yourself
ESG Portfolio : Market Portfolio : ESG Premium :
Cross-verse learning
Bleepx skills build on each other. Continue your learning path across Query, Lab, and Cloud.