Question: Working in Python 3.6 On the class website is a CSV file containing weather data from Coulter Field (in Bryan) for 3 years (1 day

Working in Python 3.6

On the class website is a CSV file containing weather data from Coulter Field (in Bryan) for 3 years (1 day is missing for some reason!); the data was taken from Weather Underground (wunderground.com). There are different versions of the file for Windows and Mac; the only difference is whether the end of a line contains just a new-line character, or both a new-line and a carriage return (you dont need to worry about the difference). Open the file in any text browser and you should see what it is. Note that the first line of the file contains the column headers explaining what each column is.

Download the file to your system, write a program that will read in the file and do the following:

a.Output the maximum and minimum temperature seen over the 3 year period

b.Output the average daily precipitation

c.Pick any 3 other interesting data analysis questions (of your choice) and output the answer to that question. For at least one, make use of the date information. Here are some ideas, but you can pick whatever you want:

a.For some particular day, such as December 25, find the maximum and minimum temperatures reached among the 3 years of data.

b.For some particular month, such as July 2015, calculate the average high temperature.

c.Calculate how frequently the pressure increases from one day to another vs. how frequently it decreases.

d.Calculate the percentage of days when the humidity was above some value, like 90%.

e.Calculate the mean and standard deviation of precipitation levels.

Be sure to include a descriptive sentence for what you are printing out in each case.

data file looks like the following

Date

Temp High

Temp Avg

Temp Low

Dew Point High

Dew Point Avg

Dew Point Low

Humidity High

Humidity Avg

Humidity Low

Pressure High

Pressure Avg

Pressure Low

Precipitation (in.)

1/1/2015

41

38

35

41

38

32

100

96

73

30.38

30.25

30.14

0.72

1/2/2015

44

42

40

44

42

40

100

99

97

30.17

30.08

29.95

0.17

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!