Big Java Late Objects
2nd Edition
ISBN: 9781119330455
Author: Horstmann
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Question
Chapter 7, Problem 6PP
Program Plan Intro
Read the values from CSV file and compute the average, minimum, or maximum value of the column
Program plan:
Filename: “CSVReader.java”
- Include the reader header files in the program
- Define the “CSVReader” class
- Declare the private variable
- Define the constructor
- Create an object “rows” for “ArrayList”
- In the “try” block, create an object for “Scanner” class
- Add the lines in the “rows” object
- In the “catch” block, display an error message
- Define the “numberOfRows” method
- Return the number of rows
- Define the “numberOfFields” method
- Check “row” is less than 0 or greater than equal to size of the “rows”
- Throw an “IllegalArgumentException”
- Return the value
- Check “row” is less than 0 or greater than equal to size of the “rows”
- Define the “getFields” method
- Create an object for “Scanner” class
- Use the “,” to separate the words
- Trim the string using the “trim ()” method
- Check the starting letter is “\”
- Check the ending letter is “\”
- Append the comma-separated fields
-
- Remove quotes
- Check the ending letter is “\”
- Replace all the “\\” to “\”
- Add the “field” to the “fields” variable
- Return the value
- Define the “field” method
- Check “row” is less than 0 or greater than equal to size of the “rows”
- Throw an “IllegalArgumentException”
- Check “column” is less than 0 or greater than equal to “numberOfFields (rows)”
- Throw an “IllegalArgumentException”
- Return the value
- Check “row” is less than 0 or greater than equal to size of the “rows”
Filename: “CSVcolumnSummary.java”
- Define the “CSVcolumnSummary” class
- Declare the private variable
- Define the constructor
- Create an object for the “CSVReader” class
- Define the “columnAvg” method
- Declare the variable and set the value
- Iterate “row” until it reaches the declare value
- Calculate the sum
- Return the average of the column
- Calculate the sum
- Define the “columnMin” method
- Declare the variable
- Iterate “row” until it reaches the declare value
- Declare the variable
- Check “value” is less than “min” value
- Set the value
-
- Return the minimum value.
- Define the “columnMax” method
- Declare the variable
- Iterate “row” until it reaches the declare value
- Declare the variable
- Check “value” is greater than “min” value
- Set the value
-
- Return the maximum value.
Filename: “CSVcolumnSummaryTester.java”
- Define the “CSVcolumnSummaryTester” class
- Define the main method
- Create the objects for the “CSVcolumnSummary” class
- Display the average volume.
- Display the minimum volume.
- Display the maximum volume
- Display the average price.
- Display the minimum price.
- Display the maximum price
- Display the expected outputs for all the above outputs.
- Define the main method
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
Big Java Late Objects
Ch. 7.1 - Prob. 1SCCh. 7.1 - Prob. 2SCCh. 7.1 - Prob. 3SCCh. 7.1 - Prob. 4SCCh. 7.1 - Prob. 5SCCh. 7.2 - Prob. 6SCCh. 7.2 - Prob. 7SCCh. 7.2 - Prob. 8SCCh. 7.2 - Prob. 9SCCh. 7.2 - Prob. 10SC
Ch. 7.3 - Prob. 11SCCh. 7.3 - Prob. 12SCCh. 7.3 - Prob. 13SCCh. 7.3 - Prob. 14SCCh. 7.3 - Prob. 15SCCh. 7.4 - Prob. 16SCCh. 7.4 - Prob. 17SCCh. 7.4 - Prob. 18SCCh. 7.4 - Prob. 19SCCh. 7.4 - Prob. 20SCCh. 7.4 - Prob. 21SCCh. 7.5 - Prob. 22SCCh. 7.5 - Prob. 23SCCh. 7.5 - Prob. 24SCCh. 7.5 - Prob. 25SCCh. 7.5 - Prob. 26SCCh. 7 - Prob. 1RECh. 7 - Prob. 2RECh. 7 - Prob. 3RECh. 7 - Prob. 4RECh. 7 - Prob. 5RECh. 7 - Prob. 6RECh. 7 - Prob. 7RECh. 7 - Prob. 8RECh. 7 - Prob. 9RECh. 7 - Prob. 10RECh. 7 - Prob. 11RECh. 7 - Prob. 12RECh. 7 - Prob. 13RECh. 7 - Prob. 14RECh. 7 - Prob. 15RECh. 7 - Prob. 16RECh. 7 - Prob. 17RECh. 7 - Prob. 18RECh. 7 - Prob. 1PECh. 7 - Prob. 2PECh. 7 - Prob. 3PECh. 7 - Prob. 4PECh. 7 - Prob. 5PECh. 7 - Prob. 6PECh. 7 - Prob. 7PECh. 7 - Prob. 8PECh. 7 - Prob. 9PECh. 7 - Prob. 10PECh. 7 - Prob. 11PECh. 7 - Prob. 12PECh. 7 - Prob. 1PPCh. 7 - Prob. 2PPCh. 7 - Prob. 3PPCh. 7 - Prob. 4PPCh. 7 - Prob. 5PPCh. 7 - Prob. 6PPCh. 7 - Prob. 7PPCh. 7 - Prob. 8PPCh. 7 - Prob. 9PPCh. 7 - Prob. 10PPCh. 7 - Prob. 11PPCh. 7 - Prob. 12PPCh. 7 - Prob. 13PP
Knowledge Booster
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
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)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education