min_wage_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "6843a5b9-04ad-4668-80cb-48fa2e65d21e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly as pl\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ec17ae94-6978-4fa7-8fdc-4ea4bbbba0a9",
   "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>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>State.Minimum.Wage</th>\n",
       "      <th>State.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Federal.Minimum.Wage</th>\n",
       "      <th>Federal.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Effective.Minimum.Wage</th>\n",
       "      <th>Effective.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>CPI.Average</th>\n",
       "      <th>Department.Of.Labor.Uncleaned.Data</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value.2020.Dollars</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value.2020.Dollars</th>\n",
       "      <th>Footnote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1350</th>\n",
       "      <td>1993</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1351</th>\n",
       "      <td>1993</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1352</th>\n",
       "      <td>1993</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1353</th>\n",
       "      <td>1993</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>3.65</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354</th>\n",
       "      <td>1993</td>\n",
       "      <td>California</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2857</th>\n",
       "      <td>2020</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25[c]</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>[c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2858</th>\n",
       "      <td>2020</td>\n",
       "      <td>Washington</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>258.66</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2859</th>\n",
       "      <td>2020</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>258.66</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>2020</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>2020</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1512 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year          State  State.Minimum.Wage  \\\n",
       "1350  1993        Alabama                0.00   \n",
       "1351  1993         Alaska                4.75   \n",
       "1352  1993        Arizona                0.00   \n",
       "1353  1993       Arkansas                3.65   \n",
       "1354  1993     California                4.25   \n",
       "...    ...            ...                 ...   \n",
       "2857  2020       Virginia                7.25   \n",
       "2858  2020     Washington               13.50   \n",
       "2859  2020  West Virginia                8.75   \n",
       "2860  2020      Wisconsin                7.25   \n",
       "2861  2020        Wyoming                5.15   \n",
       "\n",
       "      State.Minimum.Wage.2020.Dollars  Federal.Minimum.Wage  \\\n",
       "1350                             0.00                  4.25   \n",
       "1351                             8.50                  4.25   \n",
       "1352                             0.00                  4.25   \n",
       "1353                             6.53                  4.25   \n",
       "1354                             7.61                  4.25   \n",
       "...                               ...                   ...   \n",
       "2857                             7.25                  7.25   \n",
       "2858                            13.50                  7.25   \n",
       "2859                             8.75                  7.25   \n",
       "2860                             7.25                  7.25   \n",
       "2861                             5.15                  7.25   \n",
       "\n",
       "      Federal.Minimum.Wage.2020.Dollars  Effective.Minimum.Wage  \\\n",
       "1350                               7.61                    4.25   \n",
       "1351                               7.61                    4.75   \n",
       "1352                               7.61                    4.25   \n",
       "1353                               7.61                    4.25   \n",
       "1354                               7.61                    4.25   \n",
       "...                                 ...                     ...   \n",
       "2857                               7.25                    7.25   \n",
       "2858                               7.25                   13.50   \n",
       "2859                               7.25                    8.75   \n",
       "2860                               7.25                    7.25   \n",
       "2861                               7.25                    7.25   \n",
       "\n",
       "      Effective.Minimum.Wage.2020.Dollars  CPI.Average  \\\n",
       "1350                                 7.61       144.50   \n",
       "1351                                 8.50       144.50   \n",
       "1352                                 7.61       144.50   \n",
       "1353                                 7.61       144.50   \n",
       "1354                                 7.61       144.50   \n",
       "...                                   ...          ...   \n",
       "2857                                 7.25       258.66   \n",
       "2858                                13.50       258.66   \n",
       "2859                                 8.75       258.66   \n",
       "2860                                 7.25       258.66   \n",
       "2861                                 7.25       258.66   \n",
       "\n",
       "     Department.Of.Labor.Uncleaned.Data  \\\n",
       "1350                                ...   \n",
       "1351                               4.75   \n",
       "1352                                ...   \n",
       "1353                               3.65   \n",
       "1354                               4.25   \n",
       "...                                 ...   \n",
       "2857                            7.25[c]   \n",
       "2858                               13.5   \n",
       "2859                               8.75   \n",
       "2860                               7.25   \n",
       "2861                               5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value  \\\n",
       "1350                                   0.00   \n",
       "1351                                   4.75   \n",
       "1352                                   0.00   \n",
       "1353                                   3.65   \n",
       "1354                                   4.25   \n",
       "...                                     ...   \n",
       "2857                                   7.25   \n",
       "2858                                  13.50   \n",
       "2859                                   8.75   \n",
       "2860                                   7.25   \n",
       "2861                                   5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value.2020.Dollars  \\\n",
       "1350                                               0.00    \n",
       "1351                                               8.50    \n",
       "1352                                               0.00    \n",
       "1353                                               6.53    \n",
       "1354                                               7.61    \n",
       "...                                                 ...    \n",
       "2857                                               7.25    \n",
       "2858                                              13.50    \n",
       "2859                                               8.75    \n",
       "2860                                               7.25    \n",
       "2861                                               5.15    \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value  \\\n",
       "1350                                    0.00   \n",
       "1351                                    4.75   \n",
       "1352                                    0.00   \n",
       "1353                                    3.65   \n",
       "1354                                    4.25   \n",
       "...                                      ...   \n",
       "2857                                    7.25   \n",
       "2858                                   13.50   \n",
       "2859                                    8.75   \n",
       "2860                                    7.25   \n",
       "2861                                    5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value.2020.Dollars Footnote  \n",
       "1350                                               0.00        NaN  \n",
       "1351                                               8.50        NaN  \n",
       "1352                                               0.00        NaN  \n",
       "1353                                               6.53        NaN  \n",
       "1354                                               7.61        NaN  \n",
       "...                                                 ...        ...  \n",
       "2857                                               7.25        [c]  \n",
       "2858                                              13.50        NaN  \n",
       "2859                                               8.75        NaN  \n",
       "2860                                               7.25        NaN  \n",
       "2861                                               5.15        NaN  \n",
       "\n",
       "[1512 rows x 15 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_wage_df = pd.read_csv(\"min_wage.csv\",encoding='cp1252')\n",
    "min_wage_df = min_wage_df[min_wage_df['Year'] >= 1993]\n",
    "min_wage_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b10d804f-fabf-436d-af0b-fc35638754ce",
   "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>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>State.Minimum.Wage</th>\n",
       "      <th>State.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Federal.Minimum.Wage</th>\n",
       "      <th>Federal.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Effective.Minimum.Wage</th>\n",
       "      <th>Effective.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>CPI.Average</th>\n",
       "      <th>Department.Of.Labor.Uncleaned.Data</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value.2020.Dollars</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value.2020.Dollars</th>\n",
       "      <th>Footnote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1350</th>\n",
       "      <td>1993</td>\n",
       "      <td>AL</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1351</th>\n",
       "      <td>1993</td>\n",
       "      <td>AK</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1352</th>\n",
       "      <td>1993</td>\n",
       "      <td>AZ</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1353</th>\n",
       "      <td>1993</td>\n",
       "      <td>AR</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>3.65</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>3.65</td>\n",
       "      <td>6.53</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354</th>\n",
       "      <td>1993</td>\n",
       "      <td>CA</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>144.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2857</th>\n",
       "      <td>2020</td>\n",
       "      <td>VA</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25[c]</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>[c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2858</th>\n",
       "      <td>2020</td>\n",
       "      <td>WA</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>258.66</td>\n",
       "      <td>13.5</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>13.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2859</th>\n",
       "      <td>2020</td>\n",
       "      <td>WV</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>258.66</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>8.75</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>2020</td>\n",
       "      <td>WI</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>2020</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.66</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1512 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year State  State.Minimum.Wage  State.Minimum.Wage.2020.Dollars  \\\n",
       "1350  1993    AL                0.00                             0.00   \n",
       "1351  1993    AK                4.75                             8.50   \n",
       "1352  1993    AZ                0.00                             0.00   \n",
       "1353  1993    AR                3.65                             6.53   \n",
       "1354  1993    CA                4.25                             7.61   \n",
       "...    ...   ...                 ...                              ...   \n",
       "2857  2020    VA                7.25                             7.25   \n",
       "2858  2020    WA               13.50                            13.50   \n",
       "2859  2020    WV                8.75                             8.75   \n",
       "2860  2020    WI                7.25                             7.25   \n",
       "2861  2020    WY                5.15                             5.15   \n",
       "\n",
       "      Federal.Minimum.Wage  Federal.Minimum.Wage.2020.Dollars  \\\n",
       "1350                  4.25                               7.61   \n",
       "1351                  4.25                               7.61   \n",
       "1352                  4.25                               7.61   \n",
       "1353                  4.25                               7.61   \n",
       "1354                  4.25                               7.61   \n",
       "...                    ...                                ...   \n",
       "2857                  7.25                               7.25   \n",
       "2858                  7.25                               7.25   \n",
       "2859                  7.25                               7.25   \n",
       "2860                  7.25                               7.25   \n",
       "2861                  7.25                               7.25   \n",
       "\n",
       "      Effective.Minimum.Wage  Effective.Minimum.Wage.2020.Dollars  \\\n",
       "1350                    4.25                                 7.61   \n",
       "1351                    4.75                                 8.50   \n",
       "1352                    4.25                                 7.61   \n",
       "1353                    4.25                                 7.61   \n",
       "1354                    4.25                                 7.61   \n",
       "...                      ...                                  ...   \n",
       "2857                    7.25                                 7.25   \n",
       "2858                   13.50                                13.50   \n",
       "2859                    8.75                                 8.75   \n",
       "2860                    7.25                                 7.25   \n",
       "2861                    7.25                                 7.25   \n",
       "\n",
       "      CPI.Average Department.Of.Labor.Uncleaned.Data  \\\n",
       "1350       144.50                                ...   \n",
       "1351       144.50                               4.75   \n",
       "1352       144.50                                ...   \n",
       "1353       144.50                               3.65   \n",
       "1354       144.50                               4.25   \n",
       "...           ...                                ...   \n",
       "2857       258.66                            7.25[c]   \n",
       "2858       258.66                               13.5   \n",
       "2859       258.66                               8.75   \n",
       "2860       258.66                               7.25   \n",
       "2861       258.66                               5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value  \\\n",
       "1350                                   0.00   \n",
       "1351                                   4.75   \n",
       "1352                                   0.00   \n",
       "1353                                   3.65   \n",
       "1354                                   4.25   \n",
       "...                                     ...   \n",
       "2857                                   7.25   \n",
       "2858                                  13.50   \n",
       "2859                                   8.75   \n",
       "2860                                   7.25   \n",
       "2861                                   5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value.2020.Dollars  \\\n",
       "1350                                               0.00    \n",
       "1351                                               8.50    \n",
       "1352                                               0.00    \n",
       "1353                                               6.53    \n",
       "1354                                               7.61    \n",
       "...                                                 ...    \n",
       "2857                                               7.25    \n",
       "2858                                              13.50    \n",
       "2859                                               8.75    \n",
       "2860                                               7.25    \n",
       "2861                                               5.15    \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value  \\\n",
       "1350                                    0.00   \n",
       "1351                                    4.75   \n",
       "1352                                    0.00   \n",
       "1353                                    3.65   \n",
       "1354                                    4.25   \n",
       "...                                      ...   \n",
       "2857                                    7.25   \n",
       "2858                                   13.50   \n",
       "2859                                    8.75   \n",
       "2860                                    7.25   \n",
       "2861                                    5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value.2020.Dollars Footnote  \n",
       "1350                                               0.00        NaN  \n",
       "1351                                               8.50        NaN  \n",
       "1352                                               0.00        NaN  \n",
       "1353                                               6.53        NaN  \n",
       "1354                                               7.61        NaN  \n",
       "...                                                 ...        ...  \n",
       "2857                                               7.25        [c]  \n",
       "2858                                              13.50        NaN  \n",
       "2859                                               8.75        NaN  \n",
       "2860                                               7.25        NaN  \n",
       "2861                                               5.15        NaN  \n",
       "\n",
       "[1512 rows x 15 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "us_state_to_abbrev = {\"State\" : {\n",
    "    \"Alabama\": \"AL\",\n",
    "    \"Alaska\": \"AK\",\n",
    "    \"Arizona\": \"AZ\",\n",
    "    \"Arkansas\": \"AR\",\n",
    "    \"California\": \"CA\",\n",
    "    \"Colorado\": \"CO\",\n",
    "    \"Connecticut\": \"CT\",\n",
    "    \"Delaware\": \"DE\",\n",
    "    \"Florida\": \"FL\",\n",
    "    \"Georgia\": \"GA\",\n",
    "    \"Hawaii\": \"HI\",\n",
    "    \"Idaho\": \"ID\",\n",
    "    \"Illinois\": \"IL\",\n",
    "    \"Indiana\": \"IN\",\n",
    "    \"Iowa\": \"IA\",\n",
    "    \"Kansas\": \"KS\",\n",
    "    \"Kentucky\": \"KY\",\n",
    "    \"Louisiana\": \"LA\",\n",
    "    \"Maine\": \"ME\",\n",
    "    \"Maryland\": \"MD\",\n",
    "    \"Massachusetts\": \"MA\",\n",
    "    \"Michigan\": \"MI\",\n",
    "    \"Minnesota\": \"MN\",\n",
    "    \"Mississippi\": \"MS\",\n",
    "    \"Missouri\": \"MO\",\n",
    "    \"Montana\": \"MT\",\n",
    "    \"Nebraska\": \"NE\",\n",
    "    \"Nevada\": \"NV\",\n",
    "    \"New Hampshire\": \"NH\",\n",
    "    \"New Jersey\": \"NJ\",\n",
    "    \"New Mexico\": \"NM\",\n",
    "    \"New York\": \"NY\",\n",
    "    \"North Carolina\": \"NC\",\n",
    "    \"North Dakota\": \"ND\",\n",
    "    \"Ohio\": \"OH\",\n",
    "    \"Oklahoma\": \"OK\",\n",
    "    \"Oregon\": \"OR\",\n",
    "    \"Pennsylvania\": \"PA\",\n",
    "    \"Rhode Island\": \"RI\",\n",
    "    \"South Carolina\": \"SC\",\n",
    "    \"South Dakota\": \"SD\",\n",
    "    \"Tennessee\": \"TN\",\n",
    "    \"Texas\": \"TX\",\n",
    "    \"Utah\": \"UT\",\n",
    "    \"Vermont\": \"VT\",\n",
    "    \"Virginia\": \"VA\",\n",
    "    \"Washington\": \"WA\",\n",
    "    \"West Virginia\": \"WV\",\n",
    "    \"Wisconsin\": \"WI\",\n",
    "    \"Wyoming\": \"WY\",\n",
    "    \"District of Columbia\": \"DC\",\n",
    "    \"American Samoa\": \"AS\",\n",
    "    \"Guam\": \"GU\",\n",
    "    \"Northern Mariana Islands\": \"MP\",\n",
    "    \"Puerto Rico\": \"PR\",\n",
    "    \"United States Minor Outlying Islands\": \"UM\",\n",
    "    \"U.S. Virgin Islands\": \"VI\",\n",
    "}}\n",
    "min_wage_df = min_wage_df.replace(us_state_to_abbrev)\n",
    "min_wage_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6040fb36-3620-489d-98a0-bb870be3b525",
   "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>Year</th>\n",
       "      <th>State</th>\n",
       "      <th>State.Minimum.Wage</th>\n",
       "      <th>State.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Federal.Minimum.Wage</th>\n",
       "      <th>Federal.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>Effective.Minimum.Wage</th>\n",
       "      <th>Effective.Minimum.Wage.2020.Dollars</th>\n",
       "      <th>CPI.Average</th>\n",
       "      <th>Department.Of.Labor.Uncleaned.Data</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.Low.Value.2020.Dollars</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value</th>\n",
       "      <th>Department.Of.Labor.Cleaned.High.Value.2020.Dollars</th>\n",
       "      <th>Footnote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1351</th>\n",
       "      <td>1993</td>\n",
       "      <td>AK</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.61</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>144.500</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.50</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1405</th>\n",
       "      <td>1994</td>\n",
       "      <td>AK</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.29</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.42</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.29</td>\n",
       "      <td>148.200</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.29</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.29</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>1995</td>\n",
       "      <td>AK</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.06</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.21</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.06</td>\n",
       "      <td>152.400</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.06</td>\n",
       "      <td>4.75</td>\n",
       "      <td>8.06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1513</th>\n",
       "      <td>1996</td>\n",
       "      <td>AK</td>\n",
       "      <td>4.75</td>\n",
       "      <td>7.83</td>\n",
       "      <td>4.25</td>\n",
       "      <td>7.01</td>\n",
       "      <td>4.75</td>\n",
       "      <td>7.83</td>\n",
       "      <td>156.900</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>7.83</td>\n",
       "      <td>4.75</td>\n",
       "      <td>7.83</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1567</th>\n",
       "      <td>1997</td>\n",
       "      <td>AK</td>\n",
       "      <td>5.25</td>\n",
       "      <td>8.46</td>\n",
       "      <td>4.75</td>\n",
       "      <td>7.66</td>\n",
       "      <td>5.25</td>\n",
       "      <td>8.46</td>\n",
       "      <td>160.500</td>\n",
       "      <td>5.25</td>\n",
       "      <td>5.25</td>\n",
       "      <td>8.46</td>\n",
       "      <td>5.25</td>\n",
       "      <td>8.46</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2645</th>\n",
       "      <td>2016</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.55</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.81</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.81</td>\n",
       "      <td>240.007</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.55</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.55</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2699</th>\n",
       "      <td>2017</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.43</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.65</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.65</td>\n",
       "      <td>245.120</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.43</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.43</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2753</th>\n",
       "      <td>2018</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.30</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.47</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.47</td>\n",
       "      <td>251.107</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.30</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.30</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2807</th>\n",
       "      <td>2019</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.21</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.34</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.34</td>\n",
       "      <td>255.657</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.21</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2861</th>\n",
       "      <td>2020</td>\n",
       "      <td>WY</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.25</td>\n",
       "      <td>258.660</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>5.15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1512 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year State  State.Minimum.Wage  State.Minimum.Wage.2020.Dollars  \\\n",
       "1351  1993    AK                4.75                             8.50   \n",
       "1405  1994    AK                4.75                             8.29   \n",
       "1459  1995    AK                4.75                             8.06   \n",
       "1513  1996    AK                4.75                             7.83   \n",
       "1567  1997    AK                5.25                             8.46   \n",
       "...    ...   ...                 ...                              ...   \n",
       "2645  2016    WY                5.15                             5.55   \n",
       "2699  2017    WY                5.15                             5.43   \n",
       "2753  2018    WY                5.15                             5.30   \n",
       "2807  2019    WY                5.15                             5.21   \n",
       "2861  2020    WY                5.15                             5.15   \n",
       "\n",
       "      Federal.Minimum.Wage  Federal.Minimum.Wage.2020.Dollars  \\\n",
       "1351                  4.25                               7.61   \n",
       "1405                  4.25                               7.42   \n",
       "1459                  4.25                               7.21   \n",
       "1513                  4.25                               7.01   \n",
       "1567                  4.75                               7.66   \n",
       "...                    ...                                ...   \n",
       "2645                  7.25                               7.81   \n",
       "2699                  7.25                               7.65   \n",
       "2753                  7.25                               7.47   \n",
       "2807                  7.25                               7.34   \n",
       "2861                  7.25                               7.25   \n",
       "\n",
       "      Effective.Minimum.Wage  Effective.Minimum.Wage.2020.Dollars  \\\n",
       "1351                    4.75                                 8.50   \n",
       "1405                    4.75                                 8.29   \n",
       "1459                    4.75                                 8.06   \n",
       "1513                    4.75                                 7.83   \n",
       "1567                    5.25                                 8.46   \n",
       "...                      ...                                  ...   \n",
       "2645                    7.25                                 7.81   \n",
       "2699                    7.25                                 7.65   \n",
       "2753                    7.25                                 7.47   \n",
       "2807                    7.25                                 7.34   \n",
       "2861                    7.25                                 7.25   \n",
       "\n",
       "      CPI.Average Department.Of.Labor.Uncleaned.Data  \\\n",
       "1351      144.500                               4.75   \n",
       "1405      148.200                               4.75   \n",
       "1459      152.400                               4.75   \n",
       "1513      156.900                               4.75   \n",
       "1567      160.500                               5.25   \n",
       "...           ...                                ...   \n",
       "2645      240.007                               5.15   \n",
       "2699      245.120                               5.15   \n",
       "2753      251.107                               5.15   \n",
       "2807      255.657                               5.15   \n",
       "2861      258.660                               5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value  \\\n",
       "1351                                   4.75   \n",
       "1405                                   4.75   \n",
       "1459                                   4.75   \n",
       "1513                                   4.75   \n",
       "1567                                   5.25   \n",
       "...                                     ...   \n",
       "2645                                   5.15   \n",
       "2699                                   5.15   \n",
       "2753                                   5.15   \n",
       "2807                                   5.15   \n",
       "2861                                   5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.Low.Value.2020.Dollars  \\\n",
       "1351                                               8.50    \n",
       "1405                                               8.29    \n",
       "1459                                               8.06    \n",
       "1513                                               7.83    \n",
       "1567                                               8.46    \n",
       "...                                                 ...    \n",
       "2645                                               5.55    \n",
       "2699                                               5.43    \n",
       "2753                                               5.30    \n",
       "2807                                               5.21    \n",
       "2861                                               5.15    \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value  \\\n",
       "1351                                    4.75   \n",
       "1405                                    4.75   \n",
       "1459                                    4.75   \n",
       "1513                                    4.75   \n",
       "1567                                    5.25   \n",
       "...                                      ...   \n",
       "2645                                    5.15   \n",
       "2699                                    5.15   \n",
       "2753                                    5.15   \n",
       "2807                                    5.15   \n",
       "2861                                    5.15   \n",
       "\n",
       "      Department.Of.Labor.Cleaned.High.Value.2020.Dollars Footnote  \n",
       "1351                                               8.50        NaN  \n",
       "1405                                               8.29        NaN  \n",
       "1459                                               8.06        NaN  \n",
       "1513                                               7.83        NaN  \n",
       "1567                                               8.46        NaN  \n",
       "...                                                 ...        ...  \n",
       "2645                                               5.55        NaN  \n",
       "2699                                               5.43        NaN  \n",
       "2753                                               5.30        NaN  \n",
       "2807                                               5.21        NaN  \n",
       "2861                                               5.15        NaN  \n",
       "\n",
       "[1512 rows x 15 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_wage_df.sort_values(['State','Year'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0bdae043-8379-448f-bd39-a5cf57e1eef3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}