Question: 1 . To start the first task, please download the list of ASX 2 0 0 consituent companies from Refinitiv Workspace, and use Python Pandas

1. To start the first task, please download the list of ASX200 consituent companies from Refinitiv Workspace, and use Python Pandas to import it as a DataFrame (named as dfASX). Print the dataframe dfASX in a Jupyter Notebook cell.
2. Obtain a list (named as ASXlist) of tickers of ASX200 companies, and print the list.
3. Set a seed in a random drawing, with the seed number being your student number. (For example, if your student number is s1234567, your code will be random.seed(1234567)). Use a random function (random.sample()) to sample 20 stocks from the consitutents, sorted in an alphabetical order. Create another dataframe (named as dfASX20) to show the RICs (tickers)
and company names (which can be obtained from dfASX). Print dfASX20.
4. Go to Refintiv Workspace, find the ESG score of each of those selected 20 companies in the most recent year, and construct a dictionary named ESGscore. Then in dfASX20 add this dictionary as a new column named 'ESG'. Rank the dfASX20 by ESG value in descending order
and print dfASX20.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!