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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started