guava_tree_analysis .ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"guava_tree_analysis .ipynb","provenance":[],"mount_file_id":"1lHbZsyqyBMu2YugUba2CipCuxKsWO4Zl","authorship_tag":"ABX9TyOPuuCfGfo8fkdy3QPNc/0Q"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"aNsEAkdTmF_X","colab_type":"text"},"source":["---\n","---\n","### **Guava Data Analysis and Visualization**\n","---\n","---\n"]},{"cell_type":"code","metadata":{"id":"U_fCX0KLg8Xb","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":74},"executionInfo":{"status":"ok","timestamp":1600608575190,"user_tz":-120,"elapsed":1810,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"e3de1dc1-bce4-4574-bc34-9c8592dd8da6"},"source":["import numpy as np\n","import pandas as pd\n","import pandas.util.testing as tm\n","import seaborn as sns \n","import matplotlib.pyplot as plt\n","import matplotlib.colors as mcolors\n","%matplotlib inline\n","plt.style.use('seaborn')\n","plotColors = (list(mcolors.TABLEAU_COLORS)+list(mcolors.TABLEAU_COLORS)+list(mcolors.TABLEAU_COLORS))[:23]"],"execution_count":1,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py:3: FutureWarning: pandas.util.testing is deprecated. Use the functions in the public API at pandas.testing instead.\n","  This is separate from the ipykernel package so we can avoid doing imports until\n"],"name":"stderr"}]},{"cell_type":"markdown","metadata":{"id":"2oB7qwjnm-xp","colab_type":"text"},"source":["##### **I. Data Acquisition**\n","\n","---"]},{"cell_type":"code","metadata":{"id":"BCMoARz5m_jK","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608583568,"user_tz":-120,"elapsed":1306,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["path = '/content/drive/My Drive/Colab Notebooks/PA_1/Guava_tree/guava_dataset.xlsx'\n","columns_names  =['Date','Temp_H','Temp_avg','Temp_L','Dew_H','Dew_avg','Dew_L','Humidity_H',\n","                 'Humidity_avg','Humidity_L','Pressure_H','Pressure_avg','Pressure_L',\n","                 'Visibility_H','Visibility_avg','Visibility_L','Wind_H','Wind_avg',\n","                 'Gust_Speed_H','Precip_sum','Events']\n","df = pd.read_excel(path,sheet_name='weather',header = None,names = columns_names)"],"execution_count":2,"outputs":[]},{"cell_type":"code","metadata":{"id":"mz3YOmCAohEK","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":872},"executionInfo":{"status":"ok","timestamp":1600608268493,"user_tz":-120,"elapsed":1953,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"244adcd1-690d-4cf3-a104-2dbd0ea7d29f"},"source":["df.Date.value_counts()"],"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["23        24\n","14        24\n","18        24\n","19        24\n","20        24\n","21        24\n","22        24\n","15        24\n","24        24\n","25        24\n","26        24\n","27        24\n","28        24\n","16        24\n","17        24\n","13        24\n","12        24\n","10        24\n","9         24\n","8         24\n","7         24\n","6         24\n","11        24\n","5         24\n","4         24\n","3         24\n","2         24\n","30        22\n","29        22\n","31        14\n","1 Feb.     2\n","1 Aug.     2\n","1 Sep.     2\n","1 Nov.     2\n","43952      2\n","1 Dec.     2\n","1 Oct.     2\n","43983      2\n","44013      2\n","43891      2\n","43922      2\n","Jan.       1\n","2014       1\n","2015       1\n","1 Jan.     1\n","1          1\n","Name: Date, dtype: int64"]},"metadata":{"tags":[]},"execution_count":3}]},{"cell_type":"code","metadata":{"id":"cLCLELqG-FAP","colab_type":"code","colab":{}},"source":["#df.iloc['Date'== 43952]\n","\"\"\"\n","43952\n","43983\n","44013\n","43891\n","Jan.  \n","2014       \n","2015 \n","1 Jan.\n","1 Feb.     \n","1 Nov.\n","1 Aug.     \n","43922      \n","1 Oct.     \n","1 Dec.         \n","1 Sep.  \"\"\"   \n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"VC0TsSYw1DRP","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608595303,"user_tz":-120,"elapsed":1777,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["df.drop(index=[0,1], axis=0, inplace=True)"],"execution_count":3,"outputs":[]},{"cell_type":"code","metadata":{"id":"vP4gsFUQAMJI","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":128},"executionInfo":{"status":"ok","timestamp":1600512906764,"user_tz":-120,"elapsed":1224,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"a26325a2-44a5-4e06-941b-f0918d530a2d"},"source":["df.query('Date == 43952')"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Date</th>\n","      <th>Temp_H</th>\n","      <th>Temp_avg</th>\n","      <th>Temp_L</th>\n","      <th>Dew_H</th>\n","      <th>Dew_avg</th>\n","      <th>Dew_L</th>\n","      <th>Humidity_H</th>\n","      <th>Humidity_avg</th>\n","      <th>Humidity_L</th>\n","      <th>Pressure_H</th>\n","      <th>Pressure_avg</th>\n","      <th>Pressure_L</th>\n","      <th>Visibility_H</th>\n","      <th>Visibility_avg</th>\n","      <th>Visibility_L</th>\n","      <th>Wind_H</th>\n","      <th>Wind_avg</th>\n","      <th>Gust_Speed_H</th>\n","      <th>Precip_sum</th>\n","      <th>Events</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>122</th>\n","      <td>43952</td>\n","      <td>35</td>\n","      <td>27</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>8</td>\n","      <td>2</td>\n","      <td>60</td>\n","      <td>35</td>\n","      <td>7</td>\n","      <td>1014</td>\n","      <td>1011</td>\n","      <td>1008</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>29</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>488</th>\n","      <td>43952</td>\n","      <td>33</td>\n","      <td>26</td>\n","      <td>19</td>\n","      <td>18</td>\n","      <td>12</td>\n","      <td>8</td>\n","      <td>94</td>\n","      <td>44</td>\n","      <td>13</td>\n","      <td>1014</td>\n","      <td>1011</td>\n","      <td>1009</td>\n","      <td>10</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>27</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["      Date Temp_H Temp_avg Temp_L  ... Wind_avg Gust_Speed_H Precip_sum Events\n","122  43952     35       27     18  ...       14           -           0       \n","488  43952     33       26     19  ...       11            -          0    NaN\n","\n","[2 rows x 21 columns]"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"code","metadata":{"id":"XRr7rtF6DmZD","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608609175,"user_tz":-120,"elapsed":1386,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["arbitrary_values = [43952,43983,44013,43891,43922]\n","df.Date.replace(to_replace = arbitrary_values ,value= 1,inplace=True )"],"execution_count":4,"outputs":[]},{"cell_type":"code","metadata":{"id":"QIUqNi4rAd0R","colab_type":"code","colab":{}},"source":["#df.query('Date == 43983')\n","#df.query('Date == 43922')\n","#df.query('Date == 44013')\n"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"WZAiVfpHByJS","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":68},"executionInfo":{"status":"ok","timestamp":1600514742886,"user_tz":-120,"elapsed":4667,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"cb3145cd-8bfd-4c5b-dc4d-74e2e807ce79"},"source":["df.query('Date == 2015')"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Date</th>\n","      <th>Temp_H</th>\n","      <th>Temp_avg</th>\n","      <th>Temp_L</th>\n","      <th>Dew_H</th>\n","      <th>Dew_avg</th>\n","      <th>Dew_L</th>\n","      <th>Humidity_H</th>\n","      <th>Humidity_avg</th>\n","      <th>Humidity_L</th>\n","      <th>Pressure_H</th>\n","      <th>Pressure_avg</th>\n","      <th>Pressure_L</th>\n","      <th>Visibility_H</th>\n","      <th>Visibility_avg</th>\n","      <th>Visibility_L</th>\n","      <th>Wind_H</th>\n","      <th>Wind_avg</th>\n","      <th>Gust_Speed_H</th>\n","      <th>Precip_sum</th>\n","      <th>Events</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["Empty DataFrame\n","Columns: [Date, Temp_H, Temp_avg, Temp_L, Dew_H, Dew_avg, Dew_L, Humidity_H, Humidity_avg, Humidity_L, Pressure_H, Pressure_avg, Pressure_L, Visibility_H, Visibility_avg, Visibility_L, Wind_H, Wind_avg, Gust_Speed_H, Precip_sum, Events]\n","Index: []"]},"metadata":{"tags":[]},"execution_count":42}]},{"cell_type":"code","metadata":{"id":"59m3cHUuG2tB","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608622885,"user_tz":-120,"elapsed":1718,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["df.drop(labels=367,axis=0,inplace=True)"],"execution_count":5,"outputs":[]},{"cell_type":"code","metadata":{"id":"3B5J9oe2CKDw","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":115},"executionInfo":{"status":"ok","timestamp":1600514640051,"user_tz":-120,"elapsed":1529,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"80636e2c-7b76-4c58-f52b-992151ecbc3d"},"source":["df.query('Date == \"1 Jan.\"')"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Date</th>\n","      <th>Temp_H</th>\n","      <th>Temp_avg</th>\n","      <th>Temp_L</th>\n","      <th>Dew_H</th>\n","      <th>Dew_avg</th>\n","      <th>Dew_L</th>\n","      <th>Humidity_H</th>\n","      <th>Humidity_avg</th>\n","      <th>Humidity_L</th>\n","      <th>Pressure_H</th>\n","      <th>Pressure_avg</th>\n","      <th>Pressure_L</th>\n","      <th>Visibility_H</th>\n","      <th>Visibility_avg</th>\n","      <th>Visibility_L</th>\n","      <th>Wind_H</th>\n","      <th>Wind_avg</th>\n","      <th>Gust_Speed_H</th>\n","      <th>Precip_sum</th>\n","      <th>Events</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>368</th>\n","      <td>1 Jan.</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>100</td>\n","      <td>81</td>\n","      <td>52</td>\n","      <td>1022</td>\n","      <td>1020</td>\n","      <td>1019</td>\n","      <td>6</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>11</td>\n","      <td>2</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>Fog</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["       Date Temp_H Temp_avg Temp_L  ... Wind_avg Gust_Speed_H Precip_sum Events\n","368  1 Jan.     18       14     10  ...        2            -          0    Fog\n","\n","[1 rows x 21 columns]"]},"metadata":{"tags":[]},"execution_count":40}]},{"cell_type":"code","metadata":{"id":"5wPQsTyLHVAx","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608629847,"user_tz":-120,"elapsed":931,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["month_list = [\"1 Jan.\",\"1 Feb.\",\"1 Nov.\",\"1 Aug.\",\"1 Oct.\",\"1 Dec.\",\"1 Sep.\"]\n","df.Date.replace(to_replace = month_list ,value = 1,inplace = True )"],"execution_count":6,"outputs":[]},{"cell_type":"code","metadata":{"id":"isfwxWApCYr0","colab_type":"code","colab":{}},"source":["#df.query('Date == 1 Feb.')\n","#df.query('Date == 1 Nov.')\n","#df.query('Date == 1 Aug.')\n","#df.query('Date == 1 Oct.')\n","#df.query('Date == 1 Dec.')\n","#df.query('Date == 1 Sep.')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"GQRELexzDKyP","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":599},"executionInfo":{"status":"ok","timestamp":1600608636361,"user_tz":-120,"elapsed":1150,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"b84a331c-e4c6-4812-e204-c4c706d1cc98"},"source":["df.Date.value_counts()"],"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["16    24\n","15    24\n","2     24\n","3     24\n","4     24\n","5     24\n","6     24\n","7     24\n","8     24\n","9     24\n","10    24\n","11    24\n","12    24\n","13    24\n","14    24\n","1     24\n","17    24\n","18    24\n","19    24\n","20    24\n","21    24\n","22    24\n","23    24\n","24    24\n","25    24\n","26    24\n","27    24\n","28    24\n","30    22\n","29    22\n","31    14\n","Name: Date, dtype: int64"]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"id":"epBXw9oFEn22","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":1000},"executionInfo":{"status":"ok","timestamp":1600608766192,"user_tz":-120,"elapsed":1688,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"33a3ecd3-b7a2-4818-da63-2e0d65706088"},"source":["df.head(32)\n"],"execution_count":10,"outputs":[{"output_type":"execute_result","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>Date</th>\n","      <th>Temp_H</th>\n","      <th>Temp_avg</th>\n","      <th>Temp_L</th>\n","      <th>Dew_H</th>\n","      <th>Dew_avg</th>\n","      <th>Dew_L</th>\n","      <th>Humidity_H</th>\n","      <th>Humidity_avg</th>\n","      <th>Humidity_L</th>\n","      <th>Pressure_H</th>\n","      <th>Pressure_avg</th>\n","      <th>Pressure_L</th>\n","      <th>Visibility_H</th>\n","      <th>Visibility_avg</th>\n","      <th>Visibility_L</th>\n","      <th>Wind_H</th>\n","      <th>Wind_avg</th>\n","      <th>Gust_Speed_H</th>\n","      <th>Precip_sum</th>\n","      <th>Events</th>\n","      <th>Month</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2</th>\n","      <td>1</td>\n","      <td>19</td>\n","      <td>14</td>\n","      <td>11</td>\n","      <td>11</td>\n","      <td>6</td>\n","      <td>0</td>\n","      <td>82</td>\n","      <td>59</td>\n","      <td>22</td>\n","      <td>1021</td>\n","      <td>1019</td>\n","      <td>1018</td>\n","      <td>10</td>\n","      <td>4</td>\n","      <td>1</td>\n","      <td>14</td>\n","      <td>8</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>21</td>\n","      <td>16</td>\n","      <td>11</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>1</td>\n","      <td>67</td>\n","      <td>53</td>\n","      <td>38</td>\n","      <td>1024</td>\n","      <td>1023</td>\n","      <td>1021</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>40</td>\n","      <td>13</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>20</td>\n","      <td>16</td>\n","      <td>11</td>\n","      <td>12</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>88</td>\n","      <td>71</td>\n","      <td>46</td>\n","      <td>1026</td>\n","      <td>1024</td>\n","      <td>1022</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>19</td>\n","      <td>8</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>4</td>\n","      <td>19</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>13</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>94</td>\n","      <td>73</td>\n","      <td>44</td>\n","      <td>1022</td>\n","      <td>1019</td>\n","      <td>1016</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>16</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>5</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>3</td>\n","      <td>87</td>\n","      <td>61</td>\n","      <td>34</td>\n","      <td>1018</td>\n","      <td>1015</td>\n","      <td>1013</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>3</td>\n","      <td>29</td>\n","      <td>13</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>6</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>11</td>\n","      <td>7</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>67</td>\n","      <td>53</td>\n","      <td>34</td>\n","      <td>1014</td>\n","      <td>1011</td>\n","      <td>1008</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>4</td>\n","      <td>52</td>\n","      <td>27</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>7</td>\n","      <td>17</td>\n","      <td>13</td>\n","      <td>11</td>\n","      <td>8</td>\n","      <td>5</td>\n","      <td>2</td>\n","      <td>71</td>\n","      <td>56</td>\n","      <td>37</td>\n","      <td>1017</td>\n","      <td>1013</td>\n","      <td>1007</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>3</td>\n","      <td>55</td>\n","      <td>37</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>8</td>\n","      <td>17</td>\n","      <td>13</td>\n","      <td>10</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>2</td>\n","      <td>88</td>\n","      <td>62</td>\n","      <td>33</td>\n","      <td>1016</td>\n","      <td>1014</td>\n","      <td>1011</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>2</td>\n","      <td>42</td>\n","      <td>27</td>\n","      <td>-</td>\n","      <td>1.02</td>\n","      <td>rain</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>9</td>\n","      <td>11</td>\n","      <td>8</td>\n","      <td>6</td>\n","      <td>8</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>93</td>\n","      <td>77</td>\n","      <td>42</td>\n","      <td>1022</td>\n","      <td>1017</td>\n","      <td>1014</td>\n","      <td>10</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>24</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>7.87</td>\n","      <td>rain</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>10</td>\n","      <td>13</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>6</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>82</td>\n","      <td>73</td>\n","      <td>54</td>\n","      <td>1025</td>\n","      <td>1022</td>\n","      <td>1021</td>\n","      <td>10</td>\n","      <td>9</td>\n","      <td>3</td>\n","      <td>35</td>\n","      <td>16</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>11</td>\n","      <td>16</td>\n","      <td>12</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>4</td>\n","      <td>3</td>\n","      <td>81</td>\n","      <td>59</td>\n","      <td>36</td>\n","      <td>1026</td>\n","      <td>1024</td>\n","      <td>1023</td>\n","      <td>10</td>\n","      <td>9</td>\n","      <td>4</td>\n","      <td>32</td>\n","      <td>18</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>12</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>4</td>\n","      <td>3</td>\n","      <td>67</td>\n","      <td>52</td>\n","      <td>29</td>\n","      <td>1024</td>\n","      <td>1022</td>\n","      <td>1021</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>4</td>\n","      <td>16</td>\n","      <td>10</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>13</td>\n","      <td>19</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>4</td>\n","      <td>77</td>\n","      <td>58</td>\n","      <td>31</td>\n","      <td>1024</td>\n","      <td>1022</td>\n","      <td>1021</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>4</td>\n","      <td>16</td>\n","      <td>8</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>14</td>\n","      <td>19</td>\n","      <td>14</td>\n","      <td>9</td>\n","      <td>12</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>88</td>\n","      <td>70</td>\n","      <td>33</td>\n","      <td>1025</td>\n","      <td>1024</td>\n","      <td>1023</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>2</td>\n","      <td>27</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>15</td>\n","      <td>20</td>\n","      <td>14</td>\n","      <td>8</td>\n","      <td>11</td>\n","      <td>3</td>\n","      <td>-4</td>\n","      <td>94</td>\n","      <td>57</td>\n","      <td>21</td>\n","      <td>1025</td>\n","      <td>1022</td>\n","      <td>1020</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>6</td>\n","      <td>37</td>\n","      <td>16</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>16</td>\n","      <td>21</td>\n","      <td>14</td>\n","      <td>8</td>\n","      <td>7</td>\n","      <td>2</td>\n","      <td>-3</td>\n","      <td>62</td>\n","      <td>45</td>\n","      <td>21</td>\n","      <td>1021</td>\n","      <td>1018</td>\n","      <td>1016</td>\n","      <td>10</td>\n","      <td>3</td>\n","      <td>1</td>\n","      <td>84</td>\n","      <td>8</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>17</td>\n","      <td>21</td>\n","      <td>17</td>\n","      <td>12</td>\n","      <td>10</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>77</td>\n","      <td>44</td>\n","      <td>27</td>\n","      <td>1020</td>\n","      <td>1018</td>\n","      <td>1017</td>\n","      <td>10</td>\n","      <td>3</td>\n","      <td>1</td>\n","      <td>19</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>18</td>\n","      <td>19</td>\n","      <td>14</td>\n","      <td>11</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>100</td>\n","      <td>75</td>\n","      <td>43</td>\n","      <td>1017</td>\n","      <td>1015</td>\n","      <td>1008</td>\n","      <td>10</td>\n","      <td>3</td>\n","      <td>1</td>\n","      <td>16</td>\n","      <td>13</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>Fog</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>19</td>\n","      <td>20</td>\n","      <td>15</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>-1</td>\n","      <td>-10</td>\n","      <td>72</td>\n","      <td>39</td>\n","      <td>7</td>\n","      <td>1020</td>\n","      <td>1017</td>\n","      <td>1015</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>2</td>\n","      <td>23</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>20</td>\n","      <td>22</td>\n","      <td>17</td>\n","      <td>12</td>\n","      <td>3</td>\n","      <td>-1</td>\n","      <td>-6</td>\n","      <td>47</td>\n","      <td>31</td>\n","      <td>15</td>\n","      <td>1022</td>\n","      <td>1020</td>\n","      <td>1019</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>23</td>\n","      <td>13</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>21</td>\n","      <td>28</td>\n","      <td>19</td>\n","      <td>11</td>\n","      <td>2</td>\n","      <td>-3</td>\n","      <td>-8</td>\n","      <td>38</td>\n","      <td>23</td>\n","      <td>5</td>\n","      <td>1019</td>\n","      <td>1015</td>\n","      <td>1012</td>\n","      <td>10</td>\n","      <td>6</td>\n","      <td>2</td>\n","      <td>24</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>22</td>\n","      <td>24</td>\n","      <td>20</td>\n","      <td>15</td>\n","      <td>12</td>\n","      <td>4</td>\n","      <td>-2</td>\n","      <td>72</td>\n","      <td>36</td>\n","      <td>16</td>\n","      <td>1019</td>\n","      <td>1015</td>\n","      <td>1011</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>26</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>23</td>\n","      <td>19</td>\n","      <td>16</td>\n","      <td>12</td>\n","      <td>11</td>\n","      <td>9</td>\n","      <td>7</td>\n","      <td>82</td>\n","      <td>63</td>\n","      <td>32</td>\n","      <td>1021</td>\n","      <td>1020</td>\n","      <td>1019</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>6</td>\n","      <td>14</td>\n","      <td>10</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>24</td>\n","      <td>21</td>\n","      <td>17</td>\n","      <td>12</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>2</td>\n","      <td>77</td>\n","      <td>54</td>\n","      <td>32</td>\n","      <td>1019</td>\n","      <td>1015</td>\n","      <td>1011</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>4</td>\n","      <td>23</td>\n","      <td>13</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>25</td>\n","      <td>22</td>\n","      <td>19</td>\n","      <td>16</td>\n","      <td>8</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>55</td>\n","      <td>40</td>\n","      <td>25</td>\n","      <td>1015</td>\n","      <td>1013</td>\n","      <td>1010</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>26</td>\n","      <td>14</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>26</td>\n","      <td>22</td>\n","      <td>17</td>\n","      <td>13</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>55</td>\n","      <td>38</td>\n","      <td>16</td>\n","      <td>1014</td>\n","      <td>1013</td>\n","      <td>1011</td>\n","      <td>10</td>\n","      <td>5</td>\n","      <td>3</td>\n","      <td>16</td>\n","      <td>10</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>27</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>11</td>\n","      <td>7</td>\n","      <td>-2</td>\n","      <td>-6</td>\n","      <td>45</td>\n","      <td>30</td>\n","      <td>17</td>\n","      <td>1016</td>\n","      <td>1015</td>\n","      <td>1013</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>6</td>\n","      <td>21</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>28</td>\n","      <td>17</td>\n","      <td>13</td>\n","      <td>9</td>\n","      <td>4</td>\n","      <td>2</td>\n","      <td>-2</td>\n","      <td>62</td>\n","      <td>46</td>\n","      <td>23</td>\n","      <td>1017</td>\n","      <td>1014</td>\n","      <td>1012</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>3</td>\n","      <td>37</td>\n","      <td>11</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>rain</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>30</th>\n","      <td>29</td>\n","      <td>16</td>\n","      <td>12</td>\n","      <td>8</td>\n","      <td>9</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>76</td>\n","      <td>59</td>\n","      <td>42</td>\n","      <td>1018</td>\n","      <td>1017</td>\n","      <td>1016</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>2</td>\n","      <td>24</td>\n","      <td>16</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>31</th>\n","      <td>30</td>\n","      <td>18</td>\n","      <td>14</td>\n","      <td>11</td>\n","      <td>8</td>\n","      <td>4</td>\n","      <td>-1</td>\n","      <td>76</td>\n","      <td>52</td>\n","      <td>22</td>\n","      <td>1016</td>\n","      <td>1014</td>\n","      <td>1011</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>3</td>\n","      <td>34</td>\n","      <td>16</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td></td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>32</th>\n","      <td>31</td>\n","      <td>16</td>\n","      <td>13</td>\n","      <td>10</td>\n","      <td>10</td>\n","      <td>7</td>\n","      <td>5</td>\n","      <td>88</td>\n","      <td>67</td>\n","      <td>45</td>\n","      <td>1015</td>\n","      <td>1012</td>\n","      <td>1010</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>6</td>\n","      <td>39</td>\n","      <td>26</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>rain</td>\n","      <td>1.0</td>\n","    </tr>\n","    <tr>\n","      <th>33</th>\n","      <td>1</td>\n","      <td>16</td>\n","      <td>13</td>\n","      <td>10</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>6</td>\n","      <td>82</td>\n","      <td>69</td>\n","      <td>55</td>\n","      <td>1019</td>\n","      <td>1014</td>\n","      <td>1012</td>\n","      <td>10</td>\n","      <td>8</td>\n","      <td>4</td>\n","      <td>40</td>\n","      <td>24</td>\n","      <td>-</td>\n","      <td>0</td>\n","      <td>rain</td>\n","      <td>2.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["    Date Temp_H Temp_avg Temp_L  ... Gust_Speed_H Precip_sum Events Month\n","2      1     19       14     11  ...           -           0          1.0\n","3      2     21       16     11  ...           -           0          1.0\n","4      3     20       16     11  ...           -           0          1.0\n","5      4     19       14     10  ...           -           0          1.0\n","6      5     18       14     10  ...           -           0          1.0\n","7      6     18       14     11  ...           -           0          1.0\n","8      7     17       13     11  ...           -           0          1.0\n","9      8     17       13     10  ...           -        1.02   rain   1.0\n","10     9     11        8      6  ...           -        7.87   rain   1.0\n","11    10     13       10      7  ...           -           0          1.0\n","12    11     16       12      9  ...           -           0          1.0\n","13    12     18       14     10  ...           -           0          1.0\n","14    13     19       14     10  ...           -           0          1.0\n","15    14     19       14      9  ...           -           0          1.0\n","16    15     20       14      8  ...           -           0          1.0\n","17    16     21       14      8  ...           -           0          1.0\n","18    17     21       17     12  ...           -           0          1.0\n","19    18     19       14     11  ...           -           0    Fog   1.0\n","20    19     20       15     10  ...           -           0          1.0\n","21    20     22       17     12  ...           -           0          1.0\n","22    21     28       19     11  ...           -           0          1.0\n","23    22     24       20     15  ...           -           0          1.0\n","24    23     19       16     12  ...           -           0          1.0\n","25    24     21       17     12  ...           -           0          1.0\n","26    25     22       19     16  ...           -           0          1.0\n","27    26     22       17     13  ...           -           0          1.0\n","28    27     18       14     11  ...           -           0          1.0\n","29    28     17       13      9  ...           -           0   rain   1.0\n","30    29     16       12      8  ...           -           0          1.0\n","31    30     18       14     11  ...           -           0          1.0\n","32    31     16       13     10  ...           -           0   rain   1.0\n","33     1     16       13     10  ...           -           0   rain   2.0\n","\n","[32 rows x 22 columns]"]},"metadata":{"tags":[]},"execution_count":10}]},{"cell_type":"code","metadata":{"id":"_UEEAYYRb6Rg","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608524952,"user_tz":-120,"elapsed":2942,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["#df.index = df.Date"],"execution_count":7,"outputs":[]},{"cell_type":"code","metadata":{"id":"I2zNayvP2stw","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600608685548,"user_tz":-120,"elapsed":1110,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["\"\"\"df.loc[0:32,'Month'] = 1\n","df.loc[33:60,'Month'] = 2\n","df.loc[61:91,'Month'] = 3\n","df.loc[92:121,'Month'] = 4\n","df.loc[122:152,'Month'] = 5\n","df.loc[153:182,'Month'] = 6\n","df.loc[183:213,'Month'] = 7\n","df.loc[214:244,'Month'] = 8\n","df.loc[245:274,'Month'] = 9\n","df.loc[275:305,'Month'] = 10\n","df.loc[306:335,'Month'] = 11\n","df.loc[336:366,'Month'] = 12\"\"\"\n"],"execution_count":8,"outputs":[]},{"cell_type":"code","metadata":{"id":"JpN60c67Hww6","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600610033159,"user_tz":-120,"elapsed":8288,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["def month_fn(count ):\n","  count = count\n","  const_28 = 28\n","  const_30 = 30\n","  const_31 = 31\n","  df.loc[count:count+const_31,'Month'] = 1\n","  count = count+const_31\n","  df.loc[count+1:count+const_28,'Month'] = 2\n","  count = count+const_28\n","  df.loc[count+1:count+const_31,'Month'] = 3\n","  count = count+const_31\n","  df.loc[count+1:count+const_30,'Month'] = 4\n","  count = count+const_30\n","  df.loc[count+1:count+const_31,'Month'] = 5\n","  count = count+const_31\n","  df.loc[count+1:count+const_30,'Month'] = 6\n","  count = count+const_30\n","  df.loc[count+1:count+const_31,'Month'] = 7\n","  count = count+const_31\n","  df.loc[count+1:count+const_31,'Month'] = 8\n","  count = count+const_31\n","  df.loc[count+1:count+const_30,'Month'] = 9\n","  count = count+const_30\n","  df.loc[count+1:count+const_31,'Month'] = 10\n","  count = count+const_31\n","  df.loc[count+1:count+const_30,'Month'] = 11\n","  count = count+const_30\n","  df.loc[count+1:count+const_31,'Month'] = 12\n","  \n"],"execution_count":26,"outputs":[]},{"cell_type":"code","metadata":{"id":"Vuhp00tlwPBm","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600610119653,"user_tz":-120,"elapsed":992,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["month_fn(2)\n","month_fn(367)"],"execution_count":27,"outputs":[]},{"cell_type":"code","metadata":{"id":"e2iqjqSGKhyq","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":254},"executionInfo":{"status":"ok","timestamp":1600610359723,"user_tz":-120,"elapsed":1856,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}},"outputId":"0ecf94ab-576b-40ce-ed37-58a80b7573b3"},"source":["df.Month.value_counts()"],"execution_count":30,"outputs":[{"output_type":"execute_result","data":{"text/plain":["1.0     63\n","10.0    62\n","8.0     62\n","7.0     62\n","5.0     62\n","3.0     62\n","12.0    61\n","11.0    60\n","9.0     60\n","6.0     60\n","4.0     60\n","2.0     56\n","Name: Month, dtype: int64"]},"metadata":{"tags":[]},"execution_count":30}]},{"cell_type":"code","metadata":{"id":"T3Wm2rAi0zfD","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1600611551128,"user_tz":-120,"elapsed":2652,"user":{"displayName":"Nourhan Hassan","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhmFj-u4W-mrjTXtAmOW8DgGQC-W2chmkJkvKmpbg=s64","userId":"17633110278991832358"}}},"source":["df.to_csv('/content/drive/My Drive/Colab Notebooks/PA_1/Guava_tree/clean_csv_file.csv')"],"execution_count":35,"outputs":[]},{"cell_type":"code","metadata":{"id":"8pyyzNKo4fhM","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]}]}