practice6 - 风速数据 - 统计.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 风速数据 - 统计"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](images/6.jpg)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2061-01-01</td>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2061-01-02</td>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2061-01-03</td>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2061-01-04</td>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2061-01-05</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Yr_Mo_Dy    RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "0 2061-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1 2061-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "2 2061-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "3 2061-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "4 2061-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "     CLO    BEL    MAL  \n",
       "0  12.58  18.50  15.04  \n",
       "1   9.67  17.54  13.83  \n",
       "2   7.67  12.75  12.71  \n",
       "3   5.88   5.46  10.88  \n",
       "4  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_table('data/wind.data', sep='\\s+', parse_dates=[[0, 1, 2]])\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6574 entries, 0 to 6573\n",
      "Data columns (total 13 columns):\n",
      "Yr_Mo_Dy    6574 non-null datetime64[ns]\n",
      "RPT         6568 non-null float64\n",
      "VAL         6571 non-null float64\n",
      "ROS         6572 non-null float64\n",
      "KIL         6569 non-null float64\n",
      "SHA         6572 non-null float64\n",
      "BIR         6574 non-null float64\n",
      "DUB         6571 non-null float64\n",
      "CLA         6572 non-null float64\n",
      "MUL         6571 non-null float64\n",
      "CLO         6573 non-null float64\n",
      "BEL         6574 non-null float64\n",
      "MAL         6570 non-null float64\n",
      "dtypes: datetime64[ns](1), float64(12)\n",
      "memory usage: 667.8 KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对日期数据进行分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count                    6574\n",
       "unique                   6574\n",
       "top       1968-11-10 00:00:00\n",
       "freq                        1\n",
       "first     1968-01-01 00:00:00\n",
       "last      2067-12-31 00:00:00\n",
       "Name: Yr_Mo_Dy, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.Yr_Mo_Dy.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 我们发现存在2067年？创建一个函数并用它去修复这个bug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def fix_century(x):\n",
    "    year = x.year - 100 if x.year > 1989 else x.year\n",
    "    return datetime.date(year, x.month, x.day)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02</th>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-03</th>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "Yr_Mo_Dy                                                                   \n",
       "1961-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1961-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "1961-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "\n",
       "              CLO    BEL    MAL  \n",
       "Yr_Mo_Dy                         \n",
       "1961-01-01  12.58  18.50  15.04  \n",
       "1961-01-02   9.67  17.54  13.83  \n",
       "1961-01-03   7.67  12.75  12.71  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Yr_Mo_Dy'] = data['Yr_Mo_Dy'].apply(fix_century)\n",
    "data = data.set_index('Yr_Mo_Dy')\n",
    "data.head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对应每一个location，一共有多少数据值缺失"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT    6\n",
       "VAL    3\n",
       "ROS    2\n",
       "KIL    5\n",
       "SHA    2\n",
       "BIR    0\n",
       "DUB    3\n",
       "CLA    2\n",
       "MUL    3\n",
       "CLO    1\n",
       "BEL    0\n",
       "MAL    4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对应每一个location，一共有多少完整的数据值¶"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT     6\n",
       "VAL     9\n",
       "ROS    10\n",
       "KIL     7\n",
       "SHA    10\n",
       "BIR    12\n",
       "DUB     9\n",
       "CLA    10\n",
       "MUL     9\n",
       "CLO    11\n",
       "BEL    12\n",
       "MAL     8\n",
       "dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape[1] - data.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对于全体数据，计算风速的平均值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10.227982360836924"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.mean().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 创建一个名为loc_stats的数据框去计算并存储每个location的风速最小值，最大值，平均值和标准差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>RPT</th>\n",
       "      <td>0.67</td>\n",
       "      <td>35.80</td>\n",
       "      <td>12.362987</td>\n",
       "      <td>5.618413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VAL</th>\n",
       "      <td>0.21</td>\n",
       "      <td>33.37</td>\n",
       "      <td>10.644314</td>\n",
       "      <td>5.267356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROS</th>\n",
       "      <td>1.50</td>\n",
       "      <td>33.84</td>\n",
       "      <td>11.660526</td>\n",
       "      <td>5.008450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KIL</th>\n",
       "      <td>0.00</td>\n",
       "      <td>28.46</td>\n",
       "      <td>6.306468</td>\n",
       "      <td>3.605811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHA</th>\n",
       "      <td>0.13</td>\n",
       "      <td>37.54</td>\n",
       "      <td>10.455834</td>\n",
       "      <td>4.936125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BIR</th>\n",
       "      <td>0.00</td>\n",
       "      <td>26.16</td>\n",
       "      <td>7.092254</td>\n",
       "      <td>3.968683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DUB</th>\n",
       "      <td>0.00</td>\n",
       "      <td>30.37</td>\n",
       "      <td>9.797343</td>\n",
       "      <td>4.977555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLA</th>\n",
       "      <td>0.00</td>\n",
       "      <td>31.08</td>\n",
       "      <td>8.495053</td>\n",
       "      <td>4.499449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MUL</th>\n",
       "      <td>0.00</td>\n",
       "      <td>25.88</td>\n",
       "      <td>8.493590</td>\n",
       "      <td>4.166872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLO</th>\n",
       "      <td>0.04</td>\n",
       "      <td>28.21</td>\n",
       "      <td>8.707332</td>\n",
       "      <td>4.503954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BEL</th>\n",
       "      <td>0.13</td>\n",
       "      <td>42.38</td>\n",
       "      <td>13.121007</td>\n",
       "      <td>5.835037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAL</th>\n",
       "      <td>0.67</td>\n",
       "      <td>42.54</td>\n",
       "      <td>15.599079</td>\n",
       "      <td>6.699794</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      min    max       mean       std\n",
       "RPT  0.67  35.80  12.362987  5.618413\n",
       "VAL  0.21  33.37  10.644314  5.267356\n",
       "ROS  1.50  33.84  11.660526  5.008450\n",
       "KIL  0.00  28.46   6.306468  3.605811\n",
       "SHA  0.13  37.54  10.455834  4.936125\n",
       "BIR  0.00  26.16   7.092254  3.968683\n",
       "DUB  0.00  30.37   9.797343  4.977555\n",
       "CLA  0.00  31.08   8.495053  4.499449\n",
       "MUL  0.00  25.88   8.493590  4.166872\n",
       "CLO  0.04  28.21   8.707332  4.503954\n",
       "BEL  0.13  42.38  13.121007  5.835037\n",
       "MAL  0.67  42.54  15.599079  6.699794"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loc_stats = pd.DataFrame()\n",
    "loc_stats['min'] = data.min()\n",
    "loc_stats['max'] = data.max()\n",
    "loc_stats['mean'] = data.mean()\n",
    "loc_stats['std'] = data.std()\n",
    "loc_stats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 创建一个名为day_stats的数据框去计算并存储所有location的风速最小值，最大值，平均值和标准差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>min</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>9.29</td>\n",
       "      <td>18.50</td>\n",
       "      <td>13.018182</td>\n",
       "      <td>2.808875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02</th>\n",
       "      <td>6.50</td>\n",
       "      <td>17.54</td>\n",
       "      <td>11.336364</td>\n",
       "      <td>3.188994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-03</th>\n",
       "      <td>6.17</td>\n",
       "      <td>18.50</td>\n",
       "      <td>11.641818</td>\n",
       "      <td>3.681912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-04</th>\n",
       "      <td>1.79</td>\n",
       "      <td>11.75</td>\n",
       "      <td>6.619167</td>\n",
       "      <td>3.198126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-05</th>\n",
       "      <td>6.17</td>\n",
       "      <td>13.33</td>\n",
       "      <td>10.630000</td>\n",
       "      <td>2.445356</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             min    max       mean       std\n",
       "Yr_Mo_Dy                                    \n",
       "1961-01-01  9.29  18.50  13.018182  2.808875\n",
       "1961-01-02  6.50  17.54  11.336364  3.188994\n",
       "1961-01-03  6.17  18.50  11.641818  3.681912\n",
       "1961-01-04  1.79  11.75   6.619167  3.198126\n",
       "1961-01-05  6.17  13.33  10.630000  2.445356"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "day_stats = pd.DataFrame()\n",
    "day_stats['min'] = data.min(axis=1)\n",
    "day_stats['max'] = data.max(axis=1)\n",
    "day_stats['mean'] = data.mean(axis=1)\n",
    "day_stats['std'] = data.std(axis=1)\n",
    "day_stats.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对于每一个location，计算一月份的平均风速"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RPT    14.847325\n",
       "VAL    12.914560\n",
       "ROS    13.299624\n",
       "KIL     7.199498\n",
       "SHA    11.667734\n",
       "BIR     8.054839\n",
       "DUB    11.819355\n",
       "CLA     9.512047\n",
       "MUL     9.543208\n",
       "CLO    10.053566\n",
       "BEL    14.550520\n",
       "MAL    18.028763\n",
       "dtype: float64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['date'] = data.index\n",
    "data['year'] = data['date'].apply(lambda date: date.year)\n",
    "data['month'] = data['date'].apply(lambda date: date.month)\n",
    "data['day'] = data['date'].apply(lambda date: date.day)\n",
    "january_winds = data.query('month == 1')\n",
    "january_winds.loc[:, 'RPT':'MAL'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对于数据记录按照年为频率取样"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "      <th>date</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "      <td>1961-01-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-01</th>\n",
       "      <td>9.29</td>\n",
       "      <td>3.42</td>\n",
       "      <td>11.54</td>\n",
       "      <td>3.50</td>\n",
       "      <td>2.21</td>\n",
       "      <td>1.96</td>\n",
       "      <td>10.41</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.54</td>\n",
       "      <td>5.17</td>\n",
       "      <td>4.38</td>\n",
       "      <td>7.92</td>\n",
       "      <td>1962-01-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-01-01</th>\n",
       "      <td>15.59</td>\n",
       "      <td>13.62</td>\n",
       "      <td>19.79</td>\n",
       "      <td>8.38</td>\n",
       "      <td>12.25</td>\n",
       "      <td>10.00</td>\n",
       "      <td>23.45</td>\n",
       "      <td>15.71</td>\n",
       "      <td>13.59</td>\n",
       "      <td>14.37</td>\n",
       "      <td>17.58</td>\n",
       "      <td>34.13</td>\n",
       "      <td>1963-01-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1964-01-01</th>\n",
       "      <td>25.80</td>\n",
       "      <td>22.13</td>\n",
       "      <td>18.21</td>\n",
       "      <td>13.25</td>\n",
       "      <td>21.29</td>\n",
       "      <td>14.79</td>\n",
       "      <td>14.12</td>\n",
       "      <td>19.58</td>\n",
       "      <td>13.25</td>\n",
       "      <td>16.75</td>\n",
       "      <td>28.96</td>\n",
       "      <td>21.00</td>\n",
       "      <td>1964-01-01</td>\n",
       "      <td>1964</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1965-01-01</th>\n",
       "      <td>9.54</td>\n",
       "      <td>11.92</td>\n",
       "      <td>9.00</td>\n",
       "      <td>4.38</td>\n",
       "      <td>6.08</td>\n",
       "      <td>5.21</td>\n",
       "      <td>10.25</td>\n",
       "      <td>6.08</td>\n",
       "      <td>5.71</td>\n",
       "      <td>8.63</td>\n",
       "      <td>12.04</td>\n",
       "      <td>17.41</td>\n",
       "      <td>1965-01-01</td>\n",
       "      <td>1965</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1966-01-01</th>\n",
       "      <td>22.04</td>\n",
       "      <td>21.50</td>\n",
       "      <td>17.08</td>\n",
       "      <td>12.75</td>\n",
       "      <td>22.17</td>\n",
       "      <td>15.59</td>\n",
       "      <td>21.79</td>\n",
       "      <td>18.12</td>\n",
       "      <td>16.66</td>\n",
       "      <td>17.83</td>\n",
       "      <td>28.33</td>\n",
       "      <td>23.79</td>\n",
       "      <td>1966-01-01</td>\n",
       "      <td>1966</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1967-01-01</th>\n",
       "      <td>6.46</td>\n",
       "      <td>4.46</td>\n",
       "      <td>6.50</td>\n",
       "      <td>3.21</td>\n",
       "      <td>6.67</td>\n",
       "      <td>3.79</td>\n",
       "      <td>11.38</td>\n",
       "      <td>3.83</td>\n",
       "      <td>7.71</td>\n",
       "      <td>9.08</td>\n",
       "      <td>10.67</td>\n",
       "      <td>20.91</td>\n",
       "      <td>1967-01-01</td>\n",
       "      <td>1967</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1968-01-01</th>\n",
       "      <td>30.04</td>\n",
       "      <td>17.88</td>\n",
       "      <td>16.25</td>\n",
       "      <td>16.25</td>\n",
       "      <td>21.79</td>\n",
       "      <td>12.54</td>\n",
       "      <td>18.16</td>\n",
       "      <td>16.62</td>\n",
       "      <td>18.75</td>\n",
       "      <td>17.62</td>\n",
       "      <td>22.25</td>\n",
       "      <td>27.29</td>\n",
       "      <td>1968-01-01</td>\n",
       "      <td>1968</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1969-01-01</th>\n",
       "      <td>6.13</td>\n",
       "      <td>1.63</td>\n",
       "      <td>5.41</td>\n",
       "      <td>1.08</td>\n",
       "      <td>2.54</td>\n",
       "      <td>1.00</td>\n",
       "      <td>8.50</td>\n",
       "      <td>2.42</td>\n",
       "      <td>4.58</td>\n",
       "      <td>6.34</td>\n",
       "      <td>9.17</td>\n",
       "      <td>16.71</td>\n",
       "      <td>1969-01-01</td>\n",
       "      <td>1969</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1970-01-01</th>\n",
       "      <td>9.59</td>\n",
       "      <td>2.96</td>\n",
       "      <td>11.79</td>\n",
       "      <td>3.42</td>\n",
       "      <td>6.13</td>\n",
       "      <td>4.08</td>\n",
       "      <td>9.00</td>\n",
       "      <td>4.46</td>\n",
       "      <td>7.29</td>\n",
       "      <td>3.50</td>\n",
       "      <td>7.33</td>\n",
       "      <td>13.00</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1971-01-01</th>\n",
       "      <td>3.71</td>\n",
       "      <td>0.79</td>\n",
       "      <td>4.71</td>\n",
       "      <td>0.17</td>\n",
       "      <td>1.42</td>\n",
       "      <td>1.04</td>\n",
       "      <td>4.63</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.08</td>\n",
       "      <td>4.21</td>\n",
       "      <td>9.54</td>\n",
       "      <td>1971-01-01</td>\n",
       "      <td>1971</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1972-01-01</th>\n",
       "      <td>9.29</td>\n",
       "      <td>3.63</td>\n",
       "      <td>14.54</td>\n",
       "      <td>4.25</td>\n",
       "      <td>6.75</td>\n",
       "      <td>4.42</td>\n",
       "      <td>13.00</td>\n",
       "      <td>5.33</td>\n",
       "      <td>10.04</td>\n",
       "      <td>8.54</td>\n",
       "      <td>8.71</td>\n",
       "      <td>19.17</td>\n",
       "      <td>1972-01-01</td>\n",
       "      <td>1972</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1973-01-01</th>\n",
       "      <td>16.50</td>\n",
       "      <td>15.92</td>\n",
       "      <td>14.62</td>\n",
       "      <td>7.41</td>\n",
       "      <td>8.29</td>\n",
       "      <td>11.21</td>\n",
       "      <td>13.54</td>\n",
       "      <td>7.79</td>\n",
       "      <td>10.46</td>\n",
       "      <td>10.79</td>\n",
       "      <td>13.37</td>\n",
       "      <td>9.71</td>\n",
       "      <td>1973-01-01</td>\n",
       "      <td>1973</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1974-01-01</th>\n",
       "      <td>23.21</td>\n",
       "      <td>16.54</td>\n",
       "      <td>16.08</td>\n",
       "      <td>9.75</td>\n",
       "      <td>15.83</td>\n",
       "      <td>11.46</td>\n",
       "      <td>9.54</td>\n",
       "      <td>13.54</td>\n",
       "      <td>13.83</td>\n",
       "      <td>16.66</td>\n",
       "      <td>17.21</td>\n",
       "      <td>25.29</td>\n",
       "      <td>1974-01-01</td>\n",
       "      <td>1974</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1975-01-01</th>\n",
       "      <td>14.04</td>\n",
       "      <td>13.54</td>\n",
       "      <td>11.29</td>\n",
       "      <td>5.46</td>\n",
       "      <td>12.58</td>\n",
       "      <td>5.58</td>\n",
       "      <td>8.12</td>\n",
       "      <td>8.96</td>\n",
       "      <td>9.29</td>\n",
       "      <td>5.17</td>\n",
       "      <td>7.71</td>\n",
       "      <td>11.63</td>\n",
       "      <td>1975-01-01</td>\n",
       "      <td>1975</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-01-01</th>\n",
       "      <td>18.34</td>\n",
       "      <td>17.67</td>\n",
       "      <td>14.83</td>\n",
       "      <td>8.00</td>\n",
       "      <td>16.62</td>\n",
       "      <td>10.13</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.04</td>\n",
       "      <td>13.13</td>\n",
       "      <td>5.75</td>\n",
       "      <td>11.38</td>\n",
       "      <td>14.96</td>\n",
       "      <td>1976-01-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-01-01</th>\n",
       "      <td>20.04</td>\n",
       "      <td>11.92</td>\n",
       "      <td>20.25</td>\n",
       "      <td>9.13</td>\n",
       "      <td>9.29</td>\n",
       "      <td>8.04</td>\n",
       "      <td>10.75</td>\n",
       "      <td>5.88</td>\n",
       "      <td>9.00</td>\n",
       "      <td>9.00</td>\n",
       "      <td>14.88</td>\n",
       "      <td>25.70</td>\n",
       "      <td>1977-01-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-01-01</th>\n",
       "      <td>8.33</td>\n",
       "      <td>7.12</td>\n",
       "      <td>7.71</td>\n",
       "      <td>3.54</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.50</td>\n",
       "      <td>14.71</td>\n",
       "      <td>10.00</td>\n",
       "      <td>11.83</td>\n",
       "      <td>10.00</td>\n",
       "      <td>15.09</td>\n",
       "      <td>20.46</td>\n",
       "      <td>1978-01-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT    VAL    ROS    KIL    SHA    BIR    DUB    CLA    MUL  \\\n",
       "Yr_Mo_Dy                                                                    \n",
       "1961-01-01  15.04  14.96  13.17   9.29    NaN   9.87  13.67  10.25  10.83   \n",
       "1962-01-01   9.29   3.42  11.54   3.50   2.21   1.96  10.41   2.79   3.54   \n",
       "1963-01-01  15.59  13.62  19.79   8.38  12.25  10.00  23.45  15.71  13.59   \n",
       "1964-01-01  25.80  22.13  18.21  13.25  21.29  14.79  14.12  19.58  13.25   \n",
       "1965-01-01   9.54  11.92   9.00   4.38   6.08   5.21  10.25   6.08   5.71   \n",
       "1966-01-01  22.04  21.50  17.08  12.75  22.17  15.59  21.79  18.12  16.66   \n",
       "1967-01-01   6.46   4.46   6.50   3.21   6.67   3.79  11.38   3.83   7.71   \n",
       "1968-01-01  30.04  17.88  16.25  16.25  21.79  12.54  18.16  16.62  18.75   \n",
       "1969-01-01   6.13   1.63   5.41   1.08   2.54   1.00   8.50   2.42   4.58   \n",
       "1970-01-01   9.59   2.96  11.79   3.42   6.13   4.08   9.00   4.46   7.29   \n",
       "1971-01-01   3.71   0.79   4.71   0.17   1.42   1.04   4.63   0.75   1.54   \n",
       "1972-01-01   9.29   3.63  14.54   4.25   6.75   4.42  13.00   5.33  10.04   \n",
       "1973-01-01  16.50  15.92  14.62   7.41   8.29  11.21  13.54   7.79  10.46   \n",
       "1974-01-01  23.21  16.54  16.08   9.75  15.83  11.46   9.54  13.54  13.83   \n",
       "1975-01-01  14.04  13.54  11.29   5.46  12.58   5.58   8.12   8.96   9.29   \n",
       "1976-01-01  18.34  17.67  14.83   8.00  16.62  10.13  13.17   9.04  13.13   \n",
       "1977-01-01  20.04  11.92  20.25   9.13   9.29   8.04  10.75   5.88   9.00   \n",
       "1978-01-01   8.33   7.12   7.71   3.54   8.50   7.50  14.71  10.00  11.83   \n",
       "\n",
       "              CLO    BEL    MAL        date  year  month  day  \n",
       "Yr_Mo_Dy                                                       \n",
       "1961-01-01  12.58  18.50  15.04  1961-01-01  1961      1    1  \n",
       "1962-01-01   5.17   4.38   7.92  1962-01-01  1962      1    1  \n",
       "1963-01-01  14.37  17.58  34.13  1963-01-01  1963      1    1  \n",
       "1964-01-01  16.75  28.96  21.00  1964-01-01  1964      1    1  \n",
       "1965-01-01   8.63  12.04  17.41  1965-01-01  1965      1    1  \n",
       "1966-01-01  17.83  28.33  23.79  1966-01-01  1966      1    1  \n",
       "1967-01-01   9.08  10.67  20.91  1967-01-01  1967      1    1  \n",
       "1968-01-01  17.62  22.25  27.29  1968-01-01  1968      1    1  \n",
       "1969-01-01   6.34   9.17  16.71  1969-01-01  1969      1    1  \n",
       "1970-01-01   3.50   7.33  13.00  1970-01-01  1970      1    1  \n",
       "1971-01-01   1.08   4.21   9.54  1971-01-01  1971      1    1  \n",
       "1972-01-01   8.54   8.71  19.17  1972-01-01  1972      1    1  \n",
       "1973-01-01  10.79  13.37   9.71  1973-01-01  1973      1    1  \n",
       "1974-01-01  16.66  17.21  25.29  1974-01-01  1974      1    1  \n",
       "1975-01-01   5.17   7.71  11.63  1975-01-01  1975      1    1  \n",
       "1976-01-01   5.75  11.38  14.96  1976-01-01  1976      1    1  \n",
       "1977-01-01   9.00  14.88  25.70  1977-01-01  1977      1    1  \n",
       "1978-01-01  10.00  15.09  20.46  1978-01-01  1978      1    1  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.query('month == 1 and day == 1')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 对于数据记录按照月为频率取样"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "      <th>date</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "      <td>1961-01-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-02-01</th>\n",
       "      <td>14.25</td>\n",
       "      <td>15.12</td>\n",
       "      <td>9.04</td>\n",
       "      <td>5.88</td>\n",
       "      <td>12.08</td>\n",
       "      <td>7.17</td>\n",
       "      <td>10.17</td>\n",
       "      <td>3.63</td>\n",
       "      <td>6.50</td>\n",
       "      <td>5.50</td>\n",
       "      <td>9.17</td>\n",
       "      <td>8.00</td>\n",
       "      <td>1961-02-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-03-01</th>\n",
       "      <td>12.67</td>\n",
       "      <td>13.13</td>\n",
       "      <td>11.79</td>\n",
       "      <td>6.42</td>\n",
       "      <td>9.79</td>\n",
       "      <td>8.54</td>\n",
       "      <td>10.25</td>\n",
       "      <td>13.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.21</td>\n",
       "      <td>20.62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1961-03-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-04-01</th>\n",
       "      <td>8.38</td>\n",
       "      <td>6.34</td>\n",
       "      <td>8.33</td>\n",
       "      <td>6.75</td>\n",
       "      <td>9.33</td>\n",
       "      <td>9.54</td>\n",
       "      <td>11.67</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.21</td>\n",
       "      <td>6.46</td>\n",
       "      <td>11.96</td>\n",
       "      <td>7.17</td>\n",
       "      <td>1961-04-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-05-01</th>\n",
       "      <td>15.87</td>\n",
       "      <td>13.88</td>\n",
       "      <td>15.37</td>\n",
       "      <td>9.79</td>\n",
       "      <td>13.46</td>\n",
       "      <td>10.17</td>\n",
       "      <td>9.96</td>\n",
       "      <td>14.04</td>\n",
       "      <td>9.75</td>\n",
       "      <td>9.92</td>\n",
       "      <td>18.63</td>\n",
       "      <td>11.12</td>\n",
       "      <td>1961-05-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-06-01</th>\n",
       "      <td>15.92</td>\n",
       "      <td>9.59</td>\n",
       "      <td>12.04</td>\n",
       "      <td>8.79</td>\n",
       "      <td>11.54</td>\n",
       "      <td>6.04</td>\n",
       "      <td>9.75</td>\n",
       "      <td>8.29</td>\n",
       "      <td>9.33</td>\n",
       "      <td>10.34</td>\n",
       "      <td>10.67</td>\n",
       "      <td>12.12</td>\n",
       "      <td>1961-06-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-07-01</th>\n",
       "      <td>7.21</td>\n",
       "      <td>6.83</td>\n",
       "      <td>7.71</td>\n",
       "      <td>4.42</td>\n",
       "      <td>8.46</td>\n",
       "      <td>4.79</td>\n",
       "      <td>6.71</td>\n",
       "      <td>6.00</td>\n",
       "      <td>5.79</td>\n",
       "      <td>7.96</td>\n",
       "      <td>6.96</td>\n",
       "      <td>8.71</td>\n",
       "      <td>1961-07-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-08-01</th>\n",
       "      <td>9.59</td>\n",
       "      <td>5.09</td>\n",
       "      <td>5.54</td>\n",
       "      <td>4.63</td>\n",
       "      <td>8.29</td>\n",
       "      <td>5.25</td>\n",
       "      <td>4.21</td>\n",
       "      <td>5.25</td>\n",
       "      <td>5.37</td>\n",
       "      <td>5.41</td>\n",
       "      <td>8.38</td>\n",
       "      <td>9.08</td>\n",
       "      <td>1961-08-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-09-01</th>\n",
       "      <td>5.58</td>\n",
       "      <td>1.13</td>\n",
       "      <td>4.96</td>\n",
       "      <td>3.04</td>\n",
       "      <td>4.25</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.63</td>\n",
       "      <td>2.71</td>\n",
       "      <td>3.67</td>\n",
       "      <td>6.00</td>\n",
       "      <td>4.79</td>\n",
       "      <td>5.41</td>\n",
       "      <td>1961-09-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-10-01</th>\n",
       "      <td>14.25</td>\n",
       "      <td>12.87</td>\n",
       "      <td>7.87</td>\n",
       "      <td>8.00</td>\n",
       "      <td>13.00</td>\n",
       "      <td>7.75</td>\n",
       "      <td>5.83</td>\n",
       "      <td>9.00</td>\n",
       "      <td>7.08</td>\n",
       "      <td>5.29</td>\n",
       "      <td>11.79</td>\n",
       "      <td>4.04</td>\n",
       "      <td>1961-10-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-11-01</th>\n",
       "      <td>13.21</td>\n",
       "      <td>13.13</td>\n",
       "      <td>14.33</td>\n",
       "      <td>8.54</td>\n",
       "      <td>12.17</td>\n",
       "      <td>10.21</td>\n",
       "      <td>13.08</td>\n",
       "      <td>12.17</td>\n",
       "      <td>10.92</td>\n",
       "      <td>13.54</td>\n",
       "      <td>20.17</td>\n",
       "      <td>20.04</td>\n",
       "      <td>1961-11-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-12-01</th>\n",
       "      <td>9.67</td>\n",
       "      <td>7.75</td>\n",
       "      <td>8.00</td>\n",
       "      <td>3.96</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.75</td>\n",
       "      <td>7.25</td>\n",
       "      <td>2.50</td>\n",
       "      <td>5.58</td>\n",
       "      <td>5.58</td>\n",
       "      <td>7.79</td>\n",
       "      <td>11.17</td>\n",
       "      <td>1961-12-01</td>\n",
       "      <td>1961</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-01</th>\n",
       "      <td>9.29</td>\n",
       "      <td>3.42</td>\n",
       "      <td>11.54</td>\n",
       "      <td>3.50</td>\n",
       "      <td>2.21</td>\n",
       "      <td>1.96</td>\n",
       "      <td>10.41</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.54</td>\n",
       "      <td>5.17</td>\n",
       "      <td>4.38</td>\n",
       "      <td>7.92</td>\n",
       "      <td>1962-01-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-02-01</th>\n",
       "      <td>19.12</td>\n",
       "      <td>13.96</td>\n",
       "      <td>12.21</td>\n",
       "      <td>10.58</td>\n",
       "      <td>15.71</td>\n",
       "      <td>10.63</td>\n",
       "      <td>15.71</td>\n",
       "      <td>11.08</td>\n",
       "      <td>13.17</td>\n",
       "      <td>12.62</td>\n",
       "      <td>17.67</td>\n",
       "      <td>22.71</td>\n",
       "      <td>1962-02-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-03-01</th>\n",
       "      <td>8.21</td>\n",
       "      <td>4.83</td>\n",
       "      <td>9.00</td>\n",
       "      <td>4.83</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.21</td>\n",
       "      <td>7.96</td>\n",
       "      <td>1.87</td>\n",
       "      <td>4.08</td>\n",
       "      <td>3.92</td>\n",
       "      <td>4.08</td>\n",
       "      <td>5.41</td>\n",
       "      <td>1962-03-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-04-01</th>\n",
       "      <td>14.33</td>\n",
       "      <td>12.25</td>\n",
       "      <td>11.87</td>\n",
       "      <td>10.37</td>\n",
       "      <td>14.92</td>\n",
       "      <td>11.00</td>\n",
       "      <td>19.79</td>\n",
       "      <td>11.67</td>\n",
       "      <td>14.09</td>\n",
       "      <td>15.46</td>\n",
       "      <td>16.62</td>\n",
       "      <td>23.58</td>\n",
       "      <td>1962-04-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-05-01</th>\n",
       "      <td>9.62</td>\n",
       "      <td>9.54</td>\n",
       "      <td>3.58</td>\n",
       "      <td>3.33</td>\n",
       "      <td>8.75</td>\n",
       "      <td>3.75</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2.58</td>\n",
       "      <td>1.67</td>\n",
       "      <td>2.37</td>\n",
       "      <td>7.29</td>\n",
       "      <td>3.25</td>\n",
       "      <td>1962-05-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-06-01</th>\n",
       "      <td>5.88</td>\n",
       "      <td>6.29</td>\n",
       "      <td>8.67</td>\n",
       "      <td>5.21</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>5.91</td>\n",
       "      <td>5.41</td>\n",
       "      <td>4.79</td>\n",
       "      <td>9.25</td>\n",
       "      <td>5.25</td>\n",
       "      <td>10.71</td>\n",
       "      <td>1962-06-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-07-01</th>\n",
       "      <td>8.67</td>\n",
       "      <td>4.17</td>\n",
       "      <td>6.92</td>\n",
       "      <td>6.71</td>\n",
       "      <td>8.17</td>\n",
       "      <td>5.66</td>\n",
       "      <td>11.17</td>\n",
       "      <td>9.38</td>\n",
       "      <td>8.75</td>\n",
       "      <td>11.12</td>\n",
       "      <td>10.25</td>\n",
       "      <td>17.08</td>\n",
       "      <td>1962-07-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-08-01</th>\n",
       "      <td>4.58</td>\n",
       "      <td>5.37</td>\n",
       "      <td>6.04</td>\n",
       "      <td>2.29</td>\n",
       "      <td>7.87</td>\n",
       "      <td>3.71</td>\n",
       "      <td>4.46</td>\n",
       "      <td>2.58</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.79</td>\n",
       "      <td>7.21</td>\n",
       "      <td>7.46</td>\n",
       "      <td>1962-08-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-09-01</th>\n",
       "      <td>10.00</td>\n",
       "      <td>12.08</td>\n",
       "      <td>10.96</td>\n",
       "      <td>9.25</td>\n",
       "      <td>9.29</td>\n",
       "      <td>7.62</td>\n",
       "      <td>7.41</td>\n",
       "      <td>8.75</td>\n",
       "      <td>7.67</td>\n",
       "      <td>9.62</td>\n",
       "      <td>14.58</td>\n",
       "      <td>11.92</td>\n",
       "      <td>1962-09-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-01</th>\n",
       "      <td>14.58</td>\n",
       "      <td>7.83</td>\n",
       "      <td>19.21</td>\n",
       "      <td>10.08</td>\n",
       "      <td>11.54</td>\n",
       "      <td>8.38</td>\n",
       "      <td>13.29</td>\n",
       "      <td>10.63</td>\n",
       "      <td>8.21</td>\n",
       "      <td>12.92</td>\n",
       "      <td>18.05</td>\n",
       "      <td>18.12</td>\n",
       "      <td>1962-10-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-11-01</th>\n",
       "      <td>16.88</td>\n",
       "      <td>13.25</td>\n",
       "      <td>16.00</td>\n",
       "      <td>8.96</td>\n",
       "      <td>13.46</td>\n",
       "      <td>11.46</td>\n",
       "      <td>10.46</td>\n",
       "      <td>10.17</td>\n",
       "      <td>10.37</td>\n",
       "      <td>13.21</td>\n",
       "      <td>14.83</td>\n",
       "      <td>15.16</td>\n",
       "      <td>1962-11-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-12-01</th>\n",
       "      <td>18.38</td>\n",
       "      <td>15.41</td>\n",
       "      <td>11.75</td>\n",
       "      <td>6.79</td>\n",
       "      <td>12.21</td>\n",
       "      <td>8.04</td>\n",
       "      <td>8.42</td>\n",
       "      <td>10.83</td>\n",
       "      <td>5.66</td>\n",
       "      <td>9.08</td>\n",
       "      <td>11.50</td>\n",
       "      <td>11.50</td>\n",
       "      <td>1962-12-01</td>\n",
       "      <td>1962</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-01-01</th>\n",
       "      <td>15.59</td>\n",
       "      <td>13.62</td>\n",
       "      <td>19.79</td>\n",
       "      <td>8.38</td>\n",
       "      <td>12.25</td>\n",
       "      <td>10.00</td>\n",
       "      <td>23.45</td>\n",
       "      <td>15.71</td>\n",
       "      <td>13.59</td>\n",
       "      <td>14.37</td>\n",
       "      <td>17.58</td>\n",
       "      <td>34.13</td>\n",
       "      <td>1963-01-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-02-01</th>\n",
       "      <td>15.41</td>\n",
       "      <td>7.62</td>\n",
       "      <td>24.67</td>\n",
       "      <td>11.42</td>\n",
       "      <td>9.21</td>\n",
       "      <td>8.17</td>\n",
       "      <td>14.04</td>\n",
       "      <td>7.54</td>\n",
       "      <td>7.54</td>\n",
       "      <td>10.08</td>\n",
       "      <td>10.17</td>\n",
       "      <td>17.67</td>\n",
       "      <td>1963-02-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-03-01</th>\n",
       "      <td>16.75</td>\n",
       "      <td>19.67</td>\n",
       "      <td>17.67</td>\n",
       "      <td>8.87</td>\n",
       "      <td>19.08</td>\n",
       "      <td>15.37</td>\n",
       "      <td>16.21</td>\n",
       "      <td>14.29</td>\n",
       "      <td>11.29</td>\n",
       "      <td>9.21</td>\n",
       "      <td>19.92</td>\n",
       "      <td>19.79</td>\n",
       "      <td>1963-03-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-04-01</th>\n",
       "      <td>10.54</td>\n",
       "      <td>9.59</td>\n",
       "      <td>12.46</td>\n",
       "      <td>7.33</td>\n",
       "      <td>9.46</td>\n",
       "      <td>9.59</td>\n",
       "      <td>11.79</td>\n",
       "      <td>11.87</td>\n",
       "      <td>9.79</td>\n",
       "      <td>10.71</td>\n",
       "      <td>13.37</td>\n",
       "      <td>18.21</td>\n",
       "      <td>1963-04-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-05-01</th>\n",
       "      <td>18.79</td>\n",
       "      <td>14.17</td>\n",
       "      <td>13.59</td>\n",
       "      <td>11.63</td>\n",
       "      <td>14.17</td>\n",
       "      <td>11.96</td>\n",
       "      <td>14.46</td>\n",
       "      <td>12.46</td>\n",
       "      <td>12.87</td>\n",
       "      <td>13.96</td>\n",
       "      <td>15.29</td>\n",
       "      <td>21.62</td>\n",
       "      <td>1963-05-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1963-06-01</th>\n",
       "      <td>13.37</td>\n",
       "      <td>6.87</td>\n",
       "      <td>12.00</td>\n",
       "      <td>8.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.42</td>\n",
       "      <td>10.92</td>\n",
       "      <td>12.96</td>\n",
       "      <td>11.79</td>\n",
       "      <td>11.04</td>\n",
       "      <td>10.92</td>\n",
       "      <td>13.67</td>\n",
       "      <td>1963-06-01</td>\n",
       "      <td>1963</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-07-01</th>\n",
       "      <td>8.50</td>\n",
       "      <td>1.75</td>\n",
       "      <td>6.58</td>\n",
       "      <td>2.13</td>\n",
       "      <td>2.75</td>\n",
       "      <td>2.21</td>\n",
       "      <td>5.37</td>\n",
       "      <td>2.04</td>\n",
       "      <td>5.88</td>\n",
       "      <td>4.50</td>\n",
       "      <td>4.96</td>\n",
       "      <td>10.63</td>\n",
       "      <td>1976-07-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-08-01</th>\n",
       "      <td>13.00</td>\n",
       "      <td>8.38</td>\n",
       "      <td>8.63</td>\n",
       "      <td>5.83</td>\n",
       "      <td>12.92</td>\n",
       "      <td>8.25</td>\n",
       "      <td>13.00</td>\n",
       "      <td>9.42</td>\n",
       "      <td>10.58</td>\n",
       "      <td>11.34</td>\n",
       "      <td>14.21</td>\n",
       "      <td>20.25</td>\n",
       "      <td>1976-08-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-09-01</th>\n",
       "      <td>11.87</td>\n",
       "      <td>11.00</td>\n",
       "      <td>7.38</td>\n",
       "      <td>6.87</td>\n",
       "      <td>7.75</td>\n",
       "      <td>8.33</td>\n",
       "      <td>10.34</td>\n",
       "      <td>6.46</td>\n",
       "      <td>10.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>12.75</td>\n",
       "      <td>19.55</td>\n",
       "      <td>1976-09-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-10-01</th>\n",
       "      <td>10.96</td>\n",
       "      <td>6.71</td>\n",
       "      <td>10.41</td>\n",
       "      <td>4.63</td>\n",
       "      <td>7.58</td>\n",
       "      <td>5.04</td>\n",
       "      <td>5.04</td>\n",
       "      <td>5.54</td>\n",
       "      <td>6.50</td>\n",
       "      <td>3.92</td>\n",
       "      <td>6.79</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1976-10-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-11-01</th>\n",
       "      <td>13.96</td>\n",
       "      <td>15.67</td>\n",
       "      <td>10.29</td>\n",
       "      <td>6.46</td>\n",
       "      <td>12.79</td>\n",
       "      <td>9.08</td>\n",
       "      <td>10.00</td>\n",
       "      <td>9.67</td>\n",
       "      <td>10.21</td>\n",
       "      <td>11.63</td>\n",
       "      <td>23.09</td>\n",
       "      <td>21.96</td>\n",
       "      <td>1976-11-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1976-12-01</th>\n",
       "      <td>13.46</td>\n",
       "      <td>16.42</td>\n",
       "      <td>9.21</td>\n",
       "      <td>4.54</td>\n",
       "      <td>10.75</td>\n",
       "      <td>8.67</td>\n",
       "      <td>10.88</td>\n",
       "      <td>4.83</td>\n",
       "      <td>8.79</td>\n",
       "      <td>5.91</td>\n",
       "      <td>8.83</td>\n",
       "      <td>13.67</td>\n",
       "      <td>1976-12-01</td>\n",
       "      <td>1976</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-01-01</th>\n",
       "      <td>20.04</td>\n",
       "      <td>11.92</td>\n",
       "      <td>20.25</td>\n",
       "      <td>9.13</td>\n",
       "      <td>9.29</td>\n",
       "      <td>8.04</td>\n",
       "      <td>10.75</td>\n",
       "      <td>5.88</td>\n",
       "      <td>9.00</td>\n",
       "      <td>9.00</td>\n",
       "      <td>14.88</td>\n",
       "      <td>25.70</td>\n",
       "      <td>1977-01-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-02-01</th>\n",
       "      <td>11.83</td>\n",
       "      <td>9.71</td>\n",
       "      <td>11.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>8.58</td>\n",
       "      <td>8.71</td>\n",
       "      <td>6.17</td>\n",
       "      <td>5.66</td>\n",
       "      <td>8.29</td>\n",
       "      <td>7.58</td>\n",
       "      <td>11.71</td>\n",
       "      <td>16.50</td>\n",
       "      <td>1977-02-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-03-01</th>\n",
       "      <td>8.63</td>\n",
       "      <td>14.83</td>\n",
       "      <td>10.29</td>\n",
       "      <td>3.75</td>\n",
       "      <td>6.63</td>\n",
       "      <td>8.79</td>\n",
       "      <td>5.00</td>\n",
       "      <td>8.12</td>\n",
       "      <td>7.87</td>\n",
       "      <td>6.42</td>\n",
       "      <td>13.54</td>\n",
       "      <td>13.67</td>\n",
       "      <td>1977-03-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-04-01</th>\n",
       "      <td>21.67</td>\n",
       "      <td>16.00</td>\n",
       "      <td>17.33</td>\n",
       "      <td>13.59</td>\n",
       "      <td>20.83</td>\n",
       "      <td>15.96</td>\n",
       "      <td>25.62</td>\n",
       "      <td>17.62</td>\n",
       "      <td>19.41</td>\n",
       "      <td>20.67</td>\n",
       "      <td>24.37</td>\n",
       "      <td>30.09</td>\n",
       "      <td>1977-04-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-05-01</th>\n",
       "      <td>6.42</td>\n",
       "      <td>7.12</td>\n",
       "      <td>8.67</td>\n",
       "      <td>3.58</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.00</td>\n",
       "      <td>6.75</td>\n",
       "      <td>6.13</td>\n",
       "      <td>3.33</td>\n",
       "      <td>4.50</td>\n",
       "      <td>19.21</td>\n",
       "      <td>12.38</td>\n",
       "      <td>1977-05-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-06-01</th>\n",
       "      <td>7.08</td>\n",
       "      <td>5.25</td>\n",
       "      <td>9.71</td>\n",
       "      <td>2.83</td>\n",
       "      <td>2.21</td>\n",
       "      <td>3.50</td>\n",
       "      <td>5.29</td>\n",
       "      <td>1.42</td>\n",
       "      <td>2.00</td>\n",
       "      <td>0.92</td>\n",
       "      <td>5.21</td>\n",
       "      <td>5.63</td>\n",
       "      <td>1977-06-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-07-01</th>\n",
       "      <td>15.41</td>\n",
       "      <td>16.29</td>\n",
       "      <td>17.08</td>\n",
       "      <td>6.25</td>\n",
       "      <td>11.83</td>\n",
       "      <td>11.83</td>\n",
       "      <td>12.29</td>\n",
       "      <td>10.58</td>\n",
       "      <td>10.41</td>\n",
       "      <td>7.21</td>\n",
       "      <td>17.37</td>\n",
       "      <td>7.83</td>\n",
       "      <td>1977-07-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-08-01</th>\n",
       "      <td>4.33</td>\n",
       "      <td>2.96</td>\n",
       "      <td>4.42</td>\n",
       "      <td>2.33</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1.08</td>\n",
       "      <td>4.96</td>\n",
       "      <td>1.87</td>\n",
       "      <td>2.33</td>\n",
       "      <td>2.04</td>\n",
       "      <td>10.50</td>\n",
       "      <td>9.83</td>\n",
       "      <td>1977-08-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-09-01</th>\n",
       "      <td>17.37</td>\n",
       "      <td>16.33</td>\n",
       "      <td>16.83</td>\n",
       "      <td>8.58</td>\n",
       "      <td>14.46</td>\n",
       "      <td>11.83</td>\n",
       "      <td>15.09</td>\n",
       "      <td>13.92</td>\n",
       "      <td>13.29</td>\n",
       "      <td>13.88</td>\n",
       "      <td>23.29</td>\n",
       "      <td>25.17</td>\n",
       "      <td>1977-09-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-10-01</th>\n",
       "      <td>16.75</td>\n",
       "      <td>15.34</td>\n",
       "      <td>12.25</td>\n",
       "      <td>9.42</td>\n",
       "      <td>16.38</td>\n",
       "      <td>11.38</td>\n",
       "      <td>18.50</td>\n",
       "      <td>13.92</td>\n",
       "      <td>14.09</td>\n",
       "      <td>14.46</td>\n",
       "      <td>22.34</td>\n",
       "      <td>29.67</td>\n",
       "      <td>1977-10-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-11-01</th>\n",
       "      <td>16.71</td>\n",
       "      <td>11.54</td>\n",
       "      <td>12.17</td>\n",
       "      <td>4.17</td>\n",
       "      <td>8.54</td>\n",
       "      <td>7.17</td>\n",
       "      <td>11.12</td>\n",
       "      <td>6.46</td>\n",
       "      <td>8.25</td>\n",
       "      <td>6.21</td>\n",
       "      <td>11.04</td>\n",
       "      <td>15.63</td>\n",
       "      <td>1977-11-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977-12-01</th>\n",
       "      <td>13.37</td>\n",
       "      <td>10.92</td>\n",
       "      <td>12.42</td>\n",
       "      <td>2.37</td>\n",
       "      <td>5.79</td>\n",
       "      <td>6.13</td>\n",
       "      <td>8.96</td>\n",
       "      <td>7.38</td>\n",
       "      <td>6.29</td>\n",
       "      <td>5.71</td>\n",
       "      <td>8.54</td>\n",
       "      <td>12.42</td>\n",
       "      <td>1977-12-01</td>\n",
       "      <td>1977</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-01-01</th>\n",
       "      <td>8.33</td>\n",
       "      <td>7.12</td>\n",
       "      <td>7.71</td>\n",
       "      <td>3.54</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.50</td>\n",
       "      <td>14.71</td>\n",
       "      <td>10.00</td>\n",
       "      <td>11.83</td>\n",
       "      <td>10.00</td>\n",
       "      <td>15.09</td>\n",
       "      <td>20.46</td>\n",
       "      <td>1978-01-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-02-01</th>\n",
       "      <td>27.25</td>\n",
       "      <td>24.21</td>\n",
       "      <td>18.16</td>\n",
       "      <td>17.46</td>\n",
       "      <td>27.54</td>\n",
       "      <td>18.05</td>\n",
       "      <td>20.96</td>\n",
       "      <td>25.04</td>\n",
       "      <td>20.04</td>\n",
       "      <td>17.50</td>\n",
       "      <td>27.71</td>\n",
       "      <td>21.12</td>\n",
       "      <td>1978-02-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-03-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>6.21</td>\n",
       "      <td>16.04</td>\n",
       "      <td>7.87</td>\n",
       "      <td>6.42</td>\n",
       "      <td>6.67</td>\n",
       "      <td>12.29</td>\n",
       "      <td>8.00</td>\n",
       "      <td>10.58</td>\n",
       "      <td>9.33</td>\n",
       "      <td>5.41</td>\n",
       "      <td>17.00</td>\n",
       "      <td>1978-03-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-04-01</th>\n",
       "      <td>3.42</td>\n",
       "      <td>7.58</td>\n",
       "      <td>2.71</td>\n",
       "      <td>1.38</td>\n",
       "      <td>3.46</td>\n",
       "      <td>2.08</td>\n",
       "      <td>2.67</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.83</td>\n",
       "      <td>1.67</td>\n",
       "      <td>7.33</td>\n",
       "      <td>13.67</td>\n",
       "      <td>1978-04-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-05-01</th>\n",
       "      <td>10.54</td>\n",
       "      <td>12.21</td>\n",
       "      <td>9.08</td>\n",
       "      <td>5.29</td>\n",
       "      <td>11.00</td>\n",
       "      <td>10.08</td>\n",
       "      <td>11.17</td>\n",
       "      <td>13.75</td>\n",
       "      <td>11.87</td>\n",
       "      <td>11.79</td>\n",
       "      <td>12.87</td>\n",
       "      <td>27.16</td>\n",
       "      <td>1978-05-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-06-01</th>\n",
       "      <td>10.37</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.46</td>\n",
       "      <td>6.04</td>\n",
       "      <td>11.25</td>\n",
       "      <td>7.50</td>\n",
       "      <td>6.46</td>\n",
       "      <td>5.96</td>\n",
       "      <td>7.79</td>\n",
       "      <td>5.46</td>\n",
       "      <td>5.50</td>\n",
       "      <td>10.41</td>\n",
       "      <td>1978-06-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-07-01</th>\n",
       "      <td>12.46</td>\n",
       "      <td>10.63</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.75</td>\n",
       "      <td>12.92</td>\n",
       "      <td>9.04</td>\n",
       "      <td>12.42</td>\n",
       "      <td>9.62</td>\n",
       "      <td>12.08</td>\n",
       "      <td>8.04</td>\n",
       "      <td>14.04</td>\n",
       "      <td>16.17</td>\n",
       "      <td>1978-07-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-08-01</th>\n",
       "      <td>19.33</td>\n",
       "      <td>15.09</td>\n",
       "      <td>20.17</td>\n",
       "      <td>8.83</td>\n",
       "      <td>12.62</td>\n",
       "      <td>10.41</td>\n",
       "      <td>9.33</td>\n",
       "      <td>12.33</td>\n",
       "      <td>9.50</td>\n",
       "      <td>9.92</td>\n",
       "      <td>15.75</td>\n",
       "      <td>18.00</td>\n",
       "      <td>1978-08-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-09-01</th>\n",
       "      <td>8.42</td>\n",
       "      <td>6.13</td>\n",
       "      <td>9.87</td>\n",
       "      <td>5.25</td>\n",
       "      <td>3.21</td>\n",
       "      <td>5.71</td>\n",
       "      <td>7.25</td>\n",
       "      <td>3.50</td>\n",
       "      <td>7.33</td>\n",
       "      <td>6.50</td>\n",
       "      <td>7.62</td>\n",
       "      <td>15.96</td>\n",
       "      <td>1978-09-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-10-01</th>\n",
       "      <td>9.50</td>\n",
       "      <td>6.83</td>\n",
       "      <td>10.50</td>\n",
       "      <td>3.88</td>\n",
       "      <td>6.13</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.21</td>\n",
       "      <td>6.50</td>\n",
       "      <td>6.38</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.63</td>\n",
       "      <td>14.09</td>\n",
       "      <td>1978-10-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-11-01</th>\n",
       "      <td>13.59</td>\n",
       "      <td>16.75</td>\n",
       "      <td>11.25</td>\n",
       "      <td>7.08</td>\n",
       "      <td>11.04</td>\n",
       "      <td>8.33</td>\n",
       "      <td>8.17</td>\n",
       "      <td>11.29</td>\n",
       "      <td>10.75</td>\n",
       "      <td>11.25</td>\n",
       "      <td>23.13</td>\n",
       "      <td>25.00</td>\n",
       "      <td>1978-11-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1978-12-01</th>\n",
       "      <td>21.29</td>\n",
       "      <td>16.29</td>\n",
       "      <td>24.04</td>\n",
       "      <td>12.79</td>\n",
       "      <td>18.21</td>\n",
       "      <td>19.29</td>\n",
       "      <td>21.54</td>\n",
       "      <td>17.21</td>\n",
       "      <td>16.71</td>\n",
       "      <td>17.83</td>\n",
       "      <td>17.75</td>\n",
       "      <td>25.70</td>\n",
       "      <td>1978-12-01</td>\n",
       "      <td>1978</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>216 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT    VAL    ROS    KIL    SHA    BIR    DUB    CLA    MUL  \\\n",
       "Yr_Mo_Dy                                                                    \n",
       "1961-01-01  15.04  14.96  13.17   9.29    NaN   9.87  13.67  10.25  10.83   \n",
       "1961-02-01  14.25  15.12   9.04   5.88  12.08   7.17  10.17   3.63   6.50   \n",
       "1961-03-01  12.67  13.13  11.79   6.42   9.79   8.54  10.25  13.29    NaN   \n",
       "1961-04-01   8.38   6.34   8.33   6.75   9.33   9.54  11.67   8.21  11.21   \n",
       "1961-05-01  15.87  13.88  15.37   9.79  13.46  10.17   9.96  14.04   9.75   \n",
       "1961-06-01  15.92   9.59  12.04   8.79  11.54   6.04   9.75   8.29   9.33   \n",
       "1961-07-01   7.21   6.83   7.71   4.42   8.46   4.79   6.71   6.00   5.79   \n",
       "1961-08-01   9.59   5.09   5.54   4.63   8.29   5.25   4.21   5.25   5.37   \n",
       "1961-09-01   5.58   1.13   4.96   3.04   4.25   2.25   4.63   2.71   3.67   \n",
       "1961-10-01  14.25  12.87   7.87   8.00  13.00   7.75   5.83   9.00   7.08   \n",
       "1961-11-01  13.21  13.13  14.33   8.54  12.17  10.21  13.08  12.17  10.92   \n",
       "1961-12-01   9.67   7.75   8.00   3.96   6.00   2.75   7.25   2.50   5.58   \n",
       "1962-01-01   9.29   3.42  11.54   3.50   2.21   1.96  10.41   2.79   3.54   \n",
       "1962-02-01  19.12  13.96  12.21  10.58  15.71  10.63  15.71  11.08  13.17   \n",
       "1962-03-01   8.21   4.83   9.00   4.83   6.00   2.21   7.96   1.87   4.08   \n",
       "1962-04-01  14.33  12.25  11.87  10.37  14.92  11.00  19.79  11.67  14.09   \n",
       "1962-05-01   9.62   9.54   3.58   3.33   8.75   3.75   2.25   2.58   1.67   \n",
       "1962-06-01   5.88   6.29   8.67   5.21   5.00   4.25   5.91   5.41   4.79   \n",
       "1962-07-01   8.67   4.17   6.92   6.71   8.17   5.66  11.17   9.38   8.75   \n",
       "1962-08-01   4.58   5.37   6.04   2.29   7.87   3.71   4.46   2.58   4.00   \n",
       "1962-09-01  10.00  12.08  10.96   9.25   9.29   7.62   7.41   8.75   7.67   \n",
       "1962-10-01  14.58   7.83  19.21  10.08  11.54   8.38  13.29  10.63   8.21   \n",
       "1962-11-01  16.88  13.25  16.00   8.96  13.46  11.46  10.46  10.17  10.37   \n",
       "1962-12-01  18.38  15.41  11.75   6.79  12.21   8.04   8.42  10.83   5.66   \n",
       "1963-01-01  15.59  13.62  19.79   8.38  12.25  10.00  23.45  15.71  13.59   \n",
       "1963-02-01  15.41   7.62  24.67  11.42   9.21   8.17  14.04   7.54   7.54   \n",
       "1963-03-01  16.75  19.67  17.67   8.87  19.08  15.37  16.21  14.29  11.29   \n",
       "1963-04-01  10.54   9.59  12.46   7.33   9.46   9.59  11.79  11.87   9.79   \n",
       "1963-05-01  18.79  14.17  13.59  11.63  14.17  11.96  14.46  12.46  12.87   \n",
       "1963-06-01  13.37   6.87  12.00   8.50  10.04   9.42  10.92  12.96  11.79   \n",
       "...           ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "1976-07-01   8.50   1.75   6.58   2.13   2.75   2.21   5.37   2.04   5.88   \n",
       "1976-08-01  13.00   8.38   8.63   5.83  12.92   8.25  13.00   9.42  10.58   \n",
       "1976-09-01  11.87  11.00   7.38   6.87   7.75   8.33  10.34   6.46  10.17   \n",
       "1976-10-01  10.96   6.71  10.41   4.63   7.58   5.04   5.04   5.54   6.50   \n",
       "1976-11-01  13.96  15.67  10.29   6.46  12.79   9.08  10.00   9.67  10.21   \n",
       "1976-12-01  13.46  16.42   9.21   4.54  10.75   8.67  10.88   4.83   8.79   \n",
       "1977-01-01  20.04  11.92  20.25   9.13   9.29   8.04  10.75   5.88   9.00   \n",
       "1977-02-01  11.83   9.71  11.00   4.25   8.58   8.71   6.17   5.66   8.29   \n",
       "1977-03-01   8.63  14.83  10.29   3.75   6.63   8.79   5.00   8.12   7.87   \n",
       "1977-04-01  21.67  16.00  17.33  13.59  20.83  15.96  25.62  17.62  19.41   \n",
       "1977-05-01   6.42   7.12   8.67   3.58   4.58   4.00   6.75   6.13   3.33   \n",
       "1977-06-01   7.08   5.25   9.71   2.83   2.21   3.50   5.29   1.42   2.00   \n",
       "1977-07-01  15.41  16.29  17.08   6.25  11.83  11.83  12.29  10.58  10.41   \n",
       "1977-08-01   4.33   2.96   4.42   2.33   0.96   1.08   4.96   1.87   2.33   \n",
       "1977-09-01  17.37  16.33  16.83   8.58  14.46  11.83  15.09  13.92  13.29   \n",
       "1977-10-01  16.75  15.34  12.25   9.42  16.38  11.38  18.50  13.92  14.09   \n",
       "1977-11-01  16.71  11.54  12.17   4.17   8.54   7.17  11.12   6.46   8.25   \n",
       "1977-12-01  13.37  10.92  12.42   2.37   5.79   6.13   8.96   7.38   6.29   \n",
       "1978-01-01   8.33   7.12   7.71   3.54   8.50   7.50  14.71  10.00  11.83   \n",
       "1978-02-01  27.25  24.21  18.16  17.46  27.54  18.05  20.96  25.04  20.04   \n",
       "1978-03-01  15.04   6.21  16.04   7.87   6.42   6.67  12.29   8.00  10.58   \n",
       "1978-04-01   3.42   7.58   2.71   1.38   3.46   2.08   2.67   4.75   4.83   \n",
       "1978-05-01  10.54  12.21   9.08   5.29  11.00  10.08  11.17  13.75  11.87   \n",
       "1978-06-01  10.37  11.42   6.46   6.04  11.25   7.50   6.46   5.96   7.79   \n",
       "1978-07-01  12.46  10.63  11.17   6.75  12.92   9.04  12.42   9.62  12.08   \n",
       "1978-08-01  19.33  15.09  20.17   8.83  12.62  10.41   9.33  12.33   9.50   \n",
       "1978-09-01   8.42   6.13   9.87   5.25   3.21   5.71   7.25   3.50   7.33   \n",
       "1978-10-01   9.50   6.83  10.50   3.88   6.13   4.58   4.21   6.50   6.38   \n",
       "1978-11-01  13.59  16.75  11.25   7.08  11.04   8.33   8.17  11.29  10.75   \n",
       "1978-12-01  21.29  16.29  24.04  12.79  18.21  19.29  21.54  17.21  16.71   \n",
       "\n",
       "              CLO    BEL    MAL        date  year  month  day  \n",
       "Yr_Mo_Dy                                                       \n",
       "1961-01-01  12.58  18.50  15.04  1961-01-01  1961      1    1  \n",
       "1961-02-01   5.50   9.17   8.00  1961-02-01  1961      2    1  \n",
       "1961-03-01  12.21  20.62    NaN  1961-03-01  1961      3    1  \n",
       "1961-04-01   6.46  11.96   7.17  1961-04-01  1961      4    1  \n",
       "1961-05-01   9.92  18.63  11.12  1961-05-01  1961      5    1  \n",
       "1961-06-01  10.34  10.67  12.12  1961-06-01  1961      6    1  \n",
       "1961-07-01   7.96   6.96   8.71  1961-07-01  1961      7    1  \n",
       "1961-08-01   5.41   8.38   9.08  1961-08-01  1961      8    1  \n",
       "1961-09-01   6.00   4.79   5.41  1961-09-01  1961      9    1  \n",
       "1961-10-01   5.29  11.79   4.04  1961-10-01  1961     10    1  \n",
       "1961-11-01  13.54  20.17  20.04  1961-11-01  1961     11    1  \n",
       "1961-12-01   5.58   7.79  11.17  1961-12-01  1961     12    1  \n",
       "1962-01-01   5.17   4.38   7.92  1962-01-01  1962      1    1  \n",
       "1962-02-01  12.62  17.67  22.71  1962-02-01  1962      2    1  \n",
       "1962-03-01   3.92   4.08   5.41  1962-03-01  1962      3    1  \n",
       "1962-04-01  15.46  16.62  23.58  1962-04-01  1962      4    1  \n",
       "1962-05-01   2.37   7.29   3.25  1962-05-01  1962      5    1  \n",
       "1962-06-01   9.25   5.25  10.71  1962-06-01  1962      6    1  \n",
       "1962-07-01  11.12  10.25  17.08  1962-07-01  1962      7    1  \n",
       "1962-08-01   4.79   7.21   7.46  1962-08-01  1962      8    1  \n",
       "1962-09-01   9.62  14.58  11.92  1962-09-01  1962      9    1  \n",
       "1962-10-01  12.92  18.05  18.12  1962-10-01  1962     10    1  \n",
       "1962-11-01  13.21  14.83  15.16  1962-11-01  1962     11    1  \n",
       "1962-12-01   9.08  11.50  11.50  1962-12-01  1962     12    1  \n",
       "1963-01-01  14.37  17.58  34.13  1963-01-01  1963      1    1  \n",
       "1963-02-01  10.08  10.17  17.67  1963-02-01  1963      2    1  \n",
       "1963-03-01   9.21  19.92  19.79  1963-03-01  1963      3    1  \n",
       "1963-04-01  10.71  13.37  18.21  1963-04-01  1963      4    1  \n",
       "1963-05-01  13.96  15.29  21.62  1963-05-01  1963      5    1  \n",
       "1963-06-01  11.04  10.92  13.67  1963-06-01  1963      6    1  \n",
       "...           ...    ...    ...         ...   ...    ...  ...  \n",
       "1976-07-01   4.50   4.96  10.63  1976-07-01  1976      7    1  \n",
       "1976-08-01  11.34  14.21  20.25  1976-08-01  1976      8    1  \n",
       "1976-09-01   9.29  12.75  19.55  1976-09-01  1976      9    1  \n",
       "1976-10-01   3.92   6.79   5.00  1976-10-01  1976     10    1  \n",
       "1976-11-01  11.63  23.09  21.96  1976-11-01  1976     11    1  \n",
       "1976-12-01   5.91   8.83  13.67  1976-12-01  1976     12    1  \n",
       "1977-01-01   9.00  14.88  25.70  1977-01-01  1977      1    1  \n",
       "1977-02-01   7.58  11.71  16.50  1977-02-01  1977      2    1  \n",
       "1977-03-01   6.42  13.54  13.67  1977-03-01  1977      3    1  \n",
       "1977-04-01  20.67  24.37  30.09  1977-04-01  1977      4    1  \n",
       "1977-05-01   4.50  19.21  12.38  1977-05-01  1977      5    1  \n",
       "1977-06-01   0.92   5.21   5.63  1977-06-01  1977      6    1  \n",
       "1977-07-01   7.21  17.37   7.83  1977-07-01  1977      7    1  \n",
       "1977-08-01   2.04  10.50   9.83  1977-08-01  1977      8    1  \n",
       "1977-09-01  13.88  23.29  25.17  1977-09-01  1977      9    1  \n",
       "1977-10-01  14.46  22.34  29.67  1977-10-01  1977     10    1  \n",
       "1977-11-01   6.21  11.04  15.63  1977-11-01  1977     11    1  \n",
       "1977-12-01   5.71   8.54  12.42  1977-12-01  1977     12    1  \n",
       "1978-01-01  10.00  15.09  20.46  1978-01-01  1978      1    1  \n",
       "1978-02-01  17.50  27.71  21.12  1978-02-01  1978      2    1  \n",
       "1978-03-01   9.33   5.41  17.00  1978-03-01  1978      3    1  \n",
       "1978-04-01   1.67   7.33  13.67  1978-04-01  1978      4    1  \n",
       "1978-05-01  11.79  12.87  27.16  1978-05-01  1978      5    1  \n",
       "1978-06-01   5.46   5.50  10.41  1978-06-01  1978      6    1  \n",
       "1978-07-01   8.04  14.04  16.17  1978-07-01  1978      7    1  \n",
       "1978-08-01   9.92  15.75  18.00  1978-08-01  1978      8    1  \n",
       "1978-09-01   6.50   7.62  15.96  1978-09-01  1978      9    1  \n",
       "1978-10-01   6.54  10.63  14.09  1978-10-01  1978     10    1  \n",
       "1978-11-01  11.25  23.13  25.00  1978-11-01  1978     11    1  \n",
       "1978-12-01  17.83  17.75  25.70  1978-12-01  1978     12    1  \n",
       "\n",
       "[216 rows x 16 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.query('day == 1')"
   ]
  }
 ],
 "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.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}