Please complete them in either Jupter notebook or with .py file and submit your programs and running results. For eachpython program, please also provide your own testing cases. Analyze SP500.csv(excel file,of which image is been uploaded) file with Numpy array operations. Please find answers to the following questions: a)the highest daily gain and its date, the highest daily loss and its date, b)the most daily transaction volume and its date, c)a monthly report for year 2017-2018, which has monthly average open price, close price, transaction volume and gain/loss, and a query to find all of the months which have certain range of open prices d)a yearly report which has annual average open price, close price, transaction volume and gain/loss from 1950 to 2018, and the most profitable year, a every other five year report which has every five year average open price, close price, transaction volume and gain/loss from 1950 to 2018, and the most profitable five year,

1 Date 0 Open High Close Adi Close Volume 1 Date 2 1/3/1950 16.66 16.66 16.6616.6616.66 1260000 3 1/4/1950 16.85 16.85 16.8516.85 16.85 1890000 4 1/5/1950 16.9316.93 16.9316.9316.93 2550000 5 1/6/1950 16.9816.98 16.9816.9816.98 2010000 6 1/9/1950 17.08 17.08 17.0817.0817.08 2520000 Low 2 16.67 16.72 16.67 16.67 16.72 16.6 7 16.67 3330000 16.72 1460000 16.72 16.72 16.9 16.9 16.9 16.9 16.9 1440000 1 Date 0 Open High Close Adi Close Volume 1 Date 2 1/3/1950 16.66 16.66 16.6616.6616.66 1260000 3 1/4/1950 16.85 16.85 16.8516.85 16.85 1890000 4 1/5/1950 16.9316.93 16.9316.9316.93 2550000 5 1/6/1950 16.9816.98 16.9816.9816.98 2010000 6 1/9/1950 17.08 17.08 17.0817.0817.08 2520000 Low 2 16.67 16.72 16.67 16.67 16.72 16.6 7 16.67 3330000 16.72 1460000 16.72 16.72 16.9 16.9 16.9 16.9 16.9 1440000