Question

In this part of the assignment you are provided a list of mutual funds and the companies that were dropped from their portfolios. We want to obtain the 10-K filings for these companies. In the file (Dropped_Companies.csv), there is a column called "Name of Stock". Load the file, extract a list of all the companies in that column, then find the 10-K links for all these companies. DO NOT USE BEAUTIFUL SOUP FOR THIS SECTION. Use the .find function as we did in class. This is important. If you do not follow these instructions you will be deducted points. #DO NOT USE BEAUTIFUL SOUP FOR THIS SECTION. import pandas as pd import urllib

Answer 1

To find the 10-K filings for companies listed in a CSV file without using BeautifulSoup, load the file using pandas, extract the company names, and use urllib along with the .find() function to locate the 10-K links.

Step-by-step explanation:

To accomplish the task of obtaining the 10-K filings for companies listed in the Dropped_Companies.csv file without using BeautifulSoup, you'll need to follow these steps:

• First, import the required libraries, pandas for data manipulation and urllib for URL handling.
• Load the CSV file into a pandas DataFrame using the pd.read_csv() function.
• Once the data is loaded, extract the list of company names from the 'Name of Stock' column.
• For each company, construct the URL to their 10-K filing. This typically involves using the company's stock symbol to visit their investor relations page or a financial data service that provides access to such filings.
• Use the .find() function as instructed to locate the direct link to each company's 10-K filing. The .find() function can be used to search through the HTML contents of the webpage where the 10-K filings are listed.
• Collect the 10-K filing links in a list or another suitable data structure.

Please remember that the specifics of the URL format for 10-K filings may depend on the database you are accessing, and it is crucial to adhere to the guidelines provided in class regarding the use of the .find() function. Additionally, ensure that you do not use BeautifulSoup as per the instructions.