CricketClusteringAnalysis.ipynb

{
 "cells": [
  {
   "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>Player</th>\n",
       "      <th>Span</th>\n",
       "      <th>Mat</th>\n",
       "      <th>Inns</th>\n",
       "      <th>NO</th>\n",
       "      <th>Runs</th>\n",
       "      <th>HS</th>\n",
       "      <th>Ave</th>\n",
       "      <th>BF</th>\n",
       "      <th>SR</th>\n",
       "      <th>100</th>\n",
       "      <th>50</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>1989-2012</td>\n",
       "      <td>463</td>\n",
       "      <td>452</td>\n",
       "      <td>41</td>\n",
       "      <td>18426</td>\n",
       "      <td>200*</td>\n",
       "      <td>44.83</td>\n",
       "      <td>21367</td>\n",
       "      <td>86.23</td>\n",
       "      <td>49</td>\n",
       "      <td>96</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
       "      <td>2000-2015</td>\n",
       "      <td>404</td>\n",
       "      <td>380</td>\n",
       "      <td>41</td>\n",
       "      <td>14234</td>\n",
       "      <td>169</td>\n",
       "      <td>41.98</td>\n",
       "      <td>18048</td>\n",
       "      <td>78.86</td>\n",
       "      <td>25</td>\n",
       "      <td>93</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RT Ponting (AUS/ICC)</td>\n",
       "      <td>1995-2012</td>\n",
       "      <td>375</td>\n",
       "      <td>365</td>\n",
       "      <td>39</td>\n",
       "      <td>13704</td>\n",
       "      <td>164</td>\n",
       "      <td>42.03</td>\n",
       "      <td>17046</td>\n",
       "      <td>80.39</td>\n",
       "      <td>30</td>\n",
       "      <td>82</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ST Jayasuriya (Asia/SL)</td>\n",
       "      <td>1989-2011</td>\n",
       "      <td>445</td>\n",
       "      <td>433</td>\n",
       "      <td>18</td>\n",
       "      <td>13430</td>\n",
       "      <td>189</td>\n",
       "      <td>32.36</td>\n",
       "      <td>14725</td>\n",
       "      <td>91.20</td>\n",
       "      <td>28</td>\n",
       "      <td>68</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
       "      <td>1998-2015</td>\n",
       "      <td>448</td>\n",
       "      <td>418</td>\n",
       "      <td>39</td>\n",
       "      <td>12650</td>\n",
       "      <td>144</td>\n",
       "      <td>33.37</td>\n",
       "      <td>16020</td>\n",
       "      <td>78.96</td>\n",
       "      <td>19</td>\n",
       "      <td>77</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Player       Span  Mat  Inns  NO   Runs    HS    Ave  \\\n",
       "0         SR Tendulkar (INDIA)  1989-2012  463   452  41  18426  200*  44.83   \n",
       "1  KC Sangakkara (Asia/ICC/SL)  2000-2015  404   380  41  14234   169  41.98   \n",
       "2         RT Ponting (AUS/ICC)  1995-2012  375   365  39  13704   164  42.03   \n",
       "3      ST Jayasuriya (Asia/SL)  1989-2011  445   433  18  13430   189  32.36   \n",
       "4   DPMD Jayawardene (Asia/SL)  1998-2015  448   418  39  12650   144  33.37   \n",
       "\n",
       "      BF     SR  100  50   0  \n",
       "0  21367  86.23   49  96  20  \n",
       "1  18048  78.86   25  93  15  \n",
       "2  17046  80.39   30  82  20  \n",
       "3  14725  91.20   28  68  34  \n",
       "4  16020  78.96   19  77  28  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from sklearn.cluster import KMeans\n",
    "\n",
    "cric_df = pd.read_csv('Cricket.csv', encoding='palmos')\n",
    "cric_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "cric_df_1 = cric_df[['SR','Ave']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.preprocessing import StandardScaler\n",
    "\n",
    "std_scaler = StandardScaler()\n",
    "cric_df_2 = std_scaler.fit_transform(cric_df_1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KMeans(algorithm='auto', copy_x=True, init='k-means++', max_iter=50,\n",
       "    n_clusters=4, n_init=10, n_jobs=1, precompute_distances='auto',\n",
       "    random_state=100, tol=0.0001, verbose=0)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model_clus = KMeans(n_clusters = 4, max_iter=50, random_state=100)\n",
    "model_clus.fit(cric_df_2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "cluster_df = pd.DataFrame(pd.Series(model_clus.labels_), columns=['cluster'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cric_df_c = pd.concat([cric_df['Player'],cric_df_1,cluster_df], axis=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>Player</th>\n",
       "      <th>SR</th>\n",
       "      <th>Ave</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>86.23</td>\n",
       "      <td>44.83</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
       "      <td>78.86</td>\n",
       "      <td>41.98</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RT Ponting (AUS/ICC)</td>\n",
       "      <td>80.39</td>\n",
       "      <td>42.03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ST Jayasuriya (Asia/SL)</td>\n",
       "      <td>91.20</td>\n",
       "      <td>32.36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
       "      <td>78.96</td>\n",
       "      <td>33.37</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Player     SR    Ave  cluster\n",
       "0         SR Tendulkar (INDIA)  86.23  44.83        3\n",
       "1  KC Sangakkara (Asia/ICC/SL)  78.86  41.98        1\n",
       "2         RT Ponting (AUS/ICC)  80.39  42.03        1\n",
       "3      ST Jayasuriya (Asia/SL)  91.20  32.36        0\n",
       "4   DPMD Jayawardene (Asia/SL)  78.96  33.37        2"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cric_df_c.head()"
   ]
  },
  {
   "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>Player</th>\n",
       "      <th>SR</th>\n",
       "      <th>Ave</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>86.23</td>\n",
       "      <td>44.83</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
       "      <td>78.86</td>\n",
       "      <td>41.98</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RT Ponting (AUS/ICC)</td>\n",
       "      <td>80.39</td>\n",
       "      <td>42.03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ST Jayasuriya (Asia/SL)</td>\n",
       "      <td>91.20</td>\n",
       "      <td>32.36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
       "      <td>78.96</td>\n",
       "      <td>33.37</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Inzamam-ul-Haq (Asia/PAK)</td>\n",
       "      <td>74.24</td>\n",
       "      <td>39.52</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>JH Kallis (Afr/ICC/SA)</td>\n",
       "      <td>72.89</td>\n",
       "      <td>44.36</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SC Ganguly (Asia/INDIA)</td>\n",
       "      <td>73.70</td>\n",
       "      <td>41.02</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>R Dravid (Asia/ICC/INDIA)</td>\n",
       "      <td>71.24</td>\n",
       "      <td>39.16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BC Lara (ICC/WI)</td>\n",
       "      <td>79.51</td>\n",
       "      <td>40.48</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>TM Dilshan (SL)</td>\n",
       "      <td>86.23</td>\n",
       "      <td>39.27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mohammad Yousuf (Asia/PAK)</td>\n",
       "      <td>75.10</td>\n",
       "      <td>41.71</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AC Gilchrist (AUS/ICC)</td>\n",
       "      <td>96.94</td>\n",
       "      <td>35.89</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MS Dhoni (Asia/INDIA)</td>\n",
       "      <td>88.69</td>\n",
       "      <td>51.32</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>M Azharuddin (INDIA)</td>\n",
       "      <td>74.02</td>\n",
       "      <td>36.92</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AB de Villiers (Afr/SA)</td>\n",
       "      <td>100.25</td>\n",
       "      <td>53.55</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PA de Silva (SL)</td>\n",
       "      <td>81.13</td>\n",
       "      <td>34.90</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CH Gayle (ICC/WI)</td>\n",
       "      <td>85.11</td>\n",
       "      <td>37.33</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Saeed Anwar (PAK)</td>\n",
       "      <td>80.67</td>\n",
       "      <td>39.21</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>S Chanderpaul (WI)</td>\n",
       "      <td>70.74</td>\n",
       "      <td>41.60</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Yuvraj Singh (Asia/INDIA)</td>\n",
       "      <td>87.67</td>\n",
       "      <td>36.55</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>DL Haynes (WI)</td>\n",
       "      <td>63.09</td>\n",
       "      <td>41.37</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>MS Atapattu (SL)</td>\n",
       "      <td>67.72</td>\n",
       "      <td>37.57</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ME Waugh (AUS)</td>\n",
       "      <td>76.90</td>\n",
       "      <td>39.35</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>V Sehwag (Asia/ICC/INDIA)</td>\n",
       "      <td>104.33</td>\n",
       "      <td>35.05</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>V Kohli (INDIA)</td>\n",
       "      <td>90.99</td>\n",
       "      <td>53.94</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>HH Gibbs (SA)</td>\n",
       "      <td>83.26</td>\n",
       "      <td>36.13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Shahid Afridi (Asia/ICC/PAK)</td>\n",
       "      <td>117.00</td>\n",
       "      <td>23.57</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SP Fleming (ICC/NZ)</td>\n",
       "      <td>71.49</td>\n",
       "      <td>32.40</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MJ Clarke (AUS)</td>\n",
       "      <td>78.98</td>\n",
       "      <td>44.58</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ML Hayden (AUS/ICC)</td>\n",
       "      <td>78.96</td>\n",
       "      <td>43.80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>BB McCullum (NZ)</td>\n",
       "      <td>96.37</td>\n",
       "      <td>30.41</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>DM Jones (AUS)</td>\n",
       "      <td>72.56</td>\n",
       "      <td>44.61</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>DC Boon (AUS)</td>\n",
       "      <td>65.13</td>\n",
       "      <td>37.04</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>JN Rhodes (SA)</td>\n",
       "      <td>80.90</td>\n",
       "      <td>35.11</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Mohammad Hafeez (PAK)</td>\n",
       "      <td>75.58</td>\n",
       "      <td>33.01</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Rameez Raja (PAK)</td>\n",
       "      <td>63.31</td>\n",
       "      <td>32.09</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>RR Sarwan (WI)</td>\n",
       "      <td>75.74</td>\n",
       "      <td>42.67</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>EJG Morgan (ENG/IRE)</td>\n",
       "      <td>88.62</td>\n",
       "      <td>38.73</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>CL Hooper (WI)</td>\n",
       "      <td>76.63</td>\n",
       "      <td>35.34</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>SR Watson (AUS)</td>\n",
       "      <td>90.44</td>\n",
       "      <td>40.54</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Tamim Iqbal (BDESH)</td>\n",
       "      <td>78.31</td>\n",
       "      <td>34.38</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>SK Raina (INDIA)</td>\n",
       "      <td>93.76</td>\n",
       "      <td>35.46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>WJ Cronje (SA)</td>\n",
       "      <td>76.47</td>\n",
       "      <td>38.64</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>MJ Guptill (NZ)</td>\n",
       "      <td>87.73</td>\n",
       "      <td>43.30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>MEK Hussey (AUS)</td>\n",
       "      <td>87.16</td>\n",
       "      <td>48.15</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>RG Sharma (INDIA)</td>\n",
       "      <td>84.56</td>\n",
       "      <td>42.46</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>IR Bell (ENG)</td>\n",
       "      <td>77.16</td>\n",
       "      <td>37.87</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>A Jadeja (INDIA)</td>\n",
       "      <td>69.80</td>\n",
       "      <td>37.47</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>DR Martyn (AUS)</td>\n",
       "      <td>77.73</td>\n",
       "      <td>40.80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>BRM Taylor (ZIM)</td>\n",
       "      <td>74.47</td>\n",
       "      <td>34.82</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>G Gambhir (INDIA)</td>\n",
       "      <td>85.25</td>\n",
       "      <td>39.68</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>ADR Campbell (ZIM)</td>\n",
       "      <td>66.18</td>\n",
       "      <td>30.50</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>MN Samuels (WI)</td>\n",
       "      <td>76.24</td>\n",
       "      <td>34.30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>RS Mahanama (SL)</td>\n",
       "      <td>60.57</td>\n",
       "      <td>29.49</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>CG Greenidge (WI)</td>\n",
       "      <td>64.92</td>\n",
       "      <td>45.03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Misbah-ul-Haq (PAK)</td>\n",
       "      <td>73.75</td>\n",
       "      <td>43.40</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>PD Collingwood (ENG)</td>\n",
       "      <td>76.98</td>\n",
       "      <td>35.36</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>A Symonds (AUS)</td>\n",
       "      <td>92.44</td>\n",
       "      <td>39.75</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Abdul Razzaq (Asia/PAK)</td>\n",
       "      <td>81.25</td>\n",
       "      <td>29.70</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>79 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Player      SR    Ave  cluster\n",
       "0           SR Tendulkar (INDIA)   86.23  44.83        3\n",
       "1    KC Sangakkara (Asia/ICC/SL)   78.86  41.98        1\n",
       "2           RT Ponting (AUS/ICC)   80.39  42.03        1\n",
       "3        ST Jayasuriya (Asia/SL)   91.20  32.36        0\n",
       "4     DPMD Jayawardene (Asia/SL)   78.96  33.37        2\n",
       "5      Inzamam-ul-Haq (Asia/PAK)   74.24  39.52        1\n",
       "6         JH Kallis (Afr/ICC/SA)   72.89  44.36        1\n",
       "7        SC Ganguly (Asia/INDIA)   73.70  41.02        1\n",
       "8      R Dravid (Asia/ICC/INDIA)   71.24  39.16        1\n",
       "9               BC Lara (ICC/WI)   79.51  40.48        1\n",
       "10               TM Dilshan (SL)   86.23  39.27        0\n",
       "11    Mohammad Yousuf (Asia/PAK)   75.10  41.71        1\n",
       "12        AC Gilchrist (AUS/ICC)   96.94  35.89        0\n",
       "13         MS Dhoni (Asia/INDIA)   88.69  51.32        3\n",
       "14          M Azharuddin (INDIA)   74.02  36.92        2\n",
       "15       AB de Villiers (Afr/SA)  100.25  53.55        3\n",
       "16              PA de Silva (SL)   81.13  34.90        2\n",
       "17             CH Gayle (ICC/WI)   85.11  37.33        0\n",
       "18             Saeed Anwar (PAK)   80.67  39.21        1\n",
       "19            S Chanderpaul (WI)   70.74  41.60        1\n",
       "20     Yuvraj Singh (Asia/INDIA)   87.67  36.55        0\n",
       "21                DL Haynes (WI)   63.09  41.37        1\n",
       "22              MS Atapattu (SL)   67.72  37.57        2\n",
       "23                ME Waugh (AUS)   76.90  39.35        1\n",
       "24     V Sehwag (Asia/ICC/INDIA)  104.33  35.05        0\n",
       "25               V Kohli (INDIA)   90.99  53.94        3\n",
       "26                 HH Gibbs (SA)   83.26  36.13        2\n",
       "27  Shahid Afridi (Asia/ICC/PAK)  117.00  23.57        0\n",
       "28           SP Fleming (ICC/NZ)   71.49  32.40        2\n",
       "29               MJ Clarke (AUS)   78.98  44.58        1\n",
       "..                           ...     ...    ...      ...\n",
       "49           ML Hayden (AUS/ICC)   78.96  43.80        1\n",
       "50              BB McCullum (NZ)   96.37  30.41        0\n",
       "51                DM Jones (AUS)   72.56  44.61        1\n",
       "52                 DC Boon (AUS)   65.13  37.04        2\n",
       "53                JN Rhodes (SA)   80.90  35.11        2\n",
       "54         Mohammad Hafeez (PAK)   75.58  33.01        2\n",
       "55             Rameez Raja (PAK)   63.31  32.09        2\n",
       "56                RR Sarwan (WI)   75.74  42.67        1\n",
       "57          EJG Morgan (ENG/IRE)   88.62  38.73        0\n",
       "58                CL Hooper (WI)   76.63  35.34        2\n",
       "59               SR Watson (AUS)   90.44  40.54        0\n",
       "60           Tamim Iqbal (BDESH)   78.31  34.38        2\n",
       "61              SK Raina (INDIA)   93.76  35.46        0\n",
       "62                WJ Cronje (SA)   76.47  38.64        1\n",
       "63               MJ Guptill (NZ)   87.73  43.30        3\n",
       "64              MEK Hussey (AUS)   87.16  48.15        3\n",
       "65             RG Sharma (INDIA)   84.56  42.46        1\n",
       "66                 IR Bell (ENG)   77.16  37.87        1\n",
       "67              A Jadeja (INDIA)   69.80  37.47        2\n",
       "68               DR Martyn (AUS)   77.73  40.80        1\n",
       "69              BRM Taylor (ZIM)   74.47  34.82        2\n",
       "70             G Gambhir (INDIA)   85.25  39.68        1\n",
       "71            ADR Campbell (ZIM)   66.18  30.50        2\n",
       "72               MN Samuels (WI)   76.24  34.30        2\n",
       "73              RS Mahanama (SL)   60.57  29.49        2\n",
       "74             CG Greenidge (WI)   64.92  45.03        1\n",
       "75           Misbah-ul-Haq (PAK)   73.75  43.40        1\n",
       "76          PD Collingwood (ENG)   76.98  35.36        2\n",
       "77               A Symonds (AUS)   92.44  39.75        0\n",
       "78       Abdul Razzaq (Asia/PAK)   81.25  29.70        2\n",
       "\n",
       "[79 rows x 4 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cric_df_c"
   ]
  },
  {
   "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>Player</th>\n",
       "      <th>SR</th>\n",
       "      <th>Ave</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "      <td>86.23</td>\n",
       "      <td>44.83</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MS Dhoni (Asia/INDIA)</td>\n",
       "      <td>88.69</td>\n",
       "      <td>51.32</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AB de Villiers (Afr/SA)</td>\n",
       "      <td>100.25</td>\n",
       "      <td>53.55</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>V Kohli (INDIA)</td>\n",
       "      <td>90.99</td>\n",
       "      <td>53.94</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>HM Amla (SA)</td>\n",
       "      <td>89.05</td>\n",
       "      <td>50.25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>MG Bevan (AUS)</td>\n",
       "      <td>74.16</td>\n",
       "      <td>53.58</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>IVA Richards (WI)</td>\n",
       "      <td>90.20</td>\n",
       "      <td>47.00</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>MJ Guptill (NZ)</td>\n",
       "      <td>87.73</td>\n",
       "      <td>43.30</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>MEK Hussey (AUS)</td>\n",
       "      <td>87.16</td>\n",
       "      <td>48.15</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Player      SR    Ave  cluster\n",
       "0      SR Tendulkar (INDIA)   86.23  44.83        3\n",
       "13    MS Dhoni (Asia/INDIA)   88.69  51.32        3\n",
       "15  AB de Villiers (Afr/SA)  100.25  53.55        3\n",
       "25          V Kohli (INDIA)   90.99  53.94        3\n",
       "34             HM Amla (SA)   89.05  50.25        3\n",
       "38           MG Bevan (AUS)   74.16  53.58        3\n",
       "42        IVA Richards (WI)   90.20  47.00        3\n",
       "63          MJ Guptill (NZ)   87.73  43.30        3\n",
       "64         MEK Hussey (AUS)   87.16  48.15        3"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cric_df_c[cric_df_c.cluster==3]"
   ]
  },
  {
   "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>ClusterID</th>\n",
       "      <th>Avg</th>\n",
       "      <th>SR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>35.409167</td>\n",
       "      <td>94.175833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>41.484444</td>\n",
       "      <td>75.751852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>33.949355</td>\n",
       "      <td>74.014839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>49.546667</td>\n",
       "      <td>88.273333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ClusterID        Avg         SR\n",
       "0          0  35.409167  94.175833\n",
       "1          1  41.484444  75.751852\n",
       "2          2  33.949355  74.014839\n",
       "3          3  49.546667  88.273333"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cluster_avg = pd.DataFrame(cric_df_c.groupby([\"cluster\"]).Ave.mean())\n",
    "cluster_sr = pd.DataFrame(cric_df_c.groupby([\"cluster\"]).SR.mean())\n",
    "df = pd.concat([pd.Series([0,1,2,3]), cluster_avg, cluster_sr], axis=1)\n",
    "df.columns = [\"ClusterID\", \"Avg\", \"SR\"]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "from scipy.cluster.hierarchy import linkage\n",
    "from scipy.cluster.hierarchy import dendrogram\n",
    "from scipy.cluster.hierarchy import cut_tree\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAD6CAYAAACBIq1uAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGmJJREFUeJzt3XuUJGV5x/Hv4wICO9wi4yLCsqAcDXKZkYkmR49MwAsqgiTEI5OYgyZO1CNIMMeAOfFyvCdekBwvjICr4OCFe4wBURkQjVyW7SPIErktCssuK8hl8UKQJ3/U27vV71ZPV890dffb/fucM2empqurnnrft5566+2uKnN3REQkHU/rdQAiItIeJW4RkcQocYuIJEaJW0QkMUrcIiKJUeIWEUmMEreISGJaJm4ze56Z1XI/j5rZyd0ITkREtmbtXIBjZkuA+4AXu/s9lUUlIiJNtTtUcgRwp5K2iEjvbNPm/G8Ezm810+677+4rVqxYUEAiIsNo1apVv3L30TLzlh4qMbPtgHXAC9x9Q8Hr08A0wPLlyw+95x51ykVEyjKzVe4+UWbedoZKXg3cVJS0Adx9xt0n3H1idLTUQUNERBagncR9PCWGSUREpFqlEreZ7Qi8Ario2nBERKSVUh9OuvtvgGdUHIuIiJSgKydFRBKjxC0ikhglbhGRxLR7Ac6CzczA7Gy31jY8pqZgerrXUYhIN3Wtxz07C7Vat9Y2HGo1HQxFhlHXetwAY2MwN9fNNQ62ycleRyAivaAxbhGRxChxi4gkRolbRCQxStwiIolR4hYRSYwSt4hIYpS4RUQSo8QtIpIYJW4RkcQocYuIJEaJW0QkMUrcIiKJUeIWEUmMEreISGKUuEVEEqPELSKSmFKJ28x2NbMLzOw2M1tjZn9WdWAiIlKs7BNwPgtc7u7Hmdl2wI4VxiQiIvNombjNbGfgZcAJAO7+BPBEtWGJiEgzZYZK9gM2Al82s9VmdpaZLa04LhERaaJM4t4GeCHwBXcfBx4HTo1nMrNpM7vRzG7cuHFjh8MUEZG6Mon7XuBed78uTF9AlsgbuPuMu0+4+8To6GgnYxQRkZyWidvd1wO/NLPnhX8dAdxaaVQiItJU2W+VnAh8LXyj5C7gzdWFJCIi8ymVuN29BkxUHIuIiJSgKydFRBKjxC0ikpiyY9xJmJmB2dleR9E9tVr2e3Kyp2F01dQUTE/3OgqR3hqoHvfs7JZkNgzGxrKfYVGrDdeBWaSZgepxQ5bI5uZ6HYVUYZjOLETmM1A9bhGRYaDELSKSGCVuEZHEKHGLiCRGiVtEJDFK3CIiiVHiFhFJjBK3iEhilLhFRBKjxC0ikhglbhGRxChxi4gkRolbRCQxStwiIolR4hYRSYwSt4hIYpS4RUQSU+oJOGa2FngM+APwpLtPVBmUiIg0186jy/7c3X9VWSQiIlKKhkpERBJTNnE78F0zW2Vm01UGJCIi8ys7VPISd19nZs8ErjSz29z9mvwMIaFPAyxfvrzDYYqISF2pHre7rwu/HwAuBl5UMM+Mu0+4+8To6GhnoxQRkc1aJm4zW2pmO9X/Bl4J3FJ1YCIiUqzMUMky4GIzq88/6+6XVxqViIg01TJxu/tdwCFdiEVERErQ1wFFRBKjxC0ikhglbhGRxChxi4gkRolbRCQxStwiIolR4hYRSYwSt4hIYpS4RUQSo8QtIpIYJW4RkcQocYuIJEaJW0QkMUrcIiKJUeIWEUmMEreISGKUuEVEElP2Ke/SYzPr1jG7YUOvw+ip2qbnAjC5+o4eR9I7U8uWMb3nnr0OQ3pMiTsRsxs2UNu0ibGRkV6H0jNjXxrehA1Q27QJQIlblLhTMjYywtz4eK/DkB6ZXL261yFIn9AYt4hIYpS4RUQSUzpxm9kSM1ttZt+uMiAREZlfOz3udwFrqgpERETKKZW4zWwv4LXAWdWGIyIirZTtcZ8OvAd4qtkMZjZtZjea2Y0bN27sSHAiIrK1lonbzI4CHnD3VfPN5+4z7j7h7hOjo6MdC1BERBqV6XG/BDjazNYCXwcON7PzKo1KRESaapm43f00d9/L3VcAbwR+4O5/U3lkIiJSSN/jFhFJTFuXvLv7HDBXSSQiIlKKetwiIolR4hYRSYwSt4hIYpS4RUQSo8QtIpIYJW4RkcQocYuIJEaJW0QkMUrcIiKJUeIWEUmMEreISGKUuEVEEqPELSKSGCVuEZHEKHGLiCRGiVtEJDFK3CIiiVHiFhFJjBK3iEhilLhFRBKjxC0ikpiWT3k3s+2Ba4Cnh/kvcPf3t3rfzKoZZm+e3TxdW386AJMrT26Yb+qgKaYPnW4raBGRYdYycQO/Bw53901mti1wrZn9t7v/ZL43zd48S219jbE9xgAYO/Xkreapra8BKHGLiLShZeJ2dwc2hcltw4+XWfjYHmPMnTDX9PXJlZNlFiPSdTPr1jG7YUOvw2hQ25TthpOrV/c4kkZTy5YxveeevQ5jqJQa4zazJWZWAx4ArnT366oNS6S3Zjds2Jwo+8XYyAhjIyO9DqNBbdOmvjvADYMyQyW4+x+AMTPbFbjYzA5091vy85jZNDANsHz5ckborwYm0q6xkRHmxsd7HUZf67fe/7Bo61sl7v4wMAccWfDajLtPuPvE6Ohoh8ITEZFYy8RtZqOhp42Z7QC8HLit6sBERKRYmaGSZwFfMbMlZIn+m+7+7WrDEhGRZsp8q+SngAb6RET6hK6cFBFJjBK3iEhilLhFRBKjxC0ikhglbhGRxJS6crJvzczA7JY7EFLL7kDIZO6GVlNTMK2bWInI4Eg7cc/OQq0GY9kdCOfGojsQ1rK7Dypxi8ggSTtxQ5a05+aKX5uc7GYkIiJdoTFuEZHEKHGLiCRGiVtEJDFK3CIiiVHiFhFJjBK3iEhi0v86YMX65aGx/fagWD0gVqR31ONuoV8eGttPD4rVA2JFeks97hL00NhG/dLrFxlW6nGLiCRGiVtEJDFK3CIiiVHiFhFJjBK3iEhiWiZuM9vbzK4yszVm9jMze1c3AhMRkWJlvg74JPBud7/JzHYCVpnZle5+a8WxiUgHVHkRWdUXhulCr2Ite9zufr+73xT+fgxYAzy76sBEpDOqvIisygvDdKFXc21dgGNmK4Bx4LoqghGRaqR4EZku9Gqu9IeTZjYCXAic7O6PFrw+bWY3mtmNGzdu7GSMIiKSUypxm9m2ZEn7a+5+UdE87j7j7hPuPjE6OtrJGEVEJKfMt0oMOBtY4+6frj4kERGZT5ke90uANwGHm1kt/Lym4rhERKSJlh9Ouvu1gHUhFhERKUFXToqIJEb34xaRRanqAp8qL+5J/cIe9bhFZFGqusCnqot7BuHCHvW4RWTRUrrAZxAu7FGPW0QkMUrcIiKJUeIWEUmMEreISGKUuEVEEqPELSKSGH0dUIZCuxeJtHvxR+oXdEha1OOWodDuRSLtXPwxCBd0SFrU405clc8TbKbq5wwW6USPtqqLRAbhgg5JS9cS98yqGWZvnm34X219DYDJlZNbzT910BTTh053I7Sk1XuSVT33r0g31wVbDhQaihDJdC1xz948S219jbE9xjb/L/93Xj2hK3GXk9LlxguhHq1Io64OlYztMcbcCXMt5yvqgYt0W9lhKH2QKd2mDydFmij7gaY+yJRuG6wPJ2dmYDY3jl7LhlyYnNzyv6kpmNYQjJTT6WEoDftIJwxWj3t2dkuyBhgby37qarXGxC4ikqDB6nFDlqjn5opfy/e8RUQSNXiJW0SGxkKuY1jMdQj98sHyYA2ViMhQWchj0xb6SLR++mC5ZY/bzM4BjgIecPcDqw9JpLEnVdRD6peezzBo1ast04Otsr66dR1DP32wXKbHvRI4suI4RBrke1JxD6mfej7DoFWvtlUPVvXVeS173O5+jZmtqD4UkUbNelL91PMZFovp1aq+Ok8fTvZAJ28M1ckbPmn4IX1FbatZG1F9p6tjidvMpoFpgOXLlzNCd29E1Clxw69ifLWTN4bq1A2fdCOnwVDUtoraiOo7bR1L3O4+A8wATExMeNn3lb1rYLfuFhg3/LjRd6rB99uNoXQ6u3hlzqS68UFembal+k5bz4dKytw1sNt3C5yv4avBSzNlzqRanSGpJyxllPk64PnAJLC7md0LvN/dz+5kEK3uGqi7BUoqFnsmpY6BlFHmWyXHdyMQEREpp+dDJSIivdapzyegO9/W0SXvIjL0ylw6X+ZS+W5dbKQet4gInfmmV7c+o1DiHjALvbhnEO6YJr3VrO21altqP+3TUMmAWcjd0mAw7pgmvdWs7c3XttR+Fmbwe9z5x5nFjzIb0MeYdfPinkH6+lqrq2bVM2yt3bY3SO2nm/q6xz2zaobJlZPU1teora8xuXKSmVUz7S0k/ziz/KPM9BgzicQ9xnxPUT1D6Sd93eOOr6pc8BWURY8z02PMpIDuSCgp6OvEDY1XVfbqCsphval/J7/bCoNbTjJc5tsv5tsfOtn++z5x94P8PSiquulUuxbyCX67DacT996I41LiltTNt1/M9yEsdK79K3GXlD+FLvoQq9sfYDVrPJ1uOJ36oLMXQw3znSn1Q+9f985OV68/hFXiXoBmPfBu9yrbaTzDOEbbL/XUzDDeO3sx39zRgW4LJe4FKkqaw5gcu2Whved+r6du3ju7H85A5rvffasD1DAe6JpR4h5gg/Shaq96z/UyzJdfSuWWV0UZLuRgsJhv7ughERkl7i7pRRLtxw9VF6MXvee4l9ev5Vb2ANPpMuz34ahB1bPEXX9kWf4xZd16PFkv9CqJ6nvJi5cvw06UW6sku5Bx4F4eYPp9OKpI1VfJVv3s2p4l7o5dXJOQYUii7X5NcaGNN+UhjFZJdqHjwO0eYPqlDHsRx2LG2he7/E6so6dDJf1wcY10VjtfU1xM401lCKOZVkm2Gwf5finDTsTR7bH2Mqp8dq3GuDugX3ou/aLs1xQX23g7PYSxEKl/ADxfGXazXS+2LodtrH34Enf9boH5OwUu8i6BC+kx9OKrWc3W2e/JpVOqSESD9gFwXr/0yHv1wWsVOtUGhy9x15N2/i6BsOjbu7bbY+hFD6FonfH6+uG7vlWpKhF1Y1ijV2d1/XBWk9IBpNU8ndqW4Uvc0Hi3wB7eJbAXPYR4nfH6unFAKWrc0J0DQz8kooXol+TVSlUHmG588NqJpFtmnk60wVKJ28yOBD4LLAHOcvePL2ht0lQVXxFbqHYPKO320os+wOzXRNRPUjjo9MsBZiFxdCrpdqOeWiZuM1sCfA54BXAvcIOZXebut1YS0ZCq6iti3bCQXnqrnn+qhv1zBOifA8xC4uiX2Fsp8wScFwF3uPtd7v4E8HXgmGrDGk71RjM3Pt70lpH11+fGx5latmzza/U7FM6sW9fRmGbWrWNy9WpqmzbNu458bN2Iq1/lz5rqB7LaJj09RzqrzFDJs4Ff5qbvBV5cTTjSjtkNG7j6kUc4bJddALj6kUeAzva8F7KObsTVzwb1bEL6h7n7/DOY/RXwKnf/+zD9JuBF7n5iNN80UP9qxvOA/+18uCIiA2sfdx8tM2OZHve9wN656b2Arc573X0GaPNJviIi0q4yY9w3APub2b5mth3wRuCyasMSEZFmWva43f1JM3sncAXZ1wHPcfefVR6ZiIgUajnGLSIi/aXMUImIiPQRJW4RkcQocYuIJKYvE7eZ/ZGZ7WRmLzCzZ/Y6nkFhZof0OoZBZWZLzWw7MzvWzJ41z3xmZpNmtlv4ptZSM3uNme3VZP59Koh1BzM7xsxeZ2Y7dnr5w87M9jazXc1sRW56+1DeR5rZovNuxxO3me3Q5P/7ht9L6vOY2S7RPBb+/DCwEtgH+GB47WAzOyiaf6eC9awws23i6XphhYPC03OvPyP8Lny9RZyF4hjy25+b3i33985mtnM0vdUOFa/XzMbNbMcS23apmX0aOD38Llxvfj31sjWzA8xsabzOaP4l8y2zYNvry96qLcyzXmvxej6GhuXO1+bmizP3/6b1n6vrtwGnAI8DpxUtw8xOAk4FdgM+AvwTcCbwFPAvuXkPMrPnh8mVZvY5M3tV7vWW7aNe97npJbnJDwEPAg8T9q+C92+OoWifbvK/hn20xHSzXFFv14V13eQ9u4Xf8+3HFs9ftL1hulkZ75L7e/O+YGZHh59jgPcBpwN/bWbHA8cCHye7HuYY4L25ZWyVw8qo4rau3zeza4CV7n6bmZ1D1kDGzWw1sAvwuJldBhxgZivD+4ys8X8CuB241t2/Y1mv++PALWRlPwWMApuA35jZzu7+TjN7M7AU2BbYN6xr8zSwTais7wOHmtlvw3rrcW0fvf6FXFxTwD+b2b8DOwJ3m9newKHAhcCX3f3hOAbgpILtv4XsgLmfmW0P/Dqsx83Mw3sPAEbM7ELgW7myfTvwCTM7OcT1OPAWYEmLbTsT2B5Y6+5nkBXkv0br/Y9oPfuHhPSTsJw10TpPNLO/BJ4OTJjZ74HfRMt8TrTtO+frDdgh3xaAM4DPROt9NCrzpdHr383H4O6nkV0Ill/uITS2uTdE9dZQR+5+ipkdnK//UFcjIcbDzOyxqK4fBB4juz3Ek6GMG5YR4nzc3S82s/3J9oXtgauBw8N7PgX8AVhuZtcDl4S6eb2ZfRFYH7WPg6O4VkR1/6OC8vkt8OMw3ysK2vWTUQzH5ffp8L54P4/3USuY/lnYxqkQR7yMuF3vENX1C/L1Fpb1Fhr3p3g/fiIqn035+UNdx2W+c1TGN0Rt4f4ozhPJkvOXw/9/B9zu7v8WEveRYRvOITu4/87MziLKYbShiqGSb5AdXV4dkt8cWeO7xN1PAX7u7ieRFcyLgUuBk8PPYWEZV7j7bPj7p8Cj7n6eu58LPAqsAZ509/cC94f59gZ2dffPkF3ZGU/fAfzY3c8C7gTuBr4EXBziil//IDAWfuqnsRuADe7+SbIrSr8F/Bdwaqj8eJ0UbP/uwC4h9gfJduQPufuHyXaoB939DcBVZA2oXj7/mCufek/gvFAezbbtEnc/xd2/A9xFlmjq4vXG67kD2OTuXwzbEq+TUC57he16rGCZ9W2vl3Fcb3FboGC9cZnHr8cxULDceDqut7iOYOv6X+/uf0e2g+7P1nX9lVC3byU7WyxaxlXhB+A64H+A88N7bgz/X+fu7wFqgAOr3f0pd7/I3d8GPBS1jziuuF0Xlc9FZPvox4CLC8o4jiHepyn4X7yPFk2fm5suWkZRu87XdVxvsPX+FO8LcfnE8xeVeVzGcT0W7Qsfdfdr3P1qshGDHwO4+/lkCfu6UN7fAC6nOIeVVkWP+yFCgzaz5WQb9gZgWTia3wLg7meY2fvINuQK4LXAD8Jrm28Z6+5XWHaq+ylgEvgkWQU8EnqN9cvxHwnrBriPrILqt9hbR7bz/iRMbwC+E9Z5jJmdD/zI3a8Lr/8CuMbdrwcws3rvpEbWSziErKf8uLv/PLz/drJ7tTxoZpMhBtz9q2b28tz23w0cb2avCdv9q7BtY2Q7/L5mdibwPbL6+ai7X2lmY8B/hjiuIDvSn0uWcH4OXB/We4+7fysc6V9Jdh913L0W4q+rr/f1wAeAz5M1qH2AK4EDgXVmdmqowx8Cbw7r/GJYxkHAPaEn9AvgaWGZK8iS4Llm9kqyXspXyXp+G83stPD3wyG2M8zs3WGZDwL3hvU+QpZIrjCzA8N7ngDWh9efIqv/9aFOfhGWcYuZGXBzeM/9ZrYi1+YeAtYC15P1pp4GPBfYcltD+Ciw0d3XmtndwD6WndZeBLwzlEl9x7/V3deSOwUOPhaWPwmc7u71nhthB6/7Xu7vB0P9zwA7uvsPo2Vub2Znk9XlA2zpfF0GnEDW63sd8A9m9s1QPg+b2bGEm8W5+2pg852vLBtf/56Z/QXZGcAvQwx3kPUUXxh6uJ/JxXEHWf3UyNrtn+aSaQ3YKTd9JbBb6L2uZUs7vLO+3JArlpG1xZeStesdgPtydf0QWZI7jy37+m3Am8IZ3wfIDob1RPgA2dnfdmQdwNeG7f5bM7sC+FqYz8P0e8mS8p/ktv9WsrP/G0JZ3U12ZvmWUJ5vC2V6e71g3H0DWY6pT18Q/rwiV+bHsWVf2I82dfwCHMuGPm4n6+GNAuNkR767yJLp2vqswFFkBb8tcBNwVOgZxct8F1mB3kZ2X3DIKvls4HXu/nbLxpY8t9xtyQr+zhBHvN7/yy8DeD5ZJV0WDhZX5adDHJeG5Y2TNYDnRNP35ON093eY2dEt1rtnKJvxUAb35cuDLJFuXkc4tTs6LI8wzy1R+exJdoAYB27K9SLzZfruaD3bRHHdFi3zj8l6CZfmyuPz0Xs8ml5D1suvL+PZ0baOF5RxQ7kXrGOHUK/19nRE+HssVz5xe9mRxja5bbTtBxXEsTJ6z/OZp73E5RuWcVJ++939HUXzRe9pqFt3f2v0elwee9LYBu8Ftstt2z203r/itnAnW9d9XD5xGV9OY5t8Lrn2Espzc72Fg2i8b2xLY92ujV5v2HfCfh/HvjPz1/U+5NpgaC/12Oq54gga2+lcFEfD/lamXmNx3EX1Mp8qhkpudfePhL+PBNaEU2cP08eS9bQeJhsLGiHrRW0eGyywLzDi7heTVebtwIW5IQDIeo755d4a1luPI15vvIxLyMaqloaxxHgasrHia9lyGlqfrp9ix3HSZL0X5NZ7Jllv9qKwjLg84nXUl/nr3DLj9c5EyywSrycuj3iZl5D1NPPlEb8n3rb9omXE21pUxvH/4nXcGrWn+jIvzm1rHHvcJuNtL4ojfk+r9lIk3v4y4rqNFbWffPvYKdq2MvtXPE9R3cfbGs8Txx23l7je6ttatM82yxVF+30ce6u6jtsgbJ0r4nniOIr283aVqZfm3L2jP8BLc38fVzC9f256Gdlp9UeBTwMHN1nmMcDLw9+HAQfkXntV+B0vt9V6G5YBvCxa58uaxDIGnFY0HcfZJK6i2PPL2Ko8CtYZL7NovQ3vKdiOhvUUlEdc5luVR8F75l1GwbYWLTOuh3iZDfXapHzi2OO2EG97URzxe+ZtL2Xabcn9p6FuW5V5q/ZT1J5KtIUydR/PE7fJuB6L6m1R+2yT2Oet6ybtZd42VRBH2/Xaqszbfb/uVSIikpi+vABHRESaU+IWEUmMEreISGKUuEVEEqPELSKSmP8HDMxlx/j+CzEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0xdb6ef98>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<matplotlib.figure.Figure at 0xe5e7e80>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mergings = linkage(cric_df_2, method = \"complete\", metric='euclidean')\n",
    "dendrogram(mergings)\n",
    "plt.figure(figsize=(16,8))\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "clusterCut = pd.DataFrame(pd.Series(cut_tree(mergings, n_clusters = 4).reshape(-1,)), columns=['ClusterID'])\n",
    "cdf = pd.concat([cric_df_1, clusterCut, cric_df['Player']], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>SR</th>\n",
       "      <th>Ave</th>\n",
       "      <th>ClusterID</th>\n",
       "      <th>Player</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>86.23</td>\n",
       "      <td>44.83</td>\n",
       "      <td>0</td>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78.86</td>\n",
       "      <td>41.98</td>\n",
       "      <td>0</td>\n",
       "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>80.39</td>\n",
       "      <td>42.03</td>\n",
       "      <td>0</td>\n",
       "      <td>RT Ponting (AUS/ICC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91.20</td>\n",
       "      <td>32.36</td>\n",
       "      <td>1</td>\n",
       "      <td>ST Jayasuriya (Asia/SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78.96</td>\n",
       "      <td>33.37</td>\n",
       "      <td>2</td>\n",
       "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      SR    Ave  ClusterID                       Player\n",
       "0  86.23  44.83          0         SR Tendulkar (INDIA)\n",
       "1  78.86  41.98          0  KC Sangakkara (Asia/ICC/SL)\n",
       "2  80.39  42.03          0         RT Ponting (AUS/ICC)\n",
       "3  91.20  32.36          1      ST Jayasuriya (Asia/SL)\n",
       "4  78.96  33.37          2   DPMD Jayawardene (Asia/SL)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>SR</th>\n",
       "      <th>Ave</th>\n",
       "      <th>ClusterID</th>\n",
       "      <th>Player</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>86.23</td>\n",
       "      <td>44.83</td>\n",
       "      <td>0</td>\n",
       "      <td>SR Tendulkar (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78.86</td>\n",
       "      <td>41.98</td>\n",
       "      <td>0</td>\n",
       "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>80.39</td>\n",
       "      <td>42.03</td>\n",
       "      <td>0</td>\n",
       "      <td>RT Ponting (AUS/ICC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91.20</td>\n",
       "      <td>32.36</td>\n",
       "      <td>1</td>\n",
       "      <td>ST Jayasuriya (Asia/SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>78.96</td>\n",
       "      <td>33.37</td>\n",
       "      <td>2</td>\n",
       "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74.24</td>\n",
       "      <td>39.52</td>\n",
       "      <td>0</td>\n",
       "      <td>Inzamam-ul-Haq (Asia/PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>72.89</td>\n",
       "      <td>44.36</td>\n",
       "      <td>0</td>\n",
       "      <td>JH Kallis (Afr/ICC/SA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>73.70</td>\n",
       "      <td>41.02</td>\n",
       "      <td>0</td>\n",
       "      <td>SC Ganguly (Asia/INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>71.24</td>\n",
       "      <td>39.16</td>\n",
       "      <td>0</td>\n",
       "      <td>R Dravid (Asia/ICC/INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>79.51</td>\n",
       "      <td>40.48</td>\n",
       "      <td>0</td>\n",
       "      <td>BC Lara (ICC/WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>86.23</td>\n",
       "      <td>39.27</td>\n",
       "      <td>0</td>\n",
       "      <td>TM Dilshan (SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>75.10</td>\n",
       "      <td>41.71</td>\n",
       "      <td>0</td>\n",
       "      <td>Mohammad Yousuf (Asia/PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>96.94</td>\n",
       "      <td>35.89</td>\n",
       "      <td>1</td>\n",
       "      <td>AC Gilchrist (AUS/ICC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>88.69</td>\n",
       "      <td>51.32</td>\n",
       "      <td>3</td>\n",
       "      <td>MS Dhoni (Asia/INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>74.02</td>\n",
       "      <td>36.92</td>\n",
       "      <td>2</td>\n",
       "      <td>M Azharuddin (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>100.25</td>\n",
       "      <td>53.55</td>\n",
       "      <td>3</td>\n",
       "      <td>AB de Villiers (Afr/SA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>81.13</td>\n",
       "      <td>34.90</td>\n",
       "      <td>2</td>\n",
       "      <td>PA de Silva (SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>85.11</td>\n",
       "      <td>37.33</td>\n",
       "      <td>0</td>\n",
       "      <td>CH Gayle (ICC/WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>80.67</td>\n",
       "      <td>39.21</td>\n",
       "      <td>0</td>\n",
       "      <td>Saeed Anwar (PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>70.74</td>\n",
       "      <td>41.60</td>\n",
       "      <td>0</td>\n",
       "      <td>S Chanderpaul (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>87.67</td>\n",
       "      <td>36.55</td>\n",
       "      <td>0</td>\n",
       "      <td>Yuvraj Singh (Asia/INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>63.09</td>\n",
       "      <td>41.37</td>\n",
       "      <td>0</td>\n",
       "      <td>DL Haynes (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>67.72</td>\n",
       "      <td>37.57</td>\n",
       "      <td>0</td>\n",
       "      <td>MS Atapattu (SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>76.90</td>\n",
       "      <td>39.35</td>\n",
       "      <td>0</td>\n",
       "      <td>ME Waugh (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>104.33</td>\n",
       "      <td>35.05</td>\n",
       "      <td>1</td>\n",
       "      <td>V Sehwag (Asia/ICC/INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>90.99</td>\n",
       "      <td>53.94</td>\n",
       "      <td>3</td>\n",
       "      <td>V Kohli (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>83.26</td>\n",
       "      <td>36.13</td>\n",
       "      <td>0</td>\n",
       "      <td>HH Gibbs (SA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>117.00</td>\n",
       "      <td>23.57</td>\n",
       "      <td>1</td>\n",
       "      <td>Shahid Afridi (Asia/ICC/PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>71.49</td>\n",
       "      <td>32.40</td>\n",
       "      <td>2</td>\n",
       "      <td>SP Fleming (ICC/NZ)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>78.98</td>\n",
       "      <td>44.58</td>\n",
       "      <td>0</td>\n",
       "      <td>MJ Clarke (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>78.96</td>\n",
       "      <td>43.80</td>\n",
       "      <td>0</td>\n",
       "      <td>ML Hayden (AUS/ICC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>96.37</td>\n",
       "      <td>30.41</td>\n",
       "      <td>1</td>\n",
       "      <td>BB McCullum (NZ)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>72.56</td>\n",
       "      <td>44.61</td>\n",
       "      <td>0</td>\n",
       "      <td>DM Jones (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>65.13</td>\n",
       "      <td>37.04</td>\n",
       "      <td>0</td>\n",
       "      <td>DC Boon (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>80.90</td>\n",
       "      <td>35.11</td>\n",
       "      <td>2</td>\n",
       "      <td>JN Rhodes (SA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>75.58</td>\n",
       "      <td>33.01</td>\n",
       "      <td>2</td>\n",
       "      <td>Mohammad Hafeez (PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>63.31</td>\n",
       "      <td>32.09</td>\n",
       "      <td>2</td>\n",
       "      <td>Rameez Raja (PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>75.74</td>\n",
       "      <td>42.67</td>\n",
       "      <td>0</td>\n",
       "      <td>RR Sarwan (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>88.62</td>\n",
       "      <td>38.73</td>\n",
       "      <td>0</td>\n",
       "      <td>EJG Morgan (ENG/IRE)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>76.63</td>\n",
       "      <td>35.34</td>\n",
       "      <td>2</td>\n",
       "      <td>CL Hooper (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>90.44</td>\n",
       "      <td>40.54</td>\n",
       "      <td>0</td>\n",
       "      <td>SR Watson (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>78.31</td>\n",
       "      <td>34.38</td>\n",
       "      <td>2</td>\n",
       "      <td>Tamim Iqbal (BDESH)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>93.76</td>\n",
       "      <td>35.46</td>\n",
       "      <td>1</td>\n",
       "      <td>SK Raina (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>76.47</td>\n",
       "      <td>38.64</td>\n",
       "      <td>0</td>\n",
       "      <td>WJ Cronje (SA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>87.73</td>\n",
       "      <td>43.30</td>\n",
       "      <td>0</td>\n",
       "      <td>MJ Guptill (NZ)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>87.16</td>\n",
       "      <td>48.15</td>\n",
       "      <td>0</td>\n",
       "      <td>MEK Hussey (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>84.56</td>\n",
       "      <td>42.46</td>\n",
       "      <td>0</td>\n",
       "      <td>RG Sharma (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>77.16</td>\n",
       "      <td>37.87</td>\n",
       "      <td>0</td>\n",
       "      <td>IR Bell (ENG)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>69.80</td>\n",
       "      <td>37.47</td>\n",
       "      <td>0</td>\n",
       "      <td>A Jadeja (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>77.73</td>\n",
       "      <td>40.80</td>\n",
       "      <td>0</td>\n",
       "      <td>DR Martyn (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>74.47</td>\n",
       "      <td>34.82</td>\n",
       "      <td>2</td>\n",
       "      <td>BRM Taylor (ZIM)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>85.25</td>\n",
       "      <td>39.68</td>\n",
       "      <td>0</td>\n",
       "      <td>G Gambhir (INDIA)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>66.18</td>\n",
       "      <td>30.50</td>\n",
       "      <td>2</td>\n",
       "      <td>ADR Campbell (ZIM)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>76.24</td>\n",
       "      <td>34.30</td>\n",
       "      <td>2</td>\n",
       "      <td>MN Samuels (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>60.57</td>\n",
       "      <td>29.49</td>\n",
       "      <td>2</td>\n",
       "      <td>RS Mahanama (SL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>64.92</td>\n",
       "      <td>45.03</td>\n",
       "      <td>0</td>\n",
       "      <td>CG Greenidge (WI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>73.75</td>\n",
       "      <td>43.40</td>\n",
       "      <td>0</td>\n",
       "      <td>Misbah-ul-Haq (PAK)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>76.98</td>\n",
       "      <td>35.36</td>\n",
       "      <td>2</td>\n",
       "      <td>PD Collingwood (ENG)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>92.44</td>\n",
       "      <td>39.75</td>\n",
       "      <td>0</td>\n",
       "      <td>A Symonds (AUS)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>81.25</td>\n",
       "      <td>29.70</td>\n",
       "      <td>2</td>\n",
       "      <td>Abdul Razzaq (Asia/PAK)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>79 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        SR    Ave  ClusterID                        Player\n",
       "0    86.23  44.83          0          SR Tendulkar (INDIA)\n",
       "1    78.86  41.98          0   KC Sangakkara (Asia/ICC/SL)\n",
       "2    80.39  42.03          0          RT Ponting (AUS/ICC)\n",
       "3    91.20  32.36          1       ST Jayasuriya (Asia/SL)\n",
       "4    78.96  33.37          2    DPMD Jayawardene (Asia/SL)\n",
       "5    74.24  39.52          0     Inzamam-ul-Haq (Asia/PAK)\n",
       "6    72.89  44.36          0        JH Kallis (Afr/ICC/SA)\n",
       "7    73.70  41.02          0       SC Ganguly (Asia/INDIA)\n",
       "8    71.24  39.16          0     R Dravid (Asia/ICC/INDIA)\n",
       "9    79.51  40.48          0              BC Lara (ICC/WI)\n",
       "10   86.23  39.27          0               TM Dilshan (SL)\n",
       "11   75.10  41.71          0    Mohammad Yousuf (Asia/PAK)\n",
       "12   96.94  35.89          1        AC Gilchrist (AUS/ICC)\n",
       "13   88.69  51.32          3         MS Dhoni (Asia/INDIA)\n",
       "14   74.02  36.92          2          M Azharuddin (INDIA)\n",
       "15  100.25  53.55          3       AB de Villiers (Afr/SA)\n",
       "16   81.13  34.90          2              PA de Silva (SL)\n",
       "17   85.11  37.33          0             CH Gayle (ICC/WI)\n",
       "18   80.67  39.21          0             Saeed Anwar (PAK)\n",
       "19   70.74  41.60          0            S Chanderpaul (WI)\n",
       "20   87.67  36.55          0     Yuvraj Singh (Asia/INDIA)\n",
       "21   63.09  41.37          0                DL Haynes (WI)\n",
       "22   67.72  37.57          0              MS Atapattu (SL)\n",
       "23   76.90  39.35          0                ME Waugh (AUS)\n",
       "24  104.33  35.05          1     V Sehwag (Asia/ICC/INDIA)\n",
       "25   90.99  53.94          3               V Kohli (INDIA)\n",
       "26   83.26  36.13          0                 HH Gibbs (SA)\n",
       "27  117.00  23.57          1  Shahid Afridi (Asia/ICC/PAK)\n",
       "28   71.49  32.40          2           SP Fleming (ICC/NZ)\n",
       "29   78.98  44.58          0               MJ Clarke (AUS)\n",
       "..     ...    ...        ...                           ...\n",
       "49   78.96  43.80          0           ML Hayden (AUS/ICC)\n",
       "50   96.37  30.41          1              BB McCullum (NZ)\n",
       "51   72.56  44.61          0                DM Jones (AUS)\n",
       "52   65.13  37.04          0                 DC Boon (AUS)\n",
       "53   80.90  35.11          2                JN Rhodes (SA)\n",
       "54   75.58  33.01          2         Mohammad Hafeez (PAK)\n",
       "55   63.31  32.09          2             Rameez Raja (PAK)\n",
       "56   75.74  42.67          0                RR Sarwan (WI)\n",
       "57   88.62  38.73          0          EJG Morgan (ENG/IRE)\n",
       "58   76.63  35.34          2                CL Hooper (WI)\n",
       "59   90.44  40.54          0               SR Watson (AUS)\n",
       "60   78.31  34.38          2           Tamim Iqbal (BDESH)\n",
       "61   93.76  35.46          1              SK Raina (INDIA)\n",
       "62   76.47  38.64          0                WJ Cronje (SA)\n",
       "63   87.73  43.30          0               MJ Guptill (NZ)\n",
       "64   87.16  48.15          0              MEK Hussey (AUS)\n",
       "65   84.56  42.46          0             RG Sharma (INDIA)\n",
       "66   77.16  37.87          0                 IR Bell (ENG)\n",
       "67   69.80  37.47          0              A Jadeja (INDIA)\n",
       "68   77.73  40.80          0               DR Martyn (AUS)\n",
       "69   74.47  34.82          2              BRM Taylor (ZIM)\n",
       "70   85.25  39.68          0             G Gambhir (INDIA)\n",
       "71   66.18  30.50          2            ADR Campbell (ZIM)\n",
       "72   76.24  34.30          2               MN Samuels (WI)\n",
       "73   60.57  29.49          2              RS Mahanama (SL)\n",
       "74   64.92  45.03          0             CG Greenidge (WI)\n",
       "75   73.75  43.40          0           Misbah-ul-Haq (PAK)\n",
       "76   76.98  35.36          2          PD Collingwood (ENG)\n",
       "77   92.44  39.75          0               A Symonds (AUS)\n",
       "78   81.25  29.70          2       Abdul Razzaq (Asia/PAK)\n",
       "\n",
       "[79 rows x 4 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ClusterID</th>\n",
       "      <th>Avg</th>\n",
       "      <th>SR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>41.066829</td>\n",
       "      <td>78.366829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>32.123333</td>\n",
       "      <td>99.933333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>33.489630</td>\n",
       "      <td>74.390741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>52.528000</td>\n",
       "      <td>88.628000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ClusterID        Avg         SR\n",
       "0          0  41.066829  78.366829\n",
       "1          1  32.123333  99.933333\n",
       "2          2  33.489630  74.390741\n",
       "3          3  52.528000  88.628000"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cluster_avg = pd.DataFrame(cdf.groupby([\"ClusterID\"]).Ave.mean())\n",
    "cluster_sr = pd.DataFrame(cdf.groupby([\"ClusterID\"]).SR.mean())\n",
    "df = pd.concat([pd.Series([0,1,2,3]), cluster_avg, cluster_sr], axis=1)\n",
    "df.columns = [\"ClusterID\", \"Avg\", \"SR\"]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}