{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Pandas.ipynb","version":"0.3.2","provenance":[],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"code","metadata":{"id":"pelSydx1iyH6","colab_type":"code","colab":{}},"source":["import pandas as pd\n","import numpy as np"],"execution_count":0,"outputs":[]},{"cell_type":"code","metadata":{"id":"32LqUr1xkqbd","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":235},"outputId":"6a8e5554-cb2c-4f54-aceb-e13c4601d4dd","executionInfo":{"status":"ok","timestamp":1567689598120,"user_tz":-330,"elapsed":936,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["\n","def header(msg):\n","  print('-'*50)\n","  print('['+msg+']')\n","  \n","df = pd.DataFrame(\n","[['Jan',58,42,74,22,2.95],\n","['Feb',61,45,78,26,3.02],\n","['Mar',65,48,84,25,2.34],\n","['Apr',67,50,92,28,1.02],\n","['May',71,53,98,35,0.48],\n","['Jun',75,56,107,41,0.11],\n","['Jul',77,58,105,44,0.0],\n","['Aug',77,59,102,43,0.03],\n","['Sep',77,57,103,40,0.17],\n","['Oct',73,54,96,34,0.81],\n","['Nov',64,48,84,30,1.7],\n","['Dec',58,42,73,21,2.56]],\n","index = [0,1,2,3,4,5,6,7,8,9,10,11],\n","columns = ['month','avg_high','avg_low','record_high','record_low','avg_precipitation'])\n","\n","print(df)\n","df.to_csv('foo.csv')"],"execution_count":3,"outputs":[{"output_type":"stream","text":["   month  avg_high  avg_low  record_high  record_low  avg_precipitation\n","0    Jan        58       42           74          22               2.95\n","1    Feb        61       45           78          26               3.02\n","2    Mar        65       48           84          25               2.34\n","3    Apr        67       50           92          28               1.02\n","4    May        71       53           98          35               0.48\n","5    Jun        75       56          107          41               0.11\n","6    Jul        77       58          105          44               0.00\n","7    Aug        77       59          102          43               0.03\n","8    Sep        77       57          103          40               0.17\n","9    Oct        73       54           96          34               0.81\n","10   Nov        64       48           84          30               1.70\n","11   Dec        58       42           73          21               2.56\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"Icc34VFylFpG","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":286},"outputId":"4179523e-5d04-4c8a-8230-396817bc73d6","executionInfo":{"status":"ok","timestamp":1567689775617,"user_tz":-330,"elapsed":905,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"2.df.head()\")\n","print(df.head())\n","\n","header(\"3.df.tail()\")\n","print(df.head())"],"execution_count":4,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[2.df.head()]\n","  month  avg_high  avg_low  record_high  record_low  avg_precipitation\n","0   Jan        58       42           74          22               2.95\n","1   Feb        61       45           78          26               3.02\n","2   Mar        65       48           84          25               2.34\n","3   Apr        67       50           92          28               1.02\n","4   May        71       53           98          35               0.48\n","--------------------------------------------------\n","[3.df.tail()]\n","  month  avg_high  avg_low  record_high  record_low  avg_precipitation\n","0   Jan        58       42           74          22               2.95\n","1   Feb        61       45           78          26               3.02\n","2   Mar        65       48           84          25               2.34\n","3   Apr        67       50           92          28               1.02\n","4   May        71       53           98          35               0.48\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"afjrWGbMl5Yv","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":181},"outputId":"c6a9a154-041f-40ad-b004-c4d88c2c7f37","executionInfo":{"status":"ok","timestamp":1567690008901,"user_tz":-330,"elapsed":910,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"4.df.dtypes()\")\n","print(df.dtypes)\n","\n"],"execution_count":8,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[4.df.dtypes()]\n","month                 object\n","avg_high               int64\n","avg_low                int64\n","record_high            int64\n","record_low             int64\n","avg_precipitation    float64\n","dtype: object\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"wz3Rjgdnmg3f","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":72},"outputId":"da08654a-2793-4d24-d9fd-c88c696a2251","executionInfo":{"status":"ok","timestamp":1567690026805,"user_tz":-330,"elapsed":990,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"5.df.index()\")\n","print(df.index)\n","\n"],"execution_count":9,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[5.df.index()]\n","Int64Index([0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], dtype='int64')\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"No9z4n2-m2sP","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":108},"outputId":"9e8723b7-e374-4a92-fb4c-292b621df7b1","executionInfo":{"status":"ok","timestamp":1567690033222,"user_tz":-330,"elapsed":883,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"6.df.columns()\")\n","print(df.columns)\n","\n"],"execution_count":10,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[6.df.columns()]\n","Index(['month', 'avg_high', 'avg_low', 'record_high', 'record_low',\n","       'avg_precipitation'],\n","      dtype='object')\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"_RyaclDHm4SP","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":272},"outputId":"589bbfbd-291b-4d5a-94a3-9ec7892756df","executionInfo":{"status":"ok","timestamp":1567690126595,"user_tz":-330,"elapsed":1123,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"7.df.values()\")\n","print(df.values)"],"execution_count":17,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[7.df.values()]\n","[['Jan' 58 42 74 22 2.95]\n"," ['Feb' 61 45 78 26 3.02]\n"," ['Mar' 65 48 84 25 2.34]\n"," ['Apr' 67 50 92 28 1.02]\n"," ['May' 71 53 98 35 0.48]\n"," ['Jun' 75 56 107 41 0.11]\n"," ['Jul' 77 58 105 44 0.0]\n"," ['Aug' 77 59 102 43 0.03]\n"," ['Sep' 77 57 103 40 0.17]\n"," ['Oct' 73 54 96 34 0.81]\n"," ['Nov' 64 48 84 30 1.7]\n"," ['Dec' 58 42 73 21 2.56]]\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"b_Q60Dztm5dX","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":325},"outputId":"ba669789-68ad-4e61-d3db-3fe9c6806823","executionInfo":{"status":"ok","timestamp":1567690174226,"user_tz":-330,"elapsed":1085,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"8.df.describe()\")\n","df.describe()"],"execution_count":18,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[8.df.describe()]\n"],"name":"stdout"},{"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>avg_high</th>\n","      <th>avg_low</th>\n","      <th>record_high</th>\n","      <th>record_low</th>\n","      <th>avg_precipitation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>count</th>\n","      <td>12.000000</td>\n","      <td>12.000000</td>\n","      <td>12.000000</td>\n","      <td>12.000000</td>\n","      <td>12.000000</td>\n","    </tr>\n","    <tr>\n","      <th>mean</th>\n","      <td>68.583333</td>\n","      <td>51.000000</td>\n","      <td>91.333333</td>\n","      <td>32.416667</td>\n","      <td>1.265833</td>\n","    </tr>\n","    <tr>\n","      <th>std</th>\n","      <td>7.366488</td>\n","      <td>6.060303</td>\n","      <td>12.323911</td>\n","      <td>8.240238</td>\n","      <td>1.186396</td>\n","    </tr>\n","    <tr>\n","      <th>min</th>\n","      <td>58.000000</td>\n","      <td>42.000000</td>\n","      <td>73.000000</td>\n","      <td>21.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>25%</th>\n","      <td>63.250000</td>\n","      <td>47.250000</td>\n","      <td>82.500000</td>\n","      <td>25.750000</td>\n","      <td>0.155000</td>\n","    </tr>\n","    <tr>\n","      <th>50%</th>\n","      <td>69.000000</td>\n","      <td>51.500000</td>\n","      <td>94.000000</td>\n","      <td>32.000000</td>\n","      <td>0.915000</td>\n","    </tr>\n","    <tr>\n","      <th>75%</th>\n","      <td>75.500000</td>\n","      <td>56.250000</td>\n","      <td>102.250000</td>\n","      <td>40.250000</td>\n","      <td>2.395000</td>\n","    </tr>\n","    <tr>\n","      <th>max</th>\n","      <td>77.000000</td>\n","      <td>59.000000</td>\n","      <td>107.000000</td>\n","      <td>44.000000</td>\n","      <td>3.020000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["        avg_high    avg_low  record_high  record_low  avg_precipitation\n","count  12.000000  12.000000    12.000000   12.000000          12.000000\n","mean   68.583333  51.000000    91.333333   32.416667           1.265833\n","std     7.366488   6.060303    12.323911    8.240238           1.186396\n","min    58.000000  42.000000    73.000000   21.000000           0.000000\n","25%    63.250000  47.250000    82.500000   25.750000           0.155000\n","50%    69.000000  51.500000    94.000000   32.000000           0.915000\n","75%    75.500000  56.250000   102.250000   40.250000           2.395000\n","max    77.000000  59.000000   107.000000   44.000000           3.020000"]},"metadata":{"tags":[]},"execution_count":18}]},{"cell_type":"code","metadata":{"id":"NZLaZfEOm96I","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":445},"outputId":"55598255-b028-4e89-f8f8-4b84d295e284","executionInfo":{"status":"ok","timestamp":1567690301883,"user_tz":-330,"elapsed":907,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["header(\"8.df.sort_values()\")\n","df.sort_values(\"record_high\" , ascending= \"False\")"],"execution_count":21,"outputs":[{"output_type":"stream","text":["--------------------------------------------------\n","[8.df.sort_values()]\n"],"name":"stdout"},{"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>month</th>\n","      <th>avg_high</th>\n","      <th>avg_low</th>\n","      <th>record_high</th>\n","      <th>record_low</th>\n","      <th>avg_precipitation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>11</th>\n","      <td>Dec</td>\n","      <td>58</td>\n","      <td>42</td>\n","      <td>73</td>\n","      <td>21</td>\n","      <td>2.56</td>\n","    </tr>\n","    <tr>\n","      <th>0</th>\n","      <td>Jan</td>\n","      <td>58</td>\n","      <td>42</td>\n","      <td>74</td>\n","      <td>22</td>\n","      <td>2.95</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Feb</td>\n","      <td>61</td>\n","      <td>45</td>\n","      <td>78</td>\n","      <td>26</td>\n","      <td>3.02</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Mar</td>\n","      <td>65</td>\n","      <td>48</td>\n","      <td>84</td>\n","      <td>25</td>\n","      <td>2.34</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Nov</td>\n","      <td>64</td>\n","      <td>48</td>\n","      <td>84</td>\n","      <td>30</td>\n","      <td>1.70</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apr</td>\n","      <td>67</td>\n","      <td>50</td>\n","      <td>92</td>\n","      <td>28</td>\n","      <td>1.02</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Oct</td>\n","      <td>73</td>\n","      <td>54</td>\n","      <td>96</td>\n","      <td>34</td>\n","      <td>0.81</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>May</td>\n","      <td>71</td>\n","      <td>53</td>\n","      <td>98</td>\n","      <td>35</td>\n","      <td>0.48</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Aug</td>\n","      <td>77</td>\n","      <td>59</td>\n","      <td>102</td>\n","      <td>43</td>\n","      <td>0.03</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Sep</td>\n","      <td>77</td>\n","      <td>57</td>\n","      <td>103</td>\n","      <td>40</td>\n","      <td>0.17</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Jul</td>\n","      <td>77</td>\n","      <td>58</td>\n","      <td>105</td>\n","      <td>44</td>\n","      <td>0.00</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Jun</td>\n","      <td>75</td>\n","      <td>56</td>\n","      <td>107</td>\n","      <td>41</td>\n","      <td>0.11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   month  avg_high  avg_low  record_high  record_low  avg_precipitation\n","11   Dec        58       42           73          21               2.56\n","0    Jan        58       42           74          22               2.95\n","1    Feb        61       45           78          26               3.02\n","2    Mar        65       48           84          25               2.34\n","10   Nov        64       48           84          30               1.70\n","3    Apr        67       50           92          28               1.02\n","9    Oct        73       54           96          34               0.81\n","4    May        71       53           98          35               0.48\n","7    Aug        77       59          102          43               0.03\n","8    Sep        77       57          103          40               0.17\n","6    Jul        77       58          105          44               0.00\n","5    Jun        75       56          107          41               0.11"]},"metadata":{"tags":[]},"execution_count":21}]},{"cell_type":"code","metadata":{"id":"h-UR-pZ7n0e3","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":254},"outputId":"dd5dd10e-637d-4465-8f5c-cf3f9a154c42","executionInfo":{"status":"ok","timestamp":1567690323616,"user_tz":-330,"elapsed":908,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df.avg_low"],"execution_count":22,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0     42\n","1     45\n","2     48\n","3     50\n","4     53\n","5     56\n","6     58\n","7     59\n","8     57\n","9     54\n","10    48\n","11    42\n","Name: avg_low, dtype: int64"]},"metadata":{"tags":[]},"execution_count":22}]},{"cell_type":"code","metadata":{"id":"zLZqVMiOn_LX","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":254},"outputId":"9b988375-5e66-46c9-8b91-579203481bca","executionInfo":{"status":"ok","timestamp":1567690362691,"user_tz":-330,"elapsed":893,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df['avg_low']"],"execution_count":23,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0     42\n","1     45\n","2     48\n","3     50\n","4     53\n","5     56\n","6     58\n","7     59\n","8     57\n","9     54\n","10    48\n","11    42\n","Name: avg_low, dtype: int64"]},"metadata":{"tags":[]},"execution_count":23}]},{"cell_type":"code","metadata":{"id":"k-j6WJQAoIuH","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":108},"outputId":"f421f09e-11e8-4be1-a623-6a888132bb0d","executionInfo":{"status":"ok","timestamp":1567690375485,"user_tz":-330,"elapsed":902,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df[2:4]"],"execution_count":24,"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>month</th>\n","      <th>avg_high</th>\n","      <th>avg_low</th>\n","      <th>record_high</th>\n","      <th>record_low</th>\n","      <th>avg_precipitation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2</th>\n","      <td>Mar</td>\n","      <td>65</td>\n","      <td>48</td>\n","      <td>84</td>\n","      <td>25</td>\n","      <td>2.34</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apr</td>\n","      <td>67</td>\n","      <td>50</td>\n","      <td>92</td>\n","      <td>28</td>\n","      <td>1.02</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  month  avg_high  avg_low  record_high  record_low  avg_precipitation\n","2   Mar        65       48           84          25               2.34\n","3   Apr        67       50           92          28               1.02"]},"metadata":{"tags":[]},"execution_count":24}]},{"cell_type":"code","metadata":{"id":"kq7wKhXZoL13","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":408},"outputId":"94b59318-0ef7-48d1-c2d8-75e3a2d72c50","executionInfo":{"status":"ok","timestamp":1567690428125,"user_tz":-330,"elapsed":892,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df[['avg_low','avg_high','record_high']]"],"execution_count":25,"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>avg_low</th>\n","      <th>avg_high</th>\n","      <th>record_high</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>42</td>\n","      <td>58</td>\n","      <td>74</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>45</td>\n","      <td>61</td>\n","      <td>78</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>48</td>\n","      <td>65</td>\n","      <td>84</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>50</td>\n","      <td>67</td>\n","      <td>92</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>53</td>\n","      <td>71</td>\n","      <td>98</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>56</td>\n","      <td>75</td>\n","      <td>107</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>58</td>\n","      <td>77</td>\n","      <td>105</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>59</td>\n","      <td>77</td>\n","      <td>102</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>57</td>\n","      <td>77</td>\n","      <td>103</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>54</td>\n","      <td>73</td>\n","      <td>96</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>48</td>\n","      <td>64</td>\n","      <td>84</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>42</td>\n","      <td>58</td>\n","      <td>73</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["    avg_low  avg_high  record_high\n","0        42        58           74\n","1        45        61           78\n","2        48        65           84\n","3        50        67           92\n","4        53        71           98\n","5        56        75          107\n","6        58        77          105\n","7        59        77          102\n","8        57        77          103\n","9        54        73           96\n","10       48        64           84\n","11       42        58           73"]},"metadata":{"tags":[]},"execution_count":25}]},{"cell_type":"code","metadata":{"id":"lef2QUvipHBw","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":138},"outputId":"539af8bc-90bb-4c0b-9975-3cf47ef0faec","executionInfo":{"status":"ok","timestamp":1567690651829,"user_tz":-330,"elapsed":958,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df.iloc[5:8 , [0,3]]  #it will use as array "],"execution_count":31,"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>month</th>\n","      <th>record_high</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>5</th>\n","      <td>Jun</td>\n","      <td>107</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Jul</td>\n","      <td>105</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Aug</td>\n","      <td>102</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  month  record_high\n","5   Jun          107\n","6   Jul          105\n","7   Aug          102"]},"metadata":{"tags":[]},"execution_count":31}]},{"cell_type":"code","metadata":{"id":"4si2C3eEoYsf","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":168},"outputId":"9900474e-f147-43a6-a167-6b972b9ccea2","executionInfo":{"status":"ok","timestamp":1567690473497,"user_tz":-330,"elapsed":1099,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df.loc[5:8 , ['avg_low','avg_high','record_high']]"],"execution_count":26,"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>avg_low</th>\n","      <th>avg_high</th>\n","      <th>record_high</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>5</th>\n","      <td>56</td>\n","      <td>75</td>\n","      <td>107</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>58</td>\n","      <td>77</td>\n","      <td>105</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>59</td>\n","      <td>77</td>\n","      <td>102</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>57</td>\n","      <td>77</td>\n","      <td>103</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   avg_low  avg_high  record_high\n","5       56        75          107\n","6       58        77          105\n","7       59        77          102\n","8       57        77          103"]},"metadata":{"tags":[]},"execution_count":26}]},{"cell_type":"code","metadata":{"id":"SUewro9tojuP","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":90},"outputId":"c695ca48-1bd1-4a83-9a52-817af2b7f59f","executionInfo":{"status":"ok","timestamp":1567690492152,"user_tz":-330,"elapsed":899,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df.loc[9, ['avg_low','avg_high','record_high']]"],"execution_count":27,"outputs":[{"output_type":"execute_result","data":{"text/plain":["avg_low        54\n","avg_high       73\n","record_high    96\n","Name: 9, dtype: object"]},"metadata":{"tags":[]},"execution_count":27}]},{"cell_type":"code","metadata":{"id":"rZYQ0Z9_ooUv","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":108},"outputId":"8d4f91ee-adb6-4b37-cb85-ac39532fa11f","executionInfo":{"status":"ok","timestamp":1567690530488,"user_tz":-330,"elapsed":1324,"user":{"displayName":"HRITIK JAISWAL","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mAIoT5asTvy-RaZPvDKRvz2bMxFBhU-1QvQZ2E4=s64","userId":"10596177819840519504"}}},"source":["df.iloc[3:5,[0,3]]"],"execution_count":28,"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>month</th>\n","      <th>record_high</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>3</th>\n","      <td>Apr</td>\n","      <td>92</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>May</td>\n","      <td>98</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  month  record_high\n","3   Apr           92\n","4   May           98"]},"metadata":{"tags":[]},"execution_count":28}]},{"cell_type":"code","metadata":{"id":"FFsOEqRioxlP","colab_type":"code","colab":{}},"source":[""],"execution_count":0,"outputs":[]}]}