{"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":[]}]}
