Project Instruction

• Create a pandas DataFrame called nasdaq100 containing the nasdaq100.csv file and add a column called "ytd" containing year to date (YTD) performance for each company.

• Use the OpenAI API to classify each stock into a sector, saving as a new column in the nasdaq100 DataFrame called "sector" with the following values: Technology, Consumer Cyclical, Industrials, Utilities, Healthcare, Communication, Energy, Consumer Defensive, Real Estate, or Financial.

• Use the OpenAI API to provide summary information about Nasdaq-100 stock performance YTD, recommending the three best sectors and three or more companies per sector, storing as a variable called stock_recommendations.

*Note that when clicking "Submit Project" it may take a while for the code to execute and the tests to run as you are interacting with the OpenAI API.