t 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 February. ___________ has the minimum trade volume of ______________ i

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

the volume of traded Apple 
stocks during February and March 2022. 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 February.
___________ has the minimum trade volume of ______________ in February.
___________ has the maximum trade volume of _____________ in March.
___________ has the minimum trade volume of ______________in March.
The whole trade volume of these two months is ______________.
The average trade volume of February is ______________.
The average trade volume of March 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 5 steps with 4 images

Blurred answer
Knowledge Booster
Map
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
  • SEE MORE 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