HELLO DEAR, I NEED HELP . THANKS A LOT The volume of traded Apple stocks during July and August 2021. The dates are in ascending order with their respective trade volumes. Input: Write a Python program that reads the data of the dates and stock volumes into two separate lists. Output: The program must display the dates having the maximum and minimum trading volume of each month. In addition, the program must display the whole trade volume, average trade volume for each month and shows the month that Apple has a higher trading volume. Sample Output: ______________ has the maximum trade volume of ______________ in July. ______________ has the minimum trade volume of ______________ in July. ______________ has the maximum trade volume of _____________ in August. ______________ has the minimum trade volume of ______________in August. The whole trade volume of these two months is ______________. The average trade volume of July is ______________. The average trade volume of August is ______________. AAPL has higher trading volume in ______________. Coding requirements:  The program must use lists, strings and built-in list functions to complete the task.  The program should include user defined functions to modularize the code.  The program must include exception handling to handle IOError exception. Date,Volume 1/02/2022,86213900 2/02/2022,84914300 3/02/2022,89418100 4/02/2022,82465400 7/02/2022,77251200 8/02/2022,74829200 9/02/2022,71285000 10/02/2022,90865900 11/02/2022,98670700 14/02/2022,86185500 15/02/2022,62527400 16/02/2022,61177400 17/02/2022,69589300 18/02/2022,82772700 22/02/2022,91162800 23/02/2022,90009200 24/02/2022,141147500 25/02/2022,91974200 28/02/2022,95056600 1/03/2022,83474400 2/03/2022,79724800 3/03/2022,76678400 4/03/2022,83737200 7/03/2022,96418800 8/03/2022,131148300 9/03/2022,91454900 10/03/2022,105342000 11/03/2022,96970100 14/03/2022,108732100 15/03/2022,92964300 16/03/2022,102300200 17/03/2022,75615400 18/03/2022,123511700 21/03/2022,95811400 22/03/2022,81532000 23/03/2022,98062700 24/03/2022,90131400 25/03/2022,80546200 28/03/2022,90371900 29/03/2022,100589400 30/03/2022,92633200 31/03/2022,103049300

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

HELLO DEAR,

I NEED HELP . THANKS A LOT

The volume of traded Apple stocks during July and August 2021. The dates are in ascending order with their respective trade volumes.

Input: Write a Python program that reads the data of the dates and stock volumes into two separate lists.

Output: The program must display the dates having the maximum and minimum trading volume of each month. In addition, the program must display the whole trade volume, average trade volume for each month and shows the month that Apple has a higher trading volume.

Sample Output:

______________ has the maximum trade volume of ______________ in July.

______________ has the minimum trade volume of ______________ in July.

______________ has the maximum trade volume of _____________ in August.

______________ has the minimum trade volume of ______________in August.

The whole trade volume of these two months is ______________.

The average trade volume of July is ______________.

The average trade volume of August is ______________.

AAPL has higher trading volume in ______________.

Coding requirements:

 The program must use lists, strings and built-in list functions to complete the task.

 The program should include user defined functions to modularize the code.

 The program must include exception handling to handle IOError exception.

Date,Volume
1/02/2022,86213900
2/02/2022,84914300
3/02/2022,89418100
4/02/2022,82465400
7/02/2022,77251200
8/02/2022,74829200
9/02/2022,71285000
10/02/2022,90865900
11/02/2022,98670700
14/02/2022,86185500
15/02/2022,62527400
16/02/2022,61177400
17/02/2022,69589300
18/02/2022,82772700
22/02/2022,91162800
23/02/2022,90009200
24/02/2022,141147500
25/02/2022,91974200
28/02/2022,95056600
1/03/2022,83474400
2/03/2022,79724800
3/03/2022,76678400
4/03/2022,83737200
7/03/2022,96418800
8/03/2022,131148300
9/03/2022,91454900
10/03/2022,105342000
11/03/2022,96970100
14/03/2022,108732100
15/03/2022,92964300
16/03/2022,102300200
17/03/2022,75615400
18/03/2022,123511700
21/03/2022,95811400
22/03/2022,81532000
23/03/2022,98062700
24/03/2022,90131400
25/03/2022,80546200
28/03/2022,90371900
29/03/2022,100589400
30/03/2022,92633200
31/03/2022,103049300

Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Problems on Dynamic Programming
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education