# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: vrb-know
#     language: python
#     name: vrb-know
# ---

# +
# Data Source
# https://www.kaggle.com/lislejoem/us-minimum-wage-by-state-from-1968-to-2017?select=Minimum+Wage+Data.csv
# -

import pandas as pd

# +
data_path = 'Minimum Wage Data.csv'

min_wage = pd.read_csv(data_path, encoding="ISO-8859-1")

print(min_wage.shape)
min_wage.head()
# -

min_wage_2020 = min_wage[min_wage['Year'] == 2020]

min_wage_2020.sort_values(by=['State.Minimum.Wage'], ascending=False).head()

list(min_wage_2020['State.Minimum.Wage.2020.Dollars']) == list(min_wage_2020['State.Minimum.Wage'])

min_wage_2020 = min_wage_2020.drop(['Year', 
                    'State.Minimum.Wage.2020.Dollars', 
                    'Federal.Minimum.Wage.2020.Dollars', 
                    'Effective.Minimum.Wage.2020.Dollars'], axis=1)

min_wage_2020 = min_wage_2020[['State',
                               'State.Minimum.Wage', 
                               'Federal.Minimum.Wage', 
                               'Effective.Minimum.Wage',
                               'CPI.Average'
                              ]]

min_wage_2020.head()

min_wage_2020.to_csv('cols_infra_min_wage.csv')



StarcoderdataJupyterScriptsDedupFiltered