{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4c16c877-0135-4ee4-86e2-db21dca5eb5f",
   "metadata": {},
   "source": [
    "# Exploring tabular data\n",
    "When working with data in tables, the ability of quickly getting an overview about the data is key."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "05824a7f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5673e04d",
   "metadata": {},
   "source": [
    "## Loading CSV files from disk\n",
    "To ensure compatility beween different software for processing tabular data the [CSV file format](https://en.wikipedia.org/wiki/Comma-separated_values) is commonly used. We can open those files using [pandas.read_csv](https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f46f4002",
   "metadata": {},
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>XM</th>\n",
       "      <th>YM</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Angle</th>\n",
       "      <th>%Area</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18.0</td>\n",
       "      <td>730.389</td>\n",
       "      <td>103.354</td>\n",
       "      <td>592.0</td>\n",
       "      <td>948.0</td>\n",
       "      <td>435.000</td>\n",
       "      <td>4.722</td>\n",
       "      <td>434.962</td>\n",
       "      <td>4.697</td>\n",
       "      <td>5.987</td>\n",
       "      <td>3.828</td>\n",
       "      <td>168.425</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>126.0</td>\n",
       "      <td>718.333</td>\n",
       "      <td>90.367</td>\n",
       "      <td>556.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>388.087</td>\n",
       "      <td>8.683</td>\n",
       "      <td>388.183</td>\n",
       "      <td>8.687</td>\n",
       "      <td>16.559</td>\n",
       "      <td>9.688</td>\n",
       "      <td>175.471</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>608.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.665</td>\n",
       "      <td>7.359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.121</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68.0</td>\n",
       "      <td>686.985</td>\n",
       "      <td>61.169</td>\n",
       "      <td>571.0</td>\n",
       "      <td>880.0</td>\n",
       "      <td>126.147</td>\n",
       "      <td>8.809</td>\n",
       "      <td>126.192</td>\n",
       "      <td>8.811</td>\n",
       "      <td>15.136</td>\n",
       "      <td>5.720</td>\n",
       "      <td>168.133</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.438</td>\n",
       "      <td>566.0</td>\n",
       "      <td>792.0</td>\n",
       "      <td>348.500</td>\n",
       "      <td>7.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>A</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>152.0</td>\n",
       "      <td>801.599</td>\n",
       "      <td>111.328</td>\n",
       "      <td>582.0</td>\n",
       "      <td>1263.0</td>\n",
       "      <td>348.487</td>\n",
       "      <td>497.632</td>\n",
       "      <td>348.451</td>\n",
       "      <td>497.675</td>\n",
       "      <td>17.773</td>\n",
       "      <td>10.889</td>\n",
       "      <td>11.829</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>17.0</td>\n",
       "      <td>742.706</td>\n",
       "      <td>69.624</td>\n",
       "      <td>620.0</td>\n",
       "      <td>884.0</td>\n",
       "      <td>420.500</td>\n",
       "      <td>496.382</td>\n",
       "      <td>420.513</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.663</td>\n",
       "      <td>49.457</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>60.0</td>\n",
       "      <td>758.033</td>\n",
       "      <td>77.309</td>\n",
       "      <td>601.0</td>\n",
       "      <td>947.0</td>\n",
       "      <td>259.000</td>\n",
       "      <td>499.300</td>\n",
       "      <td>258.990</td>\n",
       "      <td>499.289</td>\n",
       "      <td>9.476</td>\n",
       "      <td>8.062</td>\n",
       "      <td>90.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>12.0</td>\n",
       "      <td>714.833</td>\n",
       "      <td>67.294</td>\n",
       "      <td>551.0</td>\n",
       "      <td>785.0</td>\n",
       "      <td>240.167</td>\n",
       "      <td>498.167</td>\n",
       "      <td>240.179</td>\n",
       "      <td>498.148</td>\n",
       "      <td>4.606</td>\n",
       "      <td>3.317</td>\n",
       "      <td>168.690</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>23.0</td>\n",
       "      <td>695.043</td>\n",
       "      <td>67.356</td>\n",
       "      <td>611.0</td>\n",
       "      <td>846.0</td>\n",
       "      <td>49.891</td>\n",
       "      <td>503.022</td>\n",
       "      <td>49.882</td>\n",
       "      <td>502.979</td>\n",
       "      <td>6.454</td>\n",
       "      <td>4.537</td>\n",
       "      <td>73.243</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>391 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Area     Mean   StdDev    Min     Max        X        Y       XM  \\\n",
       "                                                                         \n",
       "1     18.0  730.389  103.354  592.0   948.0  435.000    4.722  434.962   \n",
       "2    126.0  718.333   90.367  556.0  1046.0  388.087    8.683  388.183   \n",
       "3      NaN      NaN      NaN  608.0   964.0      NaN      NaN      NaN   \n",
       "4     68.0  686.985   61.169  571.0   880.0  126.147    8.809  126.192   \n",
       "5      NaN      NaN   69.438  566.0   792.0  348.500    7.500      NaN   \n",
       "..     ...      ...      ...    ...     ...      ...      ...      ...   \n",
       "387  152.0  801.599  111.328  582.0  1263.0  348.487  497.632  348.451   \n",
       "388   17.0  742.706   69.624  620.0   884.0  420.500  496.382  420.513   \n",
       "389   60.0  758.033   77.309  601.0   947.0  259.000  499.300  258.990   \n",
       "390   12.0  714.833   67.294  551.0   785.0  240.167  498.167  240.179   \n",
       "391   23.0  695.043   67.356  611.0   846.0   49.891  503.022   49.882   \n",
       "\n",
       "          YM   Major   Minor    Angle  %Area Type  \n",
       "                                                   \n",
       "1      4.697   5.987   3.828  168.425    100    A  \n",
       "2      8.687  16.559   9.688  175.471    100    A  \n",
       "3      7.665   7.359     NaN  101.121    100    A  \n",
       "4      8.811  15.136   5.720  168.133    100    A  \n",
       "5      7.508     NaN   3.088      NaN    100    A  \n",
       "..       ...     ...     ...      ...    ...  ...  \n",
       "387  497.675  17.773  10.889   11.829    100    A  \n",
       "388      NaN     NaN   3.663   49.457    100    A  \n",
       "389  499.289   9.476   8.062   90.000    100    A  \n",
       "390  498.148   4.606   3.317  168.690    100    A  \n",
       "391  502.979   6.454   4.537   73.243    100    A  \n",
       "\n",
       "[391 rows x 14 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('../../data/Results.csv', index_col=0, delimiter=';')\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7beb37a0",
   "metadata": {},
   "source": [
    "## Viewing the data\n",
    "Viewing data can be tricky, especially when working with large tables."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0a79b9c3",
   "metadata": {},
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>XM</th>\n",
       "      <th>YM</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Angle</th>\n",
       "      <th>%Area</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18.0</td>\n",
       "      <td>730.389</td>\n",
       "      <td>103.354</td>\n",
       "      <td>592.0</td>\n",
       "      <td>948.0</td>\n",
       "      <td>435.000</td>\n",
       "      <td>4.722</td>\n",
       "      <td>434.962</td>\n",
       "      <td>4.697</td>\n",
       "      <td>5.987</td>\n",
       "      <td>3.828</td>\n",
       "      <td>168.425</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>126.0</td>\n",
       "      <td>718.333</td>\n",
       "      <td>90.367</td>\n",
       "      <td>556.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>388.087</td>\n",
       "      <td>8.683</td>\n",
       "      <td>388.183</td>\n",
       "      <td>8.687</td>\n",
       "      <td>16.559</td>\n",
       "      <td>9.688</td>\n",
       "      <td>175.471</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>608.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.665</td>\n",
       "      <td>7.359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.121</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>68.0</td>\n",
       "      <td>686.985</td>\n",
       "      <td>61.169</td>\n",
       "      <td>571.0</td>\n",
       "      <td>880.0</td>\n",
       "      <td>126.147</td>\n",
       "      <td>8.809</td>\n",
       "      <td>126.192</td>\n",
       "      <td>8.811</td>\n",
       "      <td>15.136</td>\n",
       "      <td>5.720</td>\n",
       "      <td>168.133</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.438</td>\n",
       "      <td>566.0</td>\n",
       "      <td>792.0</td>\n",
       "      <td>348.500</td>\n",
       "      <td>7.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>669.0</td>\n",
       "      <td>697.164</td>\n",
       "      <td>72.863</td>\n",
       "      <td>539.0</td>\n",
       "      <td>957.0</td>\n",
       "      <td>471.696</td>\n",
       "      <td>26.253</td>\n",
       "      <td>471.694</td>\n",
       "      <td>26.197</td>\n",
       "      <td>36.656</td>\n",
       "      <td>23.237</td>\n",
       "      <td>124.340</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5.0</td>\n",
       "      <td>658.600</td>\n",
       "      <td>49.161</td>\n",
       "      <td>607.0</td>\n",
       "      <td>710.0</td>\n",
       "      <td>28.300</td>\n",
       "      <td>8.100</td>\n",
       "      <td>28.284</td>\n",
       "      <td>8.103</td>\n",
       "      <td>3.144</td>\n",
       "      <td>2.025</td>\n",
       "      <td>161.565</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7.0</td>\n",
       "      <td>677.571</td>\n",
       "      <td>49.899</td>\n",
       "      <td>596.0</td>\n",
       "      <td>768.0</td>\n",
       "      <td>415.357</td>\n",
       "      <td>8.786</td>\n",
       "      <td>415.360</td>\n",
       "      <td>8.804</td>\n",
       "      <td>4.110</td>\n",
       "      <td>2.168</td>\n",
       "      <td>112.500</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>14.0</td>\n",
       "      <td>691.071</td>\n",
       "      <td>63.873</td>\n",
       "      <td>586.0</td>\n",
       "      <td>808.0</td>\n",
       "      <td>493.286</td>\n",
       "      <td>9.000</td>\n",
       "      <td>493.295</td>\n",
       "      <td>9.016</td>\n",
       "      <td>5.120</td>\n",
       "      <td>3.481</td>\n",
       "      <td>38.802</td>\n",
       "      <td>100</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>39.0</td>\n",
       "      <td>763.615</td>\n",
       "      <td>88.786</td>\n",
       "      <td>623.0</td>\n",
       "      <td>1016.0</td>\n",
       "      <td>157.526</td>\n",
       "      <td>12.731</td>\n",
       "      <td>157.592</td>\n",
       "      <td>12.757</td>\n",
       "      <td>8.815</td>\n",
       "      <td>5.633</td>\n",
       "      <td>46.437</td>\n",
       "      <td>100</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Area     Mean   StdDev    Min     Max        X       Y       XM      YM  \\\n",
       "                                                                               \n",
       "1    18.0  730.389  103.354  592.0   948.0  435.000   4.722  434.962   4.697   \n",
       "2   126.0  718.333   90.367  556.0  1046.0  388.087   8.683  388.183   8.687   \n",
       "3     NaN      NaN      NaN  608.0   964.0      NaN     NaN      NaN   7.665   \n",
       "4    68.0  686.985   61.169  571.0   880.0  126.147   8.809  126.192   8.811   \n",
       "5     NaN      NaN   69.438  566.0   792.0  348.500   7.500      NaN   7.508   \n",
       "6   669.0  697.164   72.863  539.0   957.0  471.696  26.253  471.694  26.197   \n",
       "7     5.0  658.600   49.161  607.0   710.0   28.300   8.100   28.284   8.103   \n",
       "8     7.0  677.571   49.899  596.0   768.0  415.357   8.786  415.360   8.804   \n",
       "9    14.0  691.071   63.873  586.0   808.0  493.286   9.000  493.295   9.016   \n",
       "10   39.0  763.615   88.786  623.0  1016.0  157.526  12.731  157.592  12.757   \n",
       "\n",
       "     Major   Minor    Angle  %Area Type  \n",
       "                                         \n",
       "1    5.987   3.828  168.425    100    A  \n",
       "2   16.559   9.688  175.471    100    A  \n",
       "3    7.359     NaN  101.121    100    A  \n",
       "4   15.136   5.720  168.133    100    A  \n",
       "5      NaN   3.088      NaN    100    A  \n",
       "6   36.656  23.237  124.340    100    A  \n",
       "7    3.144   2.025  161.565    100    A  \n",
       "8    4.110   2.168  112.500    100    A  \n",
       "9    5.120   3.481   38.802    100    C  \n",
       "10   8.815   5.633   46.437    100    C  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(10) # top 10 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ef55a071",
   "metadata": {},
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>XM</th>\n",
       "      <th>YM</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Angle</th>\n",
       "      <th>%Area</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>45.0</td>\n",
       "      <td>734.356</td>\n",
       "      <td>68.637</td>\n",
       "      <td>575.0</td>\n",
       "      <td>867.0</td>\n",
       "      <td>171.500</td>\n",
       "      <td>494.789</td>\n",
       "      <td>171.492</td>\n",
       "      <td>494.739</td>\n",
       "      <td>14.630</td>\n",
       "      <td>3.916</td>\n",
       "      <td>95.698</td>\n",
       "      <td>100</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>94.0</td>\n",
       "      <td>746.617</td>\n",
       "      <td>85.198</td>\n",
       "      <td>550.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>194.032</td>\n",
       "      <td>498.223</td>\n",
       "      <td>194.014</td>\n",
       "      <td>498.239</td>\n",
       "      <td>17.295</td>\n",
       "      <td>6.920</td>\n",
       "      <td>52.720</td>\n",
       "      <td>100</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>35.0</td>\n",
       "      <td>776.257</td>\n",
       "      <td>74.746</td>\n",
       "      <td>611.0</td>\n",
       "      <td>961.0</td>\n",
       "      <td>268.957</td>\n",
       "      <td>493.586</td>\n",
       "      <td>268.977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.990</td>\n",
       "      <td>111.193</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>35.0</td>\n",
       "      <td>739.286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>593.0</td>\n",
       "      <td>928.0</td>\n",
       "      <td>291.871</td>\n",
       "      <td>493.843</td>\n",
       "      <td>291.871</td>\n",
       "      <td>493.806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.352</td>\n",
       "      <td>79.368</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>14.0</td>\n",
       "      <td>736.143</td>\n",
       "      <td>81.533</td>\n",
       "      <td>646.0</td>\n",
       "      <td>902.0</td>\n",
       "      <td>315.000</td>\n",
       "      <td>493.000</td>\n",
       "      <td>314.989</td>\n",
       "      <td>493.003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.676</td>\n",
       "      <td>45.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>152.0</td>\n",
       "      <td>801.599</td>\n",
       "      <td>111.328</td>\n",
       "      <td>582.0</td>\n",
       "      <td>1263.0</td>\n",
       "      <td>348.487</td>\n",
       "      <td>497.632</td>\n",
       "      <td>348.451</td>\n",
       "      <td>497.675</td>\n",
       "      <td>17.773</td>\n",
       "      <td>10.889</td>\n",
       "      <td>11.829</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>17.0</td>\n",
       "      <td>742.706</td>\n",
       "      <td>69.624</td>\n",
       "      <td>620.0</td>\n",
       "      <td>884.0</td>\n",
       "      <td>420.500</td>\n",
       "      <td>496.382</td>\n",
       "      <td>420.513</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.663</td>\n",
       "      <td>49.457</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>60.0</td>\n",
       "      <td>758.033</td>\n",
       "      <td>77.309</td>\n",
       "      <td>601.0</td>\n",
       "      <td>947.0</td>\n",
       "      <td>259.000</td>\n",
       "      <td>499.300</td>\n",
       "      <td>258.990</td>\n",
       "      <td>499.289</td>\n",
       "      <td>9.476</td>\n",
       "      <td>8.062</td>\n",
       "      <td>90.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>12.0</td>\n",
       "      <td>714.833</td>\n",
       "      <td>67.294</td>\n",
       "      <td>551.0</td>\n",
       "      <td>785.0</td>\n",
       "      <td>240.167</td>\n",
       "      <td>498.167</td>\n",
       "      <td>240.179</td>\n",
       "      <td>498.148</td>\n",
       "      <td>4.606</td>\n",
       "      <td>3.317</td>\n",
       "      <td>168.690</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>23.0</td>\n",
       "      <td>695.043</td>\n",
       "      <td>67.356</td>\n",
       "      <td>611.0</td>\n",
       "      <td>846.0</td>\n",
       "      <td>49.891</td>\n",
       "      <td>503.022</td>\n",
       "      <td>49.882</td>\n",
       "      <td>502.979</td>\n",
       "      <td>6.454</td>\n",
       "      <td>4.537</td>\n",
       "      <td>73.243</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Area     Mean   StdDev    Min     Max        X        Y       XM  \\\n",
       "                                                                         \n",
       "382   45.0  734.356   68.637  575.0   867.0  171.500  494.789  171.492   \n",
       "383   94.0  746.617   85.198  550.0  1021.0  194.032  498.223  194.014   \n",
       "384   35.0  776.257   74.746  611.0   961.0  268.957  493.586  268.977   \n",
       "385   35.0  739.286      NaN  593.0   928.0  291.871  493.843  291.871   \n",
       "386   14.0  736.143   81.533  646.0   902.0  315.000  493.000  314.989   \n",
       "387  152.0  801.599  111.328  582.0  1263.0  348.487  497.632  348.451   \n",
       "388   17.0  742.706   69.624  620.0   884.0  420.500  496.382  420.513   \n",
       "389   60.0  758.033   77.309  601.0   947.0  259.000  499.300  258.990   \n",
       "390   12.0  714.833   67.294  551.0   785.0  240.167  498.167  240.179   \n",
       "391   23.0  695.043   67.356  611.0   846.0   49.891  503.022   49.882   \n",
       "\n",
       "          YM   Major   Minor    Angle  %Area Type  \n",
       "                                                   \n",
       "382  494.739  14.630   3.916   95.698    100    B  \n",
       "383  498.239  17.295   6.920   52.720    100    B  \n",
       "384      NaN     NaN   5.990  111.193    100    A  \n",
       "385  493.806     NaN   5.352   79.368    100    A  \n",
       "386  493.003     NaN   3.676   45.000    100    A  \n",
       "387  497.675  17.773  10.889   11.829    100    A  \n",
       "388      NaN     NaN   3.663   49.457    100    A  \n",
       "389  499.289   9.476   8.062   90.000    100    A  \n",
       "390  498.148   4.606   3.317  168.690    100    A  \n",
       "391  502.979   6.454   4.537   73.243    100    A  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail(10) # bottom 10 rows"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a66c128b-0f4d-45e3-9918-0306614c6e31",
   "metadata": {},
   "source": [
    "## Overview descriptive statistics\n",
    "To get a glimpse of the range of values which exist in the given table, we can ask the DateFrame to _describe_ itself using [`DataFrame.describe()`](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.describe.html). It will display count, mean, standard deviation and other descriptive statistics for each column in our table."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c8c7b3af",
   "metadata": {},
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>XM</th>\n",
       "      <th>YM</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Angle</th>\n",
       "      <th>%Area</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>389.000000</td>\n",
       "      <td>386.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>389.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>386.000000</td>\n",
       "      <td>383.000000</td>\n",
       "      <td>388.000000</td>\n",
       "      <td>390.000000</td>\n",
       "      <td>391.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>107.164524</td>\n",
       "      <td>743.455565</td>\n",
       "      <td>76.575309</td>\n",
       "      <td>610.414948</td>\n",
       "      <td>962.922680</td>\n",
       "      <td>256.419859</td>\n",
       "      <td>254.384088</td>\n",
       "      <td>256.183338</td>\n",
       "      <td>253.353005</td>\n",
       "      <td>12.481016</td>\n",
       "      <td>9.500662</td>\n",
       "      <td>86.598441</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>241.037082</td>\n",
       "      <td>42.252140</td>\n",
       "      <td>31.844864</td>\n",
       "      <td>57.156709</td>\n",
       "      <td>244.897224</td>\n",
       "      <td>152.261694</td>\n",
       "      <td>155.080074</td>\n",
       "      <td>152.380388</td>\n",
       "      <td>154.426250</td>\n",
       "      <td>11.979176</td>\n",
       "      <td>49.714280</td>\n",
       "      <td>60.593686</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>587.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>516.000000</td>\n",
       "      <td>587.000000</td>\n",
       "      <td>3.978000</td>\n",
       "      <td>4.722000</td>\n",
       "      <td>4.012000</td>\n",
       "      <td>4.697000</td>\n",
       "      <td>1.128000</td>\n",
       "      <td>1.128000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>15.000000</td>\n",
       "      <td>717.060750</td>\n",
       "      <td>63.861000</td>\n",
       "      <td>570.750000</td>\n",
       "      <td>847.750000</td>\n",
       "      <td>127.142000</td>\n",
       "      <td>102.875250</td>\n",
       "      <td>126.923250</td>\n",
       "      <td>103.813750</td>\n",
       "      <td>5.098000</td>\n",
       "      <td>3.637250</td>\n",
       "      <td>34.517250</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>44.000000</td>\n",
       "      <td>741.077500</td>\n",
       "      <td>74.727000</td>\n",
       "      <td>599.000000</td>\n",
       "      <td>917.500000</td>\n",
       "      <td>243.300000</td>\n",
       "      <td>271.490000</td>\n",
       "      <td>242.288000</td>\n",
       "      <td>271.272000</td>\n",
       "      <td>9.374000</td>\n",
       "      <td>5.886000</td>\n",
       "      <td>89.703500</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>116.000000</td>\n",
       "      <td>767.260750</td>\n",
       "      <td>86.826500</td>\n",
       "      <td>633.250000</td>\n",
       "      <td>1014.500000</td>\n",
       "      <td>400.167000</td>\n",
       "      <td>395.058250</td>\n",
       "      <td>400.363500</td>\n",
       "      <td>393.800750</td>\n",
       "      <td>16.283000</td>\n",
       "      <td>9.017250</td>\n",
       "      <td>134.617250</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2755.000000</td>\n",
       "      <td>912.938000</td>\n",
       "      <td>377.767000</td>\n",
       "      <td>877.000000</td>\n",
       "      <td>3880.000000</td>\n",
       "      <td>508.214000</td>\n",
       "      <td>503.022000</td>\n",
       "      <td>508.169000</td>\n",
       "      <td>502.979000</td>\n",
       "      <td>144.475000</td>\n",
       "      <td>981.000000</td>\n",
       "      <td>568.000000</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Area        Mean      StdDev         Min          Max  \\\n",
       "count   389.000000  386.000000  388.000000  388.000000   388.000000   \n",
       "mean    107.164524  743.455565   76.575309  610.414948   962.922680   \n",
       "std     241.037082   42.252140   31.844864   57.156709   244.897224   \n",
       "min       1.000000  587.000000    0.000000  516.000000   587.000000   \n",
       "25%      15.000000  717.060750   63.861000  570.750000   847.750000   \n",
       "50%      44.000000  741.077500   74.727000  599.000000   917.500000   \n",
       "75%     116.000000  767.260750   86.826500  633.250000  1014.500000   \n",
       "max    2755.000000  912.938000  377.767000  877.000000  3880.000000   \n",
       "\n",
       "                X           Y          XM          YM       Major       Minor  \\\n",
       "count  389.000000  388.000000  388.000000  386.000000  383.000000  388.000000   \n",
       "mean   256.419859  254.384088  256.183338  253.353005   12.481016    9.500662   \n",
       "std    152.261694  155.080074  152.380388  154.426250   11.979176   49.714280   \n",
       "min      3.978000    4.722000    4.012000    4.697000    1.128000    1.128000   \n",
       "25%    127.142000  102.875250  126.923250  103.813750    5.098000    3.637250   \n",
       "50%    243.300000  271.490000  242.288000  271.272000    9.374000    5.886000   \n",
       "75%    400.167000  395.058250  400.363500  393.800750   16.283000    9.017250   \n",
       "max    508.214000  503.022000  508.169000  502.979000  144.475000  981.000000   \n",
       "\n",
       "            Angle  %Area  \n",
       "count  390.000000  391.0  \n",
       "mean    86.598441  100.0  \n",
       "std     60.593686    0.0  \n",
       "min      0.000000  100.0  \n",
       "25%     34.517250  100.0  \n",
       "50%     89.703500  100.0  \n",
       "75%    134.617250  100.0  \n",
       "max    568.000000  100.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a4e9e343-bee1-49be-bfaa-c1fdcb3d8190",
   "metadata": {},
   "source": [
    "## Sorting in tables\n",
    "In many cases, we are interested in table rows that contain the maximum value, e.g. in the `area` column we can find the largest object:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9a20c5ec",
   "metadata": {},
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>Max</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>XM</th>\n",
       "      <th>YM</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Angle</th>\n",
       "      <th>%Area</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>2755.0</td>\n",
       "      <td>859.928</td>\n",
       "      <td>235.458</td>\n",
       "      <td>539.0</td>\n",
       "      <td>3880.0</td>\n",
       "      <td>108.710</td>\n",
       "      <td>302.158</td>\n",
       "      <td>110.999</td>\n",
       "      <td>300.247</td>\n",
       "      <td>144.475</td>\n",
       "      <td>24.280</td>\n",
       "      <td>39.318</td>\n",
       "      <td>100</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2295.0</td>\n",
       "      <td>765.239</td>\n",
       "      <td>96.545</td>\n",
       "      <td>558.0</td>\n",
       "      <td>1431.0</td>\n",
       "      <td>375.003</td>\n",
       "      <td>134.888</td>\n",
       "      <td>374.982</td>\n",
       "      <td>135.359</td>\n",
       "      <td>65.769</td>\n",
       "      <td>44.429</td>\n",
       "      <td>127.247</td>\n",
       "      <td>100</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>1821.0</td>\n",
       "      <td>847.761</td>\n",
       "      <td>122.074</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1510.0</td>\n",
       "      <td>287.795</td>\n",
       "      <td>321.115</td>\n",
       "      <td>288.074</td>\n",
       "      <td>321.824</td>\n",
       "      <td>55.879</td>\n",
       "      <td>41.492</td>\n",
       "      <td>112.124</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>1528.0</td>\n",
       "      <td>763.777</td>\n",
       "      <td>83.183</td>\n",
       "      <td>572.0</td>\n",
       "      <td>1172.0</td>\n",
       "      <td>191.969</td>\n",
       "      <td>385.944</td>\n",
       "      <td>192.487</td>\n",
       "      <td>385.697</td>\n",
       "      <td>63.150</td>\n",
       "      <td>30.808</td>\n",
       "      <td>34.424</td>\n",
       "      <td>100</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>1252.0</td>\n",
       "      <td>793.371</td>\n",
       "      <td>117.139</td>\n",
       "      <td>579.0</td>\n",
       "      <td>1668.0</td>\n",
       "      <td>262.071</td>\n",
       "      <td>394.497</td>\n",
       "      <td>262.268</td>\n",
       "      <td>394.326</td>\n",
       "      <td>60.154</td>\n",
       "      <td>26.500</td>\n",
       "      <td>50.147</td>\n",
       "      <td>100</td>\n",
       "      <td>A</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>1.0</td>\n",
       "      <td>587.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>587.0</td>\n",
       "      <td>587.0</td>\n",
       "      <td>399.500</td>\n",
       "      <td>117.500</td>\n",
       "      <td>399.500</td>\n",
       "      <td>117.500</td>\n",
       "      <td>1.128</td>\n",
       "      <td>1.128</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>1.0</td>\n",
       "      <td>866.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>866.0</td>\n",
       "      <td>866.0</td>\n",
       "      <td>343.500</td>\n",
       "      <td>408.500</td>\n",
       "      <td>343.500</td>\n",
       "      <td>408.500</td>\n",
       "      <td>1.128</td>\n",
       "      <td>1.128</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>1.0</td>\n",
       "      <td>763.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>763.0</td>\n",
       "      <td>763.0</td>\n",
       "      <td>411.500</td>\n",
       "      <td>296.500</td>\n",
       "      <td>411.500</td>\n",
       "      <td>296.500</td>\n",
       "      <td>1.128</td>\n",
       "      <td>1.128</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>608.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.665</td>\n",
       "      <td>7.359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.121</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.438</td>\n",
       "      <td>566.0</td>\n",
       "      <td>792.0</td>\n",
       "      <td>348.500</td>\n",
       "      <td>7.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>391 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Area     Mean   StdDev    Min     Max        X        Y       XM  \\\n",
       "                                                                          \n",
       "190  2755.0  859.928  235.458  539.0  3880.0  108.710  302.158  110.999   \n",
       "81   2295.0  765.239   96.545  558.0  1431.0  375.003  134.888  374.982   \n",
       "209  1821.0  847.761  122.074  600.0  1510.0  287.795  321.115  288.074   \n",
       "252  1528.0  763.777   83.183  572.0  1172.0  191.969  385.944  192.487   \n",
       "265  1252.0  793.371  117.139  579.0  1668.0  262.071  394.497  262.268   \n",
       "..      ...      ...      ...    ...     ...      ...      ...      ...   \n",
       "113     1.0  587.000    0.000  587.0   587.0  399.500  117.500  399.500   \n",
       "310     1.0  866.000    0.000  866.0   866.0  343.500  408.500  343.500   \n",
       "219     1.0  763.000    0.000  763.0   763.0  411.500  296.500  411.500   \n",
       "3       NaN      NaN      NaN  608.0   964.0      NaN      NaN      NaN   \n",
       "5       NaN      NaN   69.438  566.0   792.0  348.500    7.500      NaN   \n",
       "\n",
       "          YM    Major   Minor    Angle  %Area Type  \n",
       "                                                    \n",
       "190  300.247  144.475  24.280   39.318    100    C  \n",
       "81   135.359   65.769  44.429  127.247    100    B  \n",
       "209  321.824   55.879  41.492  112.124    100    A  \n",
       "252  385.697   63.150  30.808   34.424    100    B  \n",
       "265  394.326   60.154  26.500   50.147    100    A  \n",
       "..       ...      ...     ...      ...    ...  ...  \n",
       "113  117.500    1.128   1.128    0.000    100    A  \n",
       "310  408.500    1.128   1.128    0.000    100    A  \n",
       "219  296.500    1.128   1.128    0.000    100    A  \n",
       "3      7.665    7.359     NaN  101.121    100    A  \n",
       "5      7.508      NaN   3.088      NaN    100    A  \n",
       "\n",
       "[391 rows x 14 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by = \"Area\", ascending=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}