CSV Files

For this project, the input file will be stored as comma$-$separated values $($csv files format$).$

You can take a look at csv files with an ordinary text file editor or by using Excel. Both views will be illustrated in the examples below.

The file contains a database arranged as a $2-$dimensional table. The first line $($row$)$ contains column headings. Each remaining line

$($row$)$ contains a data record that consists of plain$-$text fields separated by commas.

Here are two views of an example input file ex$.$csv $($downloadable below$)$:

Id$,$Last name,First name,Weight,Empty,Age

$10,$Saban,Nick,$147\mathrm{.}7,69$

$1,$Jones,Mac,$205\mathrm{.}2,,22$

$5,$Ingram,Mark,$210\mathrm{.}0,,31$

$3,$Henry,Derrick,$238\mathrm{.}0,,27$

$6,$Harris,Najee,$229\mathrm{.}4,,22$

$4,$Smith,Devonta,$174\mathrm{.}0,,22$

$8,$Waddle,Jaylen,$183\mathrm{.}0,,$

$2,$Ridley,Calvin,$190\mathrm{.}0,,26$

$9,$Jones,Julio,$220\mathrm{.}0,,31$

$7,$Metchie,John,$194\mathrm{.}0,,$

Implementation

Name the program p$1.$cpp$.$

The program accepts two command$-$line arguments:

input csv filename

display column width used when printing rows and columns from the csv

Example: $./$a$.$out ex$.$csv $15$

Your program will continually accept the following commands until the quit command is input:

quit

Stop accepting commands and close the program.

help

Print possible commands.

print

Print all rows and columns. Each column should be printed with a width equal to the second command line argument. Spaces should still be print for empty columns.

cols

Print all column names with each appearing on a newline.

search col$\_$name value

Formatted print all rows where the value in column col$\_$name equals the value. Each column should be printed with a width equal to the second command line argument.

If col$\_$name is $*,$ then print any rows where the value appears in any column in the row. If a value appears in a row more than once, only print the row once.

If no rows match, print $"$No results".

min col$\_$name

Determine the minimum value in the column col$\_$name. Ignore rows with blank values.

Use the normal formatting when outputting numbers $($i$.$e$.,$ do not use setprecision$()).$

Output: "The min for col $"$C$"=$ X$"$ where C is the column and X is the min or $"$N$/$A$"$ if the min cannot be computed $($all cells blank$).$

max col$\_$name

Determine the maximum value in the column col$\_$name. Ignore rows with blank values.

Use the normal formatting when outputting numbers $($i$.$e$.,$ do not use setprecision$()).$

Output: "The max for col $"$C$"=$ X$"$ where C is the column and X is the max or $"$N$/$A$"$ if the max cannot be computed $($all cells blank$).$

avg col$\_$name

Calculate the average value in the column col$\_$name. Ignore rows with blank values.

Use the normal formatting when outputting numbers $($i$.$e$.,$ do not use setprecision$()).$

Output: "The avg for col "col$\_$name" $=$ X$"$ where C is the column and X is the average or $"$N$/$A$"$ if the average cannot be computed $($all cells blank$).$

Error messages and actions:

Invalid number of command$-$line arguments: "Usage: $./$a database.csv #col$\_$width" and close program

Cannot open input csv file: "Failed to open "filename"" and close program

Invalid command: "Invalid command" and ask for another command, consuming all input still remaining on the line

Invalid col$\_$name in input command: "Invalid column "col$\_$name"" and do nothing

The col$\_$name and value provided in a command can appear inside quotes. For example: search Age $22$ and search "Age" $22$ and search Age $"22"$ and search "Age" $"22"$ all perform the same operation. This is useful when the column being searched has whitespace, such as when searching the column "Last name": search "Last name" "van der Woodsen". It can also be useful when searching for a column with a blank value: search $"*""".$ Quoted inputs also work for min, max, and avg, e$.$g$.$ max "Age".

Notes

Review command$-$line arguments $($link$)$ if necessary.

You should only include the following libraries: iostream, string, fstream, sstream, cctype, iomanip, climits

Assume valid input in the files and command $($except for input that is supposed to trigger the error messages$).$

Assume that each csv file contains at most $5,000$ rows, and that every row contains the same number of columns, which is at most $50.$

The csv file will not always have the same columns as shown in the example, as they can have variable rows and columns.

In the csv file, the data between commas is case$-$ and whitespace$-$sensitive$.$

In a command, the input is case$-$sensitive $("$Age$"$ is not the same as "age"$).$ Any whitespace that appears inside a quoted input col$\_$name$/$value is whitespace$-$sensitive $("$First$"$ is not the same as $"$ First $").$

Assume min, max, and avg will be performed on columns only containing valid doubles.

Your program should run according to the examples below.