Clean Bowler.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "62eafdc7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import math"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b7514cc0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"data/malinga.csv\")\n",
    "df.drop(labels=\"Unnamed: 0\",axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f17bf942",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Bowls_Bowled\"]=df[\"Overs\"]*6\n",
    "df[\"Bowls_Bowled\"]=df[\"Bowls_Bowled\"].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a7dfe6a8",
   "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>Overs</th>\n",
       "      <th>Mdns</th>\n",
       "      <th>Runs</th>\n",
       "      <th>Wkts</th>\n",
       "      <th>Econ</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Inns</th>\n",
       "      <th>Opposition</th>\n",
       "      <th>Ground</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Bowls_Bowled</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14.0</td>\n",
       "      <td>3</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3.57</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Darwin</td>\n",
       "      <td>1 Jul 2004</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>15.1</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>4</td>\n",
       "      <td>2.76</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Darwin</td>\n",
       "      <td>1 Jul 2004</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>29.2</td>\n",
       "      <td>2</td>\n",
       "      <td>149</td>\n",
       "      <td>4</td>\n",
       "      <td>5.07</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Cairns</td>\n",
       "      <td>9 Jul 2004</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>4.60</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Cairns</td>\n",
       "      <td>9 Jul 2004</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13.0</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>3.92</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>11 Aug 2004</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>13.0</td>\n",
       "      <td>1</td>\n",
       "      <td>54</td>\n",
       "      <td>3</td>\n",
       "      <td>4.15</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>11 Aug 2004</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Faisalabad</td>\n",
       "      <td>20 Oct 2004</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>2.16</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Faisalabad</td>\n",
       "      <td>20 Oct 2004</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>34.0</td>\n",
       "      <td>5</td>\n",
       "      <td>130</td>\n",
       "      <td>4</td>\n",
       "      <td>3.82</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Napier</td>\n",
       "      <td>4 Apr 2005</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>24.4</td>\n",
       "      <td>4</td>\n",
       "      <td>80</td>\n",
       "      <td>5</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Napier</td>\n",
       "      <td>4 Apr 2005</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>34.0</td>\n",
       "      <td>2</td>\n",
       "      <td>124</td>\n",
       "      <td>2</td>\n",
       "      <td>3.64</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>11 Apr 2005</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>71</td>\n",
       "      <td>4</td>\n",
       "      <td>5.07</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v West Indies</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>13 Jul 2005</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12.0</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v West Indies</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>13 Jul 2005</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>9.0</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2.44</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v West Indies</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>22 Jul 2005</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>12.0</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>4.00</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>v West Indies</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>22 Jul 2005</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>5.50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (RPS)</td>\n",
       "      <td>12 Sep 2005</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>5.33</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (RPS)</td>\n",
       "      <td>12 Sep 2005</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>3.55</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>20 Sep 2005</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>4.42</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>20 Sep 2005</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>32.0</td>\n",
       "      <td>4</td>\n",
       "      <td>113</td>\n",
       "      <td>3</td>\n",
       "      <td>3.53</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v India</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>18 Dec 2005</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>12.0</td>\n",
       "      <td>2</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v India</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>18 Dec 2005</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>16.5</td>\n",
       "      <td>3</td>\n",
       "      <td>57</td>\n",
       "      <td>4</td>\n",
       "      <td>3.38</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Chittagong</td>\n",
       "      <td>28 Feb 2006</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13.0</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>3.15</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Chittagong</td>\n",
       "      <td>28 Feb 2006</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20.0</td>\n",
       "      <td>1</td>\n",
       "      <td>73</td>\n",
       "      <td>2</td>\n",
       "      <td>3.65</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Bogra</td>\n",
       "      <td>8 Mar 2006</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>14.1</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>3.60</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Bogra</td>\n",
       "      <td>8 Mar 2006</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>12.0</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>26 Mar 2006</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>13.0</td>\n",
       "      <td>3</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>3.38</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>26 Mar 2006</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>3.16</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>3 Apr 2006</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6.2</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>5.21</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>3 Apr 2006</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>13.3</td>\n",
       "      <td>2</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>5.03</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v England</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>25 May 2006</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>4.14</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v England</td>\n",
       "      <td>Birmingham</td>\n",
       "      <td>25 May 2006</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>23.1</td>\n",
       "      <td>3</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>2.67</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v England</td>\n",
       "      <td>Nottingham</td>\n",
       "      <td>2 Jun 2006</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>3.42</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v England</td>\n",
       "      <td>Nottingham</td>\n",
       "      <td>2 Jun 2006</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>10.0</td>\n",
       "      <td>2</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>3.80</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>27 Jul 2006</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>16.2</td>\n",
       "      <td>0</td>\n",
       "      <td>85</td>\n",
       "      <td>1</td>\n",
       "      <td>5.20</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>27 Jul 2006</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>18.0</td>\n",
       "      <td>4</td>\n",
       "      <td>81</td>\n",
       "      <td>3</td>\n",
       "      <td>4.50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>4 Aug 2006</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>4.58</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v South Africa</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>4 Aug 2006</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>19.4</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>2.18</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>7 Dec 2006</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>8.75</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>7 Dec 2006</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>18.0</td>\n",
       "      <td>4</td>\n",
       "      <td>68</td>\n",
       "      <td>5</td>\n",
       "      <td>3.77</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>15 Dec 2006</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>16.0</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>2</td>\n",
       "      <td>3.87</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>15 Dec 2006</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>4.42</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>25 Jun 2007</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>17.0</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>4</td>\n",
       "      <td>4.70</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>25 Jun 2007</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>2.77</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>3 Jul 2007</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>15.0</td>\n",
       "      <td>1</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>5.73</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>3 Jul 2007</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>10.0</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>4.10</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>11 Jul 2007</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>4.60</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>11 Jul 2007</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>35.0</td>\n",
       "      <td>6</td>\n",
       "      <td>156</td>\n",
       "      <td>1</td>\n",
       "      <td>4.45</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>16 Nov 2007</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>12.0</td>\n",
       "      <td>0</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>5.08</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>16 Nov 2007</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>20.0</td>\n",
       "      <td>2</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>4.30</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v England</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>1 Dec 2007</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>15.0</td>\n",
       "      <td>3</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>2.60</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>v England</td>\n",
       "      <td>Kandy</td>\n",
       "      <td>1 Dec 2007</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>24.0</td>\n",
       "      <td>3</td>\n",
       "      <td>78</td>\n",
       "      <td>3</td>\n",
       "      <td>3.25</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v England</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>9 Dec 2007</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>4.62</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>v England</td>\n",
       "      <td>Colombo (SSC)</td>\n",
       "      <td>9 Dec 2007</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>9.0</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>2.88</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v England</td>\n",
       "      <td>Galle</td>\n",
       "      <td>18 Dec 2007</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>20.0</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>2.10</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>v England</td>\n",
       "      <td>Galle</td>\n",
       "      <td>18 Dec 2007</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>13.0</td>\n",
       "      <td>0</td>\n",
       "      <td>55</td>\n",
       "      <td>2</td>\n",
       "      <td>4.23</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v India</td>\n",
       "      <td>Galle</td>\n",
       "      <td>18 Jul 2010</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>17.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>2.94</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>v India</td>\n",
       "      <td>Galle</td>\n",
       "      <td>18 Jul 2010</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>30.0</td>\n",
       "      <td>3</td>\n",
       "      <td>119</td>\n",
       "      <td>3</td>\n",
       "      <td>3.96</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v India</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>3 Aug 2010</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>4.08</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>v India</td>\n",
       "      <td>Colombo (PSS)</td>\n",
       "      <td>3 Aug 2010</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Overs  Mdns  Runs  Wkts  Econ  Pos  Inns      Opposition         Ground  \\\n",
       "0    14.0     3    50     2  3.57    2     1     v Australia         Darwin   \n",
       "1    15.1     3    42     4  2.76    3     3     v Australia         Darwin   \n",
       "2    29.2     2   149     4  5.07    4     1     v Australia         Cairns   \n",
       "3     5.0     0    23     0  4.60    3     3     v Australia         Cairns   \n",
       "4    13.0     1    51     1  3.92    2     2  v South Africa  Colombo (SSC)   \n",
       "5    13.0     1    54     3  4.15    2     4  v South Africa  Colombo (SSC)   \n",
       "6    10.0     1    50     1  5.00    2     2      v Pakistan     Faisalabad   \n",
       "7     6.0     2    13     0  2.16    2     4      v Pakistan     Faisalabad   \n",
       "8    34.0     5   130     4  3.82    2     1   v New Zealand         Napier   \n",
       "9    24.4     4    80     5  3.24    2     3   v New Zealand         Napier   \n",
       "10   34.0     2   124     2  3.64    2     2   v New Zealand     Wellington   \n",
       "11   14.0     1    71     4  5.07    2     1   v West Indies  Colombo (SSC)   \n",
       "12   12.0     5    22     0  1.83    2     3   v West Indies  Colombo (SSC)   \n",
       "13    9.0     3    22     0  2.44    2     2   v West Indies          Kandy   \n",
       "14   12.0     2    48     1  4.00    1     4   v West Indies          Kandy   \n",
       "15    8.0     1    44     1  5.50    2     1    v Bangladesh  Colombo (RPS)   \n",
       "16    6.0     1    32     3  5.33    2     3    v Bangladesh  Colombo (RPS)   \n",
       "17    9.0     1    32     2  3.55    2     2    v Bangladesh  Colombo (PSS)   \n",
       "18    7.0     0    31     0  4.42    2     3    v Bangladesh  Colombo (PSS)   \n",
       "19   32.0     4   113     3  3.53    1     1         v India      Ahmedabad   \n",
       "20   12.0     2    63     1  5.25    1     3         v India      Ahmedabad   \n",
       "21   16.5     3    57     4  3.38    1     1    v Bangladesh     Chittagong   \n",
       "22   13.0     2    41     0  3.15    1     3    v Bangladesh     Chittagong   \n",
       "23   20.0     1    73     2  3.65    1     1    v Bangladesh          Bogra   \n",
       "24   14.1     1    51     3  3.60    1     3    v Bangladesh          Bogra   \n",
       "25   12.0     3    30     3  2.50    1     2      v Pakistan  Colombo (SSC)   \n",
       "26   13.0     3    44     0  3.38    1     4      v Pakistan  Colombo (SSC)   \n",
       "27    6.0     2    19     0  3.16    1     2      v Pakistan          Kandy   \n",
       "28    6.2     0    33     1  5.21    3     4      v Pakistan          Kandy   \n",
       "29   13.3     2    68     2  5.03    2     2       v England     Birmingham   \n",
       "30    7.0     1    29     0  4.14    2     4       v England     Birmingham   \n",
       "31   23.1     3    62     2  2.67    2     2       v England     Nottingham   \n",
       "32    7.0     0    24     0  3.42    2     4       v England     Nottingham   \n",
       "33   10.0     2    38     0  3.80    1     1  v South Africa  Colombo (SSC)   \n",
       "34   16.2     0    85     1  5.20    1     3  v South Africa  Colombo (SSC)   \n",
       "35   18.0     4    81     3  4.50    2     1  v South Africa  Colombo (PSS)   \n",
       "36   12.0     1    55     0  4.58    2     3  v South Africa  Colombo (PSS)   \n",
       "37   19.4     2    43     2  2.18    2     2   v New Zealand   Christchurch   \n",
       "38    4.0     1    35     0  8.75    2     4   v New Zealand   Christchurch   \n",
       "39   18.0     4    68     5  3.77    2     2   v New Zealand     Wellington   \n",
       "40   16.0     1    62     2  3.87    2     4   v New Zealand     Wellington   \n",
       "41    7.0     0    31     1  4.42    2     1    v Bangladesh  Colombo (SSC)   \n",
       "42   17.0     2    80     4  4.70    2     3    v Bangladesh  Colombo (SSC)   \n",
       "43    9.0     1    25     4  2.77    2     1    v Bangladesh  Colombo (PSS)   \n",
       "44   15.0     1    86     0  5.73    2     3    v Bangladesh  Colombo (PSS)   \n",
       "45   10.0     2    41     1  4.10    1     1    v Bangladesh          Kandy   \n",
       "46   10.0     0    46     2  4.60    1     3    v Bangladesh          Kandy   \n",
       "47   35.0     6   156     1  4.45    1     1     v Australia         Hobart   \n",
       "48   12.0     0    61     1  5.08    1     3     v Australia         Hobart   \n",
       "49   20.0     2    86     1  4.30    2     2       v England          Kandy   \n",
       "50   15.0     3    39     1  2.60    2     4       v England          Kandy   \n",
       "51   24.0     3    78     3  3.25    2     1       v England  Colombo (SSC)   \n",
       "52    8.0     1    37     0  4.62    2     3       v England  Colombo (SSC)   \n",
       "53    9.0     2    26     1  2.88    2     2       v England          Galle   \n",
       "54   20.0     3    42     0  2.10    3     3       v England          Galle   \n",
       "55   13.0     0    55     2  4.23    1     2         v India          Galle   \n",
       "56   17.0     2    50     5  2.94    1     3         v India          Galle   \n",
       "57   30.0     3   119     3  3.96    1     2         v India  Colombo (PSS)   \n",
       "58   12.0     1    49     0  4.08    1     4         v India  Colombo (PSS)   \n",
       "\n",
       "     Start Date  Bowls_Bowled  \n",
       "0    1 Jul 2004            84  \n",
       "1    1 Jul 2004            90  \n",
       "2    9 Jul 2004           175  \n",
       "3    9 Jul 2004            30  \n",
       "4   11 Aug 2004            78  \n",
       "5   11 Aug 2004            78  \n",
       "6   20 Oct 2004            60  \n",
       "7   20 Oct 2004            36  \n",
       "8    4 Apr 2005           204  \n",
       "9    4 Apr 2005           146  \n",
       "10  11 Apr 2005           204  \n",
       "11  13 Jul 2005            84  \n",
       "12  13 Jul 2005            72  \n",
       "13  22 Jul 2005            54  \n",
       "14  22 Jul 2005            72  \n",
       "15  12 Sep 2005            48  \n",
       "16  12 Sep 2005            36  \n",
       "17  20 Sep 2005            54  \n",
       "18  20 Sep 2005            42  \n",
       "19  18 Dec 2005           192  \n",
       "20  18 Dec 2005            72  \n",
       "21  28 Feb 2006            99  \n",
       "22  28 Feb 2006            78  \n",
       "23   8 Mar 2006           120  \n",
       "24   8 Mar 2006            84  \n",
       "25  26 Mar 2006            72  \n",
       "26  26 Mar 2006            78  \n",
       "27   3 Apr 2006            36  \n",
       "28   3 Apr 2006            37  \n",
       "29  25 May 2006            79  \n",
       "30  25 May 2006            42  \n",
       "31   2 Jun 2006           138  \n",
       "32   2 Jun 2006            42  \n",
       "33  27 Jul 2006            60  \n",
       "34  27 Jul 2006            97  \n",
       "35   4 Aug 2006           108  \n",
       "36   4 Aug 2006            72  \n",
       "37   7 Dec 2006           116  \n",
       "38   7 Dec 2006            24  \n",
       "39  15 Dec 2006           108  \n",
       "40  15 Dec 2006            96  \n",
       "41  25 Jun 2007            42  \n",
       "42  25 Jun 2007           102  \n",
       "43   3 Jul 2007            54  \n",
       "44   3 Jul 2007            90  \n",
       "45  11 Jul 2007            60  \n",
       "46  11 Jul 2007            60  \n",
       "47  16 Nov 2007           210  \n",
       "48  16 Nov 2007            72  \n",
       "49   1 Dec 2007           120  \n",
       "50   1 Dec 2007            90  \n",
       "51   9 Dec 2007           144  \n",
       "52   9 Dec 2007            48  \n",
       "53  18 Dec 2007            54  \n",
       "54  18 Dec 2007           120  \n",
       "55  18 Jul 2010            78  \n",
       "56  18 Jul 2010           102  \n",
       "57   3 Aug 2010           180  \n",
       "58   3 Aug 2010            72  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e97e0f71",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aa3bb52b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d6ee8842",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "deac5444",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "222f6145",
   "metadata": {},
   "outputs": [],
   "source": [
    "bowlers={'ashwin',\n",
    " 'ashwin1',\n",
    " 'badree',\n",
    " 'kumble',\n",
    "'mitchell',\n",
    " 'kumble1',\n",
    " 'kumblesp',\n",
    " 'malinga',\n",
    " 'malinga1','mendis','murali',\n",
    " 'narine','southee',\n",
    " 'steyn','warne'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "ee05d8e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "def clean_bowler(file):\n",
    "    fe=f\"data/{file}.csv\"\n",
    "    df=pd.read_csv(fe)\n",
    "    df.drop(labels=\"Unnamed: 0\",axis=1,inplace=True) #Remove the Unnamed column\n",
    "    df[\"Bowls_Bowled\"]=df[\"Overs\"]*6\n",
    "    #df[\"Bowls_Bowled\"]=df[\"Bowls_Bowled\"].astype(int)\n",
    "    a=[]\n",
    "    # Remove entries with DNB,TDNB and absent\n",
    "    for i in range(0,len(df)):\n",
    "        \n",
    "        if(df.Overs[i]==\"DNB\" or df.Overs[i]==\"TDNB\" or df.Overs[i]==\"absent\" or df.Overs[i]==\"-\"):\n",
    "            a.append(i)\n",
    "    df.drop(a,inplace=True)\n",
    "    df.reset_index(drop=True, inplace=True)\n",
    "    df[\"Overs\"]=df[\"Overs\"].astype(float)\n",
    "    for i in range(0,len(df)):\n",
    "        num = float(df[\"Overs\"][i])\n",
    "        dec,whl = math.modf(num)\n",
    "        #print(int(round(dec,1)*10+ whl*6))\n",
    "        df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n",
    "        if( df[\"Wkts\"][i] =='-'):\n",
    "            df[\"Wkts\"][i] = 0\n",
    "        if( df[\"Econ\"][i] =='-'):\n",
    "            df[\"Econ\"][i] = df[\"Runs\"][i]/df[\"Overs\"][i]\n",
    "    df.reset_index(drop=True, inplace=True)\n",
    "#     df[\"Runs\"] = df[\"Runs\"].str.replace(r'*', '').astype(int)\n",
    "#     # Replace '*' with space, to convert the column to numbers\n",
    "#     df[\"SR\"] = df[\"SR\"].str.replace('-', '0').astype(float)\n",
    "#     df[\"BF\"] = df[\"BF\"].str.replace('-', '0').astype(float)\n",
    "    return(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "92f7138f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Naman\\AppData\\Local\\Temp/ipykernel_12096/1927580033.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n"
     ]
    },
    {
     "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>Overs</th>\n",
       "      <th>Mdns</th>\n",
       "      <th>Runs</th>\n",
       "      <th>Wkts</th>\n",
       "      <th>Econ</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Inns</th>\n",
       "      <th>Opposition</th>\n",
       "      <th>Ground</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Bowls_Bowled</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9.1</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>4.36</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Asia XI</td>\n",
       "      <td>Centurion</td>\n",
       "      <td>17 Aug 2005</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Asia XI</td>\n",
       "      <td>Durban</td>\n",
       "      <td>21 Aug 2005</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>11.60</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Melbourne (Docklands)</td>\n",
       "      <td>20 Jan 2006</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>10.66</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Sri Lanka</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>7 Feb 2006</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>4.28</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Ireland</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>24 Jun 2007</td>\n",
       "      <td>42</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>10.0</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>3</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>7 Mar 2015</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>4.44</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v U.A.E.</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>12 Mar 2015</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>7.0</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2.57</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Sri Lanka</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>18 Mar 2015</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>8.5</td>\n",
       "      <td>0</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>8.60</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>24 Mar 2015</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Centurion</td>\n",
       "      <td>19 Aug 2015</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Overs Mdns Runs Wkts   Econ Pos Inns     Opposition  \\\n",
       "0      9.1    2   40    1   4.36   2    2      v Asia XI   \n",
       "1      1.0    0    2    1   2.00   2    2      v Asia XI   \n",
       "2      5.0    0   58    1  11.60   2    1    v Australia   \n",
       "3      3.0    0   32    0  10.66   2    1    v Sri Lanka   \n",
       "4      7.0    0   30    2   4.28   2    2      v Ireland   \n",
       "..     ...  ...  ...  ...    ...  ..  ...            ...   \n",
       "99    10.0    3   30    3   3.00   1    1     v Pakistan   \n",
       "100    9.0    1   40    1   4.44   1    2       v U.A.E.   \n",
       "101    7.0    2   18    1   2.57   1    1    v Sri Lanka   \n",
       "102    8.5    0   76    1   8.60   1    2  v New Zealand   \n",
       "103    9.0    0   50    2   5.55   1    2  v New Zealand   \n",
       "\n",
       "                    Ground   Start Date Bowls_Bowled  \n",
       "0                Centurion  17 Aug 2005           55  \n",
       "1                   Durban  21 Aug 2005            6  \n",
       "2    Melbourne (Docklands)  20 Jan 2006           30  \n",
       "3                   Hobart   7 Feb 2006           18  \n",
       "4                  Belfast  24 Jun 2007           42  \n",
       "..                     ...          ...          ...  \n",
       "99                Auckland   7 Mar 2015           60  \n",
       "100             Wellington  12 Mar 2015           54  \n",
       "101                 Sydney  18 Mar 2015           42  \n",
       "102               Auckland  24 Mar 2015           53  \n",
       "103              Centurion  19 Aug 2015           54  \n",
       "\n",
       "[104 rows x 11 columns]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_bowler(\"steyn\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f35ebe9c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "a7095169",
   "metadata": {},
   "outputs": [],
   "source": [
    "def over_clean(num):\n",
    "    dec,whl = math.modf(num)\n",
    "    if(round(dec,1) >= 0.6):\n",
    "        num = round(num,1)+(1-round(dec,1))\n",
    "    return num\n",
    "\n",
    "\n",
    "def bowl_calculator(over):\n",
    "    dec,whl = math.modf(over)\n",
    "    bf=int(round(dec,1)*10+ whl*6)\n",
    "    return bf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "272f550a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "2505e7c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "def ground_details(l,df):\n",
    "        ru=0\n",
    "        over=0\n",
    "        wkts=0\n",
    "        cnt=0\n",
    "        ec=0\n",
    "        bf=0\n",
    "        for i in range(0, len(df)):\n",
    "            if(df[\"Ground\"][i]==l):\n",
    "                ru=ru+int(df[\"Runs\"][i])\n",
    "                over=over+float(df[\"Overs\"][i])\n",
    "                wkts=wkts+int(df[\"Wkts\"][i])\n",
    "                cnt=cnt+1\n",
    "                ec=ec+float(df[\"Econ\"][i])\n",
    "                over=over_clean(over)\n",
    "                bf=bowl_calculator(over)\n",
    "        return(ru,round(over,1),bf,int(cnt),round(ec/cnt,2),wkts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "19fdbeca",
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_dataset_ground(bowler):\n",
    "    ndf=pd.DataFrame(columns=[\"Bowler\",\"Ground\",\"Overs\",\"Balls Bowled\",\"Wickets\",\"No. of Matches Played\",\"Average Economy\",\"Runs\"])\n",
    "    \n",
    "    for bowl in bowler:\n",
    "        #print(str(x))\n",
    "        df=clean_bowler(str(bowl))\n",
    "        li=list(set(df[\"Ground\"]))\n",
    "        for gnd in li:\n",
    "            ru,over,bf,nmf,avg_ec,wkts=ground_details(gnd,df)\n",
    "            add={\"Bowler\":bowl.capitalize(),\"Ground\":gnd,\"Runs\":ru,\"Overs\":over,\"Balls Bowled\":bf,\"No. of Matches Played\":nmf,\"Average Economy\":avg_ec,\"Wickets\":wkts}\n",
    "            ndf=ndf.append(add,ignore_index=True)\n",
    "    return(ndf)        \n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "id": "565cd93c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Naman\\AppData\\Local\\Temp/ipykernel_12096/1927580033.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n"
     ]
    },
    {
     "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>Bowler</th>\n",
       "      <th>Ground</th>\n",
       "      <th>Overs</th>\n",
       "      <th>Balls Bowled</th>\n",
       "      <th>Wickets</th>\n",
       "      <th>No. of Matches Played</th>\n",
       "      <th>Average Economy</th>\n",
       "      <th>Runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>335.4</td>\n",
       "      <td>2014</td>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "      <td>3.15</td>\n",
       "      <td>1006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>209.3</td>\n",
       "      <td>1257</td>\n",
       "      <td>29</td>\n",
       "      <td>8</td>\n",
       "      <td>2.68</td>\n",
       "      <td>554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>Mohali</td>\n",
       "      <td>142.0</td>\n",
       "      <td>852</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>3.60</td>\n",
       "      <td>425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>Lucknow</td>\n",
       "      <td>64.3</td>\n",
       "      <td>387</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>2.00</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>178.3</td>\n",
       "      <td>1071</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>2.47</td>\n",
       "      <td>439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>Narine</td>\n",
       "      <td>Roseau</td>\n",
       "      <td>7.0</td>\n",
       "      <td>42</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5.54</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>Narine</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>11.50</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>Narine</td>\n",
       "      <td>Dhaka</td>\n",
       "      <td>23.0</td>\n",
       "      <td>138</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5.33</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>Narine</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4.50</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>Narine</td>\n",
       "      <td>Nottingham</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7.00</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>418 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Bowler      Ground  Overs Balls Bowled Wickets No. of Matches Played  \\\n",
       "0    Kumble   Bangalore  335.4         2014      34                    11   \n",
       "1    Kumble     Chennai  209.3         1257      29                     8   \n",
       "2    Kumble      Mohali  142.0          852      21                     6   \n",
       "3    Kumble     Lucknow   64.3          387      11                     2   \n",
       "4    Kumble   Ahmedabad  178.3         1071      14                     7   \n",
       "..      ...         ...    ...          ...     ...                   ...   \n",
       "413  Narine      Roseau    7.0           42       2                     2   \n",
       "414  Narine    Auckland    4.0           24       0                     1   \n",
       "415  Narine       Dhaka   23.0          138       6                     6   \n",
       "416  Narine  Wellington    4.0           24       2                     1   \n",
       "417  Narine  Nottingham    4.0           24       0                     1   \n",
       "\n",
       "     Average Economy  Runs  \n",
       "0               3.15  1006  \n",
       "1               2.68   554  \n",
       "2               3.60   425  \n",
       "3               2.00   128  \n",
       "4               2.47   439  \n",
       "..               ...   ...  \n",
       "413             5.54    38  \n",
       "414            11.50    46  \n",
       "415             5.33   119  \n",
       "416             4.50    18  \n",
       "417             7.00    28  \n",
       "\n",
       "[418 rows x 8 columns]"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prep_dataset_ground(bowlers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "68206693",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Naman\\AppData\\Local\\Temp/ipykernel_12096/1927580033.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n"
     ]
    }
   ],
   "source": [
    "bowler_ground=prep_dataset_ground(bowlers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "f47d5e7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "bowler_ground.to_csv('Bowler_ground.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "408cdba1",
   "metadata": {},
   "outputs": [],
   "source": [
    "def opposition_details(l,df):\n",
    "        ru=0\n",
    "        over=0\n",
    "        wkts=0\n",
    "        cnt=0\n",
    "        ec=0\n",
    "        bf=0\n",
    "        for i in range(0, len(df)):\n",
    "            if(df[\"Opposition\"][i]==l):\n",
    "                ru=ru+int(df[\"Runs\"][i])\n",
    "                over=over+float(df[\"Overs\"][i])\n",
    "                wkts=wkts+int(df[\"Wkts\"][i])\n",
    "                cnt=cnt+1\n",
    "                ec=ec+float(df[\"Econ\"][i])\n",
    "                over=over_clean(over)\n",
    "                bf=bowl_calculator(over)\n",
    "        return(ru,round(over,1),bf,int(cnt),round(ec/cnt,2),wkts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "b7998f69",
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_dataset_opposition(bowler):\n",
    "    ndf=pd.DataFrame(columns=[\"Bowler\",\"Opposition\",\"Overs\",\"Balls Bowled\",\"Wickets\",\"No. of Matches Played\",\"Average Economy\",\"Runs\"])\n",
    "    \n",
    "    for bowl in bowler:\n",
    "        #print(str(x))\n",
    "        df=clean_bowler(str(bowl))\n",
    "        li=list(set(df[\"Opposition\"]))\n",
    "        for gnd in li:\n",
    "            ru,over,bf,nmf,avg_ec,wkts=opposition_details(gnd,df)\n",
    "            add={\"Bowler\":bowl.capitalize(),\"Opposition\":gnd,\"Runs\":ru,\"Overs\":over,\"Balls Bowled\":bf,\"No. of Matches Played\":nmf,\"Average Economy\":avg_ec,\"Wickets\":wkts}\n",
    "            ndf=ndf.append(add,ignore_index=True)\n",
    "    return(ndf)        \n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "ece4742d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Naman\\AppData\\Local\\Temp/ipykernel_12096/1927580033.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n"
     ]
    },
    {
     "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>Bowler</th>\n",
       "      <th>Opposition</th>\n",
       "      <th>Overs</th>\n",
       "      <th>Balls Bowled</th>\n",
       "      <th>Wickets</th>\n",
       "      <th>No. of Matches Played</th>\n",
       "      <th>Average Economy</th>\n",
       "      <th>Runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>v Sri Lanka</td>\n",
       "      <td>260.0</td>\n",
       "      <td>1560</td>\n",
       "      <td>35</td>\n",
       "      <td>10</td>\n",
       "      <td>2.64</td>\n",
       "      <td>650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>v Zimbabwe</td>\n",
       "      <td>215.3</td>\n",
       "      <td>1293</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>2.09</td>\n",
       "      <td>451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>334.3</td>\n",
       "      <td>2007</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>2.91</td>\n",
       "      <td>965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>388.4</td>\n",
       "      <td>2332</td>\n",
       "      <td>46</td>\n",
       "      <td>14</td>\n",
       "      <td>2.70</td>\n",
       "      <td>1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kumble</td>\n",
       "      <td>v England</td>\n",
       "      <td>356.4</td>\n",
       "      <td>2140</td>\n",
       "      <td>43</td>\n",
       "      <td>12</td>\n",
       "      <td>2.37</td>\n",
       "      <td>828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Narine</td>\n",
       "      <td>v Bangladesh</td>\n",
       "      <td>7.0</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>6.62</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Narine</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>21.0</td>\n",
       "      <td>126</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6.11</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Narine</td>\n",
       "      <td>v India</td>\n",
       "      <td>4.0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Narine</td>\n",
       "      <td>v England</td>\n",
       "      <td>14.0</td>\n",
       "      <td>84</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>6.94</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Narine</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>27.0</td>\n",
       "      <td>162</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>6.23</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>149 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Bowler     Opposition  Overs Balls Bowled Wickets No. of Matches Played  \\\n",
       "0    Kumble    v Sri Lanka  260.0         1560      35                    10   \n",
       "1    Kumble     v Zimbabwe  215.3         1293      24                     6   \n",
       "2    Kumble     v Pakistan  334.3         2007      40                    12   \n",
       "3    Kumble    v Australia  388.4         2332      46                    14   \n",
       "4    Kumble      v England  356.4         2140      43                    12   \n",
       "..      ...            ...    ...          ...     ...                   ...   \n",
       "144  Narine   v Bangladesh    7.0           42       1                     2   \n",
       "145  Narine    v Australia   21.0          126       6                     6   \n",
       "146  Narine        v India    4.0           24       0                     1   \n",
       "147  Narine      v England   14.0           84       2                     4   \n",
       "148  Narine  v New Zealand   27.0          162      14                     7   \n",
       "\n",
       "     Average Economy  Runs  \n",
       "0               2.64   650  \n",
       "1               2.09   451  \n",
       "2               2.91   965  \n",
       "3               2.70  1050  \n",
       "4               2.37   828  \n",
       "..               ...   ...  \n",
       "144             6.62    44  \n",
       "145             6.11   125  \n",
       "146             5.00    20  \n",
       "147             6.94   103  \n",
       "148             6.23   168  \n",
       "\n",
       "[149 rows x 8 columns]"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prep_dataset_opposition(bowlers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "9faf0e98",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Naman\\AppData\\Local\\Temp/ipykernel_12096/1927580033.py:25: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"Bowls_Bowled\"][i]=int(round(dec,1)*10+ whl*6)\n"
     ]
    }
   ],
   "source": [
    "bowler_opposition=prep_dataset_opposition(bowlers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "24632c6b",
   "metadata": {},
   "outputs": [],
   "source": [
    "bowler_opposition.to_csv('Bowler_Opposition.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d63a19a9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "76ed660a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"data/steyn.csv\")\n",
    "df.drop(labels=\"Unnamed: 0\",axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "4f27b3fb",
   "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>Overs</th>\n",
       "      <th>Mdns</th>\n",
       "      <th>Runs</th>\n",
       "      <th>Wkts</th>\n",
       "      <th>Econ</th>\n",
       "      <th>Pos</th>\n",
       "      <th>Inns</th>\n",
       "      <th>Opposition</th>\n",
       "      <th>Ground</th>\n",
       "      <th>Start Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9.1</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>4.36</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Asia XI</td>\n",
       "      <td>Centurion</td>\n",
       "      <td>17 Aug 2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Asia XI</td>\n",
       "      <td>Durban</td>\n",
       "      <td>21 Aug 2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>11.60</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Australia</td>\n",
       "      <td>Melbourne (Docklands)</td>\n",
       "      <td>20 Jan 2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>10.66</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>v Sri Lanka</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>7 Feb 2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7.0</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>4.28</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>v Ireland</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>24 Jun 2007</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>10.0</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>3</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Pakistan</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>7 Mar 2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>4.44</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v U.A.E.</td>\n",
       "      <td>Wellington</td>\n",
       "      <td>12 Mar 2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>7.0</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2.57</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>v Sri Lanka</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>18 Mar 2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>8.5</td>\n",
       "      <td>0</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>8.60</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>24 Mar 2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>v New Zealand</td>\n",
       "      <td>Centurion</td>\n",
       "      <td>19 Aug 2015</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Overs Mdns Runs Wkts   Econ Pos Inns     Opposition  \\\n",
       "0     9.1    2   40    1   4.36   2    2      v Asia XI   \n",
       "1     1.0    0    2    1   2.00   2    2      v Asia XI   \n",
       "2     5.0    0   58    1  11.60   2    1    v Australia   \n",
       "3     3.0    0   32    0  10.66   2    1    v Sri Lanka   \n",
       "4     7.0    0   30    2   4.28   2    2      v Ireland   \n",
       "..    ...  ...  ...  ...    ...  ..  ...            ...   \n",
       "100  10.0    3   30    3   3.00   1    1     v Pakistan   \n",
       "101   9.0    1   40    1   4.44   1    2       v U.A.E.   \n",
       "102   7.0    2   18    1   2.57   1    1    v Sri Lanka   \n",
       "103   8.5    0   76    1   8.60   1    2  v New Zealand   \n",
       "104   9.0    0   50    2   5.55   1    2  v New Zealand   \n",
       "\n",
       "                    Ground   Start Date  \n",
       "0                Centurion  17 Aug 2005  \n",
       "1                   Durban  21 Aug 2005  \n",
       "2    Melbourne (Docklands)  20 Jan 2006  \n",
       "3                   Hobart   7 Feb 2006  \n",
       "4                  Belfast  24 Jun 2007  \n",
       "..                     ...          ...  \n",
       "100               Auckland   7 Mar 2015  \n",
       "101             Wellington  12 Mar 2015  \n",
       "102                 Sydney  18 Mar 2015  \n",
       "103               Auckland  24 Mar 2015  \n",
       "104              Centurion  19 Aug 2015  \n",
       "\n",
       "[105 rows x 10 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "f9daa4ab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Overs         object\n",
       "Mdns          object\n",
       "Runs          object\n",
       "Wkts          object\n",
       "Econ          object\n",
       "Pos           object\n",
       "Inns          object\n",
       "Opposition    object\n",
       "Ground        object\n",
       "Start Date    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "ec900a50",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "55\n"
     ]
    }
   ],
   "source": [
    "num = float(df[\"Overs\"][0])\n",
    "\n",
    "\n",
    "dec,whl = math.modf(num)\n",
    "\n",
    "print(int(round(dec,1)*10+ whl*6))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "b67d5cf6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8\n",
      "254.0\n",
      "0.0 254.0\n"
     ]
    }
   ],
   "source": [
    "num = 253.8\n",
    "dec,whl = math.modf(num)\n",
    "print(round(dec,1))\n",
    "if(round(dec,1) >= 0.6):\n",
    "    num = round(num,1)+(1-round(dec,1))\n",
    "    dec,whl = math.modf(num)\n",
    "    print(num)\n",
    "print(dec, whl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "e21310c7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "254.0\n"
     ]
    }
   ],
   "source": [
    "num = 253.8\n",
    "dec,whl = math.modf(num)\n",
    "if(round(dec,1) >= 0.6):\n",
    "    num = round(num,1)+(1-round(dec,1))\n",
    "    dec,whl = math.modf(num)\n",
    "    print(num)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "38d1f284",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}