Gathering aggregated ESG data on companies
Read Jonathan Legrand & Zach Sivell’s full article on the Developer Portal.
Environmental, Social and Governance (ESG) data on companies are difficult to investigate graphically. To aid in this initiative, the article below (and on our Developer Portal) builds a Python class to gather ESG data on all companies included in the MSCI World Index and then create graphs to uncover insight behind the data.
The framework built can be used for any data-frame setup in a similar fashion, so that you may insert your own data-frame and still use this class.
This code, runs on Python version 3.7.7 use Refinitiv’s Eikon Python Application Programming Interface (API) to access financial data. Specifically the Eikon Data API (EDAPI). FYI: A new version of this API, RD, is available.
This class has functions to:
Plot Graphs: via
- ESG_Boolean_Data.get_data().Aggregate_Graph
- ESG_Boolean_Data.get_data().Aggregate_Graph_with_Tot
- ESG_Boolean_Data().get_data().Aggregate_Map_Graph
The latter of which can be used for graphs such as:
The entire code can be found on GitHub.
Do not hesitate to use it and suggest any improvements you may want to see with this class.
References
SOURCE CODE
RELATED APIS
RELATED ARTICLES
- Datastream Sustainable Development Goals Country Scores
- May 20, 2020 • Jonathan Legrand
- Explore all Articles
You can find more detail regarding the Eikon Data API and related technologies for this notebook from the following resources:
- Refinitiv Eikon Data API page on the Refinitiv Developer Community web site.
- Eikon Data API Quick Start Guide page.
- Eikon Data API Tutorial page.
- Python Quants Video Tutorial Series for Eikon API.
- Eikon Data API Troubleshooting article.
- Pandas API Reference.
For any question related to this example or Eikon Data API, please use the Developers Community Q&A Forum.