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
To start the first task, please download the list of ASX 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.
Obtain a list named as ASXlist of tickers of ASX companies, and print the list.
Set a seed in a random drawing, with the seed number being your student number. For example, if your student number is s your code will be random.seed Use a random function randomsample to sample stocks from the consitutents, sorted in an alphabetical order. Create another dataframe named as dfASX to show the RICs tickers
and company names which can be obtained from dfASX Print dfASX
Go to Refintiv Workspace, find the ESG score of each of those selected companies in the most recent year, and construct a dictionary named ESGscore. Then in dfASX add this dictionary as a new column named 'ESG'. Rank the dfASX by ESG value in descending order
and print dfASX
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
