Find an interesting data set in CSV format (or in spreadsheet format, then use a spreadsheet to
Question:
Find an interesting data set in CSV format (or in spreadsheet format, then use a spreadsheet to save the data as CSV). Using the CSVReader program from Exercise P7.5, read the data and compute a summary, such as the maximum, minimum, or average of one of the columns.
Data from Exercise P7.5,
The CSV (or comma-separated values) format is commonly used for tabular data. Each table row is a line, with columns separated by commas. Items may be enclosed in quotation marks, and they must be if they contain commas or quotation marks. Quotation marks inside quoted fields are doubled. Here is a line with four fields:
1729, San Francisco, "Hello, World", "He asked: ""Quo vadis?""" Write a CSVReader program that reads a CSV file, and provide methods
int numberOfRows()
int numberOfFields(int row)
String field(int row, int column)
Step by Step Answer:
import csv Read in the CSV file reader csvreaderopenpopulationcsv Skip the header nextreader Initialize variables totalpop 0 maxpop 0 minpop 99999999999 Loop over the rows of the file for row in reader Add the population ...View the full answer
