Generate climate data graph

climate_data.py

%matplotlib qt

import pandas as pd

df = pd.read_csv("/home/selah/Data/PHL climate data.csv")
#df.plot(use_index=True,y='TMAX',grid=True)

import matplotlib.pyplot as plt
import datetime as dt

f = lambda d: dt.datetime.strptime(str(d), '%Y%m%d').date()
dates = df.DATE.apply(f)

import matplotlib.dates as mdates
ax=plt.gca()
ax.xaxis.set_major_formatter(mdates.DateFormatter('%m/%d/%Y'))
ax.xaxis.set_major_locator(mdates.DayLocator())

#plt.plot(dates, df.TMAX)
plt.plot(dates, pd.rolling_mean(df.TMAX, 90, center=True), label='90 day rolling average')
plt.plot(dates, pd.rolling_mean(df.TMAX, 365, center=True), label='365 day rolling average')
plt.grid(True)
plt.legend()
plt.title("Temperature at PHL International Airport")