Question

Write in Java please.

The purpose of this program is to read a file, called WaterData.csv. It will output date and gallons. So it would look something like "2/04/15 40 Gallons". The pseudo code is as follows.

prompt the user for a file name
open the file
if that file cannot be opened
    display an error message and quit
endif

create a String variable 'currentDate' and initialize it to the empty string.
create a variable gallonsUsed and initialize it to 0

while the file has contents
    read a line
    if the line begins with an octothorpe (#) or is length 0
        throw the line away
    end if

    split the line into fields called String[] dataFields
    if there are < or > 2 fields
        add an error message to an error list (ArrayList<String>)
        throw the line away
    end if

    split dataFields[0] (the date field) into dateFields (what is the delimiter?)
    ignore the time field.

    if currentDate is empty
        assign dataField[0] to currentDate
        add the hours' reading to gallonsUsed 
    else if currentDate <> dataField[0]
        we've found a new day
        output the date and the gallonsUsed for that date
        do not display any more than 1 digit to the right of the decimal point
        assign dataField[0] to currentDate 
        reset gallonsUsed
    end if
        
end while

output the last reading

The water.csv program looks like this

"

#DateTime,Gallons
1/28/2019 16:00,0.7
1/28/2019 15:00,5.5
1/28/2019 14:00,0
1/28/2019 13:00,0.3
1/28/2019 12:00,0.7
"

The output should look like this:

1/28/19    43 Gallons
1/27/19    56 Gallons

Answer 1

Solution(s):

I will be writing this code in Python. However, I do not have the CSV file. So, I will be providing a partial solution. Thumbs up if you like the solution.

# Displaying error if the file can not be opened.

import sys
try:
f = open('WaterData.csv', 'rb')
except IOError:
print ("Could not read file: WaterData.csv")
sys.exit()

#Defining the variables.

currentDate = ''
gallonsUsed = 0

#Reading the CSV file.

import csv

with open("WaterData.csv", "r") as f:
reader = csv.reader(f, delimiter="\t") #Change the delimeter according to your file.
for i, line in enumerate(reader):
if not line.startswith('#') or not line.startswith(''):
if len(list)==2:
  
else:
print('Error in the line.')
continue: