pycurl1

{"nbformat_minor": 0, "cells": [{"execution_count": 1, "cell_type": "code", "source": "#Importing libraries\nimport pandas as pd\nimport os as os\nimport pycurl\nimport csv", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 2, "cell_type": "code", "source": "#To get the location of current working directory\nos.getcwd()", "outputs": [{"execution_count": 2, "output_type": "execute_result", "data": {"text/plain": "'C:\\\\Anaconda'"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 4, "cell_type": "code", "source": "#To change the working directory\nos.chdir('C:\\\\Anaconda\\\\abalone')\nos.getcwd()", "outputs": [{"execution_count": 4, "output_type": "execute_result", "data": {"text/plain": "'C:\\\\Anaconda\\\\abalone'"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 5, "cell_type": "code", "source": "#Use pycurl to get a datafile from https and write it to a csv file\nurl = 'https://archive.ics.uci.edu/ml/machine-learning-databases/abalone/abalone.data'\nc = pycurl.Curl()\nc.setopt(c.URL, url)\nwith open('abalone.csv', 'w+') as s:\n    c.setopt(c.WRITEFUNCTION, s.write)\n    c.perform()", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 6, "cell_type": "code", "source": "abalone = pd.read_csv('abalone.csv')\nabalone", "outputs": [{"execution_count": 6, "output_type": "execute_result", "data": {"text/plain": "      M  0.455  0.365  0.095   0.514  0.2245   0.101    0.15  15\n0     M  0.350  0.265  0.090  0.2255  0.0995  0.0485  0.0700   7\n1     F  0.530  0.420  0.135  0.6770  0.2565  0.1415  0.2100   9\n2     M  0.440  0.365  0.125  0.5160  0.2155  0.1140  0.1550  10\n3     I  0.330  0.255  0.080  0.2050  0.0895  0.0395  0.0550   7\n4     I  0.425  0.300  0.095  0.3515  0.1410  0.0775  0.1200   8\n5     F  0.530  0.415  0.150  0.7775  0.2370  0.1415  0.3300  20\n6     F  0.545  0.425  0.125  0.7680  0.2940  0.1495  0.2600  16\n7     M  0.475  0.370  0.125  0.5095  0.2165  0.1125  0.1650   9\n8     F  0.550  0.440  0.150  0.8945  0.3145  0.1510  0.3200  19\n9     F  0.525  0.380  0.140  0.6065  0.1940  0.1475  0.2100  14\n10    M  0.430  0.350  0.110  0.4060  0.1675  0.0810  0.1350  10\n11    M  0.490  0.380  0.135  0.5415  0.2175  0.0950  0.1900  11\n12    F  0.535  0.405  0.145  0.6845  0.2725  0.1710  0.2050  10\n13    F  0.470  0.355  0.100  0.4755  0.1675  0.0805  0.1850  10\n14    M  0.500  0.400  0.130  0.6645  0.2580  0.1330  0.2400  12\n15    I  0.355  0.280  0.085  0.2905  0.0950  0.0395  0.1150   7\n16    F  0.440  0.340  0.100  0.4510  0.1880  0.0870  0.1300  10\n17    M  0.365  0.295  0.080  0.2555  0.0970  0.0430  0.1000   7\n18    M  0.450  0.320  0.100  0.3810  0.1705  0.0750  0.1150   9\n19    M  0.355  0.280  0.095  0.2455  0.0955  0.0620  0.0750  11\n20    I  0.380  0.275  0.100  0.2255  0.0800  0.0490  0.0850  10\n21    F  0.565  0.440  0.155  0.9395  0.4275  0.2140  0.2700  12\n22    F  0.550  0.415  0.135  0.7635  0.3180  0.2100  0.2000   9\n23    F  0.615  0.480  0.165  1.1615  0.5130  0.3010  0.3050  10\n24    F  0.560  0.440  0.140  0.9285  0.3825  0.1880  0.3000  11\n25    F  0.580  0.450  0.185  0.9955  0.3945  0.2720  0.2850  11\n26    M  0.590  0.445  0.140  0.9310  0.3560  0.2340  0.2800  12\n27    M  0.605  0.475  0.180  0.9365  0.3940  0.2190  0.2950  15\n28    M  0.575  0.425  0.140  0.8635  0.3930  0.2270  0.2000  11\n29    M  0.580  0.470  0.165  0.9975  0.3935  0.2420  0.3300  10\n...  ..    ...    ...    ...     ...     ...     ...     ...  ..\n4146  M  0.695  0.550  0.195  1.6645  0.7270  0.3600  0.4450  11\n4147  M  0.770  0.605  0.175  2.0505  0.8005  0.5260  0.3550  11\n4148  I  0.280  0.215  0.070  0.1240  0.0630  0.0215  0.0300   6\n4149  I  0.330  0.230  0.080  0.1400  0.0565  0.0365  0.0460   7\n4150  I  0.350  0.250  0.075  0.1695  0.0835  0.0355  0.0410   6\n4151  I  0.370  0.280  0.090  0.2180  0.0995  0.0545  0.0615   7\n4152  I  0.430  0.315  0.115  0.3840  0.1885  0.0715  0.1100   8\n4153  I  0.435  0.330  0.095  0.3930  0.2190  0.0750  0.0885   6\n4154  I  0.440  0.350  0.110  0.3805  0.1575  0.0895  0.1150   6\n4155  M  0.475  0.370  0.110  0.4895  0.2185  0.1070  0.1460   8\n4156  M  0.475  0.360  0.140  0.5135  0.2410  0.1045  0.1550   8\n4157  I  0.480  0.355  0.110  0.4495  0.2010  0.0890  0.1400   8\n4158  F  0.560  0.440  0.135  0.8025  0.3500  0.1615  0.2590   9\n4159  F  0.585  0.475  0.165  1.0530  0.4580  0.2170  0.3000  11\n4160  F  0.585  0.455  0.170  0.9945  0.4255  0.2630  0.2845  11\n4161  M  0.385  0.255  0.100  0.3175  0.1370  0.0680  0.0920   8\n4162  I  0.390  0.310  0.085  0.3440  0.1810  0.0695  0.0790   7\n4163  I  0.390  0.290  0.100  0.2845  0.1255  0.0635  0.0810   7\n4164  I  0.405  0.300  0.085  0.3035  0.1500  0.0505  0.0880   7\n4165  I  0.475  0.365  0.115  0.4990  0.2320  0.0885  0.1560  10\n4166  M  0.500  0.380  0.125  0.5770  0.2690  0.1265  0.1535   9\n4167  F  0.515  0.400  0.125  0.6150  0.2865  0.1230  0.1765   8\n4168  M  0.520  0.385  0.165  0.7910  0.3750  0.1800  0.1815  10\n4169  M  0.550  0.430  0.130  0.8395  0.3155  0.1955  0.2405  10\n4170  M  0.560  0.430  0.155  0.8675  0.4000  0.1720  0.2290   8\n4171  F  0.565  0.450  0.165  0.8870  0.3700  0.2390  0.2490  11\n4172  M  0.590  0.440  0.135  0.9660  0.4390  0.2145  0.2605  10\n4173  M  0.600  0.475  0.205  1.1760  0.5255  0.2875  0.3080   9\n4174  F  0.625  0.485  0.150  1.0945  0.5310  0.2610  0.2960  10\n4175  M  0.710  0.555  0.195  1.9485  0.9455  0.3765  0.4950  12\n\n[4176 rows x 9 columns]", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>M</th>\n      <th>0.455</th>\n      <th>0.365</th>\n      <th>0.095</th>\n      <th>0.514</th>\n      <th>0.2245</th>\n      <th>0.101</th>\n      <th>0.15</th>\n      <th>15</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0   </th>\n      <td> M</td>\n      <td> 0.350</td>\n      <td> 0.265</td>\n      <td> 0.090</td>\n      <td> 0.2255</td>\n      <td> 0.0995</td>\n      <td> 0.0485</td>\n      <td> 0.0700</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>1   </th>\n      <td> F</td>\n      <td> 0.530</td>\n      <td> 0.420</td>\n      <td> 0.135</td>\n      <td> 0.6770</td>\n      <td> 0.2565</td>\n      <td> 0.1415</td>\n      <td> 0.2100</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>2   </th>\n      <td> M</td>\n      <td> 0.440</td>\n      <td> 0.365</td>\n      <td> 0.125</td>\n      <td> 0.5160</td>\n      <td> 0.2155</td>\n      <td> 0.1140</td>\n      <td> 0.1550</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>3   </th>\n      <td> I</td>\n      <td> 0.330</td>\n      <td> 0.255</td>\n      <td> 0.080</td>\n      <td> 0.2050</td>\n      <td> 0.0895</td>\n      <td> 0.0395</td>\n      <td> 0.0550</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4   </th>\n      <td> I</td>\n      <td> 0.425</td>\n      <td> 0.300</td>\n      <td> 0.095</td>\n      <td> 0.3515</td>\n      <td> 0.1410</td>\n      <td> 0.0775</td>\n      <td> 0.1200</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>5   </th>\n      <td> F</td>\n      <td> 0.530</td>\n      <td> 0.415</td>\n      <td> 0.150</td>\n      <td> 0.7775</td>\n      <td> 0.2370</td>\n      <td> 0.1415</td>\n      <td> 0.3300</td>\n      <td> 20</td>\n    </tr>\n    <tr>\n      <th>6   </th>\n      <td> F</td>\n      <td> 0.545</td>\n      <td> 0.425</td>\n      <td> 0.125</td>\n      <td> 0.7680</td>\n      <td> 0.2940</td>\n      <td> 0.1495</td>\n      <td> 0.2600</td>\n      <td> 16</td>\n    </tr>\n    <tr>\n      <th>7   </th>\n      <td> M</td>\n      <td> 0.475</td>\n      <td> 0.370</td>\n      <td> 0.125</td>\n      <td> 0.5095</td>\n      <td> 0.2165</td>\n      <td> 0.1125</td>\n      <td> 0.1650</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>8   </th>\n      <td> F</td>\n      <td> 0.550</td>\n      <td> 0.440</td>\n      <td> 0.150</td>\n      <td> 0.8945</td>\n      <td> 0.3145</td>\n      <td> 0.1510</td>\n      <td> 0.3200</td>\n      <td> 19</td>\n    </tr>\n    <tr>\n      <th>9   </th>\n      <td> F</td>\n      <td> 0.525</td>\n      <td> 0.380</td>\n      <td> 0.140</td>\n      <td> 0.6065</td>\n      <td> 0.1940</td>\n      <td> 0.1475</td>\n      <td> 0.2100</td>\n      <td> 14</td>\n    </tr>\n    <tr>\n      <th>10  </th>\n      <td> M</td>\n      <td> 0.430</td>\n      <td> 0.350</td>\n      <td> 0.110</td>\n      <td> 0.4060</td>\n      <td> 0.1675</td>\n      <td> 0.0810</td>\n      <td> 0.1350</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>11  </th>\n      <td> M</td>\n      <td> 0.490</td>\n      <td> 0.380</td>\n      <td> 0.135</td>\n      <td> 0.5415</td>\n      <td> 0.2175</td>\n      <td> 0.0950</td>\n      <td> 0.1900</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>12  </th>\n      <td> F</td>\n      <td> 0.535</td>\n      <td> 0.405</td>\n      <td> 0.145</td>\n      <td> 0.6845</td>\n      <td> 0.2725</td>\n      <td> 0.1710</td>\n      <td> 0.2050</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>13  </th>\n      <td> F</td>\n      <td> 0.470</td>\n      <td> 0.355</td>\n      <td> 0.100</td>\n      <td> 0.4755</td>\n      <td> 0.1675</td>\n      <td> 0.0805</td>\n      <td> 0.1850</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>14  </th>\n      <td> M</td>\n      <td> 0.500</td>\n      <td> 0.400</td>\n      <td> 0.130</td>\n      <td> 0.6645</td>\n      <td> 0.2580</td>\n      <td> 0.1330</td>\n      <td> 0.2400</td>\n      <td> 12</td>\n    </tr>\n    <tr>\n      <th>15  </th>\n      <td> I</td>\n      <td> 0.355</td>\n      <td> 0.280</td>\n      <td> 0.085</td>\n      <td> 0.2905</td>\n      <td> 0.0950</td>\n      <td> 0.0395</td>\n      <td> 0.1150</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>16  </th>\n      <td> F</td>\n      <td> 0.440</td>\n      <td> 0.340</td>\n      <td> 0.100</td>\n      <td> 0.4510</td>\n      <td> 0.1880</td>\n      <td> 0.0870</td>\n      <td> 0.1300</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>17  </th>\n      <td> M</td>\n      <td> 0.365</td>\n      <td> 0.295</td>\n      <td> 0.080</td>\n      <td> 0.2555</td>\n      <td> 0.0970</td>\n      <td> 0.0430</td>\n      <td> 0.1000</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>18  </th>\n      <td> M</td>\n      <td> 0.450</td>\n      <td> 0.320</td>\n      <td> 0.100</td>\n      <td> 0.3810</td>\n      <td> 0.1705</td>\n      <td> 0.0750</td>\n      <td> 0.1150</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>19  </th>\n      <td> M</td>\n      <td> 0.355</td>\n      <td> 0.280</td>\n      <td> 0.095</td>\n      <td> 0.2455</td>\n      <td> 0.0955</td>\n      <td> 0.0620</td>\n      <td> 0.0750</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>20  </th>\n      <td> I</td>\n      <td> 0.380</td>\n      <td> 0.275</td>\n      <td> 0.100</td>\n      <td> 0.2255</td>\n      <td> 0.0800</td>\n      <td> 0.0490</td>\n      <td> 0.0850</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>21  </th>\n      <td> F</td>\n      <td> 0.565</td>\n      <td> 0.440</td>\n      <td> 0.155</td>\n      <td> 0.9395</td>\n      <td> 0.4275</td>\n      <td> 0.2140</td>\n      <td> 0.2700</td>\n      <td> 12</td>\n    </tr>\n    <tr>\n      <th>22  </th>\n      <td> F</td>\n      <td> 0.550</td>\n      <td> 0.415</td>\n      <td> 0.135</td>\n      <td> 0.7635</td>\n      <td> 0.3180</td>\n      <td> 0.2100</td>\n      <td> 0.2000</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>23  </th>\n      <td> F</td>\n      <td> 0.615</td>\n      <td> 0.480</td>\n      <td> 0.165</td>\n      <td> 1.1615</td>\n      <td> 0.5130</td>\n      <td> 0.3010</td>\n      <td> 0.3050</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>24  </th>\n      <td> F</td>\n      <td> 0.560</td>\n      <td> 0.440</td>\n      <td> 0.140</td>\n      <td> 0.9285</td>\n      <td> 0.3825</td>\n      <td> 0.1880</td>\n      <td> 0.3000</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>25  </th>\n      <td> F</td>\n      <td> 0.580</td>\n      <td> 0.450</td>\n      <td> 0.185</td>\n      <td> 0.9955</td>\n      <td> 0.3945</td>\n      <td> 0.2720</td>\n      <td> 0.2850</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>26  </th>\n      <td> M</td>\n      <td> 0.590</td>\n      <td> 0.445</td>\n      <td> 0.140</td>\n      <td> 0.9310</td>\n      <td> 0.3560</td>\n      <td> 0.2340</td>\n      <td> 0.2800</td>\n      <td> 12</td>\n    </tr>\n    <tr>\n      <th>27  </th>\n      <td> M</td>\n      <td> 0.605</td>\n      <td> 0.475</td>\n      <td> 0.180</td>\n      <td> 0.9365</td>\n      <td> 0.3940</td>\n      <td> 0.2190</td>\n      <td> 0.2950</td>\n      <td> 15</td>\n    </tr>\n    <tr>\n      <th>28  </th>\n      <td> M</td>\n      <td> 0.575</td>\n      <td> 0.425</td>\n      <td> 0.140</td>\n      <td> 0.8635</td>\n      <td> 0.3930</td>\n      <td> 0.2270</td>\n      <td> 0.2000</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>29  </th>\n      <td> M</td>\n      <td> 0.580</td>\n      <td> 0.470</td>\n      <td> 0.165</td>\n      <td> 0.9975</td>\n      <td> 0.3935</td>\n      <td> 0.2420</td>\n      <td> 0.3300</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>4146</th>\n      <td> M</td>\n      <td> 0.695</td>\n      <td> 0.550</td>\n      <td> 0.195</td>\n      <td> 1.6645</td>\n      <td> 0.7270</td>\n      <td> 0.3600</td>\n      <td> 0.4450</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>4147</th>\n      <td> M</td>\n      <td> 0.770</td>\n      <td> 0.605</td>\n      <td> 0.175</td>\n      <td> 2.0505</td>\n      <td> 0.8005</td>\n      <td> 0.5260</td>\n      <td> 0.3550</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>4148</th>\n      <td> I</td>\n      <td> 0.280</td>\n      <td> 0.215</td>\n      <td> 0.070</td>\n      <td> 0.1240</td>\n      <td> 0.0630</td>\n      <td> 0.0215</td>\n      <td> 0.0300</td>\n      <td>  6</td>\n    </tr>\n    <tr>\n      <th>4149</th>\n      <td> I</td>\n      <td> 0.330</td>\n      <td> 0.230</td>\n      <td> 0.080</td>\n      <td> 0.1400</td>\n      <td> 0.0565</td>\n      <td> 0.0365</td>\n      <td> 0.0460</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4150</th>\n      <td> I</td>\n      <td> 0.350</td>\n      <td> 0.250</td>\n      <td> 0.075</td>\n      <td> 0.1695</td>\n      <td> 0.0835</td>\n      <td> 0.0355</td>\n      <td> 0.0410</td>\n      <td>  6</td>\n    </tr>\n    <tr>\n      <th>4151</th>\n      <td> I</td>\n      <td> 0.370</td>\n      <td> 0.280</td>\n      <td> 0.090</td>\n      <td> 0.2180</td>\n      <td> 0.0995</td>\n      <td> 0.0545</td>\n      <td> 0.0615</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4152</th>\n      <td> I</td>\n      <td> 0.430</td>\n      <td> 0.315</td>\n      <td> 0.115</td>\n      <td> 0.3840</td>\n      <td> 0.1885</td>\n      <td> 0.0715</td>\n      <td> 0.1100</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4153</th>\n      <td> I</td>\n      <td> 0.435</td>\n      <td> 0.330</td>\n      <td> 0.095</td>\n      <td> 0.3930</td>\n      <td> 0.2190</td>\n      <td> 0.0750</td>\n      <td> 0.0885</td>\n      <td>  6</td>\n    </tr>\n    <tr>\n      <th>4154</th>\n      <td> I</td>\n      <td> 0.440</td>\n      <td> 0.350</td>\n      <td> 0.110</td>\n      <td> 0.3805</td>\n      <td> 0.1575</td>\n      <td> 0.0895</td>\n      <td> 0.1150</td>\n      <td>  6</td>\n    </tr>\n    <tr>\n      <th>4155</th>\n      <td> M</td>\n      <td> 0.475</td>\n      <td> 0.370</td>\n      <td> 0.110</td>\n      <td> 0.4895</td>\n      <td> 0.2185</td>\n      <td> 0.1070</td>\n      <td> 0.1460</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4156</th>\n      <td> M</td>\n      <td> 0.475</td>\n      <td> 0.360</td>\n      <td> 0.140</td>\n      <td> 0.5135</td>\n      <td> 0.2410</td>\n      <td> 0.1045</td>\n      <td> 0.1550</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4157</th>\n      <td> I</td>\n      <td> 0.480</td>\n      <td> 0.355</td>\n      <td> 0.110</td>\n      <td> 0.4495</td>\n      <td> 0.2010</td>\n      <td> 0.0890</td>\n      <td> 0.1400</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4158</th>\n      <td> F</td>\n      <td> 0.560</td>\n      <td> 0.440</td>\n      <td> 0.135</td>\n      <td> 0.8025</td>\n      <td> 0.3500</td>\n      <td> 0.1615</td>\n      <td> 0.2590</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>4159</th>\n      <td> F</td>\n      <td> 0.585</td>\n      <td> 0.475</td>\n      <td> 0.165</td>\n      <td> 1.0530</td>\n      <td> 0.4580</td>\n      <td> 0.2170</td>\n      <td> 0.3000</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>4160</th>\n      <td> F</td>\n      <td> 0.585</td>\n      <td> 0.455</td>\n      <td> 0.170</td>\n      <td> 0.9945</td>\n      <td> 0.4255</td>\n      <td> 0.2630</td>\n      <td> 0.2845</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>4161</th>\n      <td> M</td>\n      <td> 0.385</td>\n      <td> 0.255</td>\n      <td> 0.100</td>\n      <td> 0.3175</td>\n      <td> 0.1370</td>\n      <td> 0.0680</td>\n      <td> 0.0920</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4162</th>\n      <td> I</td>\n      <td> 0.390</td>\n      <td> 0.310</td>\n      <td> 0.085</td>\n      <td> 0.3440</td>\n      <td> 0.1810</td>\n      <td> 0.0695</td>\n      <td> 0.0790</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4163</th>\n      <td> I</td>\n      <td> 0.390</td>\n      <td> 0.290</td>\n      <td> 0.100</td>\n      <td> 0.2845</td>\n      <td> 0.1255</td>\n      <td> 0.0635</td>\n      <td> 0.0810</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4164</th>\n      <td> I</td>\n      <td> 0.405</td>\n      <td> 0.300</td>\n      <td> 0.085</td>\n      <td> 0.3035</td>\n      <td> 0.1500</td>\n      <td> 0.0505</td>\n      <td> 0.0880</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>4165</th>\n      <td> I</td>\n      <td> 0.475</td>\n      <td> 0.365</td>\n      <td> 0.115</td>\n      <td> 0.4990</td>\n      <td> 0.2320</td>\n      <td> 0.0885</td>\n      <td> 0.1560</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4166</th>\n      <td> M</td>\n      <td> 0.500</td>\n      <td> 0.380</td>\n      <td> 0.125</td>\n      <td> 0.5770</td>\n      <td> 0.2690</td>\n      <td> 0.1265</td>\n      <td> 0.1535</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>4167</th>\n      <td> F</td>\n      <td> 0.515</td>\n      <td> 0.400</td>\n      <td> 0.125</td>\n      <td> 0.6150</td>\n      <td> 0.2865</td>\n      <td> 0.1230</td>\n      <td> 0.1765</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4168</th>\n      <td> M</td>\n      <td> 0.520</td>\n      <td> 0.385</td>\n      <td> 0.165</td>\n      <td> 0.7910</td>\n      <td> 0.3750</td>\n      <td> 0.1800</td>\n      <td> 0.1815</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4169</th>\n      <td> M</td>\n      <td> 0.550</td>\n      <td> 0.430</td>\n      <td> 0.130</td>\n      <td> 0.8395</td>\n      <td> 0.3155</td>\n      <td> 0.1955</td>\n      <td> 0.2405</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4170</th>\n      <td> M</td>\n      <td> 0.560</td>\n      <td> 0.430</td>\n      <td> 0.155</td>\n      <td> 0.8675</td>\n      <td> 0.4000</td>\n      <td> 0.1720</td>\n      <td> 0.2290</td>\n      <td>  8</td>\n    </tr>\n    <tr>\n      <th>4171</th>\n      <td> F</td>\n      <td> 0.565</td>\n      <td> 0.450</td>\n      <td> 0.165</td>\n      <td> 0.8870</td>\n      <td> 0.3700</td>\n      <td> 0.2390</td>\n      <td> 0.2490</td>\n      <td> 11</td>\n    </tr>\n    <tr>\n      <th>4172</th>\n      <td> M</td>\n      <td> 0.590</td>\n      <td> 0.440</td>\n      <td> 0.135</td>\n      <td> 0.9660</td>\n      <td> 0.4390</td>\n      <td> 0.2145</td>\n      <td> 0.2605</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4173</th>\n      <td> M</td>\n      <td> 0.600</td>\n      <td> 0.475</td>\n      <td> 0.205</td>\n      <td> 1.1760</td>\n      <td> 0.5255</td>\n      <td> 0.2875</td>\n      <td> 0.3080</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>4174</th>\n      <td> F</td>\n      <td> 0.625</td>\n      <td> 0.485</td>\n      <td> 0.150</td>\n      <td> 1.0945</td>\n      <td> 0.5310</td>\n      <td> 0.2610</td>\n      <td> 0.2960</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4175</th>\n      <td> M</td>\n      <td> 0.710</td>\n      <td> 0.555</td>\n      <td> 0.195</td>\n      <td> 1.9485</td>\n      <td> 0.9455</td>\n      <td> 0.3765</td>\n      <td> 0.4950</td>\n      <td> 12</td>\n    </tr>\n  </tbody>\n</table>\n<p>4176 rows \u00d7 9 columns</p>\n</div>"}, "metadata": {}}], "metadata": {"scrolled": true, "collapsed": false, "trusted": true}}, {"execution_count": 8, "cell_type": "code", "source": "#To add column names\nabalone.columns = ['Sex', 'Length','Diameter','Height','Whole weight','Shucked weight','Viscera weight','Shell weight','Rings']", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 14, "cell_type": "code", "source": "#To write data to a csv file\nabalone.to_csv('abalone.csv')", "outputs": [], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 15, "cell_type": "code", "source": "#To get 4 top-most observations\nabalone.head(4)", "outputs": [{"execution_count": 15, "output_type": "execute_result", "data": {"text/plain": "  Sex  Length  Diameter  Height  Whole weight  Shucked weight  Viscera weight  \\\n0   M    0.35     0.265   0.090        0.2255          0.0995          0.0485   \n1   F    0.53     0.420   0.135        0.6770          0.2565          0.1415   \n2   M    0.44     0.365   0.125        0.5160          0.2155          0.1140   \n3   I    0.33     0.255   0.080        0.2050          0.0895          0.0395   \n\n   Shell weight  Rings  \n0         0.070      7  \n1         0.210      9  \n2         0.155     10  \n3         0.055      7  ", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Sex</th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n      <th>Whole weight</th>\n      <th>Shucked weight</th>\n      <th>Viscera weight</th>\n      <th>Shell weight</th>\n      <th>Rings</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td> M</td>\n      <td> 0.35</td>\n      <td> 0.265</td>\n      <td> 0.090</td>\n      <td> 0.2255</td>\n      <td> 0.0995</td>\n      <td> 0.0485</td>\n      <td> 0.070</td>\n      <td>  7</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td> F</td>\n      <td> 0.53</td>\n      <td> 0.420</td>\n      <td> 0.135</td>\n      <td> 0.6770</td>\n      <td> 0.2565</td>\n      <td> 0.1415</td>\n      <td> 0.210</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td> M</td>\n      <td> 0.44</td>\n      <td> 0.365</td>\n      <td> 0.125</td>\n      <td> 0.5160</td>\n      <td> 0.2155</td>\n      <td> 0.1140</td>\n      <td> 0.155</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td> I</td>\n      <td> 0.33</td>\n      <td> 0.255</td>\n      <td> 0.080</td>\n      <td> 0.2050</td>\n      <td> 0.0895</td>\n      <td> 0.0395</td>\n      <td> 0.055</td>\n      <td>  7</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 16, "cell_type": "code", "source": "#To get 4 bottom-most observations\nabalone.tail(4)", "outputs": [{"execution_count": 16, "output_type": "execute_result", "data": {"text/plain": "     Sex  Length  Diameter  Height  Whole weight  Shucked weight  \\\n4172   M   0.590     0.440   0.135        0.9660          0.4390   \n4173   M   0.600     0.475   0.205        1.1760          0.5255   \n4174   F   0.625     0.485   0.150        1.0945          0.5310   \n4175   M   0.710     0.555   0.195        1.9485          0.9455   \n\n      Viscera weight  Shell weight  Rings  \n4172          0.2145        0.2605     10  \n4173          0.2875        0.3080      9  \n4174          0.2610        0.2960     10  \n4175          0.3765        0.4950     12  ", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Sex</th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n      <th>Whole weight</th>\n      <th>Shucked weight</th>\n      <th>Viscera weight</th>\n      <th>Shell weight</th>\n      <th>Rings</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>4172</th>\n      <td> M</td>\n      <td> 0.590</td>\n      <td> 0.440</td>\n      <td> 0.135</td>\n      <td> 0.9660</td>\n      <td> 0.4390</td>\n      <td> 0.2145</td>\n      <td> 0.2605</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4173</th>\n      <td> M</td>\n      <td> 0.600</td>\n      <td> 0.475</td>\n      <td> 0.205</td>\n      <td> 1.1760</td>\n      <td> 0.5255</td>\n      <td> 0.2875</td>\n      <td> 0.3080</td>\n      <td>  9</td>\n    </tr>\n    <tr>\n      <th>4174</th>\n      <td> F</td>\n      <td> 0.625</td>\n      <td> 0.485</td>\n      <td> 0.150</td>\n      <td> 1.0945</td>\n      <td> 0.5310</td>\n      <td> 0.2610</td>\n      <td> 0.2960</td>\n      <td> 10</td>\n    </tr>\n    <tr>\n      <th>4175</th>\n      <td> M</td>\n      <td> 0.710</td>\n      <td> 0.555</td>\n      <td> 0.195</td>\n      <td> 1.9485</td>\n      <td> 0.9455</td>\n      <td> 0.3765</td>\n      <td> 0.4950</td>\n      <td> 12</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 17, "cell_type": "code", "source": "#To get basic statistics for all numeric variables\nabalone.describe()", "outputs": [{"execution_count": 17, "output_type": "execute_result", "data": {"text/plain": "            Length     Diameter       Height  Whole weight  Shucked weight  \\\ncount  4176.000000  4176.000000  4176.000000   4176.000000      4176.00000   \nmean      0.524009     0.407892     0.139527      0.828818         0.35940   \nstd       0.120103     0.099250     0.041826      0.490424         0.22198   \nmin       0.075000     0.055000     0.000000      0.002000         0.00100   \n25%       0.450000     0.350000     0.115000      0.441500         0.18600   \n50%       0.545000     0.425000     0.140000      0.799750         0.33600   \n75%       0.615000     0.480000     0.165000      1.153250         0.50200   \nmax       0.815000     0.650000     1.130000      2.825500         1.48800   \n\n       Viscera weight  Shell weight        Rings  \ncount     4176.000000   4176.000000  4176.000000  \nmean         0.180613      0.238852     9.932471  \nstd          0.109620      0.139213     3.223601  \nmin          0.000500      0.001500     1.000000  \n25%          0.093375      0.130000     8.000000  \n50%          0.171000      0.234000     9.000000  \n75%          0.253000      0.329000    11.000000  \nmax          0.760000      1.005000    29.000000  ", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n      <th>Whole weight</th>\n      <th>Shucked weight</th>\n      <th>Viscera weight</th>\n      <th>Shell weight</th>\n      <th>Rings</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>count</th>\n      <td> 4176.000000</td>\n      <td> 4176.000000</td>\n      <td> 4176.000000</td>\n      <td> 4176.000000</td>\n      <td> 4176.00000</td>\n      <td> 4176.000000</td>\n      <td> 4176.000000</td>\n      <td> 4176.000000</td>\n    </tr>\n    <tr>\n      <th>mean</th>\n      <td>    0.524009</td>\n      <td>    0.407892</td>\n      <td>    0.139527</td>\n      <td>    0.828818</td>\n      <td>    0.35940</td>\n      <td>    0.180613</td>\n      <td>    0.238852</td>\n      <td>    9.932471</td>\n    </tr>\n    <tr>\n      <th>std</th>\n      <td>    0.120103</td>\n      <td>    0.099250</td>\n      <td>    0.041826</td>\n      <td>    0.490424</td>\n      <td>    0.22198</td>\n      <td>    0.109620</td>\n      <td>    0.139213</td>\n      <td>    3.223601</td>\n    </tr>\n    <tr>\n      <th>min</th>\n      <td>    0.075000</td>\n      <td>    0.055000</td>\n      <td>    0.000000</td>\n      <td>    0.002000</td>\n      <td>    0.00100</td>\n      <td>    0.000500</td>\n      <td>    0.001500</td>\n      <td>    1.000000</td>\n    </tr>\n    <tr>\n      <th>25%</th>\n      <td>    0.450000</td>\n      <td>    0.350000</td>\n      <td>    0.115000</td>\n      <td>    0.441500</td>\n      <td>    0.18600</td>\n      <td>    0.093375</td>\n      <td>    0.130000</td>\n      <td>    8.000000</td>\n    </tr>\n    <tr>\n      <th>50%</th>\n      <td>    0.545000</td>\n      <td>    0.425000</td>\n      <td>    0.140000</td>\n      <td>    0.799750</td>\n      <td>    0.33600</td>\n      <td>    0.171000</td>\n      <td>    0.234000</td>\n      <td>    9.000000</td>\n    </tr>\n    <tr>\n      <th>75%</th>\n      <td>    0.615000</td>\n      <td>    0.480000</td>\n      <td>    0.165000</td>\n      <td>    1.153250</td>\n      <td>    0.50200</td>\n      <td>    0.253000</td>\n      <td>    0.329000</td>\n      <td>   11.000000</td>\n    </tr>\n    <tr>\n      <th>max</th>\n      <td>    0.815000</td>\n      <td>    0.650000</td>\n      <td>    1.130000</td>\n      <td>    2.825500</td>\n      <td>    1.48800</td>\n      <td>    0.760000</td>\n      <td>    1.005000</td>\n      <td>   29.000000</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 18, "cell_type": "code", "source": "#To get covariance \nabalone.cov()", "outputs": [{"execution_count": 18, "output_type": "execute_result", "data": {"text/plain": "                  Length  Diameter    Height  Whole weight  Shucked weight  \\\nLength          0.014425  0.011763  0.004157      0.054499        0.023938   \nDiameter        0.011763  0.009850  0.003461      0.045046        0.019678   \nHeight          0.004157  0.003461  0.001749      0.016804        0.007195   \nWhole weight    0.054499  0.045046  0.016804      0.240515        0.105533   \nShucked weight  0.023938  0.019678  0.007195      0.105533        0.049275   \nViscera weight  0.011889  0.009789  0.003660      0.051953        0.022678   \nShell weight    0.015009  0.012509  0.004759      0.065225        0.027275   \nRings           0.215697  0.183968  0.075251      0.854995        0.301440   \n\n                Viscera weight  Shell weight      Rings  \nLength                0.011889      0.015009   0.215697  \nDiameter              0.009789      0.012509   0.183968  \nHeight                0.003660      0.004759   0.075251  \nWhole weight          0.051953      0.065225   0.854995  \nShucked weight        0.022678      0.027275   0.301440  \nViscera weight        0.012017      0.013851   0.178196  \nShell weight          0.013851      0.019380   0.281839  \nRings                 0.178196      0.281839  10.391606  ", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n      <th>Whole weight</th>\n      <th>Shucked weight</th>\n      <th>Viscera weight</th>\n      <th>Shell weight</th>\n      <th>Rings</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>Length</th>\n      <td> 0.014425</td>\n      <td> 0.011763</td>\n      <td> 0.004157</td>\n      <td> 0.054499</td>\n      <td> 0.023938</td>\n      <td> 0.011889</td>\n      <td> 0.015009</td>\n      <td>  0.215697</td>\n    </tr>\n    <tr>\n      <th>Diameter</th>\n      <td> 0.011763</td>\n      <td> 0.009850</td>\n      <td> 0.003461</td>\n      <td> 0.045046</td>\n      <td> 0.019678</td>\n      <td> 0.009789</td>\n      <td> 0.012509</td>\n      <td>  0.183968</td>\n    </tr>\n    <tr>\n      <th>Height</th>\n      <td> 0.004157</td>\n      <td> 0.003461</td>\n      <td> 0.001749</td>\n      <td> 0.016804</td>\n      <td> 0.007195</td>\n      <td> 0.003660</td>\n      <td> 0.004759</td>\n      <td>  0.075251</td>\n    </tr>\n    <tr>\n      <th>Whole weight</th>\n      <td> 0.054499</td>\n      <td> 0.045046</td>\n      <td> 0.016804</td>\n      <td> 0.240515</td>\n      <td> 0.105533</td>\n      <td> 0.051953</td>\n      <td> 0.065225</td>\n      <td>  0.854995</td>\n    </tr>\n    <tr>\n      <th>Shucked weight</th>\n      <td> 0.023938</td>\n      <td> 0.019678</td>\n      <td> 0.007195</td>\n      <td> 0.105533</td>\n      <td> 0.049275</td>\n      <td> 0.022678</td>\n      <td> 0.027275</td>\n      <td>  0.301440</td>\n    </tr>\n    <tr>\n      <th>Viscera weight</th>\n      <td> 0.011889</td>\n      <td> 0.009789</td>\n      <td> 0.003660</td>\n      <td> 0.051953</td>\n      <td> 0.022678</td>\n      <td> 0.012017</td>\n      <td> 0.013851</td>\n      <td>  0.178196</td>\n    </tr>\n    <tr>\n      <th>Shell weight</th>\n      <td> 0.015009</td>\n      <td> 0.012509</td>\n      <td> 0.004759</td>\n      <td> 0.065225</td>\n      <td> 0.027275</td>\n      <td> 0.013851</td>\n      <td> 0.019380</td>\n      <td>  0.281839</td>\n    </tr>\n    <tr>\n      <th>Rings</th>\n      <td> 0.215697</td>\n      <td> 0.183968</td>\n      <td> 0.075251</td>\n      <td> 0.854995</td>\n      <td> 0.301440</td>\n      <td> 0.178196</td>\n      <td> 0.281839</td>\n      <td> 10.391606</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 19, "cell_type": "code", "source": "#To get pairwise-correlation coefficients for all numeric variables\nabalone.corr()", "outputs": [{"execution_count": 19, "output_type": "execute_result", "data": {"text/plain": "                  Length  Diameter    Height  Whole weight  Shucked weight  \\\nLength          1.000000  0.986813  0.827552      0.925255        0.897905   \nDiameter        0.986813  1.000000  0.833705      0.925452        0.893159   \nHeight          0.827552  0.833705  1.000000      0.819209        0.774957   \nWhole weight    0.925255  0.925452  0.819209      1.000000        0.969403   \nShucked weight  0.897905  0.893159  0.774957      0.969403        1.000000   \nViscera weight  0.903010  0.899726  0.798293      0.966372        0.931956   \nShell weight    0.897697  0.905328  0.817326      0.955351        0.882606   \nRings           0.557123  0.575005  0.558109      0.540818        0.421256   \n\n                Viscera weight  Shell weight     Rings  \nLength                0.903010      0.897697  0.557123  \nDiameter              0.899726      0.905328  0.575005  \nHeight                0.798293      0.817326  0.558109  \nWhole weight          0.966372      0.955351  0.540818  \nShucked weight        0.931956      0.882606  0.421256  \nViscera weight        1.000000      0.907647  0.504274  \nShell weight          0.907647      1.000000  0.628031  \nRings                 0.504274      0.628031  1.000000  ", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n      <th>Whole weight</th>\n      <th>Shucked weight</th>\n      <th>Viscera weight</th>\n      <th>Shell weight</th>\n      <th>Rings</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>Length</th>\n      <td> 1.000000</td>\n      <td> 0.986813</td>\n      <td> 0.827552</td>\n      <td> 0.925255</td>\n      <td> 0.897905</td>\n      <td> 0.903010</td>\n      <td> 0.897697</td>\n      <td> 0.557123</td>\n    </tr>\n    <tr>\n      <th>Diameter</th>\n      <td> 0.986813</td>\n      <td> 1.000000</td>\n      <td> 0.833705</td>\n      <td> 0.925452</td>\n      <td> 0.893159</td>\n      <td> 0.899726</td>\n      <td> 0.905328</td>\n      <td> 0.575005</td>\n    </tr>\n    <tr>\n      <th>Height</th>\n      <td> 0.827552</td>\n      <td> 0.833705</td>\n      <td> 1.000000</td>\n      <td> 0.819209</td>\n      <td> 0.774957</td>\n      <td> 0.798293</td>\n      <td> 0.817326</td>\n      <td> 0.558109</td>\n    </tr>\n    <tr>\n      <th>Whole weight</th>\n      <td> 0.925255</td>\n      <td> 0.925452</td>\n      <td> 0.819209</td>\n      <td> 1.000000</td>\n      <td> 0.969403</td>\n      <td> 0.966372</td>\n      <td> 0.955351</td>\n      <td> 0.540818</td>\n    </tr>\n    <tr>\n      <th>Shucked weight</th>\n      <td> 0.897905</td>\n      <td> 0.893159</td>\n      <td> 0.774957</td>\n      <td> 0.969403</td>\n      <td> 1.000000</td>\n      <td> 0.931956</td>\n      <td> 0.882606</td>\n      <td> 0.421256</td>\n    </tr>\n    <tr>\n      <th>Viscera weight</th>\n      <td> 0.903010</td>\n      <td> 0.899726</td>\n      <td> 0.798293</td>\n      <td> 0.966372</td>\n      <td> 0.931956</td>\n      <td> 1.000000</td>\n      <td> 0.907647</td>\n      <td> 0.504274</td>\n    </tr>\n    <tr>\n      <th>Shell weight</th>\n      <td> 0.897697</td>\n      <td> 0.905328</td>\n      <td> 0.817326</td>\n      <td> 0.955351</td>\n      <td> 0.882606</td>\n      <td> 0.907647</td>\n      <td> 1.000000</td>\n      <td> 0.628031</td>\n    </tr>\n    <tr>\n      <th>Rings</th>\n      <td> 0.557123</td>\n      <td> 0.575005</td>\n      <td> 0.558109</td>\n      <td> 0.540818</td>\n      <td> 0.421256</td>\n      <td> 0.504274</td>\n      <td> 0.628031</td>\n      <td> 1.000000</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 20, "cell_type": "code", "source": "# To get unique values of 'Rings' column\nabalone['Rings'].unique() ", "outputs": [{"execution_count": 20, "output_type": "execute_result", "data": {"text/plain": "array([ 7,  9, 10,  8, 20, 16, 19, 14, 11, 12, 15, 18, 13,  5,  4,  6, 21,\n       17, 22,  1,  3, 26, 23, 29,  2, 27, 25, 24], dtype=int64)"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 21, "cell_type": "code", "source": "#To subset - have only 'Length','Diameter' and 'Height' in dataset abalone1\nabalone1 = abalone[['Length','Diameter','Height']]", "outputs": [], "metadata": {"collapsed": true, "trusted": true}}, {"execution_count": 22, "cell_type": "code", "source": "#Inspect abalone1 by checking head and tail\nabalone1.head(3)", "outputs": [{"execution_count": 22, "output_type": "execute_result", "data": {"text/plain": "   Length  Diameter  Height\n0    0.35     0.265   0.090\n1    0.53     0.420   0.135\n2    0.44     0.365   0.125", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td> 0.35</td>\n      <td> 0.265</td>\n      <td> 0.090</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td> 0.53</td>\n      <td> 0.420</td>\n      <td> 0.135</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td> 0.44</td>\n      <td> 0.365</td>\n      <td> 0.125</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}, {"execution_count": 23, "cell_type": "code", "source": "abalone1.tail(3)", "outputs": [{"execution_count": 23, "output_type": "execute_result", "data": {"text/plain": "      Length  Diameter  Height\n4173   0.600     0.475   0.205\n4174   0.625     0.485   0.150\n4175   0.710     0.555   0.195", "text/html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Length</th>\n      <th>Diameter</th>\n      <th>Height</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>4173</th>\n      <td> 0.600</td>\n      <td> 0.475</td>\n      <td> 0.205</td>\n    </tr>\n    <tr>\n      <th>4174</th>\n      <td> 0.625</td>\n      <td> 0.485</td>\n      <td> 0.150</td>\n    </tr>\n    <tr>\n      <th>4175</th>\n      <td> 0.710</td>\n      <td> 0.555</td>\n      <td> 0.195</td>\n    </tr>\n  </tbody>\n</table>\n</div>"}, "metadata": {}}], "metadata": {"collapsed": false, "trusted": true}}], "nbformat": 4, "metadata": {"kernelspec": {"display_name": "Python 2", "name": "python2", "language": "python"}, "language_info": {"mimetype": "text/x-python", "nbconvert_exporter": "python", "version": "2.7.9", "name": "python", "file_extension": ".py", "pygments_lexer": "ipython2", "codemirror_mode": {"version": 2, "name": "ipython"}}}}