1. By utilizing Python language, please create a program named: _Assignment2.py

Your program shall read and parse the following three CompanyList files:

https://raw.githubusercontent.com/gheniabla/datasets/master/companylist-1.csv

https://raw.githubusercontent.com/gheniabla/datasets/master/companylist-2.csv

https://raw.githubusercontent.com/gheniabla/datasets/master/companylist-3.csv

2. Your program shall be able to merge the contents of three input files and produce a sorted (by stock symbols in alphabetical order) and merged output file.

merged.csv

Your program shall identify 15 companies which has highest MarketCap, sorted by the largest to smallest. The identified information shall be written in the CSV file named marketcap.csv.

The fields of the CSV file are: SequenceNumber, "Symbol", "Name","LastSale", "MarketCap", "IPOyear", "Sector", and "Industry. The CSV file shall include the above field names as headers.

The usage of your program shall be functional on the command line for this functionality is similar to the following:

C:\>python Assignment2.py

3. Your program shall provide stock symbol search functionality. If the stock symbol (provided by user) as the command line input parameter is found, your program shall display relevant company information, including: "Symbol","Name","LastSale","MarketCap","IPOyear","Sector","Industry.

If the stock symbol is not found, your program shall display Not found. Message.

The usage of your program shall be functional on the command line similar to the following:

C:\>python Assignment2.py GOOG