Big Java, Binder Ready Version: Early Objects
6th Edition
ISBN: 9781119056447
Author: Cay S. Horstmann
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 5PP
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 11 Solutions
Big Java, Binder Ready Version: Early Objects
Ch. 11.1 -
What happens when you supply the same name for...Ch. 11.1 -
What happens when you supply the name of a...Ch. 11.1 -
Suppose you wanted to add the total to an...Ch. 11.1 -
How do you modify the Total program so that it...Ch. 11.1 -
How can you modify the Total program so that it...Ch. 11.2 -
Suppose the input contains the characters Hello,...Ch. 11.2 - Prob. 7SCCh. 11.2 - Prob. 8SCCh. 11.2 -
Your input file contains a sequence of numbers,...Ch. 11.2 -
How can you remove spaces from the country name...
Ch. 11.3 - Prob. 11SCCh. 11.3 - Prob. 12SCCh. 11.3 - Prob. 13SCCh. 11.3 - Prob. 14SCCh. 11.3 - Prob. 15SCCh. 11.4 - Prob. 16SCCh. 11.4 - Prob. 17SCCh. 11.4 - Prob. 18SCCh. 11.4 - Prob. 19SCCh. 11.4 - Prob. 20SCCh. 11.4 - Prob. 21SCCh. 11.4 - Prob. 22SCCh. 11.4 - Prob. 23SCCh. 11.5 - Prob. 24SCCh. 11.5 - Prob. 25SCCh. 11.5 - Prob. 26SCCh. 11.5 - Prob. 27SCCh. 11.5 - Prob. 28SCCh. 11 - Prob. 1RECh. 11 - Prob. 2RECh. 11 - Prob. 3RECh. 11 - Prob. 4RECh. 11 - Prob. 5RECh. 11 - Prob. 6RECh. 11 - Prob. 7RECh. 11 - Prob. 8RECh. 11 - Prob. 9RECh. 11 - Prob. 10RECh. 11 - Prob. 11RECh. 11 - Prob. 12RECh. 11 - Prob. 13RECh. 11 - Prob. 14RECh. 11 - Prob. 15RECh. 11 - Prob. 16RECh. 11 - Prob. 17RECh. 11 - Prob. 18RECh. 11 - Write a program that carries out the following...Ch. 11 - Write a program that reads a file, removes any...Ch. 11 - Write a program that reads a file, removes any...Ch. 11 - Write a program that reads a file containing text....Ch. 11 - Repeat Exercise E11.4, but allow the user to...Ch. 11 - Write a program that reads a file containing two...Ch. 11 - Write a program that asks the user for a file name...Ch. 11 - Prob. 8PECh. 11 - Prob. 9PECh. 11 - Prob. 10PECh. 11 - Prob. 11PECh. 11 - Prob. 12PECh. 11 - Prob. 13PECh. 11 - Prob. 14PECh. 11 - Prob. 15PECh. 11 - Prob. 16PECh. 11 - Prob. 1PPCh. 11 - Prob. 2PPCh. 11 - Prob. 3PPCh. 11 - Prob. 4PPCh. 11 - Prob. 5PPCh. 11 - Prob. 6PPCh. 11 - Prob. 7PPCh. 11 - Prob. 8PPCh. 11 - Prob. 9PPCh. 11 - Prob. 10PPCh. 11 - Prob. 11PPCh. 11 - Prob. 12PPCh. 11 - Prob. 13PPCh. 11 - Prob. 14PP
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