06-Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pandas \n",
    "\n",
    "pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool,\n",
    "built on top of the Python programming language."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"Glasgow_Weather.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>2019-11-26</td>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>2019-11-28</td>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             day  tempMin  tempMax                                  summary  \\\n",
       "0     2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "1     2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2     2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "3     2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "4     2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...          ...      ...      ...                                      ...   \n",
       "1790  2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "1791  2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "1792  2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "1793  2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "1794  2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                   desc  cloudCover  humidity  windSpeed  visibility  \n",
       "0                  rain        0.80      0.89      14.69        4.43  \n",
       "1                  rain        0.62      0.79      15.04        5.64  \n",
       "2                  rain        0.31      0.84       4.48        6.20  \n",
       "3     partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "4     partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                 ...         ...       ...        ...         ...  \n",
       "1790               rain        0.96      0.85       6.80       10.00  \n",
       "1791               rain        0.87      0.85       6.82        9.03  \n",
       "1792  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "1793          clear-day        0.18      0.76       4.85        9.11  \n",
       "1794  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can find the dimension of your data base by using the attribute shape. Be aware it is an attribute because we do not use the rounded brackets at the end."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1795, 9)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The function info will give you greater detail on each column, stating number of non-null data points and the type of data.\n",
    "\n",
    "If you see object, it normally means it is a string but if you aren't sure take a look at the data yourself."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1795 entries, 0 to 1794\n",
      "Data columns (total 9 columns):\n",
      " #   Column      Non-Null Count  Dtype  \n",
      "---  ------      --------------  -----  \n",
      " 0   day         1795 non-null   object \n",
      " 1   tempMin     1795 non-null   float64\n",
      " 2   tempMax     1795 non-null   float64\n",
      " 3   summary     1788 non-null   object \n",
      " 4   desc        1611 non-null   object \n",
      " 5   cloudCover  1792 non-null   float64\n",
      " 6   humidity    1795 non-null   float64\n",
      " 7   windSpeed   1795 non-null   float64\n",
      " 8   visibility  1795 non-null   float64\n",
      "dtypes: float64(6), object(3)\n",
      "memory usage: 126.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To view the data you can use the function head or tail. If you leave the brackets empty it shows only 5 rows but you can tell it how many to show. \n",
    "\n",
    "Be aware after 60 rows it will squash the rows together just like when you output the dataframe itself."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          day  tempMin  tempMax                                  summary  \\\n",
       "0  2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "1  2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2  2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "3  2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "4  2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "\n",
       "                desc  cloudCover  humidity  windSpeed  visibility  \n",
       "0               rain        0.80      0.89      14.69        4.43  \n",
       "1               rain        0.62      0.79      15.04        5.64  \n",
       "2               rain        0.31      0.84       4.48        6.20  \n",
       "3  partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "4  partly-cloudy-day        0.85      0.91       6.20        5.91  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>2019-11-26</td>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>2019-11-28</td>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             day  tempMin  tempMax                            summary  \\\n",
       "1790  2019-11-26     8.55    10.57  Mostly cloudy throughout the day.   \n",
       "1791  2019-11-27     5.79     9.40  Mostly cloudy throughout the day.   \n",
       "1792  2019-11-28     2.30     6.67  Mostly cloudy throughout the day.   \n",
       "1793  2019-11-29     1.08     6.14  Mostly cloudy throughout the day.   \n",
       "1794  2019-11-30     0.42     5.69  Mostly cloudy throughout the day.   \n",
       "\n",
       "                   desc  cloudCover  humidity  windSpeed  visibility  \n",
       "1790               rain        0.96      0.85       6.80       10.00  \n",
       "1791               rain        0.87      0.85       6.82        9.03  \n",
       "1792  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "1793          clear-day        0.18      0.76       4.85        9.11  \n",
       "1794  partly-cloudy-day        0.55      0.72       4.79       10.00  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "More indepth look at data can be done by using describe and correlation."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1795.000000</td>\n",
       "      <td>1795.000000</td>\n",
       "      <td>1792.000000</td>\n",
       "      <td>1795.000000</td>\n",
       "      <td>1795.000000</td>\n",
       "      <td>1795.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>6.037253</td>\n",
       "      <td>12.998630</td>\n",
       "      <td>0.596964</td>\n",
       "      <td>0.818462</td>\n",
       "      <td>7.013616</td>\n",
       "      <td>5.773359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>4.720846</td>\n",
       "      <td>5.270358</td>\n",
       "      <td>0.224010</td>\n",
       "      <td>0.076162</td>\n",
       "      <td>3.924601</td>\n",
       "      <td>0.797354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-8.670000</td>\n",
       "      <td>-1.390000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.140000</td>\n",
       "      <td>0.190000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.590000</td>\n",
       "      <td>9.225000</td>\n",
       "      <td>0.450000</td>\n",
       "      <td>0.770000</td>\n",
       "      <td>4.115000</td>\n",
       "      <td>5.560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>6.220000</td>\n",
       "      <td>13.050000</td>\n",
       "      <td>0.630000</td>\n",
       "      <td>0.830000</td>\n",
       "      <td>6.220000</td>\n",
       "      <td>6.030000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>9.800000</td>\n",
       "      <td>16.830000</td>\n",
       "      <td>0.770000</td>\n",
       "      <td>0.870000</td>\n",
       "      <td>9.135000</td>\n",
       "      <td>6.220000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>18.030000</td>\n",
       "      <td>30.360000</td>\n",
       "      <td>0.990000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>24.840000</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           tempMin      tempMax   cloudCover     humidity    windSpeed  \\\n",
       "count  1795.000000  1795.000000  1792.000000  1795.000000  1795.000000   \n",
       "mean      6.037253    12.998630     0.596964     0.818462     7.013616   \n",
       "std       4.720846     5.270358     0.224010     0.076162     3.924601   \n",
       "min      -8.670000    -1.390000     0.000000     0.500000     0.140000   \n",
       "25%       2.590000     9.225000     0.450000     0.770000     4.115000   \n",
       "50%       6.220000    13.050000     0.630000     0.830000     6.220000   \n",
       "75%       9.800000    16.830000     0.770000     0.870000     9.135000   \n",
       "max      18.030000    30.360000     0.990000     1.000000    24.840000   \n",
       "\n",
       "        visibility  \n",
       "count  1795.000000  \n",
       "mean      5.773359  \n",
       "std       0.797354  \n",
       "min       0.190000  \n",
       "25%       5.560000  \n",
       "50%       6.030000  \n",
       "75%       6.220000  \n",
       "max      10.000000  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tempMin</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.804079</td>\n",
       "      <td>0.271800</td>\n",
       "      <td>-0.054032</td>\n",
       "      <td>0.187183</td>\n",
       "      <td>0.167162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tempMax</th>\n",
       "      <td>0.804079</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.114470</td>\n",
       "      <td>-0.362103</td>\n",
       "      <td>0.018456</td>\n",
       "      <td>0.174937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cloudCover</th>\n",
       "      <td>0.271800</td>\n",
       "      <td>-0.114470</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.584773</td>\n",
       "      <td>0.300535</td>\n",
       "      <td>-0.263438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>humidity</th>\n",
       "      <td>-0.054032</td>\n",
       "      <td>-0.362103</td>\n",
       "      <td>0.584773</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.016887</td>\n",
       "      <td>-0.429461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>windSpeed</th>\n",
       "      <td>0.187183</td>\n",
       "      <td>0.018456</td>\n",
       "      <td>0.300535</td>\n",
       "      <td>-0.016887</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.144079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>visibility</th>\n",
       "      <td>0.167162</td>\n",
       "      <td>0.174937</td>\n",
       "      <td>-0.263438</td>\n",
       "      <td>-0.429461</td>\n",
       "      <td>0.144079</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             tempMin   tempMax  cloudCover  humidity  windSpeed  visibility\n",
       "tempMin     1.000000  0.804079    0.271800 -0.054032   0.187183    0.167162\n",
       "tempMax     0.804079  1.000000   -0.114470 -0.362103   0.018456    0.174937\n",
       "cloudCover  0.271800 -0.114470    1.000000  0.584773   0.300535   -0.263438\n",
       "humidity   -0.054032 -0.362103    0.584773  1.000000  -0.016887   -0.429461\n",
       "windSpeed   0.187183  0.018456    0.300535 -0.016887   1.000000    0.144079\n",
       "visibility  0.167162  0.174937   -0.263438 -0.429461   0.144079    1.000000"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.corr()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can filter on each column on the dataframe and a single column will be called a series.\n",
    "\n",
    "Use the dataframe name and square brackets is how to filter your data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       7.53\n",
       "1       3.58\n",
       "2      -0.61\n",
       "3      -0.63\n",
       "4       6.51\n",
       "        ... \n",
       "1790    8.55\n",
       "1791    5.79\n",
       "1792    2.30\n",
       "1793    1.08\n",
       "1794    0.42\n",
       "Name: tempMin, Length: 1795, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['tempMin']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Again the above will look familiar to you, as its almost like a dictionary.\n",
    "\n",
    "If you want to view multiple columns at once, then replace the string with a list of the column names."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      tempMin  tempMax\n",
       "0        7.53    12.23\n",
       "1        3.58     7.15\n",
       "2       -0.61     6.54\n",
       "3       -0.63     7.59\n",
       "4        6.51    10.43\n",
       "...       ...      ...\n",
       "1790     8.55    10.57\n",
       "1791     5.79     9.40\n",
       "1792     2.30     6.67\n",
       "1793     1.08     6.14\n",
       "1794     0.42     5.69\n",
       "\n",
       "[1795 rows x 2 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[ ['tempMin', 'tempMax'] ]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The order in which you type the list is the order in which the filtered dataframe will output."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>tempMax</th>\n",
       "      <th>tempMin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12.23</td>\n",
       "      <td>7.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7.15</td>\n",
       "      <td>3.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6.54</td>\n",
       "      <td>-0.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7.59</td>\n",
       "      <td>-0.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10.43</td>\n",
       "      <td>6.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>10.57</td>\n",
       "      <td>8.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>9.40</td>\n",
       "      <td>5.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>6.67</td>\n",
       "      <td>2.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>6.14</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>5.69</td>\n",
       "      <td>0.42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      tempMax  tempMin\n",
       "0       12.23     7.53\n",
       "1        7.15     3.58\n",
       "2        6.54    -0.61\n",
       "3        7.59    -0.63\n",
       "4       10.43     6.51\n",
       "...       ...      ...\n",
       "1790    10.57     8.55\n",
       "1791     9.40     5.79\n",
       "1792     6.67     2.30\n",
       "1793     6.14     1.08\n",
       "1794     5.69     0.42\n",
       "\n",
       "[1795 rows x 2 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['tempMax', 'tempMin']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To find out all the columns use the attribute columns. This is useful if you are working on a very large dataframe where the column names are squashed together when output."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['day', 'tempMin', 'tempMax', 'summary', 'desc', 'cloudCover',\n",
       "       'humidity', 'windSpeed', 'visibility'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If you are wanting to find the data for a particular row then you will use the iloc function. \n",
    "\n",
    "Image the iloc function like the list indexing. If you want the first row you pass 0 into the function."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "day                                   2015-01-01\n",
       "tempMin                                     7.53\n",
       "tempMax                                    12.23\n",
       "summary       Possible light rain until evening.\n",
       "desc                                        rain\n",
       "cloudCover                                   0.8\n",
       "humidity                                    0.89\n",
       "windSpeed                                  14.69\n",
       "visibility                                  4.43\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If you want a single row, it provides a data series.\n",
    "\n",
    "Just like if you want to slice a list use colon between the numbers in the iloc function. It will return a dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          day  tempMin  tempMax                                  summary  \\\n",
       "0  2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "1  2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2  2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "3  2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "4  2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "\n",
       "                desc  cloudCover  humidity  windSpeed  visibility  \n",
       "0               rain        0.80      0.89      14.69        4.43  \n",
       "1               rain        0.62      0.79      15.04        5.64  \n",
       "2               rain        0.31      0.84       4.48        6.20  \n",
       "3  partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "4  partly-cloudy-day        0.85      0.91       6.20        5.91  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[0:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can also pass a list of indexs in any order."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-01-06</td>\n",
       "      <td>3.66</td>\n",
       "      <td>9.95</td>\n",
       "      <td>Possible light rain in the morning and afternoon.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.88</td>\n",
       "      <td>8.70</td>\n",
       "      <td>5.93</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          day  tempMin  tempMax  \\\n",
       "0  2015-01-01     7.53    12.23   \n",
       "2  2015-01-03    -0.61     6.54   \n",
       "4  2015-01-05     6.51    10.43   \n",
       "3  2015-01-04    -0.63     7.59   \n",
       "5  2015-01-06     3.66     9.95   \n",
       "\n",
       "                                             summary               desc  \\\n",
       "0                 Possible light rain until evening.               rain   \n",
       "2                          Clear throughout the day.               rain   \n",
       "4                       Overcast throughout the day.  partly-cloudy-day   \n",
       "3                  Mostly cloudy throughout the day.  partly-cloudy-day   \n",
       "5  Possible light rain in the morning and afternoon.               rain   \n",
       "\n",
       "   cloudCover  humidity  windSpeed  visibility  \n",
       "0        0.80      0.89      14.69        4.43  \n",
       "2        0.31      0.84       4.48        6.20  \n",
       "4        0.85      0.91       6.20        5.91  \n",
       "3        0.78      0.85       4.35        6.22  \n",
       "5        0.63      0.88       8.70        5.93  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[0,2,4,3,5]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If you only want certain rows with certain columns then seperate the row definition with a comma and use the syntax as the rows.\n",
    "\n",
    "You are passing 2 lists so remember that iloc will look like a nested list (extra square brackets). Additonally if you use colon notation, you will need to remove the brackets for the list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          day  tempMin  tempMax\n",
       "0  2015-01-01     7.53    12.23\n",
       "1  2015-01-02     3.58     7.15"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[0,1],[0,1,2]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          day  tempMin  tempMax\n",
       "0  2015-01-01     7.53    12.23\n",
       "1  2015-01-02     3.58     7.15"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[0:2,0:3]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If your dataframe has an index you can still use iloc but you will find it difficult to find the index you are looking for. \n",
    "\n",
    "Pandas has the function loc[] which you pass in the unique index which will not be a integer to end of data rows.\n",
    "\n",
    "In our current dataframe the index is numbers so we can still use loc with numbers."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>summary</th>\n",
       "      <th>cloudCover</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   summary  cloudCover\n",
       "0       Possible light rain until evening.        0.80\n",
       "1  Possible light rain throughout the day.        0.62"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[[0,1],[\"summary\", \"cloudCover\"]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It makes most sense that the dataframe index would be the date, as an index should be unique, so we shall set the dataframes index to be \"day\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</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>2015-01-01</th>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-02</th>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-03</th>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-04</th>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-26</th>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-27</th>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-28</th>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-29</th>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            tempMin  tempMax                                  summary  \\\n",
       "day                                                                     \n",
       "2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...             ...      ...                                      ...   \n",
       "2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                         desc  cloudCover  humidity  windSpeed  visibility  \n",
       "day                                                                         \n",
       "2015-01-01               rain        0.80      0.89      14.69        4.43  \n",
       "2015-01-02               rain        0.62      0.79      15.04        5.64  \n",
       "2015-01-03               rain        0.31      0.84       4.48        6.20  \n",
       "2015-01-04  partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "2015-01-05  partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                       ...         ...       ...        ...         ...  \n",
       "2019-11-26               rain        0.96      0.85       6.80       10.00  \n",
       "2019-11-27               rain        0.87      0.85       6.82        9.03  \n",
       "2019-11-28  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "2019-11-29          clear-day        0.18      0.76       4.85        9.11  \n",
       "2019-11-30  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 8 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index(\"day\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>2019-11-26</td>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>2019-11-28</td>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             day  tempMin  tempMax                                  summary  \\\n",
       "0     2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "1     2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2     2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "3     2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "4     2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...          ...      ...      ...                                      ...   \n",
       "1790  2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "1791  2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "1792  2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "1793  2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "1794  2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                   desc  cloudCover  humidity  windSpeed  visibility  \n",
       "0                  rain        0.80      0.89      14.69        4.43  \n",
       "1                  rain        0.62      0.79      15.04        5.64  \n",
       "2                  rain        0.31      0.84       4.48        6.20  \n",
       "3     partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "4     partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                 ...         ...       ...        ...         ...  \n",
       "1790               rain        0.96      0.85       6.80       10.00  \n",
       "1791               rain        0.87      0.85       6.82        9.03  \n",
       "1792  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "1793          clear-day        0.18      0.76       4.85        9.11  \n",
       "1794  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 9 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As you can see above the index still remain as the numbers from 0 to 1794. Pandas allows you to see what the result of your code is before it saves it. \n",
    "\n",
    "To save it you can either pass a paramenter of True to inplace or use assignment expression."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index(\"day\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</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>2015-01-01</th>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-02</th>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-03</th>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-04</th>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-26</th>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-27</th>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-28</th>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-29</th>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            tempMin  tempMax                                  summary  \\\n",
       "day                                                                     \n",
       "2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...             ...      ...                                      ...   \n",
       "2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                         desc  cloudCover  humidity  windSpeed  visibility  \n",
       "day                                                                         \n",
       "2015-01-01               rain        0.80      0.89      14.69        4.43  \n",
       "2015-01-02               rain        0.62      0.79      15.04        5.64  \n",
       "2015-01-03               rain        0.31      0.84       4.48        6.20  \n",
       "2015-01-04  partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "2015-01-05  partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                       ...         ...       ...        ...         ...  \n",
       "2019-11-26               rain        0.96      0.85       6.80       10.00  \n",
       "2019-11-27               rain        0.87      0.85       6.82        9.03  \n",
       "2019-11-28  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "2019-11-29          clear-day        0.18      0.76       4.85        9.11  \n",
       "2019-11-30  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 8 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To reset the index simply use the reset_index and pass true to inplace to save the result. Again you can also use assignment to save the result."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>day</th>\n",
       "      <th>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-01-03</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-01-04</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1790</th>\n",
       "      <td>2019-11-26</td>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791</th>\n",
       "      <td>2019-11-27</td>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1792</th>\n",
       "      <td>2019-11-28</td>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>2019-11-29</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1794</th>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             day  tempMin  tempMax                                  summary  \\\n",
       "0     2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "1     2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2     2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "3     2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "4     2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...          ...      ...      ...                                      ...   \n",
       "1790  2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "1791  2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "1792  2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "1793  2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "1794  2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                   desc  cloudCover  humidity  windSpeed  visibility  \n",
       "0                  rain        0.80      0.89      14.69        4.43  \n",
       "1                  rain        0.62      0.79      15.04        5.64  \n",
       "2                  rain        0.31      0.84       4.48        6.20  \n",
       "3     partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "4     partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                 ...         ...       ...        ...         ...  \n",
       "1790               rain        0.96      0.85       6.80       10.00  \n",
       "1791               rain        0.87      0.85       6.82        9.03  \n",
       "1792  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "1793          clear-day        0.18      0.76       4.85        9.11  \n",
       "1794  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 9 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index(inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>tempMin</th>\n",
       "      <th>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</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>2015-01-01</th>\n",
       "      <td>7.53</td>\n",
       "      <td>12.23</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.89</td>\n",
       "      <td>14.69</td>\n",
       "      <td>4.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-02</th>\n",
       "      <td>3.58</td>\n",
       "      <td>7.15</td>\n",
       "      <td>Possible light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.79</td>\n",
       "      <td>15.04</td>\n",
       "      <td>5.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-03</th>\n",
       "      <td>-0.61</td>\n",
       "      <td>6.54</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.48</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-04</th>\n",
       "      <td>-0.63</td>\n",
       "      <td>7.59</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.85</td>\n",
       "      <td>4.35</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>6.51</td>\n",
       "      <td>10.43</td>\n",
       "      <td>Overcast throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.91</td>\n",
       "      <td>6.20</td>\n",
       "      <td>5.91</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-26</th>\n",
       "      <td>8.55</td>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-27</th>\n",
       "      <td>5.79</td>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-28</th>\n",
       "      <td>2.30</td>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-29</th>\n",
       "      <td>1.08</td>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>0.42</td>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1795 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            tempMin  tempMax                                  summary  \\\n",
       "day                                                                     \n",
       "2015-01-01     7.53    12.23       Possible light rain until evening.   \n",
       "2015-01-02     3.58     7.15  Possible light rain throughout the day.   \n",
       "2015-01-03    -0.61     6.54                Clear throughout the day.   \n",
       "2015-01-04    -0.63     7.59        Mostly cloudy throughout the day.   \n",
       "2015-01-05     6.51    10.43             Overcast throughout the day.   \n",
       "...             ...      ...                                      ...   \n",
       "2019-11-26     8.55    10.57        Mostly cloudy throughout the day.   \n",
       "2019-11-27     5.79     9.40        Mostly cloudy throughout the day.   \n",
       "2019-11-28     2.30     6.67        Mostly cloudy throughout the day.   \n",
       "2019-11-29     1.08     6.14        Mostly cloudy throughout the day.   \n",
       "2019-11-30     0.42     5.69        Mostly cloudy throughout the day.   \n",
       "\n",
       "                         desc  cloudCover  humidity  windSpeed  visibility  \n",
       "day                                                                         \n",
       "2015-01-01               rain        0.80      0.89      14.69        4.43  \n",
       "2015-01-02               rain        0.62      0.79      15.04        5.64  \n",
       "2015-01-03               rain        0.31      0.84       4.48        6.20  \n",
       "2015-01-04  partly-cloudy-day        0.78      0.85       4.35        6.22  \n",
       "2015-01-05  partly-cloudy-day        0.85      0.91       6.20        5.91  \n",
       "...                       ...         ...       ...        ...         ...  \n",
       "2019-11-26               rain        0.96      0.85       6.80       10.00  \n",
       "2019-11-27               rain        0.87      0.85       6.82        9.03  \n",
       "2019-11-28  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "2019-11-29          clear-day        0.18      0.76       4.85        9.11  \n",
       "2019-11-30  partly-cloudy-day        0.55      0.72       4.79       10.00  \n",
       "\n",
       "[1795 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.set_index(\"day\")\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now you can see using loc with the unique index of day, returns the result for that row."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "tempMin                                    0.42\n",
       "tempMax                                    5.69\n",
       "summary       Mostly cloudy throughout the day.\n",
       "desc                          partly-cloudy-day\n",
       "cloudCover                                 0.55\n",
       "humidity                                   0.72\n",
       "windSpeed                                  4.79\n",
       "visibility                                   10\n",
       "Name: 2019-11-30, dtype: object"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[\"2019-11-30\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The functionality of loc isthe same as iloc, so you can slice both rows and columns. Using list and colons."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      summary               desc  cloudCover\n",
       "day                                                                         \n",
       "2019-11-30  Mostly cloudy throughout the day.  partly-cloudy-day        0.55"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[[\"2019-11-30\"],\"summary\":\"cloudCover\"]"
   ]
  },
  {
   "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>tempMax</th>\n",
       "      <th>summary</th>\n",
       "      <th>desc</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>humidity</th>\n",
       "      <th>windSpeed</th>\n",
       "      <th>visibility</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>day</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>2019-11-01</th>\n",
       "      <td>10.50</td>\n",
       "      <td>Light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.96</td>\n",
       "      <td>7.48</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-02</th>\n",
       "      <td>12.15</td>\n",
       "      <td>Light rain in the morning.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.95</td>\n",
       "      <td>3.76</td>\n",
       "      <td>6.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-03</th>\n",
       "      <td>11.80</td>\n",
       "      <td>Possible drizzle in the afternoon.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.88</td>\n",
       "      <td>7.97</td>\n",
       "      <td>6.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-04</th>\n",
       "      <td>10.62</td>\n",
       "      <td>Possible light rain until evening.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.87</td>\n",
       "      <td>13.51</td>\n",
       "      <td>5.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-05</th>\n",
       "      <td>10.33</td>\n",
       "      <td>Foggy overnight.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.77</td>\n",
       "      <td>6.50</td>\n",
       "      <td>6.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-06</th>\n",
       "      <td>7.85</td>\n",
       "      <td>Possible drizzle starting in the afternoon.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.88</td>\n",
       "      <td>5.05</td>\n",
       "      <td>5.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-07</th>\n",
       "      <td>8.18</td>\n",
       "      <td>Possible drizzle in the morning.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.84</td>\n",
       "      <td>12.76</td>\n",
       "      <td>5.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-08</th>\n",
       "      <td>7.81</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.77</td>\n",
       "      <td>3.14</td>\n",
       "      <td>6.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-09</th>\n",
       "      <td>5.29</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.83</td>\n",
       "      <td>7.07</td>\n",
       "      <td>6.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-10</th>\n",
       "      <td>5.72</td>\n",
       "      <td>Light rain in the evening and overnight.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.82</td>\n",
       "      <td>4.85</td>\n",
       "      <td>6.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-11</th>\n",
       "      <td>7.38</td>\n",
       "      <td>Light rain throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.87</td>\n",
       "      <td>11.88</td>\n",
       "      <td>5.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-12</th>\n",
       "      <td>10.76</td>\n",
       "      <td>Possible drizzle in the morning.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.42</td>\n",
       "      <td>5.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-13</th>\n",
       "      <td>5.94</td>\n",
       "      <td>Foggy in the morning and overnight.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.92</td>\n",
       "      <td>4.95</td>\n",
       "      <td>5.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-14</th>\n",
       "      <td>6.49</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.55</td>\n",
       "      <td>5.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-15</th>\n",
       "      <td>8.69</td>\n",
       "      <td>Partly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.64</td>\n",
       "      <td>6.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-16</th>\n",
       "      <td>4.63</td>\n",
       "      <td>Clear throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1.70</td>\n",
       "      <td>6.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-17</th>\n",
       "      <td>6.45</td>\n",
       "      <td>Foggy overnight.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.92</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-18</th>\n",
       "      <td>4.73</td>\n",
       "      <td>Foggy in the morning and overnight.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.86</td>\n",
       "      <td>3.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-19</th>\n",
       "      <td>3.67</td>\n",
       "      <td>Possible light rain in the evening and overnight.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.89</td>\n",
       "      <td>5.03</td>\n",
       "      <td>4.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-20</th>\n",
       "      <td>7.40</td>\n",
       "      <td>Possible drizzle in the morning.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.86</td>\n",
       "      <td>9.32</td>\n",
       "      <td>6.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-21</th>\n",
       "      <td>7.78</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.74</td>\n",
       "      <td>12.60</td>\n",
       "      <td>7.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-22</th>\n",
       "      <td>8.91</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.88</td>\n",
       "      <td>8.28</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-23</th>\n",
       "      <td>9.38</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.90</td>\n",
       "      <td>9.25</td>\n",
       "      <td>9.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-24</th>\n",
       "      <td>10.02</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.88</td>\n",
       "      <td>5.47</td>\n",
       "      <td>9.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-25</th>\n",
       "      <td>10.45</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.87</td>\n",
       "      <td>7.83</td>\n",
       "      <td>9.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-26</th>\n",
       "      <td>10.57</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.80</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-27</th>\n",
       "      <td>9.40</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>rain</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.85</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-28</th>\n",
       "      <td>6.67</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.79</td>\n",
       "      <td>5.15</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-29</th>\n",
       "      <td>6.14</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>clear-day</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.76</td>\n",
       "      <td>4.85</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-11-30</th>\n",
       "      <td>5.69</td>\n",
       "      <td>Mostly cloudy throughout the day.</td>\n",
       "      <td>partly-cloudy-day</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.72</td>\n",
       "      <td>4.79</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            tempMax                                            summary  \\\n",
       "day                                                                      \n",
       "2019-11-01    10.50                     Light rain throughout the day.   \n",
       "2019-11-02    12.15                         Light rain in the morning.   \n",
       "2019-11-03    11.80                 Possible drizzle in the afternoon.   \n",
       "2019-11-04    10.62                 Possible light rain until evening.   \n",
       "2019-11-05    10.33                                   Foggy overnight.   \n",
       "2019-11-06     7.85        Possible drizzle starting in the afternoon.   \n",
       "2019-11-07     8.18                   Possible drizzle in the morning.   \n",
       "2019-11-08     7.81                          Clear throughout the day.   \n",
       "2019-11-09     5.29                          Clear throughout the day.   \n",
       "2019-11-10     5.72           Light rain in the evening and overnight.   \n",
       "2019-11-11     7.38                     Light rain throughout the day.   \n",
       "2019-11-12    10.76                   Possible drizzle in the morning.   \n",
       "2019-11-13     5.94                Foggy in the morning and overnight.   \n",
       "2019-11-14     6.49                          Clear throughout the day.   \n",
       "2019-11-15     8.69                  Partly cloudy throughout the day.   \n",
       "2019-11-16     4.63                          Clear throughout the day.   \n",
       "2019-11-17     6.45                                   Foggy overnight.   \n",
       "2019-11-18     4.73                Foggy in the morning and overnight.   \n",
       "2019-11-19     3.67  Possible light rain in the evening and overnight.   \n",
       "2019-11-20     7.40                   Possible drizzle in the morning.   \n",
       "2019-11-21     7.78                  Mostly cloudy throughout the day.   \n",
       "2019-11-22     8.91                  Mostly cloudy throughout the day.   \n",
       "2019-11-23     9.38                  Mostly cloudy throughout the day.   \n",
       "2019-11-24    10.02                  Mostly cloudy throughout the day.   \n",
       "2019-11-25    10.45                  Mostly cloudy throughout the day.   \n",
       "2019-11-26    10.57                  Mostly cloudy throughout the day.   \n",
       "2019-11-27     9.40                  Mostly cloudy throughout the day.   \n",
       "2019-11-28     6.67                  Mostly cloudy throughout the day.   \n",
       "2019-11-29     6.14                  Mostly cloudy throughout the day.   \n",
       "2019-11-30     5.69                  Mostly cloudy throughout the day.   \n",
       "\n",
       "                         desc  cloudCover  humidity  windSpeed  visibility  \n",
       "day                                                                         \n",
       "2019-11-01               rain        0.97      0.96       7.48        2.00  \n",
       "2019-11-02               rain        0.76      0.95       3.76        6.21  \n",
       "2019-11-03               rain        0.73      0.88       7.97        6.07  \n",
       "2019-11-04               rain        0.70      0.87      13.51        5.42  \n",
       "2019-11-05  partly-cloudy-day        0.74      0.77       6.50        6.48  \n",
       "2019-11-06               rain        0.61      0.88       5.05        5.74  \n",
       "2019-11-07               rain        0.68      0.84      12.76        5.81  \n",
       "2019-11-08          clear-day        0.21      0.77       3.14        6.22  \n",
       "2019-11-09  partly-cloudy-day        0.34      0.83       7.07        6.16  \n",
       "2019-11-10               rain        0.32      0.82       4.85        6.10  \n",
       "2019-11-11               rain        0.78      0.87      11.88        5.98  \n",
       "2019-11-12               rain        0.43      0.85       6.42        5.93  \n",
       "2019-11-13  partly-cloudy-day        0.62      0.92       4.95        5.51  \n",
       "2019-11-14          clear-day        0.26      0.76       4.55        5.55  \n",
       "2019-11-15  partly-cloudy-day        0.40      0.76       4.64        6.34  \n",
       "2019-11-16          clear-day        0.27      0.93       1.70        6.01  \n",
       "2019-11-17          clear-day        0.30      0.94       0.92        5.60  \n",
       "2019-11-18  partly-cloudy-day        0.35      0.93       0.86        3.70  \n",
       "2019-11-19               rain        0.69      0.89       5.03        4.58  \n",
       "2019-11-20               rain        0.68      0.86       9.32        6.15  \n",
       "2019-11-21  partly-cloudy-day        0.53      0.74      12.60        7.35  \n",
       "2019-11-22               rain        0.75      0.88       8.28       10.00  \n",
       "2019-11-23               rain        0.98      0.90       9.25        9.64  \n",
       "2019-11-24               rain        0.99      0.88       5.47        9.39  \n",
       "2019-11-25               rain        0.91      0.87       7.83        9.82  \n",
       "2019-11-26               rain        0.96      0.85       6.80       10.00  \n",
       "2019-11-27               rain        0.87      0.85       6.82        9.03  \n",
       "2019-11-28  partly-cloudy-day        0.40      0.79       5.15       10.00  \n",
       "2019-11-29          clear-day        0.18      0.76       4.85        9.11  \n",
       "2019-11-30  partly-cloudy-day        0.55      0.72       4.79       10.00  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[\"2019-11-01\":\"2019-11-30\",\"tempMax\":\"visibility\"]"
   ]
  }
 ],
 "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
}