Skip to content

Instantly share code, notes, and snippets.

@alubbock

alubbock/datatable-example.ipynb

Last active April 19, 2024 03:34
Show Gist options
  • Save alubbock/e5d915397179b9626ae63a55244f510d to your computer and use it in GitHub Desktop.
Save alubbock/e5d915397179b9626ae63a55244f510d to your computer and use it in GitHub Desktop.
Download ZIP
Sortable, searchable Pandas DataFrames in Jupyter Notebook
Display the source blob
Display the rendered blob
Raw
datatable-example.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Sortable, searchable Pandas DataFrames in Jupyter Notebook\n",
"\n",
"**View on nbviewer to see it working (doesn't work on github): http://nbviewer.jupyter.org/gist/alubbock/e5d915397179b9626ae63a55244f510d**\n",
"\n",
"By Alex Lubbock, adapted from: http://blog.dornea.nu/2014/08/28/using-jquery-datatables-with-ipython/\n",
"\n",
"This is an example of using the javascript/jQuery Datatables plugin (https://datatables.net/) with Jupyter notebook. The basic code is based on the above link. I've updated DataTables to a more recent version on the plugin, added sorting for scientific format numbers (e.g. 1.245e-10) with automatic column type detection, and more reliable javascript loading using require.js."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"application/javascript": [
"require.config({\n",
" paths: {\n",
" jquery: '//code.jquery.com/jquery-2.0.3.min',\n",
" dataTables: '//cdn.datatables.net/1.10.13/js/jquery.dataTables.min'\n",
" }\n",
"});\n",
"\n",
"require(['dataTables'], function() {\n",
" jQuery.extend( jQuery.fn.dataTableExt.oSort, {\n",
" \"scientific-pre\": function ( a ) {\n",
" return parseFloat(a);\n",
" },\n",
" \"scientific-asc\": function ( a, b ) {\n",
" return ((a < b) ? -1 : ((a > b) ? 1 : 0));\n",
" },\n",
" \"scientific-desc\": function ( a, b ) {\n",
" return ((a < b) ? 1 : ((a > b) ? -1 : 0));\n",
" }\n",
" });\n",
"});\n",
"element.append('<link rel=\"stylesheet\" href=\"//cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css\">');"
],
"text/plain": [
"<IPython.core.display.Javascript object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"%%javascript\n",
"require.config({\n",
" paths: {\n",
" jquery: '//code.jquery.com/jquery-2.0.3.min',\n",
" dataTables: '//cdn.datatables.net/1.10.13/js/jquery.dataTables.min'\n",
" }\n",
"});\n",
"\n",
"require(['dataTables'], function() {\n",
" jQuery.extend( jQuery.fn.dataTableExt.oSort, {\n",
" \"scientific-pre\": function ( a ) {\n",
" return parseFloat(a);\n",
" },\n",
" \"scientific-asc\": function ( a, b ) {\n",
" return ((a < b) ? -1 : ((a > b) ? 1 : 0));\n",
" },\n",
" \"scientific-desc\": function ( a, b ) {\n",
" return ((a < b) ? 1 : ((a > b) ? -1 : 0));\n",
" }\n",
" });\n",
"});\n",
"element.append('<link rel=\"stylesheet\" href=\"//cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css\">');"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import uuid\n",
"import numpy\n",
"import pandas\n",
"\n",
"def DataTable(df):\n",
" \"\"\" Prints a pandas.DataFrame using jQuery DataTable plugin \"\"\"\n",
" from IPython.display import HTML\n",
" output = \"\"\"<div id=\"datatable-%(uuid)s\">%(html)s\n",
" <script type=\"text/javascript\">\n",
" $(document).ready(function() {\n",
" require(['dataTables'], function() {\n",
" $('#datatable-%(uuid)s').find('table.datatable').dataTable({\n",
" columnDefs: [{ targets: %(sci_cols)s, type: 'scientific' }]});\n",
" });\n",
" });\n",
" </script>\n",
" </div>\n",
" \"\"\" % {'uuid': uuid.uuid1(), 'html': df.to_html(classes=\"datatable display\"),\n",
" 'sci_cols': '[%s]' % \",\".join([str(i) for i, _ in enumerate(df.dtypes == numpy.float64)])}\n",
" return HTML(output)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"iris = pandas.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/iris.csv')"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false,
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"<div id=\"datatable-7abbf246-be82-11e6-8366-985aeb89c52c\"><table border=\"1\" class=\"dataframe datatable display\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>sepal_length</th>\n",
" <th>sepal_width</th>\n",
" <th>petal_length</th>\n",
" <th>petal_width</th>\n",
" <th>species</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>5.1</td>\n",
" <td>3.5</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>4.9</td>\n",
" <td>3.0</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>4.7</td>\n",
" <td>3.2</td>\n",
" <td>1.3</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4.6</td>\n",
" <td>3.1</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5.0</td>\n",
" <td>3.6</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>5.4</td>\n",
" <td>3.9</td>\n",
" <td>1.7</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>4.6</td>\n",
" <td>3.4</td>\n",
" <td>1.4</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>5.0</td>\n",
" <td>3.4</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>4.4</td>\n",
" <td>2.9</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>4.9</td>\n",
" <td>3.1</td>\n",
" <td>1.5</td>\n",
" <td>0.1</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>5.4</td>\n",
" <td>3.7</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>4.8</td>\n",
" <td>3.4</td>\n",
" <td>1.6</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>4.8</td>\n",
" <td>3.0</td>\n",
" <td>1.4</td>\n",
" <td>0.1</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>4.3</td>\n",
" <td>3.0</td>\n",
" <td>1.1</td>\n",
" <td>0.1</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>5.8</td>\n",
" <td>4.0</td>\n",
" <td>1.2</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>5.7</td>\n",
" <td>4.4</td>\n",
" <td>1.5</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>5.4</td>\n",
" <td>3.9</td>\n",
" <td>1.3</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>5.1</td>\n",
" <td>3.5</td>\n",
" <td>1.4</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>5.7</td>\n",
" <td>3.8</td>\n",
" <td>1.7</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>5.1</td>\n",
" <td>3.8</td>\n",
" <td>1.5</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>5.4</td>\n",
" <td>3.4</td>\n",
" <td>1.7</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>5.1</td>\n",
" <td>3.7</td>\n",
" <td>1.5</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>4.6</td>\n",
" <td>3.6</td>\n",
" <td>1.0</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>5.1</td>\n",
" <td>3.3</td>\n",
" <td>1.7</td>\n",
" <td>0.5</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>4.8</td>\n",
" <td>3.4</td>\n",
" <td>1.9</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>5.0</td>\n",
" <td>3.0</td>\n",
" <td>1.6</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>5.0</td>\n",
" <td>3.4</td>\n",
" <td>1.6</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>5.2</td>\n",
" <td>3.5</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>5.2</td>\n",
" <td>3.4</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>4.7</td>\n",
" <td>3.2</td>\n",
" <td>1.6</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>4.8</td>\n",
" <td>3.1</td>\n",
" <td>1.6</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>5.4</td>\n",
" <td>3.4</td>\n",
" <td>1.5</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>5.2</td>\n",
" <td>4.1</td>\n",
" <td>1.5</td>\n",
" <td>0.1</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>5.5</td>\n",
" <td>4.2</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>4.9</td>\n",
" <td>3.1</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>5.0</td>\n",
" <td>3.2</td>\n",
" <td>1.2</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>5.5</td>\n",
" <td>3.5</td>\n",
" <td>1.3</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>4.9</td>\n",
" <td>3.6</td>\n",
" <td>1.4</td>\n",
" <td>0.1</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>4.4</td>\n",
" <td>3.0</td>\n",
" <td>1.3</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>5.1</td>\n",
" <td>3.4</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>5.0</td>\n",
" <td>3.5</td>\n",
" <td>1.3</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>4.5</td>\n",
" <td>2.3</td>\n",
" <td>1.3</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>4.4</td>\n",
" <td>3.2</td>\n",
" <td>1.3</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>5.0</td>\n",
" <td>3.5</td>\n",
" <td>1.6</td>\n",
" <td>0.6</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>5.1</td>\n",
" <td>3.8</td>\n",
" <td>1.9</td>\n",
" <td>0.4</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>4.8</td>\n",
" <td>3.0</td>\n",
" <td>1.4</td>\n",
" <td>0.3</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>5.1</td>\n",
" <td>3.8</td>\n",
" <td>1.6</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>4.6</td>\n",
" <td>3.2</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>5.3</td>\n",
" <td>3.7</td>\n",
" <td>1.5</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>5.0</td>\n",
" <td>3.3</td>\n",
" <td>1.4</td>\n",
" <td>0.2</td>\n",
" <td>setosa</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>7.0</td>\n",
" <td>3.2</td>\n",
" <td>4.7</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>6.4</td>\n",
" <td>3.2</td>\n",
" <td>4.5</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>6.9</td>\n",
" <td>3.1</td>\n",
" <td>4.9</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>5.5</td>\n",
" <td>2.3</td>\n",
" <td>4.0</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>6.5</td>\n",
" <td>2.8</td>\n",
" <td>4.6</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>5.7</td>\n",
" <td>2.8</td>\n",
" <td>4.5</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>6.3</td>\n",
" <td>3.3</td>\n",
" <td>4.7</td>\n",
" <td>1.6</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>4.9</td>\n",
" <td>2.4</td>\n",
" <td>3.3</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>6.6</td>\n",
" <td>2.9</td>\n",
" <td>4.6</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>5.2</td>\n",
" <td>2.7</td>\n",
" <td>3.9</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>5.0</td>\n",
" <td>2.0</td>\n",
" <td>3.5</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>5.9</td>\n",
" <td>3.0</td>\n",
" <td>4.2</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>6.0</td>\n",
" <td>2.2</td>\n",
" <td>4.0</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>6.1</td>\n",
" <td>2.9</td>\n",
" <td>4.7</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>5.6</td>\n",
" <td>2.9</td>\n",
" <td>3.6</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>6.7</td>\n",
" <td>3.1</td>\n",
" <td>4.4</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>5.6</td>\n",
" <td>3.0</td>\n",
" <td>4.5</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>5.8</td>\n",
" <td>2.7</td>\n",
" <td>4.1</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>6.2</td>\n",
" <td>2.2</td>\n",
" <td>4.5</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>5.6</td>\n",
" <td>2.5</td>\n",
" <td>3.9</td>\n",
" <td>1.1</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>5.9</td>\n",
" <td>3.2</td>\n",
" <td>4.8</td>\n",
" <td>1.8</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>6.1</td>\n",
" <td>2.8</td>\n",
" <td>4.0</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>6.3</td>\n",
" <td>2.5</td>\n",
" <td>4.9</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>6.1</td>\n",
" <td>2.8</td>\n",
" <td>4.7</td>\n",
" <td>1.2</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>6.4</td>\n",
" <td>2.9</td>\n",
" <td>4.3</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>6.6</td>\n",
" <td>3.0</td>\n",
" <td>4.4</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>6.8</td>\n",
" <td>2.8</td>\n",
" <td>4.8</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>6.7</td>\n",
" <td>3.0</td>\n",
" <td>5.0</td>\n",
" <td>1.7</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>6.0</td>\n",
" <td>2.9</td>\n",
" <td>4.5</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>5.7</td>\n",
" <td>2.6</td>\n",
" <td>3.5</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>5.5</td>\n",
" <td>2.4</td>\n",
" <td>3.8</td>\n",
" <td>1.1</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>5.5</td>\n",
" <td>2.4</td>\n",
" <td>3.7</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>5.8</td>\n",
" <td>2.7</td>\n",
" <td>3.9</td>\n",
" <td>1.2</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>6.0</td>\n",
" <td>2.7</td>\n",
" <td>5.1</td>\n",
" <td>1.6</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td>5.4</td>\n",
" <td>3.0</td>\n",
" <td>4.5</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>6.0</td>\n",
" <td>3.4</td>\n",
" <td>4.5</td>\n",
" <td>1.6</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>6.7</td>\n",
" <td>3.1</td>\n",
" <td>4.7</td>\n",
" <td>1.5</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>6.3</td>\n",
" <td>2.3</td>\n",
" <td>4.4</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>5.6</td>\n",
" <td>3.0</td>\n",
" <td>4.1</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>5.5</td>\n",
" <td>2.5</td>\n",
" <td>4.0</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>5.5</td>\n",
" <td>2.6</td>\n",
" <td>4.4</td>\n",
" <td>1.2</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91</th>\n",
" <td>6.1</td>\n",
" <td>3.0</td>\n",
" <td>4.6</td>\n",
" <td>1.4</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>5.8</td>\n",
" <td>2.6</td>\n",
" <td>4.0</td>\n",
" <td>1.2</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93</th>\n",
" <td>5.0</td>\n",
" <td>2.3</td>\n",
" <td>3.3</td>\n",
" <td>1.0</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>94</th>\n",
" <td>5.6</td>\n",
" <td>2.7</td>\n",
" <td>4.2</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>5.7</td>\n",
" <td>3.0</td>\n",
" <td>4.2</td>\n",
" <td>1.2</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td>5.7</td>\n",
" <td>2.9</td>\n",
" <td>4.2</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>6.2</td>\n",
" <td>2.9</td>\n",
" <td>4.3</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>5.1</td>\n",
" <td>2.5</td>\n",
" <td>3.0</td>\n",
" <td>1.1</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td>5.7</td>\n",
" <td>2.8</td>\n",
" <td>4.1</td>\n",
" <td>1.3</td>\n",
" <td>versicolor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <td>6.3</td>\n",
" <td>3.3</td>\n",
" <td>6.0</td>\n",
" <td>2.5</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>101</th>\n",
" <td>5.8</td>\n",
" <td>2.7</td>\n",
" <td>5.1</td>\n",
" <td>1.9</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>102</th>\n",
" <td>7.1</td>\n",
" <td>3.0</td>\n",
" <td>5.9</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103</th>\n",
" <td>6.3</td>\n",
" <td>2.9</td>\n",
" <td>5.6</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>104</th>\n",
" <td>6.5</td>\n",
" <td>3.0</td>\n",
" <td>5.8</td>\n",
" <td>2.2</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>7.6</td>\n",
" <td>3.0</td>\n",
" <td>6.6</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>4.9</td>\n",
" <td>2.5</td>\n",
" <td>4.5</td>\n",
" <td>1.7</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td>7.3</td>\n",
" <td>2.9</td>\n",
" <td>6.3</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>108</th>\n",
" <td>6.7</td>\n",
" <td>2.5</td>\n",
" <td>5.8</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>7.2</td>\n",
" <td>3.6</td>\n",
" <td>6.1</td>\n",
" <td>2.5</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td>6.5</td>\n",
" <td>3.2</td>\n",
" <td>5.1</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>111</th>\n",
" <td>6.4</td>\n",
" <td>2.7</td>\n",
" <td>5.3</td>\n",
" <td>1.9</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>6.8</td>\n",
" <td>3.0</td>\n",
" <td>5.5</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>113</th>\n",
" <td>5.7</td>\n",
" <td>2.5</td>\n",
" <td>5.0</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>114</th>\n",
" <td>5.8</td>\n",
" <td>2.8</td>\n",
" <td>5.1</td>\n",
" <td>2.4</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td>6.4</td>\n",
" <td>3.2</td>\n",
" <td>5.3</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>116</th>\n",
" <td>6.5</td>\n",
" <td>3.0</td>\n",
" <td>5.5</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>117</th>\n",
" <td>7.7</td>\n",
" <td>3.8</td>\n",
" <td>6.7</td>\n",
" <td>2.2</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>118</th>\n",
" <td>7.7</td>\n",
" <td>2.6</td>\n",
" <td>6.9</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>119</th>\n",
" <td>6.0</td>\n",
" <td>2.2</td>\n",
" <td>5.0</td>\n",
" <td>1.5</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>120</th>\n",
" <td>6.9</td>\n",
" <td>3.2</td>\n",
" <td>5.7</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121</th>\n",
" <td>5.6</td>\n",
" <td>2.8</td>\n",
" <td>4.9</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>122</th>\n",
" <td>7.7</td>\n",
" <td>2.8</td>\n",
" <td>6.7</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>123</th>\n",
" <td>6.3</td>\n",
" <td>2.7</td>\n",
" <td>4.9</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>124</th>\n",
" <td>6.7</td>\n",
" <td>3.3</td>\n",
" <td>5.7</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>125</th>\n",
" <td>7.2</td>\n",
" <td>3.2</td>\n",
" <td>6.0</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>126</th>\n",
" <td>6.2</td>\n",
" <td>2.8</td>\n",
" <td>4.8</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>6.1</td>\n",
" <td>3.0</td>\n",
" <td>4.9</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td>6.4</td>\n",
" <td>2.8</td>\n",
" <td>5.6</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>129</th>\n",
" <td>7.2</td>\n",
" <td>3.0</td>\n",
" <td>5.8</td>\n",
" <td>1.6</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>130</th>\n",
" <td>7.4</td>\n",
" <td>2.8</td>\n",
" <td>6.1</td>\n",
" <td>1.9</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>131</th>\n",
" <td>7.9</td>\n",
" <td>3.8</td>\n",
" <td>6.4</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>132</th>\n",
" <td>6.4</td>\n",
" <td>2.8</td>\n",
" <td>5.6</td>\n",
" <td>2.2</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>133</th>\n",
" <td>6.3</td>\n",
" <td>2.8</td>\n",
" <td>5.1</td>\n",
" <td>1.5</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td>6.1</td>\n",
" <td>2.6</td>\n",
" <td>5.6</td>\n",
" <td>1.4</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>135</th>\n",
" <td>7.7</td>\n",
" <td>3.0</td>\n",
" <td>6.1</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136</th>\n",
" <td>6.3</td>\n",
" <td>3.4</td>\n",
" <td>5.6</td>\n",
" <td>2.4</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>137</th>\n",
" <td>6.4</td>\n",
" <td>3.1</td>\n",
" <td>5.5</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>6.0</td>\n",
" <td>3.0</td>\n",
" <td>4.8</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>139</th>\n",
" <td>6.9</td>\n",
" <td>3.1</td>\n",
" <td>5.4</td>\n",
" <td>2.1</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>140</th>\n",
" <td>6.7</td>\n",
" <td>3.1</td>\n",
" <td>5.6</td>\n",
" <td>2.4</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>141</th>\n",
" <td>6.9</td>\n",
" <td>3.1</td>\n",
" <td>5.1</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>142</th>\n",
" <td>5.8</td>\n",
" <td>2.7</td>\n",
" <td>5.1</td>\n",
" <td>1.9</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>143</th>\n",
" <td>6.8</td>\n",
" <td>3.2</td>\n",
" <td>5.9</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>144</th>\n",
" <td>6.7</td>\n",
" <td>3.3</td>\n",
" <td>5.7</td>\n",
" <td>2.5</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>145</th>\n",
" <td>6.7</td>\n",
" <td>3.0</td>\n",
" <td>5.2</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>146</th>\n",
" <td>6.3</td>\n",
" <td>2.5</td>\n",
" <td>5.0</td>\n",
" <td>1.9</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>147</th>\n",
" <td>6.5</td>\n",
" <td>3.0</td>\n",
" <td>5.2</td>\n",
" <td>2.0</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>148</th>\n",
" <td>6.2</td>\n",
" <td>3.4</td>\n",
" <td>5.4</td>\n",
" <td>2.3</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" <tr>\n",
" <th>149</th>\n",
" <td>5.9</td>\n",
" <td>3.0</td>\n",
" <td>5.1</td>\n",
" <td>1.8</td>\n",
" <td>virginica</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
" <script type=\"text/javascript\">\n",
" $(document).ready(function() {\n",
" require(['dataTables'], function() {\n",
" $('#datatable-7abbf246-be82-11e6-8366-985aeb89c52c').find('table.datatable').dataTable({\n",
" columnDefs: [{ targets: [0,1,2,3,4], type: 'scientific' }]});\n",
" });\n",
" });\n",
" </script>\n",
" </div>\n",
" "
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"DataTable(iris)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment