Question: The objective is to write a program to process a file containing weather data. Input File Weather data is stored in a CSV-format file of

The objective is to write a program to process a file containing weather data.

Input File

Weather data is stored in a CSV-format file of multiples rows, one row per line, with each row having the specific format shown below:

STATION,STATION_NAME,DATE,TMAX,TMIN,AWND

The columns have the following meaning:

STATION: the station-id for this row

STATION_NAME: the name of this station

DATE: the daily date the readings were taken, in the format yyyymmdd

TMAX: maximum temperature on that date, in tenths of degree Celsius

TMIN: minimum temperature on that date, in tenths of degree Celsius

AWND: average wind speed on that date, in tenths of meters per second.

In addition, note the following details about the file format:

The first row of this file is a column-heading line.

All rows for a particular station appear contiguously, with the rows in chronological date order, with no date rows missing in between the start and end of the data for this station.

Data in the TMAX,TMIN or AWND cells for a station and date might be missing, in which case the cell will have an entry of N/A.

Methodology

The input and output file names be read as command line arguments. So I should be able to invoke your program (called, for example,WeatherProcess.java) from thecommand line as follows:

java WeatherProcess weather1.csv summary.csv

Be aware that some of the input files might be large. Note that the starting and ending dates for the data do not have to be on a month or year boundary. Clearly, your code should work for any input file in this format.

You will need to detect when the rows for a particular station end and data for a new station begins. This can be done by tracking the station name and detecting when that changes.

Within each station data, you will need to detect when each month ends and another month begins.

(java)

Im not really sure where to start on this if anyone can give sometime of help it would be well appricated

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!