Skip to content

Instantly share code, notes, and snippets.

@mattspence

mattspence/2013 Full-Time Year-Round Computer Occupations.ipynb

Created August 20, 2015 02:52
Show Gist options
  • Save mattspence/056011b9f3d0f5086eb7 to your computer and use it in GitHub Desktop.
Save mattspence/056011b9f3d0f5086eb7 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
2013 Full-Time Year-Round Computer Occupations.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_C24020.csv\")"
]
},
{
"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>GEO.id</th>\n",
" <th>GEO.id2</th>\n",
" <th>GEO.display-label</th>\n",
" <th>HD01_VD01</th>\n",
" <th>HD02_VD01</th>\n",
" <th>HD01_VD02</th>\n",
" <th>HD02_VD02</th>\n",
" <th>HD01_VD03</th>\n",
" <th>HD02_VD03</th>\n",
" <th>HD01_VD04</th>\n",
" <th>...</th>\n",
" <th>HD01_VD69</th>\n",
" <th>HD02_VD69</th>\n",
" <th>HD01_VD70</th>\n",
" <th>HD02_VD70</th>\n",
" <th>HD01_VD71</th>\n",
" <th>HD02_VD71</th>\n",
" <th>HD01_VD72</th>\n",
" <th>HD02_VD72</th>\n",
" <th>HD01_VD73</th>\n",
" <th>HD02_VD73</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0500000US01001</td>\n",
" <td>1001</td>\n",
" <td>Autauga County, Alabama</td>\n",
" <td>18071</td>\n",
" <td>647</td>\n",
" <td>10043</td>\n",
" <td>428</td>\n",
" <td>3244</td>\n",
" <td>409</td>\n",
" <td>1772</td>\n",
" <td>...</td>\n",
" <td>52</td>\n",
" <td>65</td>\n",
" <td>341</td>\n",
" <td>128</td>\n",
" <td>271</td>\n",
" <td>113</td>\n",
" <td>24</td>\n",
" <td>22</td>\n",
" <td>46</td>\n",
" <td>34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0500000US01003</td>\n",
" <td>1003</td>\n",
" <td>Baldwin County, Alabama</td>\n",
" <td>56669</td>\n",
" <td>1337</td>\n",
" <td>32671</td>\n",
" <td>904</td>\n",
" <td>10946</td>\n",
" <td>758</td>\n",
" <td>5783</td>\n",
" <td>...</td>\n",
" <td>70</td>\n",
" <td>55</td>\n",
" <td>910</td>\n",
" <td>229</td>\n",
" <td>557</td>\n",
" <td>184</td>\n",
" <td>172</td>\n",
" <td>86</td>\n",
" <td>181</td>\n",
" <td>114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0500000US01005</td>\n",
" <td>1005</td>\n",
" <td>Barbour County, Alabama</td>\n",
" <td>6611</td>\n",
" <td>419</td>\n",
" <td>3703</td>\n",
" <td>318</td>\n",
" <td>864</td>\n",
" <td>165</td>\n",
" <td>336</td>\n",
" <td>...</td>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>401</td>\n",
" <td>129</td>\n",
" <td>356</td>\n",
" <td>124</td>\n",
" <td>33</td>\n",
" <td>32</td>\n",
" <td>12</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0500000US01007</td>\n",
" <td>1007</td>\n",
" <td>Bibb County, Alabama</td>\n",
" <td>5677</td>\n",
" <td>594</td>\n",
" <td>3789</td>\n",
" <td>401</td>\n",
" <td>594</td>\n",
" <td>198</td>\n",
" <td>209</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>21</td>\n",
" <td>154</td>\n",
" <td>98</td>\n",
" <td>107</td>\n",
" <td>85</td>\n",
" <td>11</td>\n",
" <td>17</td>\n",
" <td>36</td>\n",
" <td>36</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0500000US01009</td>\n",
" <td>1009</td>\n",
" <td>Blount County, Alabama</td>\n",
" <td>16722</td>\n",
" <td>679</td>\n",
" <td>10030</td>\n",
" <td>440</td>\n",
" <td>2308</td>\n",
" <td>342</td>\n",
" <td>1251</td>\n",
" <td>...</td>\n",
" <td>35</td>\n",
" <td>44</td>\n",
" <td>722</td>\n",
" <td>202</td>\n",
" <td>500</td>\n",
" <td>180</td>\n",
" <td>99</td>\n",
" <td>84</td>\n",
" <td>123</td>\n",
" <td>67</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 149 columns</p>\n",
"</div>"
],
"text/plain": [
" GEO.id GEO.id2 GEO.display-label HD01_VD01 HD02_VD01 \\\n",
"0 0500000US01001 1001 Autauga County, Alabama 18071 647 \n",
"1 0500000US01003 1003 Baldwin County, Alabama 56669 1337 \n",
"2 0500000US01005 1005 Barbour County, Alabama 6611 419 \n",
"3 0500000US01007 1007 Bibb County, Alabama 5677 594 \n",
"4 0500000US01009 1009 Blount County, Alabama 16722 679 \n",
"\n",
" HD01_VD02 HD02_VD02 HD01_VD03 HD02_VD03 HD01_VD04 ... \\\n",
"0 10043 428 3244 409 1772 ... \n",
"1 32671 904 10946 758 5783 ... \n",
"2 3703 318 864 165 336 ... \n",
"3 3789 401 594 198 209 ... \n",
"4 10030 440 2308 342 1251 ... \n",
"\n",
" HD01_VD69 HD02_VD69 HD01_VD70 HD02_VD70 HD01_VD71 HD02_VD71 \\\n",
"0 52 65 341 128 271 113 \n",
"1 70 55 910 229 557 184 \n",
"2 4 7 401 129 356 124 \n",
"3 0 21 154 98 107 85 \n",
"4 35 44 722 202 500 180 \n",
"\n",
" HD01_VD72 HD02_VD72 HD01_VD73 HD02_VD73 \n",
"0 24 22 46 34 \n",
"1 172 86 181 114 \n",
"2 33 32 12 13 \n",
"3 11 17 36 36 \n",
"4 99 84 123 67 \n",
"\n",
"[5 rows x 149 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.head()"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data[\"Total Peoples\"]=data[\"HD01_VD01\"]\n",
"data[\"Total Dudes\"]=data[\"HD01_VD02\"]\n",
"data[\"Total Ladies\"]=data[\"HD01_VD38\"]\n",
"data[\"Total Tech Dudes\"]=data[\"HD01_VD08\"]\n",
"data[\"Total Tech Ladies\"]=data[\"HD01_VD44\"]\n",
"data[\"Total Tech Peoples\"]=data[\"Total Tech Dudes\"]+data[\"Total Tech Ladies\"]"
]
},
{
"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>GEO.id</th>\n",
" <th>GEO.id2</th>\n",
" <th>GEO.display-label</th>\n",
" <th>HD01_VD01</th>\n",
" <th>HD02_VD01</th>\n",
" <th>HD01_VD02</th>\n",
" <th>HD02_VD02</th>\n",
" <th>HD01_VD03</th>\n",
" <th>HD02_VD03</th>\n",
" <th>HD01_VD04</th>\n",
" <th>...</th>\n",
" <th>HD01_VD72</th>\n",
" <th>HD02_VD72</th>\n",
" <th>HD01_VD73</th>\n",
" <th>HD02_VD73</th>\n",
" <th>Total Peoples</th>\n",
" <th>Total Dudes</th>\n",
" <th>Total Ladies</th>\n",
" <th>Total Tech Dudes</th>\n",
" <th>Total Tech Ladies</th>\n",
" <th>Total Tech Peoples</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0500000US01001</td>\n",
" <td>1001</td>\n",
" <td>Autauga County, Alabama</td>\n",
" <td>18071</td>\n",
" <td>647</td>\n",
" <td>10043</td>\n",
" <td>428</td>\n",
" <td>3244</td>\n",
" <td>409</td>\n",
" <td>1772</td>\n",
" <td>...</td>\n",
" <td>24</td>\n",
" <td>22</td>\n",
" <td>46</td>\n",
" <td>34</td>\n",
" <td>18071</td>\n",
" <td>10043</td>\n",
" <td>8028</td>\n",
" <td>410</td>\n",
" <td>135</td>\n",
" <td>545</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0500000US01003</td>\n",
" <td>1003</td>\n",
" <td>Baldwin County, Alabama</td>\n",
" <td>56669</td>\n",
" <td>1337</td>\n",
" <td>32671</td>\n",
" <td>904</td>\n",
" <td>10946</td>\n",
" <td>758</td>\n",
" <td>5783</td>\n",
" <td>...</td>\n",
" <td>172</td>\n",
" <td>86</td>\n",
" <td>181</td>\n",
" <td>114</td>\n",
" <td>56669</td>\n",
" <td>32671</td>\n",
" <td>23998</td>\n",
" <td>778</td>\n",
" <td>182</td>\n",
" <td>960</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0500000US01005</td>\n",
" <td>1005</td>\n",
" <td>Barbour County, Alabama</td>\n",
" <td>6611</td>\n",
" <td>419</td>\n",
" <td>3703</td>\n",
" <td>318</td>\n",
" <td>864</td>\n",
" <td>165</td>\n",
" <td>336</td>\n",
" <td>...</td>\n",
" <td>33</td>\n",
" <td>32</td>\n",
" <td>12</td>\n",
" <td>13</td>\n",
" <td>6611</td>\n",
" <td>3703</td>\n",
" <td>2908</td>\n",
" <td>65</td>\n",
" <td>37</td>\n",
" <td>102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0500000US01007</td>\n",
" <td>1007</td>\n",
" <td>Bibb County, Alabama</td>\n",
" <td>5677</td>\n",
" <td>594</td>\n",
" <td>3789</td>\n",
" <td>401</td>\n",
" <td>594</td>\n",
" <td>198</td>\n",
" <td>209</td>\n",
" <td>...</td>\n",
" <td>11</td>\n",
" <td>17</td>\n",
" <td>36</td>\n",
" <td>36</td>\n",
" <td>5677</td>\n",
" <td>3789</td>\n",
" <td>1888</td>\n",
" <td>2</td>\n",
" <td>93</td>\n",
" <td>95</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0500000US01009</td>\n",
" <td>1009</td>\n",
" <td>Blount County, Alabama</td>\n",
" <td>16722</td>\n",
" <td>679</td>\n",
" <td>10030</td>\n",
" <td>440</td>\n",
" <td>2308</td>\n",
" <td>342</td>\n",
" <td>1251</td>\n",
" <td>...</td>\n",
" <td>99</td>\n",
" <td>84</td>\n",
" <td>123</td>\n",
" <td>67</td>\n",
" <td>16722</td>\n",
" <td>10030</td>\n",
" <td>6692</td>\n",
" <td>215</td>\n",
" <td>21</td>\n",
" <td>236</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 155 columns</p>\n",
"</div>"
],
"text/plain": [
" GEO.id GEO.id2 GEO.display-label HD01_VD01 HD02_VD01 \\\n",
"0 0500000US01001 1001 Autauga County, Alabama 18071 647 \n",
"1 0500000US01003 1003 Baldwin County, Alabama 56669 1337 \n",
"2 0500000US01005 1005 Barbour County, Alabama 6611 419 \n",
"3 0500000US01007 1007 Bibb County, Alabama 5677 594 \n",
"4 0500000US01009 1009 Blount County, Alabama 16722 679 \n",
"\n",
" HD01_VD02 HD02_VD02 HD01_VD03 HD02_VD03 HD01_VD04 ... \\\n",
"0 10043 428 3244 409 1772 ... \n",
"1 32671 904 10946 758 5783 ... \n",
"2 3703 318 864 165 336 ... \n",
"3 3789 401 594 198 209 ... \n",
"4 10030 440 2308 342 1251 ... \n",
"\n",
" HD01_VD72 HD02_VD72 HD01_VD73 HD02_VD73 Total Peoples Total Dudes \\\n",
"0 24 22 46 34 18071 10043 \n",
"1 172 86 181 114 56669 32671 \n",
"2 33 32 12 13 6611 3703 \n",
"3 11 17 36 36 5677 3789 \n",
"4 99 84 123 67 16722 10030 \n",
"\n",
" Total Ladies Total Tech Dudes Total Tech Ladies Total Tech Peoples \n",
"0 8028 410 135 545 \n",
"1 23998 778 182 960 \n",
"2 2908 65 37 102 \n",
"3 1888 2 93 95 \n",
"4 6692 215 21 236 \n",
"\n",
"[5 rows x 155 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.head()"
]
},
{
"cell_type": "code",
"execution_count": 6,
"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>GEO.display-label</th>\n",
" <th>Total Tech Peoples</th>\n",
" <th>Total Tech Ladies</th>\n",
" <th>Total Tech Dudes</th>\n",
" <th>Total Peoples</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>204</th>\n",
" <td>Los Angeles County, California</td>\n",
" <td>74847</td>\n",
" <td>17753</td>\n",
" <td>57094</td>\n",
" <td>3021803</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228</th>\n",
" <td>Santa Clara County, California</td>\n",
" <td>68385</td>\n",
" <td>14301</td>\n",
" <td>54084</td>\n",
" <td>600114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2970</th>\n",
" <td>King County, Washington</td>\n",
" <td>66398</td>\n",
" <td>12723</td>\n",
" <td>53675</td>\n",
" <td>703694</td>\n",
" </tr>\n",
" <tr>\n",
" <th>610</th>\n",
" <td>Cook County, Illinois</td>\n",
" <td>58424</td>\n",
" <td>15549</td>\n",
" <td>42875</td>\n",
" <td>1671089</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2848</th>\n",
" <td>Fairfax County, Virginia</td>\n",
" <td>51435</td>\n",
" <td>14047</td>\n",
" <td>37388</td>\n",
" <td>437077</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103</th>\n",
" <td>Maricopa County, Arizona</td>\n",
" <td>46733</td>\n",
" <td>11652</td>\n",
" <td>35081</td>\n",
" <td>1224513</td>\n",
" </tr>\n",
" <tr>\n",
" <th>222</th>\n",
" <td>San Diego County, California</td>\n",
" <td>41829</td>\n",
" <td>9163</td>\n",
" <td>32666</td>\n",
" <td>929007</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1225</th>\n",
" <td>Middlesex County, Massachusetts</td>\n",
" <td>41293</td>\n",
" <td>9858</td>\n",
" <td>31435</td>\n",
" <td>545793</td>\n",
" </tr>\n",
" <tr>\n",
" <th>215</th>\n",
" <td>Orange County, California</td>\n",
" <td>38212</td>\n",
" <td>8149</td>\n",
" <td>30063</td>\n",
" <td>980965</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2623</th>\n",
" <td>Harris County, Texas</td>\n",
" <td>38093</td>\n",
" <td>9448</td>\n",
" <td>28645</td>\n",
" <td>1439608</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>Alameda County, California</td>\n",
" <td>36260</td>\n",
" <td>8764</td>\n",
" <td>27496</td>\n",
" <td>491160</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1207</th>\n",
" <td>Montgomery County, Maryland</td>\n",
" <td>31252</td>\n",
" <td>9209</td>\n",
" <td>22043</td>\n",
" <td>379164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2579</th>\n",
" <td>Dallas County, Texas</td>\n",
" <td>28814</td>\n",
" <td>7096</td>\n",
" <td>21718</td>\n",
" <td>842845</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1981</th>\n",
" <td>Wake County, North Carolina</td>\n",
" <td>26738</td>\n",
" <td>6157</td>\n",
" <td>20581</td>\n",
" <td>333294</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2565</th>\n",
" <td>Collin County, Texas</td>\n",
" <td>26058</td>\n",
" <td>6448</td>\n",
" <td>19610</td>\n",
" <td>314880</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1340</th>\n",
" <td>Hennepin County, Minnesota</td>\n",
" <td>25360</td>\n",
" <td>5832</td>\n",
" <td>19528</td>\n",
" <td>421740</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2749</th>\n",
" <td>Travis County, Texas</td>\n",
" <td>24905</td>\n",
" <td>5332</td>\n",
" <td>19573</td>\n",
" <td>395686</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1785</th>\n",
" <td>Middlesex County, New Jersey</td>\n",
" <td>24592</td>\n",
" <td>5607</td>\n",
" <td>18985</td>\n",
" <td>284473</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1851</th>\n",
" <td>Kings County, New York</td>\n",
" <td>23349</td>\n",
" <td>6069</td>\n",
" <td>17280</td>\n",
" <td>801850</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2742</th>\n",
" <td>Tarrant County, Texas</td>\n",
" <td>22455</td>\n",
" <td>5669</td>\n",
" <td>16786</td>\n",
" <td>652586</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223</th>\n",
" <td>San Francisco County, California</td>\n",
" <td>22140</td>\n",
" <td>4660</td>\n",
" <td>17480</td>\n",
" <td>313255</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1858</th>\n",
" <td>New York County, New York</td>\n",
" <td>21812</td>\n",
" <td>6420</td>\n",
" <td>15392</td>\n",
" <td>623020</td>\n",
" </tr>\n",
" <tr>\n",
" <th>219</th>\n",
" <td>Sacramento County, California</td>\n",
" <td>21602</td>\n",
" <td>7400</td>\n",
" <td>14202</td>\n",
" <td>398793</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1868</th>\n",
" <td>Queens County, New York</td>\n",
" <td>20431</td>\n",
" <td>4889</td>\n",
" <td>15542</td>\n",
" <td>785409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2067</th>\n",
" <td>Franklin County, Ohio</td>\n",
" <td>20294</td>\n",
" <td>5049</td>\n",
" <td>15245</td>\n",
" <td>411009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1208</th>\n",
" <td>Prince George's County, Maryland</td>\n",
" <td>19427</td>\n",
" <td>8462</td>\n",
" <td>10965</td>\n",
" <td>341309</td>\n",
" </tr>\n",
" <tr>\n",
" <th>446</th>\n",
" <td>Fulton County, Georgia</td>\n",
" <td>19108</td>\n",
" <td>4673</td>\n",
" <td>14435</td>\n",
" <td>325269</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1293</th>\n",
" <td>Oakland County, Michigan</td>\n",
" <td>18730</td>\n",
" <td>4563</td>\n",
" <td>14167</td>\n",
" <td>392491</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2872</th>\n",
" <td>Loudoun County, Virginia</td>\n",
" <td>18503</td>\n",
" <td>4571</td>\n",
" <td>13932</td>\n",
" <td>131523</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2537</th>\n",
" <td>Bexar County, Texas</td>\n",
" <td>17903</td>\n",
" <td>4328</td>\n",
" <td>13575</td>\n",
" <td>558867</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1652</th>\n",
" <td>Wibaux County, Montana</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>321</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2883</th>\n",
" <td>Northumberland County, Virginia</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3267</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1656</th>\n",
" <td>Arthur County, Nebraska</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>147</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2715</th>\n",
" <td>Real County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>231</th>\n",
" <td>Sierra County, California</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>630</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2717</th>\n",
" <td>Reeves County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3375</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1706</th>\n",
" <td>Kimball County, Nebraska</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1491</th>\n",
" <td>Bollinger County, Missouri</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3431</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1705</th>\n",
" <td>Keya Paha County, Nebraska</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>297</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1584</th>\n",
" <td>Shelby County, Missouri</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1864</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1651</th>\n",
" <td>Wheatland County, Montana</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>576</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1649</th>\n",
" <td>Treasure County, Montana</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>214</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2694</th>\n",
" <td>Morris County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3306</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2545</th>\n",
" <td>Briscoe County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>530</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1643</th>\n",
" <td>Sheridan County, Montana</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1215</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1456</th>\n",
" <td>Perry County, Mississippi</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2909</td>\n",
" </tr>\n",
" <tr>\n",
" <th>596</th>\n",
" <td>Alexander County, Illinois</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1650</td>\n",
" </tr>\n",
" <tr>\n",
" <th>172</th>\n",
" <td>St. Francis County, Arkansas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6548</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2539</th>\n",
" <td>Borden County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>227</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2918</th>\n",
" <td>Buena Vista city, Virginia</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1906</td>\n",
" </tr>\n",
" <tr>\n",
" <th>175</th>\n",
" <td>Searcy County, Arkansas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1747</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1646</th>\n",
" <td>Sweet Grass County, Montana</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2695</th>\n",
" <td>Motley County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>306</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1460</th>\n",
" <td>Quitman County, Mississippi</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1883</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2535</th>\n",
" <td>Bee County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>7396</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1721</th>\n",
" <td>Perkins County, Nebraska</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2531</th>\n",
" <td>Bailey County, Texas</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2331</td>\n",
" </tr>\n",
" <tr>\n",
" <th>481</th>\n",
" <td>McIntosh County, Georgia</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3647</td>\n",
" </tr>\n",
" <tr>\n",
" <th>187</th>\n",
" <td>Alpine County, California</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>280</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1752</th>\n",
" <td>Eureka County, Nevada</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>551</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3143 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" GEO.display-label Total Tech Peoples Total Tech Ladies \\\n",
"204 Los Angeles County, California 74847 17753 \n",
"228 Santa Clara County, California 68385 14301 \n",
"2970 King County, Washington 66398 12723 \n",
"610 Cook County, Illinois 58424 15549 \n",
"2848 Fairfax County, Virginia 51435 14047 \n",
"103 Maricopa County, Arizona 46733 11652 \n",
"222 San Diego County, California 41829 9163 \n",
"1225 Middlesex County, Massachusetts 41293 9858 \n",
"215 Orange County, California 38212 8149 \n",
"2623 Harris County, Texas 38093 9448 \n",
"186 Alameda County, California 36260 8764 \n",
"1207 Montgomery County, Maryland 31252 9209 \n",
"2579 Dallas County, Texas 28814 7096 \n",
"1981 Wake County, North Carolina 26738 6157 \n",
"2565 Collin County, Texas 26058 6448 \n",
"1340 Hennepin County, Minnesota 25360 5832 \n",
"2749 Travis County, Texas 24905 5332 \n",
"1785 Middlesex County, New Jersey 24592 5607 \n",
"1851 Kings County, New York 23349 6069 \n",
"2742 Tarrant County, Texas 22455 5669 \n",
"223 San Francisco County, California 22140 4660 \n",
"1858 New York County, New York 21812 6420 \n",
"219 Sacramento County, California 21602 7400 \n",
"1868 Queens County, New York 20431 4889 \n",
"2067 Franklin County, Ohio 20294 5049 \n",
"1208 Prince George's County, Maryland 19427 8462 \n",
"446 Fulton County, Georgia 19108 4673 \n",
"1293 Oakland County, Michigan 18730 4563 \n",
"2872 Loudoun County, Virginia 18503 4571 \n",
"2537 Bexar County, Texas 17903 4328 \n",
"... ... ... ... \n",
"1652 Wibaux County, Montana 0 0 \n",
"2883 Northumberland County, Virginia 0 0 \n",
"1656 Arthur County, Nebraska 0 0 \n",
"2715 Real County, Texas 0 0 \n",
"231 Sierra County, California 0 0 \n",
"2717 Reeves County, Texas 0 0 \n",
"1706 Kimball County, Nebraska 0 0 \n",
"1491 Bollinger County, Missouri 0 0 \n",
"1705 Keya Paha County, Nebraska 0 0 \n",
"1584 Shelby County, Missouri 0 0 \n",
"1651 Wheatland County, Montana 0 0 \n",
"1649 Treasure County, Montana 0 0 \n",
"2694 Morris County, Texas 0 0 \n",
"2545 Briscoe County, Texas 0 0 \n",
"1643 Sheridan County, Montana 0 0 \n",
"1456 Perry County, Mississippi 0 0 \n",
"596 Alexander County, Illinois 0 0 \n",
"172 St. Francis County, Arkansas 0 0 \n",
"2539 Borden County, Texas 0 0 \n",
"2918 Buena Vista city, Virginia 0 0 \n",
"175 Searcy County, Arkansas 0 0 \n",
"1646 Sweet Grass County, Montana 0 0 \n",
"2695 Motley County, Texas 0 0 \n",
"1460 Quitman County, Mississippi 0 0 \n",
"2535 Bee County, Texas 0 0 \n",
"1721 Perkins County, Nebraska 0 0 \n",
"2531 Bailey County, Texas 0 0 \n",
"481 McIntosh County, Georgia 0 0 \n",
"187 Alpine County, California 0 0 \n",
"1752 Eureka County, Nevada 0 0 \n",
"\n",
" Total Tech Dudes Total Peoples \n",
"204 57094 3021803 \n",
"228 54084 600114 \n",
"2970 53675 703694 \n",
"610 42875 1671089 \n",
"2848 37388 437077 \n",
"103 35081 1224513 \n",
"222 32666 929007 \n",
"1225 31435 545793 \n",
"215 30063 980965 \n",
"2623 28645 1439608 \n",
"186 27496 491160 \n",
"1207 22043 379164 \n",
"2579 21718 842845 \n",
"1981 20581 333294 \n",
"2565 19610 314880 \n",
"1340 19528 421740 \n",
"2749 19573 395686 \n",
"1785 18985 284473 \n",
"1851 17280 801850 \n",
"2742 16786 652586 \n",
"223 17480 313255 \n",
"1858 15392 623020 \n",
"219 14202 398793 \n",
"1868 15542 785409 \n",
"2067 15245 411009 \n",
"1208 10965 341309 \n",
"446 14435 325269 \n",
"1293 14167 392491 \n",
"2872 13932 131523 \n",
"2537 13575 558867 \n",
"... ... ... \n",
"1652 0 321 \n",
"2883 0 3267 \n",
"1656 0 147 \n",
"2715 0 684 \n",
"231 0 630 \n",
"2717 0 3375 \n",
"1706 0 1250 \n",
"1491 0 3431 \n",
"1705 0 297 \n",
"1584 0 1864 \n",
"1651 0 576 \n",
"1649 0 214 \n",
"2694 0 3306 \n",
"2545 0 530 \n",
"1643 0 1215 \n",
"1456 0 2909 \n",
"596 0 1650 \n",
"172 0 6548 \n",
"2539 0 227 \n",
"2918 0 1906 \n",
"175 0 1747 \n",
"1646 0 1232 \n",
"2695 0 306 \n",
"1460 0 1883 \n",
"2535 0 7396 \n",
"1721 0 1158 \n",
"2531 0 2331 \n",
"481 0 3647 \n",
"187 0 280 \n",
"1752 0 551 \n",
"\n",
"[3143 rows x 5 columns]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.sort(\"Total Tech Peoples\",ascending=False)[[\"GEO.display-label\",\"Total Tech Peoples\",\"Total Tech Ladies\",\"Total Tech Dudes\", \"Total Peoples\"]]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data[\"Tech Peoples Per Population\"]=data[\"Total Tech Peoples\"]/data[\"Total Peoples\"]"
]
},
{
"cell_type": "code",
"execution_count": 8,
"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>GEO.display-label</th>\n",
" <th>Tech Peoples Per Population</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2872</th>\n",
" <td>Loudoun County, Virginia</td>\n",
" <td>0.140683</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2848</th>\n",
" <td>Fairfax County, Virginia</td>\n",
" <td>0.117679</td>\n",
" </tr>\n",
" <tr>\n",
" <th>228</th>\n",
" <td>Santa Clara County, California</td>\n",
" <td>0.113953</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1205</th>\n",
" <td>Howard County, Maryland</td>\n",
" <td>0.112533</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2926</th>\n",
" <td>Falls Church city, Virginia</td>\n",
" <td>0.104673</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2868</th>\n",
" <td>King George County, Virginia</td>\n",
" <td>0.101086</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2925</th>\n",
" <td>Fairfax city, Virginia</td>\n",
" <td>0.099525</td>\n",
" </tr>\n",
" <tr>\n",
" <th>651</th>\n",
" <td>McLean County, Illinois</td>\n",
" <td>0.099179</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2826</th>\n",
" <td>Arlington County, Virginia</td>\n",
" <td>0.097733</td>\n",
" </tr>\n",
" <tr>\n",
" <th>251</th>\n",
" <td>Broomfield County, Colorado</td>\n",
" <td>0.097452</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2970</th>\n",
" <td>King County, Washington</td>\n",
" <td>0.094356</td>\n",
" </tr>\n",
" <tr>\n",
" <th>444</th>\n",
" <td>Forsyth County, Georgia</td>\n",
" <td>0.087348</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1785</th>\n",
" <td>Middlesex County, New Jersey</td>\n",
" <td>0.086448</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2892</th>\n",
" <td>Prince William County, Virginia</td>\n",
" <td>0.085958</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2905</th>\n",
" <td>Stafford County, Virginia</td>\n",
" <td>0.085435</td>\n",
" </tr>\n",
" <tr>\n",
" <th>250</th>\n",
" <td>Boulder County, Colorado</td>\n",
" <td>0.084262</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2565</th>\n",
" <td>Collin County, Texas</td>\n",
" <td>0.082755</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1207</th>\n",
" <td>Montgomery County, Maryland</td>\n",
" <td>0.082423</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2768</th>\n",
" <td>Williamson County, Texas</td>\n",
" <td>0.080417</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1981</th>\n",
" <td>Wake County, North Carolina</td>\n",
" <td>0.080223</td>\n",
" </tr>\n",
" <tr>\n",
" <th>262</th>\n",
" <td>Douglas County, Colorado</td>\n",
" <td>0.080173</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1791</th>\n",
" <td>Somerset County, New Jersey</td>\n",
" <td>0.079756</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2915</th>\n",
" <td>Alexandria city, Virginia</td>\n",
" <td>0.078819</td>\n",
" </tr>\n",
" <tr>\n",
" <th>264</th>\n",
" <td>Elbert County, Colorado</td>\n",
" <td>0.076514</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1194</th>\n",
" <td>Anne Arundel County, Maryland</td>\n",
" <td>0.076372</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1225</th>\n",
" <td>Middlesex County, Massachusetts</td>\n",
" <td>0.075657</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>Madison County, Alabama</td>\n",
" <td>0.075203</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>Alameda County, California</td>\n",
" <td>0.073825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>223</th>\n",
" <td>San Francisco County, California</td>\n",
" <td>0.070677</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2849</th>\n",
" <td>Fauquier County, Virginia</td>\n",
" <td>0.070628</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2883</th>\n",
" <td>Northumberland County, Virginia</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1721</th>\n",
" <td>Perkins County, Nebraska</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2644</th>\n",
" <td>Jeff Davis County, Texas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1710</th>\n",
" <td>Logan County, Nebraska</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1452</th>\n",
" <td>Noxubee County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159</th>\n",
" <td>Montgomery County, Arkansas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1456</th>\n",
" <td>Perry County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1460</th>\n",
" <td>Quitman County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1706</th>\n",
" <td>Kimball County, Nebraska</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>149</th>\n",
" <td>Lee County, Arkansas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1433</th>\n",
" <td>Jefferson Davis County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1432</th>\n",
" <td>Jefferson County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1754</th>\n",
" <td>Lander County, Nevada</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1411</th>\n",
" <td>Claiborne County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2918</th>\n",
" <td>Buena Vista city, Virginia</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>779</th>\n",
" <td>Vermillion County, Indiana</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2591</th>\n",
" <td>Edwards County, Texas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1759</th>\n",
" <td>Pershing County, Nevada</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1757</th>\n",
" <td>Mineral County, Nevada</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2600</th>\n",
" <td>Foard County, Texas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1752</th>\n",
" <td>Eureka County, Nevada</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1741</th>\n",
" <td>Valley County, Nebraska</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>141</th>\n",
" <td>Howard County, Arkansas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1751</th>\n",
" <td>Esmeralda County, Nevada</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1421</th>\n",
" <td>Greene County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2605</th>\n",
" <td>Gaines County, Texas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2609</th>\n",
" <td>Glasscock County, Texas</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1745</th>\n",
" <td>Wheeler County, Nebraska</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1428</th>\n",
" <td>Issaquena County, Mississippi</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>814</th>\n",
" <td>Davis County, Iowa</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3143 rows × 2 columns</p>\n",
"</div>"
],
"text/plain": [
" GEO.display-label Tech Peoples Per Population\n",
"2872 Loudoun County, Virginia 0.140683\n",
"2848 Fairfax County, Virginia 0.117679\n",
"228 Santa Clara County, California 0.113953\n",
"1205 Howard County, Maryland 0.112533\n",
"2926 Falls Church city, Virginia 0.104673\n",
"2868 King George County, Virginia 0.101086\n",
"2925 Fairfax city, Virginia 0.099525\n",
"651 McLean County, Illinois 0.099179\n",
"2826 Arlington County, Virginia 0.097733\n",
"251 Broomfield County, Colorado 0.097452\n",
"2970 King County, Washington 0.094356\n",
"444 Forsyth County, Georgia 0.087348\n",
"1785 Middlesex County, New Jersey 0.086448\n",
"2892 Prince William County, Virginia 0.085958\n",
"2905 Stafford County, Virginia 0.085435\n",
"250 Boulder County, Colorado 0.084262\n",
"2565 Collin County, Texas 0.082755\n",
"1207 Montgomery County, Maryland 0.082423\n",
"2768 Williamson County, Texas 0.080417\n",
"1981 Wake County, North Carolina 0.080223\n",
"262 Douglas County, Colorado 0.080173\n",
"1791 Somerset County, New Jersey 0.079756\n",
"2915 Alexandria city, Virginia 0.078819\n",
"264 Elbert County, Colorado 0.076514\n",
"1194 Anne Arundel County, Maryland 0.076372\n",
"1225 Middlesex County, Massachusetts 0.075657\n",
"44 Madison County, Alabama 0.075203\n",
"186 Alameda County, California 0.073825\n",
"223 San Francisco County, California 0.070677\n",
"2849 Fauquier County, Virginia 0.070628\n",
"... ... ...\n",
"2883 Northumberland County, Virginia 0.000000\n",
"1721 Perkins County, Nebraska 0.000000\n",
"2644 Jeff Davis County, Texas 0.000000\n",
"1710 Logan County, Nebraska 0.000000\n",
"1452 Noxubee County, Mississippi 0.000000\n",
"159 Montgomery County, Arkansas 0.000000\n",
"1456 Perry County, Mississippi 0.000000\n",
"1460 Quitman County, Mississippi 0.000000\n",
"1706 Kimball County, Nebraska 0.000000\n",
"149 Lee County, Arkansas 0.000000\n",
"1433 Jefferson Davis County, Mississippi 0.000000\n",
"1432 Jefferson County, Mississippi 0.000000\n",
"1754 Lander County, Nevada 0.000000\n",
"1411 Claiborne County, Mississippi 0.000000\n",
"2918 Buena Vista city, Virginia 0.000000\n",
"779 Vermillion County, Indiana 0.000000\n",
"2591 Edwards County, Texas 0.000000\n",
"1759 Pershing County, Nevada 0.000000\n",
"1757 Mineral County, Nevada 0.000000\n",
"2600 Foard County, Texas 0.000000\n",
"1752 Eureka County, Nevada 0.000000\n",
"1741 Valley County, Nebraska 0.000000\n",
"141 Howard County, Arkansas 0.000000\n",
"1751 Esmeralda County, Nevada 0.000000\n",
"1421 Greene County, Mississippi 0.000000\n",
"2605 Gaines County, Texas 0.000000\n",
"2609 Glasscock County, Texas 0.000000\n",
"1745 Wheeler County, Nebraska 0.000000\n",
"1428 Issaquena County, Mississippi 0.000000\n",
"814 Davis County, Iowa 0.000000\n",
"\n",
"[3143 rows x 2 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.sort(\"Tech Peoples Per Population\",ascending=False)[[\"GEO.display-label\",\"Tech Peoples Per Population\"]]"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"df_la=data.ix[data[\"GEO.display-label\"]==\"Los Angeles County, California\",[\"GEO.display-label\",\"Total Peoples\",\"Total Tech Peoples\"]]\n",
"df_la[\"Proportion\"]=df_la[\"Total Tech Peoples\"]/df_la[\"Total Peoples\"]"
]
},
{
"cell_type": "code",
"execution_count": 30,
"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>GEO.display-label</th>\n",
" <th>Total Peoples</th>\n",
" <th>Total Tech Peoples</th>\n",
" <th>Proportion</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>204</th>\n",
" <td>Los Angeles County, California</td>\n",
" <td>3021803</td>\n",
" <td>74847</td>\n",
" <td>0.024769</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" GEO.display-label Total Peoples Total Tech Peoples \\\n",
"204 Los Angeles County, California 3021803 74847 \n",
"\n",
" Proportion \n",
"204 0.024769 "
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_la"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"df=data.ix[data[\"GEO.display-label\"].isin([\"Santa Clara County, California\", \"San Mateo County, California\",\"San Francisco County, California\"]),[\"GEO.display-label\",\"Total Peoples\",\"Total Tech Peoples\"]]\n",
"df=df.append(df.sum(), ignore_index=True)\n",
"df[\"Proportion\"]=df[\"Total Tech Peoples\"]/df[\"Total Peoples\"]"
]
},
{
"cell_type": "code",
"execution_count": 39,
"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>GEO.display-label</th>\n",
" <th>Total Peoples</th>\n",
" <th>Total Tech Peoples</th>\n",
" <th>Proportion</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>San Francisco County, California</td>\n",
" <td>313255</td>\n",
" <td>22140</td>\n",
" <td>0.070677</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>San Mateo County, California</td>\n",
" <td>254912</td>\n",
" <td>15116</td>\n",
" <td>0.059299</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Santa Clara County, California</td>\n",
" <td>600114</td>\n",
" <td>68385</td>\n",
" <td>0.113953</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>San Francisco County, CaliforniaSan Mateo Coun...</td>\n",
" <td>1168281</td>\n",
" <td>105641</td>\n",
" <td>0.090424</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" GEO.display-label Total Peoples \\\n",
"0 San Francisco County, California 313255 \n",
"1 San Mateo County, California 254912 \n",
"2 Santa Clara County, California 600114 \n",
"3 San Francisco County, CaliforniaSan Mateo Coun... 1168281 \n",
"\n",
" Total Tech Peoples Proportion \n",
"0 22140 0.070677 \n",
"1 15116 0.059299 \n",
"2 68385 0.113953 \n",
"3 105641 0.090424 "
]
},
"execution_count": 39,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 42,
"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>GEO.display-label</th>\n",
" <th>Total Peoples</th>\n",
" <th>Total Tech Peoples</th>\n",
" <th>Proportion</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Bronx County, New York</td>\n",
" <td>386589</td>\n",
" <td>4598</td>\n",
" <td>0.011894</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Kings County, New York</td>\n",
" <td>801850</td>\n",
" <td>23349</td>\n",
" <td>0.029119</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>New York County, New York</td>\n",
" <td>623020</td>\n",
" <td>21812</td>\n",
" <td>0.035010</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Queens County, New York</td>\n",
" <td>785409</td>\n",
" <td>20431</td>\n",
" <td>0.026013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Richmond County, New York</td>\n",
" <td>155476</td>\n",
" <td>4481</td>\n",
" <td>0.028821</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Bronx County, New YorkKings County, New YorkNe...</td>\n",
" <td>2752344</td>\n",
" <td>74671</td>\n",
" <td>0.027130</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" GEO.display-label Total Peoples \\\n",
"0 Bronx County, New York 386589 \n",
"1 Kings County, New York 801850 \n",
"2 New York County, New York 623020 \n",
"3 Queens County, New York 785409 \n",
"4 Richmond County, New York 155476 \n",
"5 Bronx County, New YorkKings County, New YorkNe... 2752344 \n",
"\n",
" Total Tech Peoples Proportion \n",
"0 4598 0.011894 \n",
"1 23349 0.029119 \n",
"2 21812 0.035010 \n",
"3 20431 0.026013 \n",
"4 4481 0.028821 \n",
"5 74671 0.027130 "
]
},
"execution_count": 42,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_ny=data.ix[data[\"GEO.display-label\"].isin([\"Kings County, New York\", \"Queens County, New York\",\"New York County, New York\",\"Bronx County, New York\",\"Richmond County, New York\"]),[\"GEO.display-label\",\"Total Peoples\",\"Total Tech Peoples\"]]\n",
"df_ny=df_ny.append(df_ny.sum(), ignore_index=True)\n",
"df_ny[\"Proportion\"]=df_ny[\"Total Tech Peoples\"]/df_ny[\"Total Peoples\"]\n",
"df_ny"
]
},
{
"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