{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "#DO IT YOURSELF #3\n", "#Can you compute the hourly max and min temperature in degrees of Celsius? \n", "dat = pd.read_csv('module8_WBB.csv',sep=',',skiprows=6,index_col=1,parse_dates=True)\n", "dat['air_temp_set_1'] = (dat['air_temp_set_1'] - 32) * (5/9)\n", "dat1_hr = dat.resample('60Min').min()\n", "dat1_hr = dat.resample('60Min').max()" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " Station_ID air_temp_set_1 relative_humidity_set_1 \\\n", "Date_Time \n", "2011-11-30 12:00:00-07:00 WBB 5.777778 65.40 \n", "2011-11-30 13:00:00-07:00 WBB 4.211111 86.00 \n", "2011-11-30 14:00:00-07:00 WBB 3.711111 82.50 \n", "2011-11-30 15:00:00-07:00 WBB 4.411111 80.00 \n", "2011-11-30 16:00:00-07:00 WBB 2.788889 83.60 \n", "2011-11-30 17:00:00-07:00 WBB 2.377778 82.90 \n", "2011-11-30 18:00:00-07:00 WBB 2.311111 84.90 \n", "2011-11-30 19:00:00-07:00 WBB 2.711111 81.20 \n", "2011-11-30 20:00:00-07:00 WBB 2.827778 78.42 \n", "2011-11-30 21:00:00-07:00 WBB 2.327778 77.62 \n", "2011-11-30 22:00:00-07:00 WBB 2.727778 65.35 \n", "2011-11-30 23:00:00-07:00 WBB 2.850000 63.51 \n", "2011-12-01 00:00:00-07:00 WBB 2.272222 66.12 \n", "2011-12-01 01:00:00-07:00 WBB 1.661111 66.33 \n", "2011-12-01 02:00:00-07:00 WBB 3.500000 63.70 \n", "2011-12-01 03:00:00-07:00 WBB 3.688889 41.63 \n", "2011-12-01 04:00:00-07:00 WBB 3.461111 37.14 \n", "2011-12-01 05:00:00-07:00 WBB 3.122222 36.89 \n", "2011-12-01 06:00:00-07:00 WBB 2.772222 36.08 \n", "2011-12-01 07:00:00-07:00 WBB 2.377778 35.11 \n", "2011-12-01 08:00:00-07:00 WBB 2.511111 31.81 \n", "2011-12-01 09:00:00-07:00 WBB 3.227778 30.85 \n", "2011-12-01 10:00:00-07:00 WBB 3.450000 29.76 \n", "2011-12-01 11:00:00-07:00 WBB 3.611111 31.35 \n", "2011-12-01 12:00:00-07:00 WBB 2.561111 33.92 \n", "2011-12-01 13:00:00-07:00 WBB 2.777778 35.73 \n", "2011-12-01 14:00:00-07:00 WBB 3.272222 35.37 \n", "2011-12-01 15:00:00-07:00 WBB 2.850000 35.15 \n", "2011-12-01 16:00:00-07:00 WBB 2.872222 34.84 \n", "2011-12-01 17:00:00-07:00 WBB 1.811111 40.97 \n", "2011-12-01 18:00:00-07:00 WBB 0.222222 43.81 \n", "2011-12-01 19:00:00-07:00 WBB 0.922222 46.27 \n", "2011-12-01 20:00:00-07:00 WBB 1.011111 40.07 \n", "2011-12-01 21:00:00-07:00 WBB 0.661111 38.99 \n", "2011-12-01 22:00:00-07:00 WBB 0.438889 42.55 \n", "2011-12-01 23:00:00-07:00 WBB 0.272222 41.80 \n", "2011-12-02 00:00:00-07:00 WBB -0.111111 42.27 \n", "2011-12-02 01:00:00-07:00 WBB 0.161111 42.47 \n", "2011-12-02 02:00:00-07:00 WBB 0.011111 45.82 \n", "2011-12-02 03:00:00-07:00 WBB -0.038889 46.74 \n", "2011-12-02 04:00:00-07:00 WBB -0.538889 53.85 \n", "2011-12-02 05:00:00-07:00 WBB -1.488889 52.25 \n", "2011-12-02 06:00:00-07:00 WBB -2.038889 61.07 \n", "2011-12-02 07:00:00-07:00 WBB -2.900000 62.75 \n", "2011-12-02 08:00:00-07:00 WBB 0.288889 57.55 \n", "2011-12-02 09:00:00-07:00 WBB 1.188889 51.48 \n", "2011-12-02 10:00:00-07:00 WBB 2.327778 47.13 \n", "2011-12-02 11:00:00-07:00 WBB 3.272222 45.98 \n", "2011-12-02 12:00:00-07:00 WBB 3.338889 38.91 \n", "\n", " wind_speed_set_1 wind_direction_set_1 \\\n", "Date_Time \n", "2011-11-30 12:00:00-07:00 13.62 319.00 \n", "2011-11-30 13:00:00-07:00 11.50 329.30 \n", "2011-11-30 14:00:00-07:00 9.93 359.80 \n", "2011-11-30 15:00:00-07:00 8.63 302.20 \n", "2011-11-30 16:00:00-07:00 6.26 315.90 \n", "2011-11-30 17:00:00-07:00 11.61 333.30 \n", "2011-11-30 18:00:00-07:00 11.61 358.10 \n", "2011-11-30 19:00:00-07:00 3.89 349.00 \n", "2011-11-30 20:00:00-07:00 4.07 294.40 \n", "2011-11-30 21:00:00-07:00 8.95 278.00 \n", "2011-11-30 22:00:00-07:00 7.87 322.30 \n", "2011-11-30 23:00:00-07:00 3.91 298.70 \n", "2011-12-01 00:00:00-07:00 5.01 275.80 \n", "2011-12-01 01:00:00-07:00 4.63 352.20 \n", "2011-12-01 02:00:00-07:00 14.36 354.90 \n", "2011-12-01 03:00:00-07:00 50.76 352.50 \n", "2011-12-01 04:00:00-07:00 36.95 82.40 \n", "2011-12-01 05:00:00-07:00 31.56 79.99 \n", "2011-12-01 06:00:00-07:00 41.81 72.21 \n", "2011-12-01 07:00:00-07:00 46.37 70.32 \n", "2011-12-01 08:00:00-07:00 46.15 68.26 \n", "2011-12-01 09:00:00-07:00 49.32 64.79 \n", "2011-12-01 10:00:00-07:00 37.89 90.90 \n", "2011-12-01 11:00:00-07:00 30.65 107.00 \n", "2011-12-01 12:00:00-07:00 24.34 106.00 \n", "2011-12-01 13:00:00-07:00 18.23 317.20 \n", "2011-12-01 14:00:00-07:00 24.11 288.10 \n", "2011-12-01 15:00:00-07:00 15.12 172.10 \n", "2011-12-01 16:00:00-07:00 18.28 209.10 \n", "2011-12-01 17:00:00-07:00 22.57 98.80 \n", "2011-12-01 18:00:00-07:00 37.27 89.30 \n", "2011-12-01 19:00:00-07:00 28.12 95.80 \n", "2011-12-01 20:00:00-07:00 30.13 69.28 \n", "2011-12-01 21:00:00-07:00 31.72 73.12 \n", "2011-12-01 22:00:00-07:00 22.06 75.25 \n", "2011-12-01 23:00:00-07:00 22.57 61.33 \n", "2011-12-02 00:00:00-07:00 13.02 329.30 \n", "2011-12-02 01:00:00-07:00 11.88 320.10 \n", "2011-12-02 02:00:00-07:00 4.14 334.60 \n", "2011-12-02 03:00:00-07:00 6.15 153.30 \n", "2011-12-02 04:00:00-07:00 4.18 326.50 \n", "2011-12-02 05:00:00-07:00 3.62 352.90 \n", "2011-12-02 06:00:00-07:00 3.83 298.20 \n", "2011-12-02 07:00:00-07:00 3.91 343.50 \n", "2011-12-02 08:00:00-07:00 5.14 327.00 \n", "2011-12-02 09:00:00-07:00 3.09 334.50 \n", "2011-12-02 10:00:00-07:00 3.69 325.40 \n", "2011-12-02 11:00:00-07:00 4.29 328.80 \n", "2011-12-02 12:00:00-07:00 1.90 235.70 \n", "\n", " wind_gust_set_1 \n", "Date_Time \n", "2011-11-30 12:00:00-07:00 20.69 \n", "2011-11-30 13:00:00-07:00 15.82 \n", "2011-11-30 14:00:00-07:00 12.80 \n", "2011-11-30 15:00:00-07:00 13.06 \n", "2011-11-30 16:00:00-07:00 8.77 \n", "2011-11-30 17:00:00-07:00 14.83 \n", "2011-11-30 18:00:00-07:00 16.31 \n", "2011-11-30 19:00:00-07:00 5.17 \n", "2011-11-30 20:00:00-07:00 4.92 \n", "2011-11-30 21:00:00-07:00 12.80 \n", "2011-11-30 22:00:00-07:00 11.59 \n", "2011-11-30 23:00:00-07:00 6.98 \n", "2011-12-01 00:00:00-07:00 7.63 \n", "2011-12-01 01:00:00-07:00 9.04 \n", "2011-12-01 02:00:00-07:00 29.42 \n", "2011-12-01 03:00:00-07:00 69.43 \n", "2011-12-01 04:00:00-07:00 54.87 \n", "2011-12-01 05:00:00-07:00 53.66 \n", "2011-12-01 06:00:00-07:00 60.76 \n", "2011-12-01 07:00:00-07:00 66.84 \n", "2011-12-01 08:00:00-07:00 64.04 \n", "2011-12-01 09:00:00-07:00 65.74 \n", "2011-12-01 10:00:00-07:00 61.25 \n", "2011-12-01 11:00:00-07:00 39.37 \n", "2011-12-01 12:00:00-07:00 34.85 \n", "2011-12-01 13:00:00-07:00 26.26 \n", "2011-12-01 14:00:00-07:00 35.95 \n", "2011-12-01 15:00:00-07:00 33.71 \n", "2011-12-01 16:00:00-07:00 30.56 \n", "2011-12-01 17:00:00-07:00 34.54 \n", "2011-12-01 18:00:00-07:00 47.47 \n", "2011-12-01 19:00:00-07:00 41.34 \n", "2011-12-01 20:00:00-07:00 48.09 \n", "2011-12-01 21:00:00-07:00 48.23 \n", "2011-12-01 22:00:00-07:00 39.24 \n", "2011-12-01 23:00:00-07:00 31.92 \n", "2011-12-02 00:00:00-07:00 19.51 \n", "2011-12-02 01:00:00-07:00 17.13 \n", "2011-12-02 02:00:00-07:00 6.71 \n", "2011-12-02 03:00:00-07:00 8.23 \n", "2011-12-02 04:00:00-07:00 6.06 \n", "2011-12-02 05:00:00-07:00 5.08 \n", "2011-12-02 06:00:00-07:00 6.31 \n", "2011-12-02 07:00:00-07:00 4.76 \n", "2011-12-02 08:00:00-07:00 6.02 \n", "2011-12-02 09:00:00-07:00 4.61 \n", "2011-12-02 10:00:00-07:00 5.95 \n", "2011-12-02 11:00:00-07:00 6.76 \n", "2011-12-02 12:00:00-07:00 3.47 \n" ] } ], "source": [ "print(dat1_hr)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.3" } }, "nbformat": 4, "nbformat_minor": 4 }