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
  • 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
    • 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

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
  • 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.