R5_InternalLab_PBRS.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "GS68who2tTMW"
   },
   "source": [
    "### About Dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "83X1t52htTMY"
   },
   "source": [
    "Anonymous Ratings on jokes."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "GW5bjiN-tTMa"
   },
   "source": [
    "1. Ratings are real values ranging from -10.00 to +10.00 (the value \"99\" corresponds to \"null\" = \"not rated\").\n",
    "\n",
    "2. One row per user\n",
    "\n",
    "3. The first column gives the number of jokes rated by that user. The next 100 columns give the ratings for jokes 01 - 100."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "BTae_Il_tTMc"
   },
   "source": [
    "### Read the dataset(jokes.csv)\n",
    "\n",
    "Take care about the header in read_csv() as there are no column names given in the dataset. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "NdPsejadtTMe"
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "KmTNAzprtTMl"
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/jd/anaconda3/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "data = pd.read_csv('jokes.csv', header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "mYhh1h_RtTMq",
    "outputId": "ed0adda6-5d60-44a0-d925-07291540893b"
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>91</th>\n",
       "      <th>92</th>\n",
       "      <th>93</th>\n",
       "      <th>94</th>\n",
       "      <th>95</th>\n",
       "      <th>96</th>\n",
       "      <th>97</th>\n",
       "      <th>98</th>\n",
       "      <th>99</th>\n",
       "      <th>100</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NumJokes</td>\n",
       "      <td>Joke1</td>\n",
       "      <td>Joke2</td>\n",
       "      <td>Joke3</td>\n",
       "      <td>Joke4</td>\n",
       "      <td>Joke5</td>\n",
       "      <td>Joke6</td>\n",
       "      <td>Joke7</td>\n",
       "      <td>Joke8</td>\n",
       "      <td>Joke9</td>\n",
       "      <td>...</td>\n",
       "      <td>Joke91</td>\n",
       "      <td>Joke92</td>\n",
       "      <td>Joke93</td>\n",
       "      <td>Joke94</td>\n",
       "      <td>Joke95</td>\n",
       "      <td>Joke96</td>\n",
       "      <td>Joke97</td>\n",
       "      <td>Joke98</td>\n",
       "      <td>Joke99</td>\n",
       "      <td>Joke100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>74</td>\n",
       "      <td>-7.82</td>\n",
       "      <td>8.79</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>-7.52</td>\n",
       "      <td>-8.5</td>\n",
       "      <td>-9.85</td>\n",
       "      <td>4.17</td>\n",
       "      <td>-8.98</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-5.63</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100</td>\n",
       "      <td>4.08</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>6.36</td>\n",
       "      <td>4.37</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>-5.34</td>\n",
       "      <td>8.88</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>7.86</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>-2.14</td>\n",
       "      <td>3.06</td>\n",
       "      <td>0.34</td>\n",
       "      <td>-4.32</td>\n",
       "      <td>1.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.08</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>99</td>\n",
       "      <td>8.35</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.8</td>\n",
       "      <td>8.16</td>\n",
       "      <td>-2.82</td>\n",
       "      <td>6.21</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>0.53</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 101 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        0      1      2      3      4      5      6      7      8      9    \\\n",
       "0  NumJokes  Joke1  Joke2  Joke3  Joke4  Joke5  Joke6  Joke7  Joke8  Joke9   \n",
       "1        74  -7.82   8.79  -9.66  -8.16  -7.52   -8.5  -9.85   4.17  -8.98   \n",
       "2       100   4.08  -0.29   6.36   4.37  -2.38  -9.66  -0.73  -5.34   8.88   \n",
       "3        49     99     99     99     99   9.03   9.27   9.03   9.27     99   \n",
       "4        48     99   8.35     99     99    1.8   8.16  -2.82   6.21     99   \n",
       "\n",
       "   ...     91      92      93      94      95      96      97      98   \\\n",
       "0  ...  Joke91  Joke92  Joke93  Joke94  Joke95  Joke96  Joke97  Joke98   \n",
       "1  ...    2.82      99      99      99      99      99   -5.63      99   \n",
       "2  ...    2.82   -4.95   -0.29    7.86   -0.19   -2.14    3.06    0.34   \n",
       "3  ...      99      99      99    9.08      99      99      99      99   \n",
       "4  ...      99      99      99    0.53      99      99      99      99   \n",
       "\n",
       "      99       100  \n",
       "0  Joke99  Joke100  \n",
       "1      99       99  \n",
       "2   -4.32     1.07  \n",
       "3      99       99  \n",
       "4      99       99  \n",
       "\n",
       "[5 rows x 101 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.columns = data.iloc[0,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.iloc[1:,:]"
   ]
  },
  {
   "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>NumJokes</th>\n",
       "      <th>Joke1</th>\n",
       "      <th>Joke2</th>\n",
       "      <th>Joke3</th>\n",
       "      <th>Joke4</th>\n",
       "      <th>Joke5</th>\n",
       "      <th>Joke6</th>\n",
       "      <th>Joke7</th>\n",
       "      <th>Joke8</th>\n",
       "      <th>Joke9</th>\n",
       "      <th>...</th>\n",
       "      <th>Joke91</th>\n",
       "      <th>Joke92</th>\n",
       "      <th>Joke93</th>\n",
       "      <th>Joke94</th>\n",
       "      <th>Joke95</th>\n",
       "      <th>Joke96</th>\n",
       "      <th>Joke97</th>\n",
       "      <th>Joke98</th>\n",
       "      <th>Joke99</th>\n",
       "      <th>Joke100</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>74</td>\n",
       "      <td>-7.82</td>\n",
       "      <td>8.79</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>-7.52</td>\n",
       "      <td>-8.5</td>\n",
       "      <td>-9.85</td>\n",
       "      <td>4.17</td>\n",
       "      <td>-8.98</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-5.63</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100</td>\n",
       "      <td>4.08</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>6.36</td>\n",
       "      <td>4.37</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>-5.34</td>\n",
       "      <td>8.88</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>7.86</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>-2.14</td>\n",
       "      <td>3.06</td>\n",
       "      <td>0.34</td>\n",
       "      <td>-4.32</td>\n",
       "      <td>1.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.08</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48</td>\n",
       "      <td>99</td>\n",
       "      <td>8.35</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.8</td>\n",
       "      <td>8.16</td>\n",
       "      <td>-2.82</td>\n",
       "      <td>6.21</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>0.53</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>91</td>\n",
       "      <td>8.5</td>\n",
       "      <td>4.61</td>\n",
       "      <td>-4.17</td>\n",
       "      <td>-5.39</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.6</td>\n",
       "      <td>7.04</td>\n",
       "      <td>4.61</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>...</td>\n",
       "      <td>5.19</td>\n",
       "      <td>5.58</td>\n",
       "      <td>4.27</td>\n",
       "      <td>5.19</td>\n",
       "      <td>5.73</td>\n",
       "      <td>1.55</td>\n",
       "      <td>3.11</td>\n",
       "      <td>6.55</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 101 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "0 NumJokes  Joke1  Joke2  Joke3  Joke4  Joke5  Joke6  Joke7  Joke8  Joke9  \\\n",
       "1       74  -7.82   8.79  -9.66  -8.16  -7.52   -8.5  -9.85   4.17  -8.98   \n",
       "2      100   4.08  -0.29   6.36   4.37  -2.38  -9.66  -0.73  -5.34   8.88   \n",
       "3       49     99     99     99     99   9.03   9.27   9.03   9.27     99   \n",
       "4       48     99   8.35     99     99    1.8   8.16  -2.82   6.21     99   \n",
       "5       91    8.5   4.61  -4.17  -5.39   1.36    1.6   7.04   4.61  -0.44   \n",
       "\n",
       "0  ... Joke91 Joke92 Joke93 Joke94 Joke95 Joke96 Joke97 Joke98 Joke99 Joke100  \n",
       "1  ...   2.82     99     99     99     99     99  -5.63     99     99      99  \n",
       "2  ...   2.82  -4.95  -0.29   7.86  -0.19  -2.14   3.06   0.34  -4.32    1.07  \n",
       "3  ...     99     99     99   9.08     99     99     99     99     99      99  \n",
       "4  ...     99     99     99   0.53     99     99     99     99     99      99  \n",
       "5  ...   5.19   5.58   4.27   5.19   5.73   1.55   3.11   6.55    1.8     1.6  \n",
       "\n",
       "[5 rows x 101 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "SYQl1f7dtTM0"
   },
   "source": [
    "### Consider `ratings` named dataframe with only first 200 rows and all columns from 1(first column is 0) of dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "e5Lsz_R8tTM1"
   },
   "outputs": [],
   "source": [
    "ratings = data.iloc[:200,1:]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "JJEoYeJ7tTM4"
   },
   "source": [
    "### Change the column indices from 0 to 99"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "tKK7v4gZtTM5"
   },
   "outputs": [],
   "source": [
    "ratings.columns = range(ratings.shape[1])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "LWaJNrdbtTM8"
   },
   "source": [
    "### In the dataset, the null ratings are given as 99.00, so replace all 99.00s with 0\n",
    "Hint: You can use `ratings.replace(<the given value>, <new value you wanted to change with>)`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "XMCVZAhUtTM9"
   },
   "outputs": [],
   "source": [
    "ratings = ratings.replace(99.0, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "tTh1nWxftTNA",
    "outputId": "07cde07c-dcb6-4251-ca47-4f4059405793",
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>90</th>\n",
       "      <th>91</th>\n",
       "      <th>92</th>\n",
       "      <th>93</th>\n",
       "      <th>94</th>\n",
       "      <th>95</th>\n",
       "      <th>96</th>\n",
       "      <th>97</th>\n",
       "      <th>98</th>\n",
       "      <th>99</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-7.82</td>\n",
       "      <td>8.79</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>-7.52</td>\n",
       "      <td>-8.5</td>\n",
       "      <td>-9.85</td>\n",
       "      <td>4.17</td>\n",
       "      <td>-8.98</td>\n",
       "      <td>-4.76</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-5.63</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4.08</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>6.36</td>\n",
       "      <td>4.37</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>-5.34</td>\n",
       "      <td>8.88</td>\n",
       "      <td>9.22</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>7.86</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>-2.14</td>\n",
       "      <td>3.06</td>\n",
       "      <td>0.34</td>\n",
       "      <td>-4.32</td>\n",
       "      <td>1.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>9.03</td>\n",
       "      <td>9.27</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>9.08</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>99</td>\n",
       "      <td>8.35</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.8</td>\n",
       "      <td>8.16</td>\n",
       "      <td>-2.82</td>\n",
       "      <td>6.21</td>\n",
       "      <td>99</td>\n",
       "      <td>1.84</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>0.53</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>8.5</td>\n",
       "      <td>4.61</td>\n",
       "      <td>-4.17</td>\n",
       "      <td>-5.39</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.6</td>\n",
       "      <td>7.04</td>\n",
       "      <td>4.61</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>5.73</td>\n",
       "      <td>...</td>\n",
       "      <td>5.19</td>\n",
       "      <td>5.58</td>\n",
       "      <td>4.27</td>\n",
       "      <td>5.19</td>\n",
       "      <td>5.73</td>\n",
       "      <td>1.55</td>\n",
       "      <td>3.11</td>\n",
       "      <td>6.55</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-6.17</td>\n",
       "      <td>-3.54</td>\n",
       "      <td>0.44</td>\n",
       "      <td>-8.5</td>\n",
       "      <td>-7.09</td>\n",
       "      <td>-4.32</td>\n",
       "      <td>-8.69</td>\n",
       "      <td>-0.87</td>\n",
       "      <td>-6.65</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.54</td>\n",
       "      <td>-6.89</td>\n",
       "      <td>-0.68</td>\n",
       "      <td>-2.96</td>\n",
       "      <td>-2.18</td>\n",
       "      <td>-3.35</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-9.08</td>\n",
       "      <td>-5.05</td>\n",
       "      <td>-3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>8.59</td>\n",
       "      <td>-9.85</td>\n",
       "      <td>7.72</td>\n",
       "      <td>8.79</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>2.33</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6.84</td>\n",
       "      <td>3.16</td>\n",
       "      <td>9.17</td>\n",
       "      <td>-6.21</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>9.27</td>\n",
       "      <td>1.41</td>\n",
       "      <td>-5.19</td>\n",
       "      <td>-4.42</td>\n",
       "      <td>...</td>\n",
       "      <td>7.23</td>\n",
       "      <td>-1.12</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>-5.68</td>\n",
       "      <td>-3.16</td>\n",
       "      <td>-3.35</td>\n",
       "      <td>2.14</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-3.79</td>\n",
       "      <td>-3.54</td>\n",
       "      <td>-9.42</td>\n",
       "      <td>-6.89</td>\n",
       "      <td>-8.74</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-5.29</td>\n",
       "      <td>-8.93</td>\n",
       "      <td>-7.86</td>\n",
       "      <td>-1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>4.37</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>4.17</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>-4.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3.01</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>3.01</td>\n",
       "      <td>6.41</td>\n",
       "      <td>5.15</td>\n",
       "      <td>8.93</td>\n",
       "      <td>2.52</td>\n",
       "      <td>3.01</td>\n",
       "      <td>8.16</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>4.47</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-2.91</td>\n",
       "      <td>4.08</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-5.73</td>\n",
       "      <td>99</td>\n",
       "      <td>2.48</td>\n",
       "      <td>-5.29</td>\n",
       "      <td>99</td>\n",
       "      <td>1.46</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>6.17</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.31</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.57</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.73</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>5</td>\n",
       "      <td>-7.23</td>\n",
       "      <td>-1.36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.46</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.29</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>3.45</td>\n",
       "      <td>5.44</td>\n",
       "      <td>4.08</td>\n",
       "      <td>2.48</td>\n",
       "      <td>4.51</td>\n",
       "      <td>4.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>5.87</td>\n",
       "      <td>99</td>\n",
       "      <td>5.58</td>\n",
       "      <td>0.53</td>\n",
       "      <td>99</td>\n",
       "      <td>7.14</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>7.52</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>9.22</td>\n",
       "      <td>9.27</td>\n",
       "      <td>9.22</td>\n",
       "      <td>8.3</td>\n",
       "      <td>7.43</td>\n",
       "      <td>0.44</td>\n",
       "      <td>3.5</td>\n",
       "      <td>8.16</td>\n",
       "      <td>5.97</td>\n",
       "      <td>8.98</td>\n",
       "      <td>...</td>\n",
       "      <td>8.11</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>5.58</td>\n",
       "      <td>6.84</td>\n",
       "      <td>5.53</td>\n",
       "      <td>-5.92</td>\n",
       "      <td>8.2</td>\n",
       "      <td>8.98</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8.79</td>\n",
       "      <td>-5.78</td>\n",
       "      <td>6.02</td>\n",
       "      <td>3.69</td>\n",
       "      <td>7.77</td>\n",
       "      <td>-5.83</td>\n",
       "      <td>8.69</td>\n",
       "      <td>8.59</td>\n",
       "      <td>-5.92</td>\n",
       "      <td>7.52</td>\n",
       "      <td>...</td>\n",
       "      <td>2.72</td>\n",
       "      <td>-5.49</td>\n",
       "      <td>-8.59</td>\n",
       "      <td>8.69</td>\n",
       "      <td>-8.74</td>\n",
       "      <td>-3.01</td>\n",
       "      <td>8.3</td>\n",
       "      <td>-4.81</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>-5.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-3.5</td>\n",
       "      <td>1.55</td>\n",
       "      <td>2.33</td>\n",
       "      <td>-4.13</td>\n",
       "      <td>4.22</td>\n",
       "      <td>-2.28</td>\n",
       "      <td>-2.96</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>2.91</td>\n",
       "      <td>1.99</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.24</td>\n",
       "      <td>-5.92</td>\n",
       "      <td>7.28</td>\n",
       "      <td>-1.36</td>\n",
       "      <td>3.74</td>\n",
       "      <td>2.82</td>\n",
       "      <td>-2.86</td>\n",
       "      <td>3.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>99</td>\n",
       "      <td>-9.27</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-7.38</td>\n",
       "      <td>99</td>\n",
       "      <td>8.74</td>\n",
       "      <td>-6.31</td>\n",
       "      <td>99</td>\n",
       "      <td>2.33</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3.16</td>\n",
       "      <td>7.62</td>\n",
       "      <td>3.79</td>\n",
       "      <td>8.25</td>\n",
       "      <td>4.22</td>\n",
       "      <td>7.62</td>\n",
       "      <td>2.43</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.83</td>\n",
       "      <td>...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>5.68</td>\n",
       "      <td>3.69</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.29</td>\n",
       "      <td>3.59</td>\n",
       "      <td>0.49</td>\n",
       "      <td>8.06</td>\n",
       "      <td>0.49</td>\n",
       "      <td>7.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4.22</td>\n",
       "      <td>3.64</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>2.52</td>\n",
       "      <td>99</td>\n",
       "      <td>4.13</td>\n",
       "      <td>-5.19</td>\n",
       "      <td>99</td>\n",
       "      <td>7.91</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>0.05</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.65</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>99</td>\n",
       "      <td>7.62</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-8.64</td>\n",
       "      <td>2.43</td>\n",
       "      <td>8.93</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>99</td>\n",
       "      <td>-9.47</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2.57</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>2.57</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.22</td>\n",
       "      <td>2.67</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.31</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>1.31</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.02</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>7.28</td>\n",
       "      <td>5.39</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.22</td>\n",
       "      <td>99</td>\n",
       "      <td>8.93</td>\n",
       "      <td>3.5</td>\n",
       "      <td>99</td>\n",
       "      <td>6.12</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.55</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>0.29</td>\n",
       "      <td>-4.61</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2.72</td>\n",
       "      <td>4.17</td>\n",
       "      <td>6.5</td>\n",
       "      <td>-3.54</td>\n",
       "      <td>-3.3</td>\n",
       "      <td>2.86</td>\n",
       "      <td>7.04</td>\n",
       "      <td>4.95</td>\n",
       "      <td>6.17</td>\n",
       "      <td>8.93</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>-3.35</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>2.67</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2.09</td>\n",
       "      <td>-7.57</td>\n",
       "      <td>4.17</td>\n",
       "      <td>-8.4</td>\n",
       "      <td>-6.31</td>\n",
       "      <td>5.34</td>\n",
       "      <td>-5.19</td>\n",
       "      <td>-5.05</td>\n",
       "      <td>-8.2</td>\n",
       "      <td>2.28</td>\n",
       "      <td>...</td>\n",
       "      <td>3.06</td>\n",
       "      <td>8.25</td>\n",
       "      <td>8.5</td>\n",
       "      <td>-9.51</td>\n",
       "      <td>8.45</td>\n",
       "      <td>8.16</td>\n",
       "      <td>7.82</td>\n",
       "      <td>8.5</td>\n",
       "      <td>8.35</td>\n",
       "      <td>-8.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-3.93</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>2.28</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>-2.28</td>\n",
       "      <td>2.38</td>\n",
       "      <td>-3.93</td>\n",
       "      <td>4.51</td>\n",
       "      <td>-0.34</td>\n",
       "      <td>7.77</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-6.07</td>\n",
       "      <td>1.26</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>99</td>\n",
       "      <td>5.49</td>\n",
       "      <td>3.45</td>\n",
       "      <td>99</td>\n",
       "      <td>0.15</td>\n",
       "      <td>4.76</td>\n",
       "      <td>0.1</td>\n",
       "      <td>4.13</td>\n",
       "      <td>8.01</td>\n",
       "      <td>4.76</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>99</td>\n",
       "      <td>5.83</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>5.34</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.47</td>\n",
       "      <td>2.18</td>\n",
       "      <td>-3.98</td>\n",
       "      <td>-3.25</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>4.47</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.49</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.15</td>\n",
       "      <td>-9.56</td>\n",
       "      <td>-9.76</td>\n",
       "      <td>-9.61</td>\n",
       "      <td>0.29</td>\n",
       "      <td>1.65</td>\n",
       "      <td>-4.61</td>\n",
       "      <td>-4.71</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.7</td>\n",
       "      <td>99</td>\n",
       "      <td>8.83</td>\n",
       "      <td>-1.89</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>0.24</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>99</td>\n",
       "      <td>4.08</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>5.87</td>\n",
       "      <td>99</td>\n",
       "      <td>0.44</td>\n",
       "      <td>2.28</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>4.27</td>\n",
       "      <td>99</td>\n",
       "      <td>4.81</td>\n",
       "      <td>-6.21</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>8.54</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>-4.56</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>-2.67</td>\n",
       "      <td>99</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>0.63</td>\n",
       "      <td>-5.34</td>\n",
       "      <td>0.44</td>\n",
       "      <td>5.34</td>\n",
       "      <td>4.08</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>4.37</td>\n",
       "      <td>99</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>1.12</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>5.05</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>0.34</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>0.83</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.75</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.32</td>\n",
       "      <td>99</td>\n",
       "      <td>3.45</td>\n",
       "      <td>4.37</td>\n",
       "      <td>99</td>\n",
       "      <td>5.73</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>7.14</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>-9.42</td>\n",
       "      <td>8.83</td>\n",
       "      <td>8.45</td>\n",
       "      <td>8.64</td>\n",
       "      <td>5.73</td>\n",
       "      <td>8.45</td>\n",
       "      <td>6.89</td>\n",
       "      <td>4.56</td>\n",
       "      <td>-9.42</td>\n",
       "      <td>-9.22</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>6.12</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>-3.54</td>\n",
       "      <td>-3.2</td>\n",
       "      <td>1.12</td>\n",
       "      <td>3.83</td>\n",
       "      <td>3.3</td>\n",
       "      <td>-2.33</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>2.33</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.17</td>\n",
       "      <td>...</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-4.22</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1.02</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>2.28</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>2.09</td>\n",
       "      <td>-5.97</td>\n",
       "      <td>2.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>5.39</td>\n",
       "      <td>0.24</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-6.55</td>\n",
       "      <td>99</td>\n",
       "      <td>-8.35</td>\n",
       "      <td>3.4</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.42</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>4.13</td>\n",
       "      <td>8.4</td>\n",
       "      <td>8.54</td>\n",
       "      <td>3.59</td>\n",
       "      <td>99</td>\n",
       "      <td>4.47</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>4.42</td>\n",
       "      <td>-5.05</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>1.55</td>\n",
       "      <td>99</td>\n",
       "      <td>6.6</td>\n",
       "      <td>2.18</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.22</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>5.1</td>\n",
       "      <td>99</td>\n",
       "      <td>-6.31</td>\n",
       "      <td>1.21</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>5.44</td>\n",
       "      <td>0.49</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.21</td>\n",
       "      <td>99</td>\n",
       "      <td>0.29</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>99</td>\n",
       "      <td>5.53</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>99</td>\n",
       "      <td>-8.98</td>\n",
       "      <td>-9.66</td>\n",
       "      <td>99</td>\n",
       "      <td>-6.12</td>\n",
       "      <td>-7.91</td>\n",
       "      <td>-7.14</td>\n",
       "      <td>-5.24</td>\n",
       "      <td>99</td>\n",
       "      <td>-9.17</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-2.33</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>8.3</td>\n",
       "      <td>8.2</td>\n",
       "      <td>4.95</td>\n",
       "      <td>99</td>\n",
       "      <td>0.78</td>\n",
       "      <td>99</td>\n",
       "      <td>5.78</td>\n",
       "      <td>-2.77</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>-8.16</td>\n",
       "      <td>-7.86</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>99</td>\n",
       "      <td>0.34</td>\n",
       "      <td>99</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>99</td>\n",
       "      <td>2.14</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>-8.74</td>\n",
       "      <td>99</td>\n",
       "      <td>-7.91</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>-2.86</td>\n",
       "      <td>-6.31</td>\n",
       "      <td>-4.9</td>\n",
       "      <td>1.89</td>\n",
       "      <td>3.01</td>\n",
       "      <td>8.11</td>\n",
       "      <td>4.81</td>\n",
       "      <td>1.6</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>9.03</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>7.38</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-6.65</td>\n",
       "      <td>7.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>-0.1</td>\n",
       "      <td>-5.68</td>\n",
       "      <td>1.5</td>\n",
       "      <td>-7.72</td>\n",
       "      <td>-7.91</td>\n",
       "      <td>1.12</td>\n",
       "      <td>-1.21</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>-3.25</td>\n",
       "      <td>-1.89</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>-2.48</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>-6.31</td>\n",
       "      <td>-1.94</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>3.69</td>\n",
       "      <td>99</td>\n",
       "      <td>-4.08</td>\n",
       "      <td>3.06</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>8.16</td>\n",
       "      <td>0.15</td>\n",
       "      <td>4.03</td>\n",
       "      <td>7.67</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>99</td>\n",
       "      <td>-3.16</td>\n",
       "      <td>-3.45</td>\n",
       "      <td>99</td>\n",
       "      <td>2.96</td>\n",
       "      <td>-1.65</td>\n",
       "      <td>1.75</td>\n",
       "      <td>-4.42</td>\n",
       "      <td>99</td>\n",
       "      <td>-1.21</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>3.54</td>\n",
       "      <td>-6.7</td>\n",
       "      <td>-4.76</td>\n",
       "      <td>99</td>\n",
       "      <td>-8.16</td>\n",
       "      <td>99</td>\n",
       "      <td>1.84</td>\n",
       "      <td>-6.84</td>\n",
       "      <td>99</td>\n",
       "      <td>1.31</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>4.47</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>1.55</td>\n",
       "      <td>-1.5</td>\n",
       "      <td>-4.42</td>\n",
       "      <td>4.22</td>\n",
       "      <td>-2.38</td>\n",
       "      <td>1.46</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>-5.39</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>8.06</td>\n",
       "      <td>3.45</td>\n",
       "      <td>3.69</td>\n",
       "      <td>-1.36</td>\n",
       "      <td>3.93</td>\n",
       "      <td>2.14</td>\n",
       "      <td>2.77</td>\n",
       "      <td>0.34</td>\n",
       "      <td>2.52</td>\n",
       "      <td>3.69</td>\n",
       "      <td>...</td>\n",
       "      <td>5.78</td>\n",
       "      <td>5.05</td>\n",
       "      <td>5.68</td>\n",
       "      <td>-2.86</td>\n",
       "      <td>2.86</td>\n",
       "      <td>7.09</td>\n",
       "      <td>5.68</td>\n",
       "      <td>7.48</td>\n",
       "      <td>8.59</td>\n",
       "      <td>2.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>1.84</td>\n",
       "      <td>-2.23</td>\n",
       "      <td>5.49</td>\n",
       "      <td>5.49</td>\n",
       "      <td>4.37</td>\n",
       "      <td>9.22</td>\n",
       "      <td>9.08</td>\n",
       "      <td>5.78</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>6.5</td>\n",
       "      <td>...</td>\n",
       "      <td>-5.29</td>\n",
       "      <td>-1.26</td>\n",
       "      <td>6.21</td>\n",
       "      <td>-2.96</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>-6.17</td>\n",
       "      <td>4.9</td>\n",
       "      <td>9.22</td>\n",
       "      <td>8.16</td>\n",
       "      <td>6.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>-9.71</td>\n",
       "      <td>-8.25</td>\n",
       "      <td>-8.3</td>\n",
       "      <td>-2.62</td>\n",
       "      <td>-8.93</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>2.18</td>\n",
       "      <td>4.47</td>\n",
       "      <td>1.21</td>\n",
       "      <td>2.38</td>\n",
       "      <td>...</td>\n",
       "      <td>4.61</td>\n",
       "      <td>-9.22</td>\n",
       "      <td>-6.5</td>\n",
       "      <td>3.25</td>\n",
       "      <td>2.62</td>\n",
       "      <td>1.99</td>\n",
       "      <td>8.74</td>\n",
       "      <td>-6.55</td>\n",
       "      <td>-0.53</td>\n",
       "      <td>-8.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>5.73</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.58</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.86</td>\n",
       "      <td>7.23</td>\n",
       "      <td>2.04</td>\n",
       "      <td>-4.27</td>\n",
       "      <td>3.11</td>\n",
       "      <td>7.14</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.66</td>\n",
       "      <td>1.65</td>\n",
       "      <td>5.58</td>\n",
       "      <td>5.73</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.04</td>\n",
       "      <td>2.91</td>\n",
       "      <td>1.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>1.8</td>\n",
       "      <td>5.39</td>\n",
       "      <td>8.06</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>4.81</td>\n",
       "      <td>4.66</td>\n",
       "      <td>-7.09</td>\n",
       "      <td>-7.72</td>\n",
       "      <td>3.69</td>\n",
       "      <td>4.47</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2.62</td>\n",
       "      <td>-3.79</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>5.05</td>\n",
       "      <td>-3.69</td>\n",
       "      <td>2.18</td>\n",
       "      <td>3.3</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>...</td>\n",
       "      <td>1.41</td>\n",
       "      <td>-2.52</td>\n",
       "      <td>-0.53</td>\n",
       "      <td>-1.89</td>\n",
       "      <td>1.17</td>\n",
       "      <td>-2.04</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>7.91</td>\n",
       "      <td>99</td>\n",
       "      <td>3.64</td>\n",
       "      <td>-1.89</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>...</td>\n",
       "      <td>2.96</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>5.58</td>\n",
       "      <td>-7.28</td>\n",
       "      <td>-4.56</td>\n",
       "      <td>2.67</td>\n",
       "      <td>7.38</td>\n",
       "      <td>2.18</td>\n",
       "      <td>2.14</td>\n",
       "      <td>2.23</td>\n",
       "      <td>5.58</td>\n",
       "      <td>-4.51</td>\n",
       "      <td>...</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 100 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        0      1      2      3      4      5      6      7      8      9   \\\n",
       "1    -7.82   8.79  -9.66  -8.16  -7.52   -8.5  -9.85   4.17  -8.98  -4.76   \n",
       "2     4.08  -0.29   6.36   4.37  -2.38  -9.66  -0.73  -5.34   8.88   9.22   \n",
       "3       99     99     99     99   9.03   9.27   9.03   9.27     99     99   \n",
       "4       99   8.35     99     99    1.8   8.16  -2.82   6.21     99   1.84   \n",
       "5      8.5   4.61  -4.17  -5.39   1.36    1.6   7.04   4.61  -0.44   5.73   \n",
       "6    -6.17  -3.54   0.44   -8.5  -7.09  -4.32  -8.69  -0.87  -6.65   -1.8   \n",
       "7       99     99     99     99   8.59  -9.85   7.72   8.79     99     99   \n",
       "8     6.84   3.16   9.17  -6.21  -8.16   -1.7   9.27   1.41  -5.19  -4.42   \n",
       "9    -3.79  -3.54  -9.42  -6.89  -8.74  -0.29  -5.29  -8.93  -7.86   -1.6   \n",
       "10    3.01   5.15   5.15   3.01   6.41   5.15   8.93   2.52   3.01   8.16   \n",
       "11   -2.91   4.08     99     99  -5.73     99   2.48  -5.29     99   1.46   \n",
       "12    1.31    1.8   2.57  -2.38   0.73   0.73  -0.97      5  -7.23  -1.36   \n",
       "13      99     99     99     99   5.87     99   5.58   0.53     99   7.14   \n",
       "14    9.22   9.27   9.22    8.3   7.43   0.44    3.5   8.16   5.97   8.98   \n",
       "15    8.79  -5.78   6.02   3.69   7.77  -5.83   8.69   8.59  -5.92   7.52   \n",
       "16    -3.5   1.55   2.33  -4.13   4.22  -2.28  -2.96  -0.49   2.91   1.99   \n",
       "17      99  -9.27     99     99  -7.38     99   8.74  -6.31     99   2.33   \n",
       "18    3.16   7.62   3.79   8.25   4.22   7.62   2.43   0.97   0.53   0.83   \n",
       "19    4.22   3.64     99     99   2.52     99   4.13  -5.19     99   7.91   \n",
       "20      99   7.62     99     99  -8.64   2.43   8.93   -6.6     99  -9.47   \n",
       "21    2.57  -0.73     99     99   2.57     99  -4.22   2.67     99  -1.31   \n",
       "22    7.28   5.39     99     99  -4.22     99   8.93    3.5     99   6.12   \n",
       "23    2.72   4.17    6.5  -3.54   -3.3   2.86   7.04   4.95   6.17   8.93   \n",
       "24    2.09  -7.57   4.17   -8.4  -6.31   5.34  -5.19  -5.05   -8.2   2.28   \n",
       "25   -3.93  -1.17   2.28  -0.44  -2.28   2.38  -3.93   4.51  -0.34   7.77   \n",
       "26      99   5.49   3.45     99   0.15   4.76    0.1   4.13   8.01   4.76   \n",
       "27      99   5.83     99     99   5.34     99  -4.47   2.18  -3.98  -3.25   \n",
       "28    0.49   0.15   0.15  -9.56  -9.76  -9.61   0.29   1.65  -4.61  -4.71   \n",
       "29      99     99     99     99   -1.7     99   8.83  -1.89     99     99   \n",
       "30      99   4.08     99     99   5.87     99   0.44   2.28     99     99   \n",
       "..     ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "171     99     99     99     99   4.27     99   4.81  -6.21     99     99   \n",
       "172  -4.56  -3.74  -2.67     99   -3.4   0.63  -5.34   0.44   5.34   4.08   \n",
       "173     99     99     99     99   4.37     99   -3.4   1.12     99     99   \n",
       "174     99     99     99     99   0.34     99  -1.65   0.83     99     99   \n",
       "175     99     99     99     99  -4.32     99   3.45   4.37     99   5.73   \n",
       "176  -9.42   8.83   8.45   8.64   5.73   8.45   6.89   4.56  -9.42  -9.22   \n",
       "177  -3.54   -3.2   1.12   3.83    3.3  -2.33  -0.19   2.33   0.05   1.17   \n",
       "178   5.39   0.24     99     99  -6.55     99  -8.35    3.4     99  -4.42   \n",
       "179     99     99     99     99   4.13    8.4   8.54   3.59     99   4.47   \n",
       "180   4.42  -5.05     99     99   1.55     99    6.6   2.18     99  -4.22   \n",
       "181     99     99     99     99    5.1     99  -6.31   1.21     99     99   \n",
       "182   5.44   0.49     99     99  -1.21     99   0.29  -0.63     99   5.53   \n",
       "183     99  -8.98  -9.66     99  -6.12  -7.91  -7.14  -5.24     99  -9.17   \n",
       "184    8.3    8.2   4.95     99   0.78     99   5.78  -2.77     99     99   \n",
       "185  -8.16  -7.86  -1.02     99   0.34     99   0.49  -0.29     99   2.14   \n",
       "186  -2.86  -6.31   -4.9   1.89   3.01   8.11   4.81    1.6  -4.95   9.03   \n",
       "187   -0.1  -5.68    1.5  -7.72  -7.91   1.12  -1.21  -3.74  -3.25  -1.89   \n",
       "188  -6.31  -1.94     99     99   3.69     99  -4.08   3.06     99     99   \n",
       "189     99     99     99     99   8.16   0.15   4.03   7.67     99     99   \n",
       "190     99  -3.16  -3.45     99   2.96  -1.65   1.75  -4.42     99  -1.21   \n",
       "191   3.54   -6.7  -4.76     99  -8.16     99   1.84  -6.84     99   1.31   \n",
       "192   4.47  -0.19   1.55   -1.5  -4.42   4.22  -2.38   1.46  -0.39  -5.39   \n",
       "193   8.06   3.45   3.69  -1.36   3.93   2.14   2.77   0.34   2.52   3.69   \n",
       "194   1.84  -2.23   5.49   5.49   4.37   9.22   9.08   5.78   -3.4    6.5   \n",
       "195  -9.71  -8.25   -8.3  -2.62  -8.93  -0.05   2.18   4.47   1.21   2.38   \n",
       "196   5.73      0  -0.58   1.75   2.86   7.23   2.04  -4.27   3.11   7.14   \n",
       "197    1.8   5.39   8.06   -0.1   4.81   4.66  -7.09  -7.72   3.69   4.47   \n",
       "198   2.62  -3.79  -1.17  -0.44  -1.02   5.05  -3.69   2.18    3.3  -0.73   \n",
       "199     99     99     99     99   7.91     99   3.64  -1.89     99     99   \n",
       "200   5.58  -7.28  -4.56   2.67   7.38   2.18   2.14   2.23   5.58  -4.51   \n",
       "\n",
       "     ...     90     91     92     93     94     95     96     97     98     99  \n",
       "1    ...   2.82     99     99     99     99     99  -5.63     99     99     99  \n",
       "2    ...   2.82  -4.95  -0.29   7.86  -0.19  -2.14   3.06   0.34  -4.32   1.07  \n",
       "3    ...     99     99     99   9.08     99     99     99     99     99     99  \n",
       "4    ...     99     99     99   0.53     99     99     99     99     99     99  \n",
       "5    ...   5.19   5.58   4.27   5.19   5.73   1.55   3.11   6.55    1.8    1.6  \n",
       "6    ...  -3.54  -6.89  -0.68  -2.96  -2.18  -3.35   0.05  -9.08  -5.05  -3.45  \n",
       "7    ...     99     99     99     99     99   2.33     99     99     99     99  \n",
       "8    ...   7.23  -1.12   -0.1  -5.68  -3.16  -3.35   2.14  -0.05   1.31      0  \n",
       "9    ...   4.37  -0.29   4.17  -0.29  -0.29  -0.29  -0.29  -0.29   -3.4  -4.95  \n",
       "10   ...     99   4.47     99     99     99     99     99     99     99     99  \n",
       "11   ...     99   6.17     99     99     99     99     99     99     99     99  \n",
       "12   ...   1.46    1.7   0.29   -3.3   3.45   5.44   4.08   2.48   4.51   4.66  \n",
       "13   ...     99     99   7.52     99     99     99     99     99     99     99  \n",
       "14   ...   8.11  -1.02   5.58   6.84   5.53  -5.92    8.2   8.98  -8.16    6.5  \n",
       "15   ...   2.72  -5.49  -8.59   8.69  -8.74  -3.01    8.3  -4.81  -2.38  -5.97  \n",
       "16   ...   3.11    1.7   0.24  -5.92   7.28  -1.36   3.74   2.82  -2.86   3.45  \n",
       "17   ...     99     99     99     99     99     99     99     99     99     99  \n",
       "18   ...   0.83   5.68   3.69   0.19   0.29   3.59   0.49   8.06   0.49   7.62  \n",
       "19   ...     99   0.05     99     99     99     99   1.65     99     99     99  \n",
       "20   ...     99     99     99     99     99     99     99     99     99     99  \n",
       "21   ...     99   1.31     99     99     99     99   1.02     99     99     99  \n",
       "22   ...     99  -1.55     99     99     99     99   0.29  -4.61     99     99  \n",
       "23   ...     99  -3.35     99     99     99   2.67     99     99     99     99  \n",
       "24   ...   3.06   8.25    8.5  -9.51   8.45   8.16   7.82    8.5   8.35  -8.35  \n",
       "25   ...     99     99     99     99     99     99   -1.5  -6.07   1.26    0.1  \n",
       "26   ...     99     99     99     99     99     99     99     99     99     99  \n",
       "27   ...     99     99   4.47     99     99     99     99     99     99     99  \n",
       "28   ...     99     99     99     99  -0.97     99     99     99     99     99  \n",
       "29   ...   0.24     99     99     99     99     99     99     99     99     99  \n",
       "30   ...     99     99     99     99     99     99     99     99     99     99  \n",
       "..   ...    ...    ...    ...    ...    ...    ...    ...    ...    ...    ...  \n",
       "171  ...     99     99   8.54     99     99     99     99     99     99     99  \n",
       "172  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "173  ...     99     99     99     99     99   5.05     99     99     99     99  \n",
       "174  ...     99     99     99     99     99     99  -1.75     99     99     99  \n",
       "175  ...     99     99     99     99   7.14     99     99     99     99     99  \n",
       "176  ...     99     99     99     99     99     99   6.12     99     99     99  \n",
       "177  ...   0.49  -4.22    1.5   1.02  -3.74   2.28  -1.65   2.09  -5.97   2.18  \n",
       "178  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "179  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "180  ...     99     99     99     99     99     99     99  -0.24     99     99  \n",
       "181  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "182  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "183  ...     99     99  -2.33     99     99     99     99     99     99     99  \n",
       "184  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "185  ...     99  -8.74     99  -7.91     99     99     99     99     99     99  \n",
       "186  ...     99     99     99     99   7.38     99     99     99  -6.65   7.18  \n",
       "187  ...     99     99  -2.48     99     99     99     99     99     99     99  \n",
       "188  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "189  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "190  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "191  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "192  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "193  ...   5.78   5.05   5.68  -2.86   2.86   7.09   5.68   7.48   8.59   2.23  \n",
       "194  ...  -5.29  -1.26   6.21  -2.96  -1.02  -6.17    4.9   9.22   8.16    6.8  \n",
       "195  ...   4.61  -9.22   -6.5   3.25   2.62   1.99   8.74  -6.55  -0.53  -8.59  \n",
       "196  ...    1.7   4.66   1.65   5.58   5.73    3.5      0  -2.04   2.91   1.84  \n",
       "197  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "198  ...   1.41  -2.52  -0.53  -1.89   1.17  -2.04  -1.17  -0.73   0.73   0.44  \n",
       "199  ...   2.96     99     99     99     99     99     99     99     99     99  \n",
       "200  ...     99     99     99     99     99     99     99     99     99     99  \n",
       "\n",
       "[200 rows x 100 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "LoArEJGbtTNF"
   },
   "source": [
    "#### Normalize the ratings using StandardScaler and save them in `ratings_diff` variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "S2BxyUwAtTNG"
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/jd/anaconda3/lib/python3.7/site-packages/sklearn/preprocessing/data.py:645: DataConversionWarning: Data with input dtype object were all converted to float64 by StandardScaler.\n",
      "  return self.partial_fit(X, y)\n",
      "/home/jd/anaconda3/lib/python3.7/site-packages/sklearn/base.py:464: DataConversionWarning: Data with input dtype object were all converted to float64 by StandardScaler.\n",
      "  return self.fit(X, **fit_params).transform(X)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.preprocessing import StandardScaler\n",
    "ratings_diff = StandardScaler().fit_transform(ratings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "ckVQjiKctTNI",
    "outputId": "b8daf660-c819-44fa-ceca-04d468442497",
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[-0.83401707, -0.26302556, -0.9426833 , ...,  0.70778183,\n",
       "         0.7894014 ,  0.70807651],\n",
       "       [-0.5697436 , -0.49904647, -0.60368031, ..., -1.40370926,\n",
       "        -1.3580697 , -1.41633091],\n",
       "       [ 1.5382259 ,  2.08184746,  1.35669652, ...,  0.70778183,\n",
       "         0.7894014 ,  0.70807651],\n",
       "       ...,\n",
       "       [-0.60216707, -0.5900237 , -0.76302442, ..., -1.42660908,\n",
       "        -1.25310717, -1.42999758],\n",
       "       [ 1.5382259 ,  2.08184746,  1.35669652, ...,  0.70778183,\n",
       "         0.7894014 ,  0.70807651],\n",
       "       [-0.53643182, -0.68074099, -0.834761  , ...,  0.70778183,\n",
       "         0.7894014 ,  0.70807651]])"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_diff"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "e_RgjrKdtTNL"
   },
   "source": [
    "### Popularity based recommendation system"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "pKLIpvSztTNN"
   },
   "source": [
    "#### Find the mean for each column  in `ratings_diff` i.e, for each joke"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "bF5A6IUdtTNO"
   },
   "outputs": [],
   "source": [
    "mean_ratings = ratings_diff.mean(axis=0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "H4zz3T9ztTNQ"
   },
   "source": [
    "#### Consider all the mean ratings and find the jokes with highest mean value and display the top 10 joke IDs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "QZURE1hstTNR"
   },
   "outputs": [],
   "source": [
    "mean_ratings = pd.DataFrame(mean_ratings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "6er4N_3NtTNU",
    "outputId": "75dcfcd4-1949-4967-c234-a16e79b301ab"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "99    78\n",
       "98    73\n",
       "97    70\n",
       "96    97\n",
       "95    95\n",
       "94     3\n",
       "93    88\n",
       "92    87\n",
       "91    84\n",
       "Name: 0, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mean_ratings.iloc[:,0].argsort()[:-10:-1]"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "name": "Popularity based Recommendation_Lab_Solution.ipynb",
   "provenance": [],
   "version": "0.3.2"
  },
  "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": 2
}