Download the nycflights$13\_$weather.csv$.$gz data file from our unit site $($Learning Resources $->$ Data$).$

It gives the hourly meteorological data for three airports in New York: LGA, JFK$,$ and EWR for the whole

year of $2013.$ The columns are:

$$ origin $$ weather station: LGA, JFK$,$ or EWR,

$$ year, month, day, hour $$ time of recording,

$$ temp, dewp $$ temperature and dew point in degrees Fahrenheit,

$$ humid $$ relative humidity,

$$ wind$\_$dir, wind$\_$speed, wind$\_$gust $$ wind direction $($in degrees$),$ speed and gust speed $($in mph$),$

$$ precip $$ precipitation, in inches,

$$ pressure $$ sea level pressure in millibars,

$$ visib $$ visibility in miles,

$$ time$\_$hour $$ date and hour $($based on the year, month, day, hour fields$)$ formatted as YYYY$-$mmdd HH:MM:SS $($actually$,$ YYYY$-$mm$-$dd HH:$00$:$00).$ However, due to a bug in the dataset, the data in this

column are $($incorrectly$!)$ shifted by $1$ hour. Do not rely on it unless you manually correct it$.$

Then, create a single Jupyter$/$IPython notebook $($see the Artefacts section below for all the requirements$),$

where you perform what follows.

$1.$ Convert all columns so that they use metric $($International System of Units, SI$)$ or derived units:

temp and dewp to Celsius, precip to millimetres, visib to metres, as well as wind$\_$speed and

wind$\_$gust to metres per second. Replace the data in$-$place $($overwrite existing columns with new

ones$).$

$2.$ Compute daily mean wind speeds for the LGA airport $($~$365$ total speed values, for each day separately; you can, for example, group the data by year, month, and day at the same time$).$

$3.$ Present the daily mean wind speeds at LGA $($~$365$ aforementioned data points$)$ in a single plot, e$.$g$.,$

using the matplotlib.pyplot.plot function. The x$-$axis labels should be human$-$readable and

intuitive $($e$.$g$.,$ month names or dates$).$ Reference result: