Skip to content

Instantly share code, notes, and snippets.

@mattspence

mattspence/2013 Computer Occupations by MSA.ipynb

Created August 20, 2015 14:10
Show Gist options
  • Save mattspence/3ac0b996800210813cbf to your computer and use it in GitHub Desktop.
Save mattspence/3ac0b996800210813cbf to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
2013 Computer Occupations by MSA.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import pandas"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data=pandas.read_csv(\"../data/ACS_13_5YR_C24010_MSA.csv\")\n",
"data=data.rename(columns={\"GEO.display-label\":\"MSA\",\n",
" \"HD01_VD01\":\"Total_People\",\n",
" \"HD01_VD02\":\"Total_Male\",\n",
" \"HD01_VD38\":\"Total_Female\",\n",
" \"HD01_VD07\":\"Male_Computer-Engineering-Science_Occupations\",\n",
" \"HD01_VD43\":\"Female_Computer-Engineering-Science_Occupations\",\n",
" \"HD01_VD08\":\"Male_Computer-Math_Occupations\",\n",
" \"HD01_VD44\":\"Female_Computer-Math_Occupations\", \n",
" \"HD01_VD09\":\"Male_Architect-Engineer_Occupations\",\n",
" \"HD01_VD45\":\"Female_Architect-Engineer_Occupations\",\n",
" \"HD01_VD10\":\"Male_Science_Occupations\",\n",
" \"HD01_VD46\":\"Female_Science_Occupations\",\n",
" })\n",
"data[\"Total_Computer-Engineering-Science_Occupations\"]=data[\"Male_Computer-Engineering-Science_Occupations\"]+data[\"Female_Computer-Engineering-Science_Occupations\"]\n",
"data[\"Total_Computer-Math_Occupations\"]=data[\"Male_Computer-Math_Occupations\"]+data[\"Female_Computer-Math_Occupations\"]\n",
"data[\"Total_Architect-Engineer_Occupations\"]=data[\"Male_Architect-Engineer_Occupations\"]+data[\"Female_Architect-Engineer_Occupations\"]\n",
"data[\"Total_Science_Occupations\"]=data[\"Male_Science_Occupations\"]+data[\"Female_Science_Occupations\"]\n",
"\n",
"data[\"Total_Computer-Engineering_Occupations\"]=data[\"Total_Computer-Math_Occupations\"]+data[\"Total_Architect-Engineer_Occupations\"]\n",
"\n",
"data[\"PerCapita_Computer-Engineering-Science_Occupations\"]=100.*data[\"Total_Computer-Engineering-Science_Occupations\"]/data[\"Total_People\"]\n",
"data[\"PerCapita_Computer-Math_Occupations\"]=100.*data[\"Total_Computer-Math_Occupations\"]/data[\"Total_People\"]\n",
"data[\"PerCapita_Architect-Engineer_Occupations\"]=100.*data[\"Total_Architect-Engineer_Occupations\"]/data[\"Total_People\"]\n",
"data[\"PerCapita_Science_Occupations\"]=100.*data[\"Total_Science_Occupations\"]/data[\"Total_People\"]\n",
"\n",
"data[\"PerCapita_Computer-Engineering_Occupations\"]=100.*data[\"Total_Computer-Engineering_Occupations\"]/data[\"Total_People\"]"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false,
"scrolled": 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>MSA</th>\n",
" <th>Total_Computer-Engineering-Science_Occupations</th>\n",
" <th>Total_People</th>\n",
" <th>PerCapita_Computer-Engineering-Science_Occupations</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>New York-Newark-Jersey City, NY-NJ-PA Metro Area</td>\n",
" <td>463348</td>\n",
" <td>9264128</td>\n",
" <td>5.001528</td>\n",
" </tr>\n",
" <tr>\n",
" <th>362</th>\n",
" <td>Washington-Arlington-Alexandria, DC-VA-MD-WV M...</td>\n",
" <td>338344</td>\n",
" <td>3037310</td>\n",
" <td>11.139594</td>\n",
" </tr>\n",
" <tr>\n",
" <th>209</th>\n",
" <td>Los Angeles-Long Beach-Anaheim, CA Metro Area</td>\n",
" <td>293215</td>\n",
" <td>5943925</td>\n",
" <td>4.933020</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>Chicago-Naperville-Elgin, IL-IN-WI Metro Area</td>\n",
" <td>233859</td>\n",
" <td>4463443</td>\n",
" <td>5.239431</td>\n",
" </tr>\n",
" <tr>\n",
" <th>309</th>\n",
" <td>San Francisco-Oakland-Hayward, CA Metro Area</td>\n",
" <td>209476</td>\n",
" <td>2176766</td>\n",
" <td>9.623267</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Boston-Cambridge-Newton, MA-NH Metro Area</td>\n",
" <td>204841</td>\n",
" <td>2377006</td>\n",
" <td>8.617606</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>Dallas-Fort Worth-Arlington, TX Metro Area</td>\n",
" <td>194611</td>\n",
" <td>3167340</td>\n",
" <td>6.144304</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158</th>\n",
" <td>Houston-The Woodlands-Sugar Land, TX Metro Area</td>\n",
" <td>184243</td>\n",
" <td>2839405</td>\n",
" <td>6.488789</td>\n",
" </tr>\n",
" <tr>\n",
" <th>268</th>\n",
" <td>Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me...</td>\n",
" <td>173206</td>\n",
" <td>2811555</td>\n",
" <td>6.160505</td>\n",
" </tr>\n",
" <tr>\n",
" <th>318</th>\n",
" <td>Seattle-Tacoma-Bellevue, WA Metro Area</td>\n",
" <td>171720</td>\n",
" <td>1735528</td>\n",
" <td>9.894395</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Atlanta-Sandy Springs-Roswell, GA Metro Area</td>\n",
" <td>151438</td>\n",
" <td>2493097</td>\n",
" <td>6.074292</td>\n",
" </tr>\n",
" <tr>\n",
" <th>310</th>\n",
" <td>San Jose-Sunnyvale-Santa Clara, CA Metro Area</td>\n",
" <td>145801</td>\n",
" <td>890120</td>\n",
" <td>16.379926</td>\n",
" </tr>\n",
" <tr>\n",
" <th>229</th>\n",
" <td>Minneapolis-St. Paul-Bloomington, MN-WI Metro ...</td>\n",
" <td>131233</td>\n",
" <td>1777911</td>\n",
" <td>7.381303</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>Detroit-Warren-Dearborn, MI Metro Area</td>\n",
" <td>119622</td>\n",
" <td>1835053</td>\n",
" <td>6.518722</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Baltimore-Columbia-Towson, MD Metro Area</td>\n",
" <td>116023</td>\n",
" <td>1349821</td>\n",
" <td>8.595436</td>\n",
" </tr>\n",
" <tr>\n",
" <th>308</th>\n",
" <td>San Diego-Carlsbad, CA Metro Area</td>\n",
" <td>113003</td>\n",
" <td>1390197</td>\n",
" <td>8.128560</td>\n",
" </tr>\n",
" <tr>\n",
" <th>269</th>\n",
" <td>Phoenix-Mesa-Scottsdale, AZ Metro Area</td>\n",
" <td>108922</td>\n",
" <td>1867805</td>\n",
" <td>5.831551</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>Denver-Aurora-Lakewood, CO Metro Area</td>\n",
" <td>104950</td>\n",
" <td>1324181</td>\n",
" <td>7.925654</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224</th>\n",
" <td>Miami-Fort Lauderdale-West Palm Beach, FL Metr...</td>\n",
" <td>85008</td>\n",
" <td>2576592</td>\n",
" <td>3.299242</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Austin-Round Rock, TX Metro Area</td>\n",
" <td>79223</td>\n",
" <td>903962</td>\n",
" <td>8.763975</td>\n",
" </tr>\n",
" <tr>\n",
" <th>275</th>\n",
" <td>Portland-Vancouver-Hillsboro, OR-WA Metro Area</td>\n",
" <td>77906</td>\n",
" <td>1078842</td>\n",
" <td>7.221261</td>\n",
" </tr>\n",
" <tr>\n",
" <th>301</th>\n",
" <td>St. Louis, MO-IL Metro Area</td>\n",
" <td>76295</td>\n",
" <td>1333776</td>\n",
" <td>5.720226</td>\n",
" </tr>\n",
" <tr>\n",
" <th>296</th>\n",
" <td>Sacramento--Roseville--Arden-Arcade, CA Metro ...</td>\n",
" <td>66725</td>\n",
" <td>940496</td>\n",
" <td>7.094661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td>Pittsburgh, PA Metro Area</td>\n",
" <td>64974</td>\n",
" <td>1125110</td>\n",
" <td>5.774902</td>\n",
" </tr>\n",
" <tr>\n",
" <th>283</th>\n",
" <td>Raleigh, NC Metro Area</td>\n",
" <td>59290</td>\n",
" <td>571769</td>\n",
" <td>10.369572</td>\n",
" </tr>\n",
" <tr>\n",
" <th>179</th>\n",
" <td>Kansas City, MO-KS Metro Area</td>\n",
" <td>59253</td>\n",
" <td>993639</td>\n",
" <td>5.963232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>340</th>\n",
" <td>Tampa-St. Petersburg-Clearwater, FL Metro Area</td>\n",
" <td>58819</td>\n",
" <td>1230926</td>\n",
" <td>4.778435</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>Columbus, OH Metro Area</td>\n",
" <td>56670</td>\n",
" <td>937655</td>\n",
" <td>6.043801</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>Cincinnati, OH-KY-IN Metro Area</td>\n",
" <td>56560</td>\n",
" <td>1004439</td>\n",
" <td>5.631004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>Charlotte-Concord-Gastonia, NC-SC Metro Area</td>\n",
" <td>53275</td>\n",
" <td>1049535</td>\n",
" <td>5.076057</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>178</th>\n",
" <td>Kankakee, IL Metro Area</td>\n",
" <td>1184</td>\n",
" <td>49441</td>\n",
" <td>2.394774</td>\n",
" </tr>\n",
" <tr>\n",
" <th>342</th>\n",
" <td>Texarkana, TX-AR Metro Area</td>\n",
" <td>1177</td>\n",
" <td>61690</td>\n",
" <td>1.907927</td>\n",
" </tr>\n",
" <tr>\n",
" <th>306</th>\n",
" <td>San Angelo, TX Metro Area</td>\n",
" <td>1167</td>\n",
" <td>50741</td>\n",
" <td>2.299915</td>\n",
" </tr>\n",
" <tr>\n",
" <th>356</th>\n",
" <td>Vineland-Bridgeton, NJ Metro Area</td>\n",
" <td>1160</td>\n",
" <td>61872</td>\n",
" <td>1.874838</td>\n",
" </tr>\n",
" <tr>\n",
" <th>167</th>\n",
" <td>Jackson, TN Metro Area</td>\n",
" <td>1146</td>\n",
" <td>55153</td>\n",
" <td>2.077856</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225</th>\n",
" <td>Michigan City-La Porte, IN Metro Area</td>\n",
" <td>1113</td>\n",
" <td>47049</td>\n",
" <td>2.365619</td>\n",
" </tr>\n",
" <tr>\n",
" <th>132</th>\n",
" <td>Goldsboro, NC Metro Area</td>\n",
" <td>1105</td>\n",
" <td>50744</td>\n",
" <td>2.177597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Beckley, WV Metro Area</td>\n",
" <td>1101</td>\n",
" <td>45202</td>\n",
" <td>2.435733</td>\n",
" </tr>\n",
" <tr>\n",
" <th>214</th>\n",
" <td>Madera, CA Metro Area</td>\n",
" <td>1093</td>\n",
" <td>52029</td>\n",
" <td>2.100752</td>\n",
" </tr>\n",
" <tr>\n",
" <th>237</th>\n",
" <td>Morristown, TN Metro Area</td>\n",
" <td>1084</td>\n",
" <td>47225</td>\n",
" <td>2.295394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>Carson City, NV Metro Area</td>\n",
" <td>1073</td>\n",
" <td>22624</td>\n",
" <td>4.742751</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>Cumberland, MD-WV Metro Area</td>\n",
" <td>1048</td>\n",
" <td>40712</td>\n",
" <td>2.574180</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>Great Falls, MT Metro Area</td>\n",
" <td>1044</td>\n",
" <td>36775</td>\n",
" <td>2.838885</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>El Centro, CA Metro Area</td>\n",
" <td>1017</td>\n",
" <td>58169</td>\n",
" <td>1.748354</td>\n",
" </tr>\n",
" <tr>\n",
" <th>137</th>\n",
" <td>Grants Pass, OR Metro Area</td>\n",
" <td>1006</td>\n",
" <td>28546</td>\n",
" <td>3.524136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>295</th>\n",
" <td>Rome, GA Metro Area</td>\n",
" <td>984</td>\n",
" <td>38841</td>\n",
" <td>2.533405</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>Cape Girardeau, MO-IL Metro Area</td>\n",
" <td>977</td>\n",
" <td>44440</td>\n",
" <td>2.198470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360</th>\n",
" <td>Walla Walla, WA Metro Area</td>\n",
" <td>975</td>\n",
" <td>27098</td>\n",
" <td>3.598052</td>\n",
" </tr>\n",
" <tr>\n",
" <th>147</th>\n",
" <td>Hanford-Corcoran, CA Metro Area</td>\n",
" <td>949</td>\n",
" <td>51566</td>\n",
" <td>1.840360</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>Brunswick, GA Metro Area</td>\n",
" <td>939</td>\n",
" <td>47858</td>\n",
" <td>1.962054</td>\n",
" </tr>\n",
" <tr>\n",
" <th>155</th>\n",
" <td>Homosassa Springs, FL Metro Area</td>\n",
" <td>910</td>\n",
" <td>43751</td>\n",
" <td>2.079952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>270</th>\n",
" <td>Pine Bluff, AR Metro Area</td>\n",
" <td>894</td>\n",
" <td>36336</td>\n",
" <td>2.460370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>200</th>\n",
" <td>Lewiston, ID-WA Metro Area</td>\n",
" <td>870</td>\n",
" <td>27842</td>\n",
" <td>3.124776</td>\n",
" </tr>\n",
" <tr>\n",
" <th>156</th>\n",
" <td>Hot Springs, AR Metro Area</td>\n",
" <td>845</td>\n",
" <td>38810</td>\n",
" <td>2.177274</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>Danville, IL Metro Area</td>\n",
" <td>799</td>\n",
" <td>32883</td>\n",
" <td>2.429827</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td>Grand Island, NE Metro Area</td>\n",
" <td>790</td>\n",
" <td>42702</td>\n",
" <td>1.850030</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>Gadsden, AL Metro Area</td>\n",
" <td>749</td>\n",
" <td>39289</td>\n",
" <td>1.906386</td>\n",
" </tr>\n",
" <tr>\n",
" <th>154</th>\n",
" <td>Hinesville, GA Metro Area</td>\n",
" <td>692</td>\n",
" <td>27778</td>\n",
" <td>2.491180</td>\n",
" </tr>\n",
" <tr>\n",
" <th>320</th>\n",
" <td>Sebring, FL Metro Area</td>\n",
" <td>463</td>\n",
" <td>30935</td>\n",
" <td>1.496687</td>\n",
" </tr>\n",
" <tr>\n",
" <th>343</th>\n",
" <td>The Villages, FL Metro Area</td>\n",
" <td>421</td>\n",
" <td>20740</td>\n",
" <td>2.029894</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>381 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" MSA \\\n",
"248 New York-Newark-Jersey City, NY-NJ-PA Metro Area \n",
"362 Washington-Arlington-Alexandria, DC-VA-MD-WV M... \n",
"209 Los Angeles-Long Beach-Anaheim, CA Metro Area \n",
"68 Chicago-Naperville-Elgin, IL-IN-WI Metro Area \n",
"309 San Francisco-Oakland-Hayward, CA Metro Area \n",
"42 Boston-Cambridge-Newton, MA-NH Metro Area \n",
"86 Dallas-Fort Worth-Arlington, TX Metro Area \n",
"158 Houston-The Woodlands-Sugar Land, TX Metro Area \n",
"268 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me... \n",
"318 Seattle-Tacoma-Bellevue, WA Metro Area \n",
"17 Atlanta-Sandy Springs-Roswell, GA Metro Area \n",
"310 San Jose-Sunnyvale-Santa Clara, CA Metro Area \n",
"229 Minneapolis-St. Paul-Bloomington, MN-WI Metro ... \n",
"97 Detroit-Warren-Dearborn, MI Metro Area \n",
"23 Baltimore-Columbia-Towson, MD Metro Area \n",
"308 San Diego-Carlsbad, CA Metro Area \n",
"269 Phoenix-Mesa-Scottsdale, AZ Metro Area \n",
"95 Denver-Aurora-Lakewood, CO Metro Area \n",
"224 Miami-Fort Lauderdale-West Palm Beach, FL Metr... \n",
"21 Austin-Round Rock, TX Metro Area \n",
"275 Portland-Vancouver-Hillsboro, OR-WA Metro Area \n",
"301 St. Louis, MO-IL Metro Area \n",
"296 Sacramento--Roseville--Arden-Arcade, CA Metro ... \n",
"271 Pittsburgh, PA Metro Area \n",
"283 Raleigh, NC Metro Area \n",
"179 Kansas City, MO-KS Metro Area \n",
"340 Tampa-St. Petersburg-Clearwater, FL Metro Area \n",
"81 Columbus, OH Metro Area \n",
"70 Cincinnati, OH-KY-IN Metro Area \n",
"64 Charlotte-Concord-Gastonia, NC-SC Metro Area \n",
".. ... \n",
"178 Kankakee, IL Metro Area \n",
"342 Texarkana, TX-AR Metro Area \n",
"306 San Angelo, TX Metro Area \n",
"356 Vineland-Bridgeton, NJ Metro Area \n",
"167 Jackson, TN Metro Area \n",
"225 Michigan City-La Porte, IN Metro Area \n",
"132 Goldsboro, NC Metro Area \n",
"30 Beckley, WV Metro Area \n",
"214 Madera, CA Metro Area \n",
"237 Morristown, TN Metro Area \n",
"57 Carson City, NV Metro Area \n",
"85 Cumberland, MD-WV Metro Area \n",
"138 Great Falls, MT Metro Area \n",
"105 El Centro, CA Metro Area \n",
"137 Grants Pass, OR Metro Area \n",
"295 Rome, GA Metro Area \n",
"55 Cape Girardeau, MO-IL Metro Area \n",
"360 Walla Walla, WA Metro Area \n",
"147 Hanford-Corcoran, CA Metro Area \n",
"48 Brunswick, GA Metro Area \n",
"155 Homosassa Springs, FL Metro Area \n",
"270 Pine Bluff, AR Metro Area \n",
"200 Lewiston, ID-WA Metro Area \n",
"156 Hot Springs, AR Metro Area \n",
"88 Danville, IL Metro Area \n",
"134 Grand Island, NE Metro Area \n",
"127 Gadsden, AL Metro Area \n",
"154 Hinesville, GA Metro Area \n",
"320 Sebring, FL Metro Area \n",
"343 The Villages, FL Metro Area \n",
"\n",
" Total_Computer-Engineering-Science_Occupations Total_People \\\n",
"248 463348 9264128 \n",
"362 338344 3037310 \n",
"209 293215 5943925 \n",
"68 233859 4463443 \n",
"309 209476 2176766 \n",
"42 204841 2377006 \n",
"86 194611 3167340 \n",
"158 184243 2839405 \n",
"268 173206 2811555 \n",
"318 171720 1735528 \n",
"17 151438 2493097 \n",
"310 145801 890120 \n",
"229 131233 1777911 \n",
"97 119622 1835053 \n",
"23 116023 1349821 \n",
"308 113003 1390197 \n",
"269 108922 1867805 \n",
"95 104950 1324181 \n",
"224 85008 2576592 \n",
"21 79223 903962 \n",
"275 77906 1078842 \n",
"301 76295 1333776 \n",
"296 66725 940496 \n",
"271 64974 1125110 \n",
"283 59290 571769 \n",
"179 59253 993639 \n",
"340 58819 1230926 \n",
"81 56670 937655 \n",
"70 56560 1004439 \n",
"64 53275 1049535 \n",
".. ... ... \n",
"178 1184 49441 \n",
"342 1177 61690 \n",
"306 1167 50741 \n",
"356 1160 61872 \n",
"167 1146 55153 \n",
"225 1113 47049 \n",
"132 1105 50744 \n",
"30 1101 45202 \n",
"214 1093 52029 \n",
"237 1084 47225 \n",
"57 1073 22624 \n",
"85 1048 40712 \n",
"138 1044 36775 \n",
"105 1017 58169 \n",
"137 1006 28546 \n",
"295 984 38841 \n",
"55 977 44440 \n",
"360 975 27098 \n",
"147 949 51566 \n",
"48 939 47858 \n",
"155 910 43751 \n",
"270 894 36336 \n",
"200 870 27842 \n",
"156 845 38810 \n",
"88 799 32883 \n",
"134 790 42702 \n",
"127 749 39289 \n",
"154 692 27778 \n",
"320 463 30935 \n",
"343 421 20740 \n",
"\n",
" PerCapita_Computer-Engineering-Science_Occupations \n",
"248 5.001528 \n",
"362 11.139594 \n",
"209 4.933020 \n",
"68 5.239431 \n",
"309 9.623267 \n",
"42 8.617606 \n",
"86 6.144304 \n",
"158 6.488789 \n",
"268 6.160505 \n",
"318 9.894395 \n",
"17 6.074292 \n",
"310 16.379926 \n",
"229 7.381303 \n",
"97 6.518722 \n",
"23 8.595436 \n",
"308 8.128560 \n",
"269 5.831551 \n",
"95 7.925654 \n",
"224 3.299242 \n",
"21 8.763975 \n",
"275 7.221261 \n",
"301 5.720226 \n",
"296 7.094661 \n",
"271 5.774902 \n",
"283 10.369572 \n",
"179 5.963232 \n",
"340 4.778435 \n",
"81 6.043801 \n",
"70 5.631004 \n",
"64 5.076057 \n",
".. ... \n",
"178 2.394774 \n",
"342 1.907927 \n",
"306 2.299915 \n",
"356 1.874838 \n",
"167 2.077856 \n",
"225 2.365619 \n",
"132 2.177597 \n",
"30 2.435733 \n",
"214 2.100752 \n",
"237 2.295394 \n",
"57 4.742751 \n",
"85 2.574180 \n",
"138 2.838885 \n",
"105 1.748354 \n",
"137 3.524136 \n",
"295 2.533405 \n",
"55 2.198470 \n",
"360 3.598052 \n",
"147 1.840360 \n",
"48 1.962054 \n",
"155 2.079952 \n",
"270 2.460370 \n",
"200 3.124776 \n",
"156 2.177274 \n",
"88 2.429827 \n",
"134 1.850030 \n",
"127 1.906386 \n",
"154 2.491180 \n",
"320 1.496687 \n",
"343 2.029894 \n",
"\n",
"[381 rows x 4 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.sort(\"Total_Computer-Engineering-Science_Occupations\",ascending=False)[[\"MSA\",\"Total_Computer-Engineering-Science_Occupations\",\"Total_People\",\"PerCapita_Computer-Engineering-Science_Occupations\"]]"
]
},
{
"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>MSA</th>\n",
" <th>Total_Computer-Math_Occupations</th>\n",
" <th>Total_People</th>\n",
" <th>PerCapita_Computer-Math_Occupations</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>New York-Newark-Jersey City, NY-NJ-PA Metro Area</td>\n",
" <td>260661</td>\n",
" <td>9264128</td>\n",
" <td>2.813659</td>\n",
" </tr>\n",
" <tr>\n",
" <th>362</th>\n",
" <td>Washington-Arlington-Alexandria, DC-VA-MD-WV M...</td>\n",
" <td>212731</td>\n",
" <td>3037310</td>\n",
" <td>7.003928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>209</th>\n",
" <td>Los Angeles-Long Beach-Anaheim, CA Metro Area</td>\n",
" <td>134886</td>\n",
" <td>5943925</td>\n",
" <td>2.269309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>Chicago-Naperville-Elgin, IL-IN-WI Metro Area</td>\n",
" <td>128719</td>\n",
" <td>4463443</td>\n",
" <td>2.883850</td>\n",
" </tr>\n",
" <tr>\n",
" <th>309</th>\n",
" <td>San Francisco-Oakland-Hayward, CA Metro Area</td>\n",
" <td>109146</td>\n",
" <td>2176766</td>\n",
" <td>5.014136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Boston-Cambridge-Newton, MA-NH Metro Area</td>\n",
" <td>98726</td>\n",
" <td>2377006</td>\n",
" <td>4.153376</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>Dallas-Fort Worth-Arlington, TX Metro Area</td>\n",
" <td>111297</td>\n",
" <td>3167340</td>\n",
" <td>3.513895</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158</th>\n",
" <td>Houston-The Woodlands-Sugar Land, TX Metro Area</td>\n",
" <td>67106</td>\n",
" <td>2839405</td>\n",
" <td>2.363382</td>\n",
" </tr>\n",
" <tr>\n",
" <th>268</th>\n",
" <td>Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me...</td>\n",
" <td>86053</td>\n",
" <td>2811555</td>\n",
" <td>3.060691</td>\n",
" </tr>\n",
" <tr>\n",
" <th>318</th>\n",
" <td>Seattle-Tacoma-Bellevue, WA Metro Area</td>\n",
" <td>99012</td>\n",
" <td>1735528</td>\n",
" <td>5.705007</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Atlanta-Sandy Springs-Roswell, GA Metro Area</td>\n",
" <td>89516</td>\n",
" <td>2493097</td>\n",
" <td>3.590554</td>\n",
" </tr>\n",
" <tr>\n",
" <th>310</th>\n",
" <td>San Jose-Sunnyvale-Santa Clara, CA Metro Area</td>\n",
" <td>79243</td>\n",
" <td>890120</td>\n",
" <td>8.902508</td>\n",
" </tr>\n",
" <tr>\n",
" <th>229</th>\n",
" <td>Minneapolis-St. Paul-Bloomington, MN-WI Metro ...</td>\n",
" <td>71950</td>\n",
" <td>1777911</td>\n",
" <td>4.046884</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>Detroit-Warren-Dearborn, MI Metro Area</td>\n",
" <td>47744</td>\n",
" <td>1835053</td>\n",
" <td>2.601778</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Baltimore-Columbia-Towson, MD Metro Area</td>\n",
" <td>64911</td>\n",
" <td>1349821</td>\n",
" <td>4.808860</td>\n",
" </tr>\n",
" <tr>\n",
" <th>308</th>\n",
" <td>San Diego-Carlsbad, CA Metro Area</td>\n",
" <td>48973</td>\n",
" <td>1390197</td>\n",
" <td>3.522738</td>\n",
" </tr>\n",
" <tr>\n",
" <th>269</th>\n",
" <td>Phoenix-Mesa-Scottsdale, AZ Metro Area</td>\n",
" <td>57476</td>\n",
" <td>1867805</td>\n",
" <td>3.077195</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>Denver-Aurora-Lakewood, CO Metro Area</td>\n",
" <td>56770</td>\n",
" <td>1324181</td>\n",
" <td>4.287178</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224</th>\n",
" <td>Miami-Fort Lauderdale-West Palm Beach, FL Metr...</td>\n",
" <td>43710</td>\n",
" <td>2576592</td>\n",
" <td>1.696427</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Austin-Round Rock, TX Metro Area</td>\n",
" <td>46085</td>\n",
" <td>903962</td>\n",
" <td>5.098113</td>\n",
" </tr>\n",
" <tr>\n",
" <th>275</th>\n",
" <td>Portland-Vancouver-Hillsboro, OR-WA Metro Area</td>\n",
" <td>35637</td>\n",
" <td>1078842</td>\n",
" <td>3.303264</td>\n",
" </tr>\n",
" <tr>\n",
" <th>301</th>\n",
" <td>St. Louis, MO-IL Metro Area</td>\n",
" <td>41004</td>\n",
" <td>1333776</td>\n",
" <td>3.074279</td>\n",
" </tr>\n",
" <tr>\n",
" <th>296</th>\n",
" <td>Sacramento--Roseville--Arden-Arcade, CA Metro ...</td>\n",
" <td>34226</td>\n",
" <td>940496</td>\n",
" <td>3.639144</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td>Pittsburgh, PA Metro Area</td>\n",
" <td>29621</td>\n",
" <td>1125110</td>\n",
" <td>2.632720</td>\n",
" </tr>\n",
" <tr>\n",
" <th>283</th>\n",
" <td>Raleigh, NC Metro Area</td>\n",
" <td>32796</td>\n",
" <td>571769</td>\n",
" <td>5.735883</td>\n",
" </tr>\n",
" <tr>\n",
" <th>179</th>\n",
" <td>Kansas City, MO-KS Metro Area</td>\n",
" <td>35086</td>\n",
" <td>993639</td>\n",
" <td>3.531061</td>\n",
" </tr>\n",
" <tr>\n",
" <th>340</th>\n",
" <td>Tampa-St. Petersburg-Clearwater, FL Metro Area</td>\n",
" <td>35051</td>\n",
" <td>1230926</td>\n",
" <td>2.847531</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>Columbus, OH Metro Area</td>\n",
" <td>32966</td>\n",
" <td>937655</td>\n",
" <td>3.515792</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>Cincinnati, OH-KY-IN Metro Area</td>\n",
" <td>27009</td>\n",
" <td>1004439</td>\n",
" <td>2.688964</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>Charlotte-Concord-Gastonia, NC-SC Metro Area</td>\n",
" <td>30921</td>\n",
" <td>1049535</td>\n",
" <td>2.946162</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>178</th>\n",
" <td>Kankakee, IL Metro Area</td>\n",
" <td>478</td>\n",
" <td>49441</td>\n",
" <td>0.966809</td>\n",
" </tr>\n",
" <tr>\n",
" <th>342</th>\n",
" <td>Texarkana, TX-AR Metro Area</td>\n",
" <td>489</td>\n",
" <td>61690</td>\n",
" <td>0.792673</td>\n",
" </tr>\n",
" <tr>\n",
" <th>306</th>\n",
" <td>San Angelo, TX Metro Area</td>\n",
" <td>459</td>\n",
" <td>50741</td>\n",
" <td>0.904594</td>\n",
" </tr>\n",
" <tr>\n",
" <th>356</th>\n",
" <td>Vineland-Bridgeton, NJ Metro Area</td>\n",
" <td>477</td>\n",
" <td>61872</td>\n",
" <td>0.770946</td>\n",
" </tr>\n",
" <tr>\n",
" <th>167</th>\n",
" <td>Jackson, TN Metro Area</td>\n",
" <td>381</td>\n",
" <td>55153</td>\n",
" <td>0.690806</td>\n",
" </tr>\n",
" <tr>\n",
" <th>225</th>\n",
" <td>Michigan City-La Porte, IN Metro Area</td>\n",
" <td>432</td>\n",
" <td>47049</td>\n",
" <td>0.918192</td>\n",
" </tr>\n",
" <tr>\n",
" <th>132</th>\n",
" <td>Goldsboro, NC Metro Area</td>\n",
" <td>369</td>\n",
" <td>50744</td>\n",
" <td>0.727180</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Beckley, WV Metro Area</td>\n",
" <td>214</td>\n",
" <td>45202</td>\n",
" <td>0.473430</td>\n",
" </tr>\n",
" <tr>\n",
" <th>214</th>\n",
" <td>Madera, CA Metro Area</td>\n",
" <td>436</td>\n",
" <td>52029</td>\n",
" <td>0.837994</td>\n",
" </tr>\n",
" <tr>\n",
" <th>237</th>\n",
" <td>Morristown, TN Metro Area</td>\n",
" <td>350</td>\n",
" <td>47225</td>\n",
" <td>0.741133</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>Carson City, NV Metro Area</td>\n",
" <td>385</td>\n",
" <td>22624</td>\n",
" <td>1.701733</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>Cumberland, MD-WV Metro Area</td>\n",
" <td>316</td>\n",
" <td>40712</td>\n",
" <td>0.776184</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>Great Falls, MT Metro Area</td>\n",
" <td>319</td>\n",
" <td>36775</td>\n",
" <td>0.867437</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>El Centro, CA Metro Area</td>\n",
" <td>357</td>\n",
" <td>58169</td>\n",
" <td>0.613729</td>\n",
" </tr>\n",
" <tr>\n",
" <th>137</th>\n",
" <td>Grants Pass, OR Metro Area</td>\n",
" <td>494</td>\n",
" <td>28546</td>\n",
" <td>1.730540</td>\n",
" </tr>\n",
" <tr>\n",
" <th>295</th>\n",
" <td>Rome, GA Metro Area</td>\n",
" <td>388</td>\n",
" <td>38841</td>\n",
" <td>0.998944</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>Cape Girardeau, MO-IL Metro Area</td>\n",
" <td>287</td>\n",
" <td>44440</td>\n",
" <td>0.645815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360</th>\n",
" <td>Walla Walla, WA Metro Area</td>\n",
" <td>473</td>\n",
" <td>27098</td>\n",
" <td>1.745516</td>\n",
" </tr>\n",
" <tr>\n",
" <th>147</th>\n",
" <td>Hanford-Corcoran, CA Metro Area</td>\n",
" <td>482</td>\n",
" <td>51566</td>\n",
" <td>0.934724</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>Brunswick, GA Metro Area</td>\n",
" <td>300</td>\n",
" <td>47858</td>\n",
" <td>0.626854</td>\n",
" </tr>\n",
" <tr>\n",
" <th>155</th>\n",
" <td>Homosassa Springs, FL Metro Area</td>\n",
" <td>426</td>\n",
" <td>43751</td>\n",
" <td>0.973692</td>\n",
" </tr>\n",
" <tr>\n",
" <th>270</th>\n",
" <td>Pine Bluff, AR Metro Area</td>\n",
" <td>316</td>\n",
" <td>36336</td>\n",
" <td>0.869661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>200</th>\n",
" <td>Lewiston, ID-WA Metro Area</td>\n",
" <td>338</td>\n",
" <td>27842</td>\n",
" <td>1.213993</td>\n",
" </tr>\n",
" <tr>\n",
" <th>156</th>\n",
" <td>Hot Springs, AR Metro Area</td>\n",
" <td>410</td>\n",
" <td>38810</td>\n",
" <td>1.056429</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>Danville, IL Metro Area</td>\n",
" <td>247</td>\n",
" <td>32883</td>\n",
" <td>0.751148</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td>Grand Island, NE Metro Area</td>\n",
" <td>329</td>\n",
" <td>42702</td>\n",
" <td>0.770456</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>Gadsden, AL Metro Area</td>\n",
" <td>178</td>\n",
" <td>39289</td>\n",
" <td>0.453053</td>\n",
" </tr>\n",
" <tr>\n",
" <th>154</th>\n",
" <td>Hinesville, GA Metro Area</td>\n",
" <td>333</td>\n",
" <td>27778</td>\n",
" <td>1.198790</td>\n",
" </tr>\n",
" <tr>\n",
" <th>320</th>\n",
" <td>Sebring, FL Metro Area</td>\n",
" <td>75</td>\n",
" <td>30935</td>\n",
" <td>0.242444</td>\n",
" </tr>\n",
" <tr>\n",
" <th>343</th>\n",
" <td>The Villages, FL Metro Area</td>\n",
" <td>122</td>\n",
" <td>20740</td>\n",
" <td>0.588235</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>381 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" MSA \\\n",
"248 New York-Newark-Jersey City, NY-NJ-PA Metro Area \n",
"362 Washington-Arlington-Alexandria, DC-VA-MD-WV M... \n",
"209 Los Angeles-Long Beach-Anaheim, CA Metro Area \n",
"68 Chicago-Naperville-Elgin, IL-IN-WI Metro Area \n",
"309 San Francisco-Oakland-Hayward, CA Metro Area \n",
"42 Boston-Cambridge-Newton, MA-NH Metro Area \n",
"86 Dallas-Fort Worth-Arlington, TX Metro Area \n",
"158 Houston-The Woodlands-Sugar Land, TX Metro Area \n",
"268 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me... \n",
"318 Seattle-Tacoma-Bellevue, WA Metro Area \n",
"17 Atlanta-Sandy Springs-Roswell, GA Metro Area \n",
"310 San Jose-Sunnyvale-Santa Clara, CA Metro Area \n",
"229 Minneapolis-St. Paul-Bloomington, MN-WI Metro ... \n",
"97 Detroit-Warren-Dearborn, MI Metro Area \n",
"23 Baltimore-Columbia-Towson, MD Metro Area \n",
"308 San Diego-Carlsbad, CA Metro Area \n",
"269 Phoenix-Mesa-Scottsdale, AZ Metro Area \n",
"95 Denver-Aurora-Lakewood, CO Metro Area \n",
"224 Miami-Fort Lauderdale-West Palm Beach, FL Metr... \n",
"21 Austin-Round Rock, TX Metro Area \n",
"275 Portland-Vancouver-Hillsboro, OR-WA Metro Area \n",
"301 St. Louis, MO-IL Metro Area \n",
"296 Sacramento--Roseville--Arden-Arcade, CA Metro ... \n",
"271 Pittsburgh, PA Metro Area \n",
"283 Raleigh, NC Metro Area \n",
"179 Kansas City, MO-KS Metro Area \n",
"340 Tampa-St. Petersburg-Clearwater, FL Metro Area \n",
"81 Columbus, OH Metro Area \n",
"70 Cincinnati, OH-KY-IN Metro Area \n",
"64 Charlotte-Concord-Gastonia, NC-SC Metro Area \n",
".. ... \n",
"178 Kankakee, IL Metro Area \n",
"342 Texarkana, TX-AR Metro Area \n",
"306 San Angelo, TX Metro Area \n",
"356 Vineland-Bridgeton, NJ Metro Area \n",
"167 Jackson, TN Metro Area \n",
"225 Michigan City-La Porte, IN Metro Area \n",
"132 Goldsboro, NC Metro Area \n",
"30 Beckley, WV Metro Area \n",
"214 Madera, CA Metro Area \n",
"237 Morristown, TN Metro Area \n",
"57 Carson City, NV Metro Area \n",
"85 Cumberland, MD-WV Metro Area \n",
"138 Great Falls, MT Metro Area \n",
"105 El Centro, CA Metro Area \n",
"137 Grants Pass, OR Metro Area \n",
"295 Rome, GA Metro Area \n",
"55 Cape Girardeau, MO-IL Metro Area \n",
"360 Walla Walla, WA Metro Area \n",
"147 Hanford-Corcoran, CA Metro Area \n",
"48 Brunswick, GA Metro Area \n",
"155 Homosassa Springs, FL Metro Area \n",
"270 Pine Bluff, AR Metro Area \n",
"200 Lewiston, ID-WA Metro Area \n",
"156 Hot Springs, AR Metro Area \n",
"88 Danville, IL Metro Area \n",
"134 Grand Island, NE Metro Area \n",
"127 Gadsden, AL Metro Area \n",
"154 Hinesville, GA Metro Area \n",
"320 Sebring, FL Metro Area \n",
"343 The Villages, FL Metro Area \n",
"\n",
" Total_Computer-Math_Occupations Total_People \\\n",
"248 260661 9264128 \n",
"362 212731 3037310 \n",
"209 134886 5943925 \n",
"68 128719 4463443 \n",
"309 109146 2176766 \n",
"42 98726 2377006 \n",
"86 111297 3167340 \n",
"158 67106 2839405 \n",
"268 86053 2811555 \n",
"318 99012 1735528 \n",
"17 89516 2493097 \n",
"310 79243 890120 \n",
"229 71950 1777911 \n",
"97 47744 1835053 \n",
"23 64911 1349821 \n",
"308 48973 1390197 \n",
"269 57476 1867805 \n",
"95 56770 1324181 \n",
"224 43710 2576592 \n",
"21 46085 903962 \n",
"275 35637 1078842 \n",
"301 41004 1333776 \n",
"296 34226 940496 \n",
"271 29621 1125110 \n",
"283 32796 571769 \n",
"179 35086 993639 \n",
"340 35051 1230926 \n",
"81 32966 937655 \n",
"70 27009 1004439 \n",
"64 30921 1049535 \n",
".. ... ... \n",
"178 478 49441 \n",
"342 489 61690 \n",
"306 459 50741 \n",
"356 477 61872 \n",
"167 381 55153 \n",
"225 432 47049 \n",
"132 369 50744 \n",
"30 214 45202 \n",
"214 436 52029 \n",
"237 350 47225 \n",
"57 385 22624 \n",
"85 316 40712 \n",
"138 319 36775 \n",
"105 357 58169 \n",
"137 494 28546 \n",
"295 388 38841 \n",
"55 287 44440 \n",
"360 473 27098 \n",
"147 482 51566 \n",
"48 300 47858 \n",
"155 426 43751 \n",
"270 316 36336 \n",
"200 338 27842 \n",
"156 410 38810 \n",
"88 247 32883 \n",
"134 329 42702 \n",
"127 178 39289 \n",
"154 333 27778 \n",
"320 75 30935 \n",
"343 122 20740 \n",
"\n",
" PerCapita_Computer-Math_Occupations \n",
"248 2.813659 \n",
"362 7.003928 \n",
"209 2.269309 \n",
"68 2.883850 \n",
"309 5.014136 \n",
"42 4.153376 \n",
"86 3.513895 \n",
"158 2.363382 \n",
"268 3.060691 \n",
"318 5.705007 \n",
"17 3.590554 \n",
"310 8.902508 \n",
"229 4.046884 \n",
"97 2.601778 \n",
"23 4.808860 \n",
"308 3.522738 \n",
"269 3.077195 \n",
"95 4.287178 \n",
"224 1.696427 \n",
"21 5.098113 \n",
"275 3.303264 \n",
"301 3.074279 \n",
"296 3.639144 \n",
"271 2.632720 \n",
"283 5.735883 \n",
"179 3.531061 \n",
"340 2.847531 \n",
"81 3.515792 \n",
"70 2.688964 \n",
"64 2.946162 \n",
".. ... \n",
"178 0.966809 \n",
"342 0.792673 \n",
"306 0.904594 \n",
"356 0.770946 \n",
"167 0.690806 \n",
"225 0.918192 \n",
"132 0.727180 \n",
"30 0.473430 \n",
"214 0.837994 \n",
"237 0.741133 \n",
"57 1.701733 \n",
"85 0.776184 \n",
"138 0.867437 \n",
"105 0.613729 \n",
"137 1.730540 \n",
"295 0.998944 \n",
"55 0.645815 \n",
"360 1.745516 \n",
"147 0.934724 \n",
"48 0.626854 \n",
"155 0.973692 \n",
"270 0.869661 \n",
"200 1.213993 \n",
"156 1.056429 \n",
"88 0.751148 \n",
"134 0.770456 \n",
"127 0.453053 \n",
"154 1.198790 \n",
"320 0.242444 \n",
"343 0.588235 \n",
"\n",
"[381 rows x 4 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.sort(\"Total_Computer-Engineering-Science_Occupations\",ascending=False)[[\"MSA\",\"Total_Computer-Math_Occupations\",\"Total_People\",\"PerCapita_Computer-Math_Occupations\"]]"
]
},
{
"cell_type": "code",
"execution_count": 5,
"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>MSA</th>\n",
" <th>Total_Computer-Engineering_Occupations</th>\n",
" <th>Total_People</th>\n",
" <th>PerCapita_Computer-Engineering_Occupations</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>New York-Newark-Jersey City, NY-NJ-PA Metro Area</td>\n",
" <td>380211</td>\n",
" <td>9264128</td>\n",
" <td>4.104121</td>\n",
" </tr>\n",
" <tr>\n",
" <th>362</th>\n",
" <td>Washington-Arlington-Alexandria, DC-VA-MD-WV M...</td>\n",
" <td>279162</td>\n",
" <td>3037310</td>\n",
" <td>9.191093</td>\n",
" </tr>\n",
" <tr>\n",
" <th>209</th>\n",
" <td>Los Angeles-Long Beach-Anaheim, CA Metro Area</td>\n",
" <td>248209</td>\n",
" <td>5943925</td>\n",
" <td>4.175843</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>Chicago-Naperville-Elgin, IL-IN-WI Metro Area</td>\n",
" <td>201086</td>\n",
" <td>4463443</td>\n",
" <td>4.505177</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>Dallas-Fort Worth-Arlington, TX Metro Area</td>\n",
" <td>178798</td>\n",
" <td>3167340</td>\n",
" <td>5.645052</td>\n",
" </tr>\n",
" <tr>\n",
" <th>309</th>\n",
" <td>San Francisco-Oakland-Hayward, CA Metro Area</td>\n",
" <td>167847</td>\n",
" <td>2176766</td>\n",
" <td>7.710843</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Boston-Cambridge-Newton, MA-NH Metro Area</td>\n",
" <td>155403</td>\n",
" <td>2377006</td>\n",
" <td>6.537762</td>\n",
" </tr>\n",
" <tr>\n",
" <th>158</th>\n",
" <td>Houston-The Woodlands-Sugar Land, TX Metro Area</td>\n",
" <td>154688</td>\n",
" <td>2839405</td>\n",
" <td>5.447902</td>\n",
" </tr>\n",
" <tr>\n",
" <th>318</th>\n",
" <td>Seattle-Tacoma-Bellevue, WA Metro Area</td>\n",
" <td>153293</td>\n",
" <td>1735528</td>\n",
" <td>8.832643</td>\n",
" </tr>\n",
" <tr>\n",
" <th>268</th>\n",
" <td>Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me...</td>\n",
" <td>136328</td>\n",
" <td>2811555</td>\n",
" <td>4.848847</td>\n",
" </tr>\n",
" <tr>\n",
" <th>310</th>\n",
" <td>San Jose-Sunnyvale-Santa Clara, CA Metro Area</td>\n",
" <td>133544</td>\n",
" <td>890120</td>\n",
" <td>15.002921</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Atlanta-Sandy Springs-Roswell, GA Metro Area</td>\n",
" <td>132347</td>\n",
" <td>2493097</td>\n",
" <td>5.308538</td>\n",
" </tr>\n",
" <tr>\n",
" <th>229</th>\n",
" <td>Minneapolis-St. Paul-Bloomington, MN-WI Metro ...</td>\n",
" <td>112790</td>\n",
" <td>1777911</td>\n",
" <td>6.343962</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>Detroit-Warren-Dearborn, MI Metro Area</td>\n",
" <td>110521</td>\n",
" <td>1835053</td>\n",
" <td>6.022769</td>\n",
" </tr>\n",
" <tr>\n",
" <th>269</th>\n",
" <td>Phoenix-Mesa-Scottsdale, AZ Metro Area</td>\n",
" <td>98345</td>\n",
" <td>1867805</td>\n",
" <td>5.265271</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Baltimore-Columbia-Towson, MD Metro Area</td>\n",
" <td>96020</td>\n",
" <td>1349821</td>\n",
" <td>7.113536</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>Denver-Aurora-Lakewood, CO Metro Area</td>\n",
" <td>91206</td>\n",
" <td>1324181</td>\n",
" <td>6.887729</td>\n",
" </tr>\n",
" <tr>\n",
" <th>308</th>\n",
" <td>San Diego-Carlsbad, CA Metro Area</td>\n",
" <td>89964</td>\n",
" <td>1390197</td>\n",
" <td>6.471313</td>\n",
" </tr>\n",
" <tr>\n",
" <th>224</th>\n",
" <td>Miami-Fort Lauderdale-West Palm Beach, FL Metr...</td>\n",
" <td>72882</td>\n",
" <td>2576592</td>\n",
" <td>2.828620</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Austin-Round Rock, TX Metro Area</td>\n",
" <td>71322</td>\n",
" <td>903962</td>\n",
" <td>7.889933</td>\n",
" </tr>\n",
" <tr>\n",
" <th>275</th>\n",
" <td>Portland-Vancouver-Hillsboro, OR-WA Metro Area</td>\n",
" <td>68564</td>\n",
" <td>1078842</td>\n",
" <td>6.355333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>301</th>\n",
" <td>St. Louis, MO-IL Metro Area</td>\n",
" <td>64226</td>\n",
" <td>1333776</td>\n",
" <td>4.815351</td>\n",
" </tr>\n",
" <tr>\n",
" <th>296</th>\n",
" <td>Sacramento--Roseville--Arden-Arcade, CA Metro ...</td>\n",
" <td>54578</td>\n",
" <td>940496</td>\n",
" <td>5.803108</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td>Pittsburgh, PA Metro Area</td>\n",
" <td>53698</td>\n",
" <td>1125110</td>\n",
" <td>4.772689</td>\n",
" </tr>\n",
" <tr>\n",
" <th>179</th>\n",
" <td>Kansas City, MO-KS Metro Area</td>\n",
" <td>52864</td>\n",
" <td>993639</td>\n",
" <td>5.320242</td>\n",
" </tr>\n",
" <tr>\n",
" <th>340</th>\n",
" <td>Tampa-St. Petersburg-Clearwater, FL Metro Area</td>\n",
" <td>51919</td>\n",
" <td>1230926</td>\n",
" <td>4.217881</td>\n",
" </tr>\n",
" <tr>\n",
" <th>283</th>\n",
" <td>Raleigh, NC Metro Area</td>\n",
" <td>49075</td>\n",
" <td>571769</td>\n",
" <td>8.583012</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>Columbus, OH Metro Area</td>\n",
" <td>49027</td>\n",
" <td>937655</td>\n",
" <td>5.228682</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>Charlotte-Concord-Gastonia, NC-SC Metro Area</td>\n",
" <td>47629</td>\n",
" <td>1049535</td>\n",
" <td>4.538105</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>Cincinnati, OH-KY-IN Metro Area</td>\n",
" <td>47480</td>\n",
" <td>1004439</td>\n",
" <td>4.727017</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>300</th>\n",
" <td>St. Joseph, MO-KS Metro Area</td>\n",
" <td>932</td>\n",
" <td>57908</td>\n",
" <td>1.609449</td>\n",
" </tr>\n",
" <tr>\n",
" <th>178</th>\n",
" <td>Kankakee, IL Metro Area</td>\n",
" <td>931</td>\n",
" <td>49441</td>\n",
" <td>1.883053</td>\n",
" </tr>\n",
" <tr>\n",
" <th>355</th>\n",
" <td>Victoria, TX Metro Area</td>\n",
" <td>921</td>\n",
" <td>43761</td>\n",
" <td>2.104614</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>Carson City, NV Metro Area</td>\n",
" <td>918</td>\n",
" <td>22624</td>\n",
" <td>4.057638</td>\n",
" </tr>\n",
" <tr>\n",
" <th>337</th>\n",
" <td>Sumter, SC Metro Area</td>\n",
" <td>911</td>\n",
" <td>41056</td>\n",
" <td>2.218920</td>\n",
" </tr>\n",
" <tr>\n",
" <th>167</th>\n",
" <td>Jackson, TN Metro Area</td>\n",
" <td>893</td>\n",
" <td>55153</td>\n",
" <td>1.619132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>237</th>\n",
" <td>Morristown, TN Metro Area</td>\n",
" <td>893</td>\n",
" <td>47225</td>\n",
" <td>1.890948</td>\n",
" </tr>\n",
" <tr>\n",
" <th>306</th>\n",
" <td>San Angelo, TX Metro Area</td>\n",
" <td>893</td>\n",
" <td>50741</td>\n",
" <td>1.759918</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>Cape Girardeau, MO-IL Metro Area</td>\n",
" <td>837</td>\n",
" <td>44440</td>\n",
" <td>1.883438</td>\n",
" </tr>\n",
" <tr>\n",
" <th>295</th>\n",
" <td>Rome, GA Metro Area</td>\n",
" <td>830</td>\n",
" <td>38841</td>\n",
" <td>2.136917</td>\n",
" </tr>\n",
" <tr>\n",
" <th>155</th>\n",
" <td>Homosassa Springs, FL Metro Area</td>\n",
" <td>825</td>\n",
" <td>43751</td>\n",
" <td>1.885671</td>\n",
" </tr>\n",
" <tr>\n",
" <th>132</th>\n",
" <td>Goldsboro, NC Metro Area</td>\n",
" <td>809</td>\n",
" <td>50744</td>\n",
" <td>1.594277</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Beckley, WV Metro Area</td>\n",
" <td>805</td>\n",
" <td>45202</td>\n",
" <td>1.780895</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>Great Falls, MT Metro Area</td>\n",
" <td>790</td>\n",
" <td>36775</td>\n",
" <td>2.148199</td>\n",
" </tr>\n",
" <tr>\n",
" <th>214</th>\n",
" <td>Madera, CA Metro Area</td>\n",
" <td>776</td>\n",
" <td>52029</td>\n",
" <td>1.491476</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>Cumberland, MD-WV Metro Area</td>\n",
" <td>773</td>\n",
" <td>40712</td>\n",
" <td>1.898703</td>\n",
" </tr>\n",
" <tr>\n",
" <th>360</th>\n",
" <td>Walla Walla, WA Metro Area</td>\n",
" <td>770</td>\n",
" <td>27098</td>\n",
" <td>2.841538</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>El Centro, CA Metro Area</td>\n",
" <td>746</td>\n",
" <td>58169</td>\n",
" <td>1.282470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>147</th>\n",
" <td>Hanford-Corcoran, CA Metro Area</td>\n",
" <td>738</td>\n",
" <td>51566</td>\n",
" <td>1.431176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>137</th>\n",
" <td>Grants Pass, OR Metro Area</td>\n",
" <td>716</td>\n",
" <td>28546</td>\n",
" <td>2.508232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>156</th>\n",
" <td>Hot Springs, AR Metro Area</td>\n",
" <td>699</td>\n",
" <td>38810</td>\n",
" <td>1.801082</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>Brunswick, GA Metro Area</td>\n",
" <td>678</td>\n",
" <td>47858</td>\n",
" <td>1.416691</td>\n",
" </tr>\n",
" <tr>\n",
" <th>270</th>\n",
" <td>Pine Bluff, AR Metro Area</td>\n",
" <td>645</td>\n",
" <td>36336</td>\n",
" <td>1.775099</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>Gadsden, AL Metro Area</td>\n",
" <td>633</td>\n",
" <td>39289</td>\n",
" <td>1.611138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>200</th>\n",
" <td>Lewiston, ID-WA Metro Area</td>\n",
" <td>627</td>\n",
" <td>27842</td>\n",
" <td>2.251993</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td>Grand Island, NE Metro Area</td>\n",
" <td>623</td>\n",
" <td>42702</td>\n",
" <td>1.458948</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>Danville, IL Metro Area</td>\n",
" <td>547</td>\n",
" <td>32883</td>\n",
" <td>1.663474</td>\n",
" </tr>\n",
" <tr>\n",
" <th>154</th>\n",
" <td>Hinesville, GA Metro Area</td>\n",
" <td>520</td>\n",
" <td>27778</td>\n",
" <td>1.871985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>343</th>\n",
" <td>The Villages, FL Metro Area</td>\n",
" <td>343</td>\n",
" <td>20740</td>\n",
" <td>1.653809</td>\n",
" </tr>\n",
" <tr>\n",
" <th>320</th>\n",
" <td>Sebring, FL Metro Area</td>\n",
" <td>308</td>\n",
" <td>30935</td>\n",
" <td>0.995636</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>381 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" MSA \\\n",
"248 New York-Newark-Jersey City, NY-NJ-PA Metro Area \n",
"362 Washington-Arlington-Alexandria, DC-VA-MD-WV M... \n",
"209 Los Angeles-Long Beach-Anaheim, CA Metro Area \n",
"68 Chicago-Naperville-Elgin, IL-IN-WI Metro Area \n",
"86 Dallas-Fort Worth-Arlington, TX Metro Area \n",
"309 San Francisco-Oakland-Hayward, CA Metro Area \n",
"42 Boston-Cambridge-Newton, MA-NH Metro Area \n",
"158 Houston-The Woodlands-Sugar Land, TX Metro Area \n",
"318 Seattle-Tacoma-Bellevue, WA Metro Area \n",
"268 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Me... \n",
"310 San Jose-Sunnyvale-Santa Clara, CA Metro Area \n",
"17 Atlanta-Sandy Springs-Roswell, GA Metro Area \n",
"229 Minneapolis-St. Paul-Bloomington, MN-WI Metro ... \n",
"97 Detroit-Warren-Dearborn, MI Metro Area \n",
"269 Phoenix-Mesa-Scottsdale, AZ Metro Area \n",
"23 Baltimore-Columbia-Towson, MD Metro Area \n",
"95 Denver-Aurora-Lakewood, CO Metro Area \n",
"308 San Diego-Carlsbad, CA Metro Area \n",
"224 Miami-Fort Lauderdale-West Palm Beach, FL Metr... \n",
"21 Austin-Round Rock, TX Metro Area \n",
"275 Portland-Vancouver-Hillsboro, OR-WA Metro Area \n",
"301 St. Louis, MO-IL Metro Area \n",
"296 Sacramento--Roseville--Arden-Arcade, CA Metro ... \n",
"271 Pittsburgh, PA Metro Area \n",
"179 Kansas City, MO-KS Metro Area \n",
"340 Tampa-St. Petersburg-Clearwater, FL Metro Area \n",
"283 Raleigh, NC Metro Area \n",
"81 Columbus, OH Metro Area \n",
"64 Charlotte-Concord-Gastonia, NC-SC Metro Area \n",
"70 Cincinnati, OH-KY-IN Metro Area \n",
".. ... \n",
"300 St. Joseph, MO-KS Metro Area \n",
"178 Kankakee, IL Metro Area \n",
"355 Victoria, TX Metro Area \n",
"57 Carson City, NV Metro Area \n",
"337 Sumter, SC Metro Area \n",
"167 Jackson, TN Metro Area \n",
"237 Morristown, TN Metro Area \n",
"306 San Angelo, TX Metro Area \n",
"55 Cape Girardeau, MO-IL Metro Area \n",
"295 Rome, GA Metro Area \n",
"155 Homosassa Springs, FL Metro Area \n",
"132 Goldsboro, NC Metro Area \n",
"30 Beckley, WV Metro Area \n",
"138 Great Falls, MT Metro Area \n",
"214 Madera, CA Metro Area \n",
"85 Cumberland, MD-WV Metro Area \n",
"360 Walla Walla, WA Metro Area \n",
"105 El Centro, CA Metro Area \n",
"147 Hanford-Corcoran, CA Metro Area \n",
"137 Grants Pass, OR Metro Area \n",
"156 Hot Springs, AR Metro Area \n",
"48 Brunswick, GA Metro Area \n",
"270 Pine Bluff, AR Metro Area \n",
"127 Gadsden, AL Metro Area \n",
"200 Lewiston, ID-WA Metro Area \n",
"134 Grand Island, NE Metro Area \n",
"88 Danville, IL Metro Area \n",
"154 Hinesville, GA Metro Area \n",
"343 The Villages, FL Metro Area \n",
"320 Sebring, FL Metro Area \n",
"\n",
" Total_Computer-Engineering_Occupations Total_People \\\n",
"248 380211 9264128 \n",
"362 279162 3037310 \n",
"209 248209 5943925 \n",
"68 201086 4463443 \n",
"86 178798 3167340 \n",
"309 167847 2176766 \n",
"42 155403 2377006 \n",
"158 154688 2839405 \n",
"318 153293 1735528 \n",
"268 136328 2811555 \n",
"310 133544 890120 \n",
"17 132347 2493097 \n",
"229 112790 1777911 \n",
"97 110521 1835053 \n",
"269 98345 1867805 \n",
"23 96020 1349821 \n",
"95 91206 1324181 \n",
"308 89964 1390197 \n",
"224 72882 2576592 \n",
"21 71322 903962 \n",
"275 68564 1078842 \n",
"301 64226 1333776 \n",
"296 54578 940496 \n",
"271 53698 1125110 \n",
"179 52864 993639 \n",
"340 51919 1230926 \n",
"283 49075 571769 \n",
"81 49027 937655 \n",
"64 47629 1049535 \n",
"70 47480 1004439 \n",
".. ... ... \n",
"300 932 57908 \n",
"178 931 49441 \n",
"355 921 43761 \n",
"57 918 22624 \n",
"337 911 41056 \n",
"167 893 55153 \n",
"237 893 47225 \n",
"306 893 50741 \n",
"55 837 44440 \n",
"295 830 38841 \n",
"155 825 43751 \n",
"132 809 50744 \n",
"30 805 45202 \n",
"138 790 36775 \n",
"214 776 52029 \n",
"85 773 40712 \n",
"360 770 27098 \n",
"105 746 58169 \n",
"147 738 51566 \n",
"137 716 28546 \n",
"156 699 38810 \n",
"48 678 47858 \n",
"270 645 36336 \n",
"127 633 39289 \n",
"200 627 27842 \n",
"134 623 42702 \n",
"88 547 32883 \n",
"154 520 27778 \n",
"343 343 20740 \n",
"320 308 30935 \n",
"\n",
" PerCapita_Computer-Engineering_Occupations \n",
"248 4.104121 \n",
"362 9.191093 \n",
"209 4.175843 \n",
"68 4.505177 \n",
"86 5.645052 \n",
"309 7.710843 \n",
"42 6.537762 \n",
"158 5.447902 \n",
"318 8.832643 \n",
"268 4.848847 \n",
"310 15.002921 \n",
"17 5.308538 \n",
"229 6.343962 \n",
"97 6.022769 \n",
"269 5.265271 \n",
"23 7.113536 \n",
"95 6.887729 \n",
"308 6.471313 \n",
"224 2.828620 \n",
"21 7.889933 \n",
"275 6.355333 \n",
"301 4.815351 \n",
"296 5.803108 \n",
"271 4.772689 \n",
"179 5.320242 \n",
"340 4.217881 \n",
"283 8.583012 \n",
"81 5.228682 \n",
"64 4.538105 \n",
"70 4.727017 \n",
".. ... \n",
"300 1.609449 \n",
"178 1.883053 \n",
"355 2.104614 \n",
"57 4.057638 \n",
"337 2.218920 \n",
"167 1.619132 \n",
"237 1.890948 \n",
"306 1.759918 \n",
"55 1.883438 \n",
"295 2.136917 \n",
"155 1.885671 \n",
"132 1.594277 \n",
"30 1.780895 \n",
"138 2.148199 \n",
"214 1.491476 \n",
"85 1.898703 \n",
"360 2.841538 \n",
"105 1.282470 \n",
"147 1.431176 \n",
"137 2.508232 \n",
"156 1.801082 \n",
"48 1.416691 \n",
"270 1.775099 \n",
"127 1.611138 \n",
"200 2.251993 \n",
"134 1.458948 \n",
"88 1.663474 \n",
"154 1.871985 \n",
"343 1.653809 \n",
"320 0.995636 \n",
"\n",
"[381 rows x 4 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.sort(\"Total_Computer-Engineering_Occupations\",ascending=False)[[\"MSA\",\"Total_Computer-Engineering_Occupations\",\"Total_People\",\"PerCapita_Computer-Engineering_Occupations\"]]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data.to_excel(\"../output/data.xlsx\")"
]
},
{
"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": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment