{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "# Sorting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df_cars = pd.read_csv(\"data/cars.csv\", sep=\";\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "outputs": [
    {
     "data": {
      "text/plain": "                         Car   MPG Cylinders Displacement Horsepower Weight  \\\n104  AMC Ambassador Brougham  13.0         8        360.0      175.0  3821.   \n10        AMC Ambassador DPL  15.0         8        390.0      190.0  3850.   \n74        AMC Ambassador SST  17.0         8        304.0      150.0  3672.   \n265              AMC Concord  19.4         6        232.0      90.00  3210.   \n323              AMC Concord  24.3         4        151.0      90.00  3003.   \n..                       ...   ...       ...          ...        ...    ...   \n84           Volvo 145e (sw)  18.0         4        121.0      112.0  2933.   \n187              Volvo 244DL  22.0         4        121.0      98.00  2945.   \n215                Volvo 245  20.0         4        130.0      102.0  3150.   \n283              Volvo 264gl  17.0         6        163.0      125.0  3140.   \n369             Volvo Diesel  30.7         6        145.0      76.00  3160.   \n\n    Acceleration Model  Origin  \n104         11.0    73      US  \n10           8.5    70      US  \n74          11.5    72      US  \n265         17.2    78      US  \n323         20.1    80      US  \n..           ...   ...     ...  \n84          14.5    72  Europe  \n187         14.5    75  Europe  \n215         15.7    76  Europe  \n283         13.6    78  Europe  \n369         19.6    81  Europe  \n\n[407 rows x 9 columns]",
      "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>Car</th>\n      <th>MPG</th>\n      <th>Cylinders</th>\n      <th>Displacement</th>\n      <th>Horsepower</th>\n      <th>Weight</th>\n      <th>Acceleration</th>\n      <th>Model</th>\n      <th>Origin</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>104</th>\n      <td>AMC Ambassador Brougham</td>\n      <td>13.0</td>\n      <td>8</td>\n      <td>360.0</td>\n      <td>175.0</td>\n      <td>3821.</td>\n      <td>11.0</td>\n      <td>73</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>AMC Ambassador DPL</td>\n      <td>15.0</td>\n      <td>8</td>\n      <td>390.0</td>\n      <td>190.0</td>\n      <td>3850.</td>\n      <td>8.5</td>\n      <td>70</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>AMC Ambassador SST</td>\n      <td>17.0</td>\n      <td>8</td>\n      <td>304.0</td>\n      <td>150.0</td>\n      <td>3672.</td>\n      <td>11.5</td>\n      <td>72</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>265</th>\n      <td>AMC Concord</td>\n      <td>19.4</td>\n      <td>6</td>\n      <td>232.0</td>\n      <td>90.00</td>\n      <td>3210.</td>\n      <td>17.2</td>\n      <td>78</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>323</th>\n      <td>AMC Concord</td>\n      <td>24.3</td>\n      <td>4</td>\n      <td>151.0</td>\n      <td>90.00</td>\n      <td>3003.</td>\n      <td>20.1</td>\n      <td>80</td>\n      <td>US</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>84</th>\n      <td>Volvo 145e (sw)</td>\n      <td>18.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>112.0</td>\n      <td>2933.</td>\n      <td>14.5</td>\n      <td>72</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>187</th>\n      <td>Volvo 244DL</td>\n      <td>22.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>98.00</td>\n      <td>2945.</td>\n      <td>14.5</td>\n      <td>75</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>215</th>\n      <td>Volvo 245</td>\n      <td>20.0</td>\n      <td>4</td>\n      <td>130.0</td>\n      <td>102.0</td>\n      <td>3150.</td>\n      <td>15.7</td>\n      <td>76</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>283</th>\n      <td>Volvo 264gl</td>\n      <td>17.0</td>\n      <td>6</td>\n      <td>163.0</td>\n      <td>125.0</td>\n      <td>3140.</td>\n      <td>13.6</td>\n      <td>78</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>369</th>\n      <td>Volvo Diesel</td>\n      <td>30.7</td>\n      <td>6</td>\n      <td>145.0</td>\n      <td>76.00</td>\n      <td>3160.</td>\n      <td>19.6</td>\n      <td>81</td>\n      <td>Europe</td>\n    </tr>\n  </tbody>\n</table>\n<p>407 rows × 9 columns</p>\n</div>"
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars.sort_values(by=\"Car\")"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [
    {
     "data": {
      "text/plain": "                         Car   MPG Cylinders Displacement Horsepower Weight  \\\n369             Volvo Diesel  30.7         6        145.0      76.00  3160.   \n283              Volvo 264gl  17.0         6        163.0      125.0  3140.   \n215                Volvo 245  20.0         4        130.0      102.0  3150.   \n187              Volvo 244DL  22.0         4        121.0      98.00  2945.   \n84           Volvo 145e (sw)  18.0         4        121.0      112.0  2933.   \n..                       ...   ...       ...          ...        ...    ...   \n323              AMC Concord  24.3         4        151.0      90.00  3003.   \n265              AMC Concord  19.4         6        232.0      90.00  3210.   \n74        AMC Ambassador SST  17.0         8        304.0      150.0  3672.   \n10        AMC Ambassador DPL  15.0         8        390.0      190.0  3850.   \n104  AMC Ambassador Brougham  13.0         8        360.0      175.0  3821.   \n\n    Acceleration Model  Origin  \n369         19.6    81  Europe  \n283         13.6    78  Europe  \n215         15.7    76  Europe  \n187         14.5    75  Europe  \n84          14.5    72  Europe  \n..           ...   ...     ...  \n323         20.1    80      US  \n265         17.2    78      US  \n74          11.5    72      US  \n10           8.5    70      US  \n104         11.0    73      US  \n\n[407 rows x 9 columns]",
      "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>Car</th>\n      <th>MPG</th>\n      <th>Cylinders</th>\n      <th>Displacement</th>\n      <th>Horsepower</th>\n      <th>Weight</th>\n      <th>Acceleration</th>\n      <th>Model</th>\n      <th>Origin</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>369</th>\n      <td>Volvo Diesel</td>\n      <td>30.7</td>\n      <td>6</td>\n      <td>145.0</td>\n      <td>76.00</td>\n      <td>3160.</td>\n      <td>19.6</td>\n      <td>81</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>283</th>\n      <td>Volvo 264gl</td>\n      <td>17.0</td>\n      <td>6</td>\n      <td>163.0</td>\n      <td>125.0</td>\n      <td>3140.</td>\n      <td>13.6</td>\n      <td>78</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>215</th>\n      <td>Volvo 245</td>\n      <td>20.0</td>\n      <td>4</td>\n      <td>130.0</td>\n      <td>102.0</td>\n      <td>3150.</td>\n      <td>15.7</td>\n      <td>76</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>187</th>\n      <td>Volvo 244DL</td>\n      <td>22.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>98.00</td>\n      <td>2945.</td>\n      <td>14.5</td>\n      <td>75</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>84</th>\n      <td>Volvo 145e (sw)</td>\n      <td>18.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>112.0</td>\n      <td>2933.</td>\n      <td>14.5</td>\n      <td>72</td>\n      <td>Europe</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>323</th>\n      <td>AMC Concord</td>\n      <td>24.3</td>\n      <td>4</td>\n      <td>151.0</td>\n      <td>90.00</td>\n      <td>3003.</td>\n      <td>20.1</td>\n      <td>80</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>265</th>\n      <td>AMC Concord</td>\n      <td>19.4</td>\n      <td>6</td>\n      <td>232.0</td>\n      <td>90.00</td>\n      <td>3210.</td>\n      <td>17.2</td>\n      <td>78</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>AMC Ambassador SST</td>\n      <td>17.0</td>\n      <td>8</td>\n      <td>304.0</td>\n      <td>150.0</td>\n      <td>3672.</td>\n      <td>11.5</td>\n      <td>72</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>AMC Ambassador DPL</td>\n      <td>15.0</td>\n      <td>8</td>\n      <td>390.0</td>\n      <td>190.0</td>\n      <td>3850.</td>\n      <td>8.5</td>\n      <td>70</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>104</th>\n      <td>AMC Ambassador Brougham</td>\n      <td>13.0</td>\n      <td>8</td>\n      <td>360.0</td>\n      <td>175.0</td>\n      <td>3821.</td>\n      <td>11.0</td>\n      <td>73</td>\n      <td>US</td>\n    </tr>\n  </tbody>\n</table>\n<p>407 rows × 9 columns</p>\n</div>"
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars.sort_values(by=\"Car\", ascending=False)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [
    {
     "data": {
      "text/plain": "                         Car   MPG Cylinders Displacement Horsepower Weight  \\\n104  AMC Ambassador Brougham  13.0         8        360.0      175.0  3821.   \n10        AMC Ambassador DPL  15.0         8        390.0      190.0  3850.   \n74        AMC Ambassador SST  17.0         8        304.0      150.0  3672.   \n265              AMC Concord  19.4         6        232.0      90.00  3210.   \n323              AMC Concord  24.3         4        151.0      90.00  3003.   \n..                       ...   ...       ...          ...        ...    ...   \n84           Volvo 145e (sw)  18.0         4        121.0      112.0  2933.   \n187              Volvo 244DL  22.0         4        121.0      98.00  2945.   \n215                Volvo 245  20.0         4        130.0      102.0  3150.   \n283              Volvo 264gl  17.0         6        163.0      125.0  3140.   \n369             Volvo Diesel  30.7         6        145.0      76.00  3160.   \n\n    Acceleration Model  Origin  \n104         11.0    73      US  \n10           8.5    70      US  \n74          11.5    72      US  \n265         17.2    78      US  \n323         20.1    80      US  \n..           ...   ...     ...  \n84          14.5    72  Europe  \n187         14.5    75  Europe  \n215         15.7    76  Europe  \n283         13.6    78  Europe  \n369         19.6    81  Europe  \n\n[407 rows x 9 columns]",
      "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>Car</th>\n      <th>MPG</th>\n      <th>Cylinders</th>\n      <th>Displacement</th>\n      <th>Horsepower</th>\n      <th>Weight</th>\n      <th>Acceleration</th>\n      <th>Model</th>\n      <th>Origin</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>104</th>\n      <td>AMC Ambassador Brougham</td>\n      <td>13.0</td>\n      <td>8</td>\n      <td>360.0</td>\n      <td>175.0</td>\n      <td>3821.</td>\n      <td>11.0</td>\n      <td>73</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>AMC Ambassador DPL</td>\n      <td>15.0</td>\n      <td>8</td>\n      <td>390.0</td>\n      <td>190.0</td>\n      <td>3850.</td>\n      <td>8.5</td>\n      <td>70</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>AMC Ambassador SST</td>\n      <td>17.0</td>\n      <td>8</td>\n      <td>304.0</td>\n      <td>150.0</td>\n      <td>3672.</td>\n      <td>11.5</td>\n      <td>72</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>265</th>\n      <td>AMC Concord</td>\n      <td>19.4</td>\n      <td>6</td>\n      <td>232.0</td>\n      <td>90.00</td>\n      <td>3210.</td>\n      <td>17.2</td>\n      <td>78</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>323</th>\n      <td>AMC Concord</td>\n      <td>24.3</td>\n      <td>4</td>\n      <td>151.0</td>\n      <td>90.00</td>\n      <td>3003.</td>\n      <td>20.1</td>\n      <td>80</td>\n      <td>US</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>84</th>\n      <td>Volvo 145e (sw)</td>\n      <td>18.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>112.0</td>\n      <td>2933.</td>\n      <td>14.5</td>\n      <td>72</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>187</th>\n      <td>Volvo 244DL</td>\n      <td>22.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>98.00</td>\n      <td>2945.</td>\n      <td>14.5</td>\n      <td>75</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>215</th>\n      <td>Volvo 245</td>\n      <td>20.0</td>\n      <td>4</td>\n      <td>130.0</td>\n      <td>102.0</td>\n      <td>3150.</td>\n      <td>15.7</td>\n      <td>76</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>283</th>\n      <td>Volvo 264gl</td>\n      <td>17.0</td>\n      <td>6</td>\n      <td>163.0</td>\n      <td>125.0</td>\n      <td>3140.</td>\n      <td>13.6</td>\n      <td>78</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>369</th>\n      <td>Volvo Diesel</td>\n      <td>30.7</td>\n      <td>6</td>\n      <td>145.0</td>\n      <td>76.00</td>\n      <td>3160.</td>\n      <td>19.6</td>\n      <td>81</td>\n      <td>Europe</td>\n    </tr>\n  </tbody>\n</table>\n<p>407 rows × 9 columns</p>\n</div>"
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars.sort_values(by=[\"Car\", \"Model\"])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "outputs": [
    {
     "data": {
      "text/plain": "                         Car   MPG Cylinders Displacement Horsepower Weight  \\\n369             Volvo Diesel  30.7         6        145.0      76.00  3160.   \n283              Volvo 264gl  17.0         6        163.0      125.0  3140.   \n215                Volvo 245  20.0         4        130.0      102.0  3150.   \n187              Volvo 244DL  22.0         4        121.0      98.00  2945.   \n84           Volvo 145e (sw)  18.0         4        121.0      112.0  2933.   \n..                       ...   ...       ...          ...        ...    ...   \n265              AMC Concord  19.4         6        232.0      90.00  3210.   \n323              AMC Concord  24.3         4        151.0      90.00  3003.   \n74        AMC Ambassador SST  17.0         8        304.0      150.0  3672.   \n10        AMC Ambassador DPL  15.0         8        390.0      190.0  3850.   \n104  AMC Ambassador Brougham  13.0         8        360.0      175.0  3821.   \n\n    Acceleration Model  Origin  \n369         19.6    81  Europe  \n283         13.6    78  Europe  \n215         15.7    76  Europe  \n187         14.5    75  Europe  \n84          14.5    72  Europe  \n..           ...   ...     ...  \n265         17.2    78      US  \n323         20.1    80      US  \n74          11.5    72      US  \n10           8.5    70      US  \n104         11.0    73      US  \n\n[407 rows x 9 columns]",
      "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>Car</th>\n      <th>MPG</th>\n      <th>Cylinders</th>\n      <th>Displacement</th>\n      <th>Horsepower</th>\n      <th>Weight</th>\n      <th>Acceleration</th>\n      <th>Model</th>\n      <th>Origin</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>369</th>\n      <td>Volvo Diesel</td>\n      <td>30.7</td>\n      <td>6</td>\n      <td>145.0</td>\n      <td>76.00</td>\n      <td>3160.</td>\n      <td>19.6</td>\n      <td>81</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>283</th>\n      <td>Volvo 264gl</td>\n      <td>17.0</td>\n      <td>6</td>\n      <td>163.0</td>\n      <td>125.0</td>\n      <td>3140.</td>\n      <td>13.6</td>\n      <td>78</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>215</th>\n      <td>Volvo 245</td>\n      <td>20.0</td>\n      <td>4</td>\n      <td>130.0</td>\n      <td>102.0</td>\n      <td>3150.</td>\n      <td>15.7</td>\n      <td>76</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>187</th>\n      <td>Volvo 244DL</td>\n      <td>22.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>98.00</td>\n      <td>2945.</td>\n      <td>14.5</td>\n      <td>75</td>\n      <td>Europe</td>\n    </tr>\n    <tr>\n      <th>84</th>\n      <td>Volvo 145e (sw)</td>\n      <td>18.0</td>\n      <td>4</td>\n      <td>121.0</td>\n      <td>112.0</td>\n      <td>2933.</td>\n      <td>14.5</td>\n      <td>72</td>\n      <td>Europe</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>265</th>\n      <td>AMC Concord</td>\n      <td>19.4</td>\n      <td>6</td>\n      <td>232.0</td>\n      <td>90.00</td>\n      <td>3210.</td>\n      <td>17.2</td>\n      <td>78</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>323</th>\n      <td>AMC Concord</td>\n      <td>24.3</td>\n      <td>4</td>\n      <td>151.0</td>\n      <td>90.00</td>\n      <td>3003.</td>\n      <td>20.1</td>\n      <td>80</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>AMC Ambassador SST</td>\n      <td>17.0</td>\n      <td>8</td>\n      <td>304.0</td>\n      <td>150.0</td>\n      <td>3672.</td>\n      <td>11.5</td>\n      <td>72</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>AMC Ambassador DPL</td>\n      <td>15.0</td>\n      <td>8</td>\n      <td>390.0</td>\n      <td>190.0</td>\n      <td>3850.</td>\n      <td>8.5</td>\n      <td>70</td>\n      <td>US</td>\n    </tr>\n    <tr>\n      <th>104</th>\n      <td>AMC Ambassador Brougham</td>\n      <td>13.0</td>\n      <td>8</td>\n      <td>360.0</td>\n      <td>175.0</td>\n      <td>3821.</td>\n      <td>11.0</td>\n      <td>73</td>\n      <td>US</td>\n    </tr>\n  </tbody>\n</table>\n<p>407 rows × 9 columns</p>\n</div>"
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars.sort_values(by=[\"Car\", \"Model\"], ascending=[False, True])"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "outputs": [
    {
     "data": {
      "text/plain": "<bound method DataFrame.sort_index of                            Car     MPG Cylinders Displacement Horsepower  \\\n0                       STRING  DOUBLE       INT       DOUBLE     DOUBLE   \n1    Chevrolet Chevelle Malibu    18.0         8        307.0      130.0   \n2            Buick Skylark 320    15.0         8        350.0      165.0   \n3           Plymouth Satellite    18.0         8        318.0      150.0   \n4                AMC Rebel SST    16.0         8        304.0      150.0   \n..                         ...     ...       ...          ...        ...   \n402            Ford Mustang GL    27.0         4        140.0      86.00   \n403          Volkswagen Pickup    44.0         4        97.00      52.00   \n404              Dodge Rampage    32.0         4        135.0      84.00   \n405                Ford Ranger    28.0         4        120.0      79.00   \n406                 Chevy S-10    31.0         4        119.0      82.00   \n\n     Weight Acceleration Model  Origin  \n0    DOUBLE       DOUBLE   INT     CAT  \n1     3504.         12.0    70      US  \n2     3693.         11.5    70      US  \n3     3436.         11.0    70      US  \n4     3433.         12.0    70      US  \n..      ...          ...   ...     ...  \n402   2790.         15.6    82      US  \n403   2130.         24.6    82  Europe  \n404   2295.         11.6    82      US  \n405   2625.         18.6    82      US  \n406   2720.         19.4    82      US  \n\n[407 rows x 9 columns]>"
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars.sort_index"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [
    {
     "data": {
      "text/plain": "104    AMC Ambassador Brougham\n10          AMC Ambassador DPL\n74          AMC Ambassador SST\n265                AMC Concord\n323                AMC Concord\n                ...           \n84             Volvo 145e (sw)\n187                Volvo 244DL\n215                  Volvo 245\n283                Volvo 264gl\n369               Volvo Diesel\nName: Car, Length: 407, dtype: object"
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cars[\"Car\"].sort_values()"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}