Question

Hello! I have this python Homework due tonight that I don't know how to do. Here is a document with the data in the csv file, as I didn't know how to share it

https://docs.google.com/document/d/1bDJVR2MqWKInvw5u0r3fOG3-CBmu3BEiPZwlaq_CShQ/edit?usp=sharing

Activity #3: 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 don’t 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, and 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. Note that the “interesting” analysis questions you choose should be different analyses from each other; for example, you should not find the min/max temperature for just 3 different dates, or find the min/max pressure for December 25, since those are essentially the identical computation.

Answer 1

Code--

import pandas as pd
import statistics

weather_report=pd.read_csv('weather file.csv')

max_temp=max(weather_report['Temp High'])
min_temp=min(weather_report['Temp Low'])
print('Maximum and minimum temperature seen over the 3 years are',max_temp,'and',min_temp)

total_days=weather_report.shape[0]
sum_of_percipitation_values=sum(weather_report['Precipitation (in.)'])
print('The average percipitation value is ',sum_of_percipitation_values/total_days)

def resolve_date(date):
day=0
month=0
year=0
flag=0
for ch in date:
if(ch=='/'):
flag+=1
continue
if(flag==0):
month=month*10+int(ch)
elif(flag==1):
day=day*10+int(ch)
else:
year=year*10+int(ch)
return day,month,year

#calculating average high temperature for July 2015
sum_of_high_temperature=0
days_in_july15=0
for i in range(weather_report.shape[0]):
date=weather_report['Date'][i]
day,month,year=resolve_date(date)

#print(month==7,year)
if(month==7 and year==2015):
sum_of_high_temperature+=weather_report['Temp High'][i]
days_in_july15+=1
  

print('Average of high temperatures in July 2015 is ',sum_of_high_temperature/days_in_july15)
  
days_where_humidity_greater_than_90=0

for i in weather_report['Humidity Avg']:
if i>90:
days_where_humidity_greater_than_90+=1

print('The percentage of days with humidity greater than 90 is',100*(days_where_humidity_greater_than_90/total_days))

print('The mean and standard deviation of Precipitation are ',statistics.mean(weather_report['Precipitation (in.)']),statistics.stdev(weather_report['Precipitation (in.)']))

//////////////////Code ends here////////////

Code photo for indentation problem--

As you can see the variables have self explanatory names,

You will see there is a function resolve_date, what it does is it takes a string input which is (m/d/y) and returns the month,day and year value

Sample output

NOTE-- PUT the csv file in same directory as the python code file.