Skip to content

Instantly share code, notes, and snippets.

@davidrichards

davidrichards/Data+Prep.ipynb

Created October 13, 2016 03:53
Show Gist options
  • Save davidrichards/fad30bb98f61c33db2b6719bf35af940 to your computer and use it in GitHub Desktop.
Save davidrichards/fad30bb98f61c33db2b6719bf35af940 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Data+Prep.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"%matplotlib inline\n",
"\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"from scipy import stats\n",
"\n",
"from sklearn.linear_model import BayesianRidge, LinearRegression\n",
"from sklearn import preprocessing\n",
"label_encoder = preprocessing.LabelEncoder()\n",
"\n",
"from IPython.core.pylabtools import figsize\n",
"import pandas as pd\n",
"from matplotlib import pyplot as plt\n",
"plt.style.use('ggplot')\n",
"figsize(11,9)\n",
"\n",
"import scipy.stats as stats"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## County Data\n",
"\n",
"The county data was gathered from:\n",
"\n",
"* Utah Regions: Utah Workforce Services\n",
"* County Population: US Census, 2010\n",
"* Income by County: Utah Workforce Services\n",
"\n",
"Here is the basic data, as it's presented."
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>county</th>\n",
" <th>income</th>\n",
" <th>region</th>\n",
" <th>population</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Weber County</td>\n",
" <td>34938</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>231236</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Wayne County</td>\n",
" <td>30208</td>\n",
" <td>Central Utah</td>\n",
" <td>2589</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Washington County</td>\n",
" <td>29659</td>\n",
" <td>Southwest</td>\n",
" <td>138115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Wasatch County</td>\n",
" <td>38624</td>\n",
" <td>Mountainland</td>\n",
" <td>23530</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Utah County</td>\n",
" <td>32274</td>\n",
" <td>Mountainland</td>\n",
" <td>516564</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Uintah County</td>\n",
" <td>34629</td>\n",
" <td>Uintah Basin</td>\n",
" <td>32588</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Tooele County</td>\n",
" <td>31398</td>\n",
" <td>Wasatch Front South</td>\n",
" <td>58218</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Summit County</td>\n",
" <td>96766</td>\n",
" <td>Mountainland</td>\n",
" <td>36324</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Sevier County</td>\n",
" <td>29793</td>\n",
" <td>Central Utah</td>\n",
" <td>20802</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Sanpete County</td>\n",
" <td>25458</td>\n",
" <td>Central Utah</td>\n",
" <td>27882</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>San Juan County</td>\n",
" <td>23244</td>\n",
" <td>Southeast</td>\n",
" <td>14746</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Salt Lake County</td>\n",
" <td>42535</td>\n",
" <td>Wasatch Front South</td>\n",
" <td>1029665</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Rich County</td>\n",
" <td>39190</td>\n",
" <td>Bear River</td>\n",
" <td>2264</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Piute County</td>\n",
" <td>25456</td>\n",
" <td>Central Utah</td>\n",
" <td>1556</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Morgan County</td>\n",
" <td>43111</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>9469</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Millard County</td>\n",
" <td>32608</td>\n",
" <td>Central Utah</td>\n",
" <td>12503</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Kane County</td>\n",
" <td>34943</td>\n",
" <td>Southwest</td>\n",
" <td>7125</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Juab County</td>\n",
" <td>29871</td>\n",
" <td>Mountainland</td>\n",
" <td>10246</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Iron County</td>\n",
" <td>26774</td>\n",
" <td>Southwest</td>\n",
" <td>46163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Grand County</td>\n",
" <td>40844</td>\n",
" <td>Southeast</td>\n",
" <td>9225</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Garfield County</td>\n",
" <td>32829</td>\n",
" <td>Southwest</td>\n",
" <td>5172</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Emery County</td>\n",
" <td>30676</td>\n",
" <td>Castle Country</td>\n",
" <td>10976</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Duchesne County</td>\n",
" <td>39574</td>\n",
" <td>Uintah Basin</td>\n",
" <td>18607</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Davis County</td>\n",
" <td>38770</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>306479</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Daggett County</td>\n",
" <td>50523</td>\n",
" <td>Uintah Basin</td>\n",
" <td>1059</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Carbon County</td>\n",
" <td>33837</td>\n",
" <td>Castle Country</td>\n",
" <td>21403</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Cache County</td>\n",
" <td>30428</td>\n",
" <td>Bear River</td>\n",
" <td>112656</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Box Elder County</td>\n",
" <td>32208</td>\n",
" <td>Bear River</td>\n",
" <td>49975</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Beaver County</td>\n",
" <td>36622</td>\n",
" <td>Southwest</td>\n",
" <td>6629</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" county income region population\n",
"0 Weber County 34938 Wasatch Front North 231236\n",
"1 Wayne County 30208 Central Utah 2589\n",
"2 Washington County 29659 Southwest 138115\n",
"3 Wasatch County 38624 Mountainland 23530\n",
"4 Utah County 32274 Mountainland 516564\n",
"5 Uintah County 34629 Uintah Basin 32588\n",
"6 Tooele County 31398 Wasatch Front South 58218\n",
"7 Summit County 96766 Mountainland 36324\n",
"8 Sevier County 29793 Central Utah 20802\n",
"9 Sanpete County 25458 Central Utah 27882\n",
"10 San Juan County 23244 Southeast 14746\n",
"11 Salt Lake County 42535 Wasatch Front South 1029665\n",
"12 Rich County 39190 Bear River 2264\n",
"13 Piute County 25456 Central Utah 1556\n",
"14 Morgan County 43111 Wasatch Front North 9469\n",
"15 Millard County 32608 Central Utah 12503\n",
"16 Kane County 34943 Southwest 7125\n",
"17 Juab County 29871 Mountainland 10246\n",
"18 Iron County 26774 Southwest 46163\n",
"19 Grand County 40844 Southeast 9225\n",
"20 Garfield County 32829 Southwest 5172\n",
"21 Emery County 30676 Castle Country 10976\n",
"22 Duchesne County 39574 Uintah Basin 18607\n",
"23 Davis County 38770 Wasatch Front North 306479\n",
"24 Daggett County 50523 Uintah Basin 1059\n",
"25 Carbon County 33837 Castle Country 21403\n",
"26 Cache County 30428 Bear River 112656\n",
"27 Box Elder County 32208 Bear River 49975\n",
"28 Beaver County 36622 Southwest 6629"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"filename = 'data/counties.csv'\n",
"df = pd.read_csv(filename)\n",
"df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Our next challenge is to combine the mean/median (I'm not sure which I have) across counties in each region. We'll group by the region and produce the \"regional population portion.\" In other words, if there were two counties with population 60 and 40, then their regional population portion would be .6 and .4."
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>county</th>\n",
" <th>income</th>\n",
" <th>region</th>\n",
" <th>population</th>\n",
" <th>regional_population_portion</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Weber County</td>\n",
" <td>34938</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>231236</td>\n",
" <td>0.422593</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Wayne County</td>\n",
" <td>30208</td>\n",
" <td>Central Utah</td>\n",
" <td>2589</td>\n",
" <td>0.039628</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Washington County</td>\n",
" <td>29659</td>\n",
" <td>Southwest</td>\n",
" <td>138115</td>\n",
" <td>0.679686</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Wasatch County</td>\n",
" <td>38624</td>\n",
" <td>Mountainland</td>\n",
" <td>23530</td>\n",
" <td>0.040108</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Utah County</td>\n",
" <td>32274</td>\n",
" <td>Mountainland</td>\n",
" <td>516564</td>\n",
" <td>0.880511</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Uintah County</td>\n",
" <td>34629</td>\n",
" <td>Uintah Basin</td>\n",
" <td>32588</td>\n",
" <td>0.623646</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Tooele County</td>\n",
" <td>31398</td>\n",
" <td>Wasatch Front South</td>\n",
" <td>58218</td>\n",
" <td>0.053515</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Summit County</td>\n",
" <td>96766</td>\n",
" <td>Mountainland</td>\n",
" <td>36324</td>\n",
" <td>0.061916</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Sevier County</td>\n",
" <td>29793</td>\n",
" <td>Central Utah</td>\n",
" <td>20802</td>\n",
" <td>0.318404</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Sanpete County</td>\n",
" <td>25458</td>\n",
" <td>Central Utah</td>\n",
" <td>27882</td>\n",
" <td>0.426774</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>San Juan County</td>\n",
" <td>23244</td>\n",
" <td>Southeast</td>\n",
" <td>14746</td>\n",
" <td>0.615160</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Salt Lake County</td>\n",
" <td>42535</td>\n",
" <td>Wasatch Front South</td>\n",
" <td>1029665</td>\n",
" <td>0.946485</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Rich County</td>\n",
" <td>39190</td>\n",
" <td>Bear River</td>\n",
" <td>2264</td>\n",
" <td>0.013730</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Piute County</td>\n",
" <td>25456</td>\n",
" <td>Central Utah</td>\n",
" <td>1556</td>\n",
" <td>0.023817</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Morgan County</td>\n",
" <td>43111</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>9469</td>\n",
" <td>0.017305</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Millard County</td>\n",
" <td>32608</td>\n",
" <td>Central Utah</td>\n",
" <td>12503</td>\n",
" <td>0.191376</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Kane County</td>\n",
" <td>34943</td>\n",
" <td>Southwest</td>\n",
" <td>7125</td>\n",
" <td>0.035063</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Juab County</td>\n",
" <td>29871</td>\n",
" <td>Mountainland</td>\n",
" <td>10246</td>\n",
" <td>0.017465</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Iron County</td>\n",
" <td>26774</td>\n",
" <td>Southwest</td>\n",
" <td>46163</td>\n",
" <td>0.227176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Grand County</td>\n",
" <td>40844</td>\n",
" <td>Southeast</td>\n",
" <td>9225</td>\n",
" <td>0.384840</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Garfield County</td>\n",
" <td>32829</td>\n",
" <td>Southwest</td>\n",
" <td>5172</td>\n",
" <td>0.025452</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Emery County</td>\n",
" <td>30676</td>\n",
" <td>Castle Country</td>\n",
" <td>10976</td>\n",
" <td>0.338985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Duchesne County</td>\n",
" <td>39574</td>\n",
" <td>Uintah Basin</td>\n",
" <td>18607</td>\n",
" <td>0.356088</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Davis County</td>\n",
" <td>38770</td>\n",
" <td>Wasatch Front North</td>\n",
" <td>306479</td>\n",
" <td>0.560102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Daggett County</td>\n",
" <td>50523</td>\n",
" <td>Uintah Basin</td>\n",
" <td>1059</td>\n",
" <td>0.020266</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Carbon County</td>\n",
" <td>33837</td>\n",
" <td>Castle Country</td>\n",
" <td>21403</td>\n",
" <td>0.661015</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Cache County</td>\n",
" <td>30428</td>\n",
" <td>Bear River</td>\n",
" <td>112656</td>\n",
" <td>0.683198</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Box Elder County</td>\n",
" <td>32208</td>\n",
" <td>Bear River</td>\n",
" <td>49975</td>\n",
" <td>0.303072</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Beaver County</td>\n",
" <td>36622</td>\n",
" <td>Southwest</td>\n",
" <td>6629</td>\n",
" <td>0.032622</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" county income region population \\\n",
"0 Weber County 34938 Wasatch Front North 231236 \n",
"1 Wayne County 30208 Central Utah 2589 \n",
"2 Washington County 29659 Southwest 138115 \n",
"3 Wasatch County 38624 Mountainland 23530 \n",
"4 Utah County 32274 Mountainland 516564 \n",
"5 Uintah County 34629 Uintah Basin 32588 \n",
"6 Tooele County 31398 Wasatch Front South 58218 \n",
"7 Summit County 96766 Mountainland 36324 \n",
"8 Sevier County 29793 Central Utah 20802 \n",
"9 Sanpete County 25458 Central Utah 27882 \n",
"10 San Juan County 23244 Southeast 14746 \n",
"11 Salt Lake County 42535 Wasatch Front South 1029665 \n",
"12 Rich County 39190 Bear River 2264 \n",
"13 Piute County 25456 Central Utah 1556 \n",
"14 Morgan County 43111 Wasatch Front North 9469 \n",
"15 Millard County 32608 Central Utah 12503 \n",
"16 Kane County 34943 Southwest 7125 \n",
"17 Juab County 29871 Mountainland 10246 \n",
"18 Iron County 26774 Southwest 46163 \n",
"19 Grand County 40844 Southeast 9225 \n",
"20 Garfield County 32829 Southwest 5172 \n",
"21 Emery County 30676 Castle Country 10976 \n",
"22 Duchesne County 39574 Uintah Basin 18607 \n",
"23 Davis County 38770 Wasatch Front North 306479 \n",
"24 Daggett County 50523 Uintah Basin 1059 \n",
"25 Carbon County 33837 Castle Country 21403 \n",
"26 Cache County 30428 Bear River 112656 \n",
"27 Box Elder County 32208 Bear River 49975 \n",
"28 Beaver County 36622 Southwest 6629 \n",
"\n",
" regional_population_portion \n",
"0 0.422593 \n",
"1 0.039628 \n",
"2 0.679686 \n",
"3 0.040108 \n",
"4 0.880511 \n",
"5 0.623646 \n",
"6 0.053515 \n",
"7 0.061916 \n",
"8 0.318404 \n",
"9 0.426774 \n",
"10 0.615160 \n",
"11 0.946485 \n",
"12 0.013730 \n",
"13 0.023817 \n",
"14 0.017305 \n",
"15 0.191376 \n",
"16 0.035063 \n",
"17 0.017465 \n",
"18 0.227176 \n",
"19 0.384840 \n",
"20 0.025452 \n",
"21 0.338985 \n",
"22 0.356088 \n",
"23 0.560102 \n",
"24 0.020266 \n",
"25 0.661015 \n",
"26 0.683198 \n",
"27 0.303072 \n",
"28 0.032622 "
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"regional_group = df.groupby(\"region\")\n",
"regional_population = regional_group.population.sum()\n",
"df[\"regional_population_portion\"] = df.apply(lambda row: float(row.population) / regional_population[row.region], axis=1)\n",
"df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"If I were more clever, I might be able to do this in a single run. I didn't, so I re-group, calculate the weighted average of the income in the region by population (regional income). I also create the regional weight, which is just the normalized value of the regional income over the maximum income in the state.\n",
"\n",
"I then concatenate this as my final result. I'm not very happy with the way the index is shown. I may have this setup wrong."
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>income</th>\n",
" <th>weight</th>\n",
" </tr>\n",
" <tr>\n",
" <th>region</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Bear River</th>\n",
" <td>31087.769356</td>\n",
" <td>0.741262</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Castle Country</th>\n",
" <td>32765.467958</td>\n",
" <td>0.781265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Central Utah</th>\n",
" <td>28394.811333</td>\n",
" <td>0.677050</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mountainland</th>\n",
" <td>36479.817589</td>\n",
" <td>0.869830</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Southeast</th>\n",
" <td>30017.184264</td>\n",
" <td>0.715734</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Southwest</th>\n",
" <td>29496.706010</td>\n",
" <td>0.703324</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Uintah Basin</th>\n",
" <td>36711.967065</td>\n",
" <td>0.875366</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wasatch Front North</th>\n",
" <td>37225.745374</td>\n",
" <td>0.887616</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wasatch Front South</th>\n",
" <td>41939.004046</td>\n",
" <td>1.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" income weight\n",
"region \n",
"Bear River 31087.769356 0.741262\n",
"Castle Country 32765.467958 0.781265\n",
"Central Utah 28394.811333 0.677050\n",
"Mountainland 36479.817589 0.869830\n",
"Southeast 30017.184264 0.715734\n",
"Southwest 29496.706010 0.703324\n",
"Uintah Basin 36711.967065 0.875366\n",
"Wasatch Front North 37225.745374 0.887616\n",
"Wasatch Front South 41939.004046 1.000000"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"regional_group = df.groupby(\"region\") # Again, humph\n",
"regional_income = regional_group.apply(lambda row: sum(row.income * row.regional_population_portion))\n",
"regional_income.name = \"income\"\n",
"max_income = regional_income.max()\n",
"regional_weight = regional_income.apply(lambda x: x / max_income)\n",
"regional_weight.name = \"weight\"\n",
"result = pd.concat([regional_income, regional_weight], axis=1)\n",
"result"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Context\n",
"\n",
"**The nice thing about these weights is they get weighted too. Meaning, it's not like a `$100,000` job in Salt Lake is estimated at `$87,5366` in Duchesne. It's combined with job title, years of experiences, career track, and more things later when we get the chance.**"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"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.10"
}
},
"nbformat": 4,
"nbformat_minor": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment