seed_county.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_data = pd.read_csv(\n",
    "    './assets/CountyData.csv',\n",
    "    error_bad_lines=False)\n",
    "df = pd.DataFrame(csv_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['SurveyYr',\n",
       " 'Year4',\n",
       " 'YearofData',\n",
       " 'ID',\n",
       " 'IDChanged',\n",
       " 'State_Code',\n",
       " 'Type_Code',\n",
       " 'County',\n",
       " 'Name',\n",
       " 'FIPS_Code_State',\n",
       " 'FIPS_County',\n",
       " 'FIPS_Place',\n",
       " 'FYEndDate',\n",
       " 'YearPop',\n",
       " 'SchLevCode',\n",
       " 'Population',\n",
       " 'FunctionCode',\n",
       " 'Enrollment',\n",
       " 'Total_Revenue',\n",
       " 'Total_Rev_Own_Sources',\n",
       " 'General_Revenue',\n",
       " 'Gen_Rev_Own_Sources',\n",
       " 'Total_Taxes',\n",
       " 'Property_Tax',\n",
       " 'Tot_Sales___Gr_Rec_Tax',\n",
       " 'Total_Gen_Sales_Tax',\n",
       " 'Total_Select_Sales_Tax',\n",
       " 'Alcoholic_Beverage_Tax',\n",
       " 'Amusement_Tax',\n",
       " 'Insurance_Premium_Tax',\n",
       " 'Motor_Fuels_Tax',\n",
       " 'Pari_mutuels_Tax',\n",
       " 'Public_Utility_Tax',\n",
       " 'Tobacco_Tax',\n",
       " 'Other_Select_Sales_Tax',\n",
       " 'Total_License_Taxes',\n",
       " 'Alcoholic_Beverage_Lic',\n",
       " 'Amusement_License',\n",
       " 'Corporation_License',\n",
       " 'Hunting___Fishing_License',\n",
       " 'Motor_Vehicle_License',\n",
       " 'Motor_Veh_Oper_License',\n",
       " 'Motor_Vehicle_License_Total',\n",
       " 'Public_Utility_License',\n",
       " 'Occup_and_Bus_Lic_NEC',\n",
       " 'Other_License_Taxes',\n",
       " 'Total_Income_Taxes',\n",
       " 'Individual_Income_Tax',\n",
       " 'Corp_Net_Income_Tax',\n",
       " 'Death_and_Gift_Tax',\n",
       " 'Docum_and_Stock_Tr_Tax',\n",
       " 'Severance_Tax',\n",
       " 'Taxes_NEC',\n",
       " 'Total_IG_Revenue',\n",
       " 'Total_Fed_IG_Revenue',\n",
       " 'Fed_IGR_Air_Transport',\n",
       " 'Fed_IGR_Education',\n",
       " 'Fed_IGR_Emp_Sec_Adm',\n",
       " 'Fed_IGR_Gen_Rev_Shar',\n",
       " 'Fed_IGR_Gen_Support',\n",
       " 'Fed_IGR_Health___Hos',\n",
       " 'Fed_IGR_Highways',\n",
       " 'Fed_IGR_Transit_Sub',\n",
       " 'Fed_IGR_Hous_Com_Dev',\n",
       " 'Fed_IGR_Natural_Res',\n",
       " 'Fed_IGR_Public_Welf',\n",
       " 'Fed_IGR_Sewerage',\n",
       " 'Fed_IGR_Other',\n",
       " 'Total_State_IG_Revenue',\n",
       " 'State_IGR_Education',\n",
       " 'State_IGR_Tax_Relief',\n",
       " 'State_IGR_Oth_Gen_Sup',\n",
       " 'State_IGR_Gen_Sup',\n",
       " 'State_IGR_Health___Hos',\n",
       " 'State_IGR_Highways',\n",
       " 'State_IGR_Transit_Sub',\n",
       " 'State_IGR_Hous_Com_Dev',\n",
       " 'State_IGR_Public_Welf',\n",
       " 'State_IGR_Sewerage',\n",
       " 'State_IGR_Other',\n",
       " 'Tot_Local_IG_Rev',\n",
       " 'Local_IGR_InterSchool_Aid',\n",
       " 'Local_IGR_Other_Education',\n",
       " 'Local_IGR_Oth_Gen_Sup',\n",
       " 'Local_IGR_Health___Hos',\n",
       " 'Local_IGR_Highways',\n",
       " 'Local_IGR_Transit_Sub',\n",
       " 'Local_IGR_Hous_Com_Dev',\n",
       " 'Local_IGR_Public_Welf',\n",
       " 'Local_IGR_Sewerage',\n",
       " 'Local_IGR_Other',\n",
       " 'Tot_Chgs_and_Misc_Rev',\n",
       " 'Total_General_Charges',\n",
       " 'Chg_Air_Transportation',\n",
       " 'Chg_Misc_Com_Activ',\n",
       " 'Chg_Total_Education',\n",
       " 'Chg_Total_Elem_Education',\n",
       " 'Chg_Elem_Ed_Sch_Lunch',\n",
       " 'Chg_Elem_Ed_Tuition',\n",
       " 'Chg_Elem_Ed_NEC',\n",
       " 'Chg_Total_High_Ed',\n",
       " 'Chg_Hospitals',\n",
       " 'Chg_Highways',\n",
       " 'Chg_Regular_Highways',\n",
       " 'Chg_Toll_Highways',\n",
       " 'Chg_Housing___Comm_Dev',\n",
       " 'Chg_Total_Nat_Res',\n",
       " 'Chg_Parking',\n",
       " 'Chg_Parks___Recreation',\n",
       " 'Chg_Sewerage',\n",
       " 'Chg_Solid_Waste_Mgmt',\n",
       " 'Chg_Water_Transport',\n",
       " 'Chg_All_Other_NEC',\n",
       " 'Misc_General_Revenue',\n",
       " 'Special_Assessments',\n",
       " 'Prop_Sale_Total',\n",
       " 'Prop_Sale_Hous_Com_Dev',\n",
       " 'Prop_Sale_Other',\n",
       " 'Interest_Revenue',\n",
       " 'Fines_and_Forfeits',\n",
       " 'Rents_and_Royalties',\n",
       " 'Net_Lottery_Revenue',\n",
       " 'Misc_General_Rev_NEC',\n",
       " 'Liquor_Stores_Revenue',\n",
       " 'Total_Utility_Revenue',\n",
       " 'Water_Utility_Revenue',\n",
       " 'Electric_Utility_Rev',\n",
       " 'Gas_Utility_Rev',\n",
       " 'Transit_Utility_Rev',\n",
       " 'Total_Insur_Trust_Rev',\n",
       " 'Total_Insur_Trust_Ctrb',\n",
       " 'Tot_Ins_Trust_Inv_Rev',\n",
       " 'Total_Emp_Ret_Rev',\n",
       " 'Emp_Ret_Total_Ctrib',\n",
       " 'Emp_Ret_Loc_Emp_Ctrib',\n",
       " 'Emp_Ret_Loc_To_Loc_Sys',\n",
       " 'Emp_Ret_From_Other_Gov',\n",
       " 'Emp_Ret_Sta_To_Sta_Ctr',\n",
       " 'Emp_Ret_Int_Rev',\n",
       " 'Emp_Ret_Other_Earnings',\n",
       " 'Total_Unemp_Rev',\n",
       " 'Unemp_Payroll_Tax',\n",
       " 'Unemp_Int_Revenue',\n",
       " 'Unemp_Federal_Advances',\n",
       " 'Total_Expenditure',\n",
       " 'Total_IG_Expenditure',\n",
       " 'Direct_Expenditure',\n",
       " 'Total_Current_Expend',\n",
       " 'Total_Current_Oper',\n",
       " 'Total_Capital_Outlays',\n",
       " 'Total_Construction',\n",
       " 'Total_Other_Capital_Outlays',\n",
       " 'Tot_Assist___Subsidies',\n",
       " 'Total_Interest_on_Debt',\n",
       " 'Total_Insur_Trust_Ben',\n",
       " 'Total_Salaries___Wages',\n",
       " 'General_Expenditure',\n",
       " 'IG_Exp_To_State_Govt',\n",
       " 'IG_Exp_To_Local_Govts',\n",
       " 'IG_Exp_To_Federal_Govt',\n",
       " 'Direct_General_Expend',\n",
       " 'General_Current_Expend',\n",
       " 'General_Current_Oper',\n",
       " 'General_Capital_Outlay',\n",
       " 'General_Construction',\n",
       " 'General_Capital_Outlay_Other',\n",
       " 'General_Assist___Sub',\n",
       " 'General_Debt_Interest',\n",
       " 'Air_Trans_Total_Expend',\n",
       " 'Air_Trans_Direct_Expend',\n",
       " 'Air_Trans_Cap_Outlay',\n",
       " 'Air_Trans_Current_Exp',\n",
       " 'Air_Trans_Construction',\n",
       " 'Air_Trans_IG_To_State',\n",
       " 'Air_Trans_IG_Local_Govts',\n",
       " 'Misc_Com_Activ_Tot_Exp',\n",
       " 'Misc_Com_Activ_Cap_Out',\n",
       " 'Misc_Com_Activ_Current_Exp',\n",
       " 'Misc_Com_Activ_Constr',\n",
       " 'Correct_Total_Exp',\n",
       " 'Correct_Direct_Exp',\n",
       " 'Correct_Cap_Outlay',\n",
       " 'Correct_Current_Exp',\n",
       " 'Correct_Construct',\n",
       " 'Correct_IG_To_St',\n",
       " 'Correct_IG_Loc_Govts',\n",
       " 'Total_Educ_Total_Exp',\n",
       " 'Total_Educ_Direct_Exp',\n",
       " 'Total_Educ_Assist___Sub',\n",
       " 'Total_Educ_Cap_Outlay',\n",
       " 'Total_Educ_Current_Exp',\n",
       " 'Total_Educ_Construct',\n",
       " 'Elem_Educ_Total_Exp',\n",
       " 'Elem_Educ_Direct_Exp',\n",
       " 'Elem_Educ_Cap_Outlay',\n",
       " 'Elem_Educ_Current_Exp',\n",
       " 'Elem_Educ_Construction',\n",
       " 'Elem_Educ_IG_To_State',\n",
       " 'Elem_Educ_IG_Local_Govts',\n",
       " 'Elem_Educ_IG_Sch_to_Sch',\n",
       " 'Higher_Ed_Total_Exp',\n",
       " 'Higher_Ed_Direct_Exp',\n",
       " 'Higher_Ed_Cap_Outlay',\n",
       " 'Higher_Ed_Current_Exp',\n",
       " 'Higher_Ed_Construct',\n",
       " 'Higher_Ed_IG_To_St',\n",
       " 'Higher_Ed_IG_Loc_Govts',\n",
       " 'Educ_NEC_Total_Expend',\n",
       " 'Educ_NEC_Direct_Expend',\n",
       " 'Educ_NEC_Assistance',\n",
       " 'Educ_NEC_Cap_Outlay',\n",
       " 'Educ_NEC_Current_Exp',\n",
       " 'Educ_NEC_Construction',\n",
       " 'Educ_NEC_IG_To_State',\n",
       " 'Educ_NEC_IG_Local_Govts',\n",
       " 'Emp_Sec_Adm_Direct_Exp',\n",
       " 'Emp_Sec_Adm_Cap_Outlay',\n",
       " 'Emp_Sec_Adm_Current_Exp',\n",
       " 'Emp_Sec_Adm_Construct',\n",
       " 'Fin_Admin_Total_Exp',\n",
       " 'Fin_Admin_Direct_Exp',\n",
       " 'Fin_Admin_Cap_Outlay',\n",
       " 'Fin_Admin_Current_Exp',\n",
       " 'Fin_Admin_Construction',\n",
       " 'Fin_Admin_IG_To_State',\n",
       " 'Fin_Admin_IG_Local_Govts',\n",
       " 'Fire_Prot_Total_Expend',\n",
       " 'Fire_Prot_Direct_Exp',\n",
       " 'Fire_Prot_Cap_Outlay',\n",
       " 'Fire_Prot_Current_Exp',\n",
       " 'Fire_Prot_Construction',\n",
       " 'Fire_Prot_IG_To_State',\n",
       " 'Fire_Prot_IG_Local_Govts',\n",
       " 'Judicial_Total_Expend',\n",
       " 'Judicial_Direct_Expend',\n",
       " 'Judicial_Cap_Outlay',\n",
       " 'Judicial_Current_Exp',\n",
       " 'Judicial_Construction',\n",
       " 'Judicial_IG_To_State',\n",
       " 'Judicial_IG_Local_Govts',\n",
       " 'Cen_Staff_Total_Expend',\n",
       " 'Cen_Staff_Direct_Exp',\n",
       " 'Cen_Staff_Cap_Outlay',\n",
       " 'Cen_Staff_Current_Exp',\n",
       " 'Cen_Staff_Construction',\n",
       " 'Cen_Staff_IG_To_State',\n",
       " 'Cen_Staff_IG_Local_Govts',\n",
       " 'Gen_Pub_Bldg_Total_Exp',\n",
       " 'Gen_Pub_Bldg_Cap_Out',\n",
       " 'Gen_Pub_Bldg_Current_Exp',\n",
       " 'Gen_Pub_Bldg_Construct',\n",
       " 'Health_Total_Expend',\n",
       " 'Health_Direct_Expend',\n",
       " 'Health_Capital_Outlay',\n",
       " 'Health_Current_Exp',\n",
       " 'Health_Construction',\n",
       " 'Health_IG_To_State',\n",
       " 'Health_IG_Local_Govts',\n",
       " 'Total_Hospital_Total_Exp',\n",
       " 'Total_Hospital_Dir_Exp',\n",
       " 'Total_Hospital_Cap_Out',\n",
       " 'Total_Hospital_Current_Exp',\n",
       " 'Total_Hospital_Construct',\n",
       " 'Total_Hospital_IG_To_State',\n",
       " 'Total_Hospital_IG_Loc_Govts',\n",
       " 'Own_Hospital_Total_Exp',\n",
       " 'Own_Hospital_Cap_Out',\n",
       " 'Own_Hospital_Current_Exp',\n",
       " 'Own_Hospital_Construct',\n",
       " 'Hosp_Other_Total_Exp',\n",
       " 'Hosp_Other_Direct_Exp',\n",
       " 'Hosp_Other_Cap_Outlay',\n",
       " 'Hosp_Other_Current_Exp',\n",
       " 'Hosp_Other_Construct',\n",
       " 'Hosp_Other_IG_To_State',\n",
       " 'Hosp_Other_IG_Loc_Govts',\n",
       " 'Total_Highways_Tot_Exp',\n",
       " 'Total_Highways_Dir_Exp',\n",
       " 'Total_Highways_Cap_Out',\n",
       " 'Total_Highways_Current_Exp',\n",
       " 'Total_Highways_Construct',\n",
       " 'Regular_Hwy_Total_Exp',\n",
       " 'Regular_Hwy_Direct_Exp',\n",
       " 'Regular_Hwy_Cap_Outlay',\n",
       " 'Regular_Hwy_Current_Exp',\n",
       " 'Regular_Hwy_Construct',\n",
       " 'Regular_Hwy_IG_To_Sta',\n",
       " 'Regular_Hwy_IG_Loc_Govts',\n",
       " 'Toll_Hwy_Total_Expend',\n",
       " 'Toll_Hwy_Cap_Outlay',\n",
       " 'Toll_Hwy_Current_Exp',\n",
       " 'Toll_Hwy_Construction',\n",
       " 'Transit_Sub_Total_Exp',\n",
       " 'Transit_Sub_Direct_Sub',\n",
       " 'Transit_Sub_IG_To_Sta',\n",
       " 'Transit_Sub_IG_Loc_Govts',\n",
       " 'Transit_Sub_To_Own_Sys',\n",
       " 'Hous___Com_Total_Exp',\n",
       " 'Hous___Com_Direct_Exp',\n",
       " 'Hous___Com_Cap_Outlay',\n",
       " 'Hous___Com_Current_Exp',\n",
       " 'Hous___Com_Construct',\n",
       " 'Hous___Com_IG_To_State',\n",
       " 'Hous___Com_IG_Loc_Govts',\n",
       " 'Libraries_Total_Expend',\n",
       " 'Libraries_Direct_Exp',\n",
       " 'Libraries_Cap_Outlay',\n",
       " 'Libraries_Current_Exp',\n",
       " 'Libraries_Construction',\n",
       " 'Libraries_IG_To_State',\n",
       " 'Libraries_IG_Local_Govts',\n",
       " 'Natural_Res_Total_Exp',\n",
       " 'Natural_Res_Direct_Exp',\n",
       " 'Natural_Res_Cap_Outlay',\n",
       " 'Natural_Res_Current_Exp',\n",
       " 'Natural_Res_Construct',\n",
       " 'Natural_Res_IG_To_Sta',\n",
       " 'Natural_Res_IG_Loc_Govts',\n",
       " 'Parking_Total_Expend',\n",
       " 'Parking_Direct_Expend',\n",
       " 'Parking_Capital_Outlay',\n",
       " 'Parking_Current_Exp',\n",
       " 'Parking_Construction',\n",
       " 'Parking_IG_To_State',\n",
       " 'Parking_IG_Local_Govts',\n",
       " 'Parks___Rec_Total_Exp',\n",
       " 'Parks___Rec_Direct_Exp',\n",
       " 'Parks___Rec_Cap_Outlay',\n",
       " 'Parks___Rec_Current_Exp',\n",
       " 'Parks___Rec_Construct',\n",
       " 'Parks___Rec_IG_To_Sta',\n",
       " 'Parks___Rec_IG_Loc_Govts',\n",
       " 'Police_Prot_Total_Exp',\n",
       " 'Police_Prot_Direct_Exp',\n",
       " 'Police_Prot_Cap_Outlay',\n",
       " 'Police_Prot_Current_Exp',\n",
       " 'Police_Prot_Construct',\n",
       " 'Police_Prot_IG_To_Sta',\n",
       " 'Police_Prot_IG_Loc_Govts',\n",
       " 'Prot_Insp_Total_Exp',\n",
       " 'Prot_Insp_Direct_Exp',\n",
       " 'Prot_Insp_Cap_Outlay',\n",
       " 'Prot_Insp_Current_Exp',\n",
       " 'Prot_Insp_Construction',\n",
       " 'Prot_Insp_IG_To_State',\n",
       " 'Prot_Insp_IG_Local_Govts',\n",
       " 'Public_Welf_Total_Exp',\n",
       " 'Public_Welf_Direct_Exp',\n",
       " 'Public_Welf_Cash_Asst',\n",
       " 'Public_Welf_Cap_Outlay',\n",
       " 'Public_Welf_Current_Exp',\n",
       " 'Public_Welf_Construct',\n",
       " 'Welf_Categ_Total_Exp',\n",
       " 'Welf_Categ_Cash_Assist',\n",
       " 'Welf_Categ_IG_To_State',\n",
       " 'Welf_Categ_IG_Loc_Govts',\n",
       " 'Welf_Cash_Total_Exp',\n",
       " 'Welf_Cash_Cash_Assist',\n",
       " 'Welf_Cash_IG_Local_Govts',\n",
       " 'Welf_Vend_Pmts_Medical',\n",
       " 'Welf_Vend_Pmts_NEC',\n",
       " 'Welf_State_Share_Part_D',\n",
       " 'Welf_Ins_Total_Exp',\n",
       " 'Welf_Ins_Cap_Outlay',\n",
       " 'Welf_Ins_Current_Exp',\n",
       " 'Welf_Ins_Construction',\n",
       " 'Welf_NEC_Total_Expend',\n",
       " 'Welf_NEC_Direct_Expend',\n",
       " 'Welf_NEC_Cap_Outlay',\n",
       " 'Welf_NEC_Current_Exp',\n",
       " 'Welf_NEC_Construction',\n",
       " 'Welf_NEC_IG_To_State',\n",
       " 'Welf_NEC_IG_Local_Govts',\n",
       " 'Sewerage_Total_Expend',\n",
       " 'Sewerage_Direct_Expend',\n",
       " 'Sewerage_Cap_Outlay',\n",
       " 'Sewerage_Current_Exp',\n",
       " 'Sewerage_Construction',\n",
       " 'Sewerage_IG_To_State',\n",
       " 'Sewerage_IG_Local_Govts',\n",
       " 'SW_Mgmt_Total_Expend',\n",
       " 'SW_Mgmt_Direct_Expend',\n",
       " 'SW_Mgmt_Capital_Outlay',\n",
       " 'SW_Mgmt_Current_Exp',\n",
       " 'SW_Mgmt_Construction',\n",
       " 'SW_Mgmt_IG_To_State',\n",
       " 'SW_Mgmt_IG_Local_Govts',\n",
       " 'Water_Trans_Total_Exp',\n",
       " 'Water_Trans_Direct_Exp',\n",
       " 'Water_Trans_Cap_Outlay',\n",
       " 'Water_Trans_Current_Exp',\n",
       " 'Water_Trans_Construct',\n",
       " 'Water_Trans_IG_To_Sta',\n",
       " 'Water_Trans_IG_Loc_Govts',\n",
       " 'Interest_on_Gen_Debt',\n",
       " 'General_NEC_Total_Exp',\n",
       " 'General_NEC_Direct_Exp',\n",
       " 'VetBonus',\n",
       " 'General_NEC_Cap_Outlay',\n",
       " 'General_NEC_Current_Exp',\n",
       " 'General_NEC_Construct',\n",
       " 'General_NEC_IG_To_St',\n",
       " 'General_NEC_IG_Loc_Govts',\n",
       " 'General_NEC_IG_To_Fed',\n",
       " 'Liquor_Stores_Tot_Exp',\n",
       " 'Liquor_Stores_Cap_Out',\n",
       " 'Liquor_Stores_Current_Exp',\n",
       " 'Liquor_Stores_Constr',\n",
       " 'Total_Util_Total_Exp',\n",
       " 'Total_Util_Inter_Exp',\n",
       " 'Total_Util_Cap_Outlay',\n",
       " 'Total_Util_Current_Exp',\n",
       " 'Total_Util_Construct',\n",
       " 'Water_Util_Total_Exp',\n",
       " 'Water_Util_Inter_Exp',\n",
       " 'Water_Util_Cap_Outlay',\n",
       " 'Water_Util_Current_Exp',\n",
       " 'Water_Util_Construct',\n",
       " 'Elec_Util_Total_Exp',\n",
       " 'Elec_Util_Inter_Exp',\n",
       " 'Elec_Util_Cap_Outlay',\n",
       " 'Elec_Util_Current_Exp',\n",
       " 'Elec_Util_Construct',\n",
       " 'Gas_Util_Total_Exp',\n",
       " 'Gas_Util_Inter_Exp',\n",
       " 'Gas_Util_Cap_Outlay',\n",
       " 'Gas_Util_Current_Exp',\n",
       " 'Gas_Util_Construct',\n",
       " 'Trans_Util_Total_Exp',\n",
       " 'Trans_Util_Inter_Exp',\n",
       " 'Trans_Util_Cap_Outlay',\n",
       " 'Trans_Util_Current_Exp',\n",
       " 'Trans_Util_Construct',\n",
       " 'Emp_Ret_Total_Expend',\n",
       " 'Emp_Ret_Benefit_Paymts',\n",
       " 'Emp_Ret_Withdrawals',\n",
       " 'Emp_Ret_Other_Paymts',\n",
       " 'Unemp_Comp_Total_Exp',\n",
       " 'Unemp_Comp_Ben_Paymts',\n",
       " 'Unemp_Ext___Spec_Pmts',\n",
       " 'Total_Debt_Outstanding',\n",
       " 'Total_Long_Term_Debt_Out',\n",
       " 'ST_Debt_End_of_Year',\n",
       " 'Total_Beg_LTD_Out',\n",
       " 'Beg_LTD_Out_Private_Purp',\n",
       " 'Beg_LTD_Out_All_Other',\n",
       " 'Beg_LTD_Out_Utility',\n",
       " 'Beg_LTD_Out_Water_Util',\n",
       " 'Beg_LTD_Out_Elec_Util',\n",
       " 'Beg_LTD_Out_Gas_Util',\n",
       " 'Beg_LTD_Out_Trans_Util',\n",
       " 'Beg_LTD_Out_General',\n",
       " 'Beg_LTD_Out_Education',\n",
       " 'Beg_LTD_Out_Priv_Purp',\n",
       " 'Beg_LTD_Out_Other_NEC',\n",
       " 'Total_LTD_Issued',\n",
       " 'LTD_Iss_Private_Purp',\n",
       " 'LTD_Iss_All_Other',\n",
       " 'LTD_Iss_Utility',\n",
       " 'LTD_Iss_Util_Water',\n",
       " 'LTD_Iss_Util_Electric',\n",
       " 'LTD_Iss_Util_Gas_Supply',\n",
       " 'LTD_Iss_Util_Transit',\n",
       " 'LTD_Iss_General',\n",
       " 'LTD_Iss_Gen_Elem_Educ',\n",
       " 'LTD_Iss_Gen_Other_Educ',\n",
       " 'LTD_Iss_Gen_Other_NEC',\n",
       " 'Total_LTD_Iss_FFC',\n",
       " 'LTD_Iss_FFC_Utility',\n",
       " 'LTD_Iss_FFC_Water_Util',\n",
       " 'LTD_Iss_FFC_Elec_Util',\n",
       " 'LTD_Iss_FFC_Gas_Util',\n",
       " 'LTD_Iss_FFC_Trans_Util',\n",
       " 'LTD_Iss_FFC_General',\n",
       " 'LTD_Iss_FFC_Elem_Educ',\n",
       " 'LTD_Iss_FFC_Other_Educ',\n",
       " 'LTD_Iss_FFC_Other_NEC',\n",
       " 'Total_LTD_Iss_NG',\n",
       " 'LTD_Iss_NG_Utility',\n",
       " 'LTD_Iss_NG_Water_Util',\n",
       " 'LTD_Iss_NG_Elec_Util',\n",
       " 'LTD_Iss_NG_Gas_Util',\n",
       " 'LTD_Iss_NG_Trans_Util',\n",
       " 'LTD_Iss_NG_General',\n",
       " 'LTD_Iss_NG_Elem_Educ',\n",
       " 'LTD_Iss_NG_Other_Educ',\n",
       " 'LTD_Iss_NG_Private_Purp',\n",
       " 'LTD_Iss_NG_Other_NEC',\n",
       " 'Total_LTD_Iss_Unsp',\n",
       " 'LTD_Iss_Unsp_Utility',\n",
       " 'LTD_Iss_Unsp_Water_Util',\n",
       " 'LTD_Iss_Unsp_Elec_Util',\n",
       " 'LTD_Iss_Unsp_Gas_Util',\n",
       " 'LTD_Iss_Unsp_Trans_Util',\n",
       " 'LTD_Iss_Unsp_General',\n",
       " 'LTD_Iss_Unsp_Elem_Educ',\n",
       " 'LTD_Iss_Unsp_Other_Educ',\n",
       " 'LTD_Iss_Unsp_Other_NEC',\n",
       " 'Total_LTD_Retired',\n",
       " 'LTD_Ret_Private_Purp',\n",
       " 'LTD_Ret_All_Other',\n",
       " 'LTD_Ret_Utility',\n",
       " 'LTD_Ret_Util_Water',\n",
       " 'LTD_Ret_Util_Electric',\n",
       " 'LTD_Ret_Util_Gas_Supply',\n",
       " 'LTD_Ret_Util_Transit',\n",
       " 'LTD_Ret_General',\n",
       " 'LTD_Ret_Gen_Elem_Educ',\n",
       " 'LTD_Ret_Gen_Other_Educ',\n",
       " 'LTD_Ret_Gen_Other_NEC',\n",
       " 'Total_LTD_Ret_FFC',\n",
       " 'LTD_Ret_FFC_Utility',\n",
       " 'LTD_Ret_FFC_Water_Util',\n",
       " 'LTD_Ret_FFC_Elec_Util',\n",
       " 'LTD_Ret_FFC_Gas_Util',\n",
       " 'LTD_Ret_FFC_Trans_Util',\n",
       " 'LTD_Ret_FFC_General',\n",
       " 'LTD_Ret_FFC_Elem_Educ',\n",
       " 'LTD_Ret_FFC_Other_Educ',\n",
       " 'LTD_Ret_FFC_Other_NEC',\n",
       " 'Total_LTD_Ret_NG',\n",
       " 'LTD_Ret_NG_Utility',\n",
       " 'LTD_Ret_NG_Water_Util',\n",
       " 'LTD_Ret_NG_Elec_Util',\n",
       " 'LTD_Ret_NG_Gas_Util',\n",
       " 'LTD_Ret_NG_Trans_Util',\n",
       " 'LTD_Ret_NG_General',\n",
       " 'LTD_Ret_NG_Elem_Educ',\n",
       " 'LTD_Ret_NG_Other_Educ',\n",
       " 'LTD_Ret_NG_Private_Purp',\n",
       " 'LTD_Ret_NG_Other_NEC',\n",
       " 'Total_LTD_Ret_Unsp',\n",
       " 'LTD_Ret_Unsp_Utility',\n",
       " 'LTD_Ret_Unsp_Water_Util',\n",
       " 'LTD_Ret_Unsp_Elec_Utili',\n",
       " 'LTD_Ret_Unsp_Gas_Util',\n",
       " 'LTD_Ret_Unsp_Trans_Util',\n",
       " 'LTD_Ret_Unsp_General',\n",
       " 'LTD_Ret_Unsp_Elem_Educ',\n",
       " 'LTD_Ret_Unsp_Other_Educ',\n",
       " 'LTD_Ret_Unsp_Other_NEC',\n",
       " 'Total_LTD_Out',\n",
       " 'LTD_Out_Private_Purp',\n",
       " 'LTD_Out_All_Other',\n",
       " 'Total_LTD_Out_Utility',\n",
       " 'LTD_Out_Util_Water',\n",
       " 'LTD_Out_Util_Electric',\n",
       " 'LTD_Out_Util_Gas_Supply',\n",
       " 'LTD_Out_Util_Transit',\n",
       " 'LTD_Out_General',\n",
       " 'LTD_Out_Gen_Elem_Educ',\n",
       " 'LTD_Out_Gen_Other_Educ',\n",
       " 'LTD_Out_Gen_Other_NEC',\n",
       " 'Total_LTD_Out_FFC',\n",
       " 'LTD_Out_FFC_Utility',\n",
       " 'LTD_Out_FFC_Water_Util',\n",
       " 'LTD_Out_FFC_Elec_Util',\n",
       " 'LTD_Out_FFC_Gas_Util',\n",
       " 'LTD_Out_FFC_Trans_Util',\n",
       " 'LTD_Out_FFC_General',\n",
       " 'LTD_Out_FFC_Elem_Educ',\n",
       " 'LTD_Out_FFC_Other_Educ',\n",
       " 'LTD_Out_FFC_Other_NEC',\n",
       " 'Tot_LTD_Out_NG',\n",
       " 'LTD_Out_NG_Utility',\n",
       " 'LTD_Out_NG_Water_Util',\n",
       " 'LTD_Out_NG_Elec_Util',\n",
       " 'LTD_Out_NG_Gas_Util',\n",
       " 'LTD_Out_NG_Trans_Util',\n",
       " 'LTD_Out_NG_General',\n",
       " 'LTD_Out_NG_Elem_Educ',\n",
       " 'LTD_Out_NG_Other_Educ',\n",
       " 'LTD_Out_NG_Private_Purp',\n",
       " 'LTD_Out_NG_Other_NEC',\n",
       " 'Total_Cash___Securities',\n",
       " 'Insur_Trust_Cash___Sec',\n",
       " 'Emp_Retire_Cash___Sec',\n",
       " 'Emp_Retire_Cash___Dep',\n",
       " 'Emp_Retire_Total_Sec',\n",
       " 'Emp_Retire_Sec_Tot_Fed',\n",
       " 'Emp_Retire_Sec_S_L_Secur',\n",
       " 'Emp_Retire_Sec_Tot_Nong',\n",
       " 'Emp_Retire_Sec_Corp_Bds',\n",
       " 'Emp_Retire_Sec_Corp_Stk',\n",
       " 'Emp_Retire_Sec_Mortgages',\n",
       " 'Emp_Retire_Sec_Misc_Inv',\n",
       " 'Emp_Retire_Sec_Oth_Nong',\n",
       " 'Unemp_Comp_Cash___Sec',\n",
       " 'Unemp_Comp_Bal_In_US_Trs',\n",
       " 'Unemp_Comp_Other_Balance',\n",
       " 'Nonin_Trust_Cash___Sec',\n",
       " 'Sinking_Fd_Cash___Sec',\n",
       " 'Bond_Fd_Cash___Sec',\n",
       " 'Oth_Nonin_Fd_Cash___Sec']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(104151, 595)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "length = len(df)\n",
    "num_unknowns = 0\n",
    "for i in range(length):\n",
    "    try:\n",
    "        df.at[i, 'FIPS_County_Unique'] = '{}-{}'.format(int(df.iloc[i]['FIPS_Code_State']), int(df.iloc[i]['FIPS_County']))\n",
    "    except ValueError:\n",
    "        num_unknowns += 1\n",
    "        df.at[i, 'FIPS_County_Unique'] = 'unknown'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num_unknowns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3031"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df[(df['Year4']==2012)]['FIPS_County_Unique'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('./assets/CountyData_modified.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}