Climate Data

Click Here to Download this Answer Instantly

Write a program that reads in the file climate_data_2017_numeric.csv and prompts the user to enter the name of a field (other than Date), and then outputs the highest and lowest values recorded in that field for the month of August.The file climate_data_2017_numeric.csv contains the following fields:Date
Minimum temperature (C)
Maximum temperature (C)
Rainfall (mm)
Speed of maximum wind gust (km/h)
9am Temperature (C)
9am relative humidity (%)
3pm Temperature (C)
3pm relative humidity (%)
Your program should work like this:Maximum temperature (C)
Available field names:
Minimum temperature (C)
Maximum temperature (C)
Rainfall (mm)
Speed of maximum wind gust (km/h)
9am Temperature (C)
9am relative humidity (%)
3pm Temperature (C)
3pm relative humidity (%)
‚Äč
Please enter a field name: Minimum temperature (C)
Statistics for field ‘Minimum temperature (C)’:
Min: 1.0 Max: 14.6
Customer: python

Within the next two days my data set looks like this :

Date,Minimum temperature (C),Maximum temperature (C),Rainfall (mm),Speed of maximum wind gust (km/h),9am Temperature (C),9am relative humidity (%),3pm Temperature (C),3pm relative humidity (%)
2017-06-01,8.0,18.3,0,43,10.3,54,17.8,39
2017-06-01,7.4,23.3,0,24,12.1,80,22.5,55
2017-06-01,7.9,13.9,0.4,20,10.5,82,13.6,57
2017-06-02,8.0,14.7,0,20,10.6,64,13.3,69
2017-06-02,8.3,24.2,0,30,14.7,78,22.5,57
2017-06-02,8.5,18.1,0,41,10.7,61,16.4,50
2017-06-03,9.1,23.1,0,28,14.7,86,22.9,57
2017-06-03,9.9,14.3,0,19,10.8,76,13.1,73
2017-06-03,10.7,17.4,0,41,13.4,64,16.4,66
2017-06-04,4.4,15.8,0,13,5.7,100,15.5,53