Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions

Question

Why do HCMSs exist? Do they change over time?

Answered: 1 week ago