Python Code in Workspace.

Huma · April 7

do you have the python code requiring the permid of all companies for which Refinitiv can provide ESG scores or data ?

Jirapongse · April 8

Thank you for reaching out to us.

I used the method mentioned in this Evolution of ESG Disclosures article.

The code should look like this:

df = ld.get_data(["SCREEN(U(IN(Equity(active,public,private,primary))/*UNV:PublicPrivate*/), TR.TRESGScore(Period=FY2002)>=0)"],
                 ['TR.CommonName','TR.TRESGScore','TR.OrganizationID'])

df

However, please contact the helpdesk team directly via MyAccount to verify the screener formula and those fields.

Huma · April 8

@Jirapongse

When I tried using the above on Code book in Workspace , I got the below output with error.

---------------------------------------------------------------------------NameError                                 Traceback (most recent call last)/tmp/ipykernel_112/1360442533.py in <module>----> 1 df = ld.get_data(["SCREEN(U(IN(Equity(active,public,private,primary))/*UNV:PublicPrivate*/), TR.TRESGScore(Period=FY2002)>=0)"],      2                  ['TR.CommonName','TR.TRESGScore','TR.OrganizationID'])      3       4 dfNameError: name 'ld' is not defined

Jirapongse · April 9

https://community.developers.refinitiv.com/discussion/comment/125114#Comment_125114

@Huma

Please refer to the __Examples__/01. Data Retrieval and Discovery/01.01. LSEG Data Library/Access__Get_Data.ipynb example on Codebook.

shivananda.panegaon · April 18

Hello @Jirapongse
Upon checking didn't find "__Examples__/01. Data Retrieval and Discovery/01.01. LSEG Data Library/Access__Get_Data.ipynb" on Codebook(CODEBK), can you please share the path on Codebook(CODEBK).

And also can you please let us know if there any alternate python code to retrieve Perm Id of all companies for which Refinitiv can provide ESG scores or data ?