Skip to content

Instantly share code, notes, and snippets.

@colliand

colliand/womens-march-crowd-estimates.ipynb

Last active January 23, 2017 06:04
Show Gist options
  • Save colliand/e2870193c07d1dfb30a0792b93494562 to your computer and use it in GitHub Desktop.
Save colliand/e2870193c07d1dfb30a0792b93494562 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
womens-march-crowd-estimates.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"## 2017-01-21 Women's March: Crowdmark Estimates\n",
"\n",
"This Jupyter Notebook starts some basic analysis of the data on this public google document built by [@EricaChenoweth](https://twitter.com/EricaChenoweth) and [@djpressman](https://twitter.com/djpressman).\n",
"\n",
"[google doc](https://docs.google.com/spreadsheets/d/1xa0iLqYKz8x9Yc_rfhtmSOJQ2EGgeUVjvV4A8LsIaxY/htmlview?sle=true#gid=0)"
]
},
{
"cell_type": "code",
"execution_count": 70,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt "
]
},
{
"cell_type": "code",
"execution_count": 71,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data = pd.read_csv('https://docs.google.com/spreadsheets/d/1xa0iLqYKz8x9Yc_rfhtmSOJQ2EGgeUVjvV4A8LsIaxY/export?format=csv&id'\n",
" , names=['Location','State','Country','Estimate1','Estimate2','Estimate3','Not1/21','Source1','Source2','Source3']\n",
" , skiprows=[0,1,2,3,4,5]\n",
" , thousands=',')"
]
},
{
"cell_type": "code",
"execution_count": 73,
"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>Location</th>\n",
" <th>State</th>\n",
" <th>Country</th>\n",
" <th>Estimate1</th>\n",
" <th>Estimate2</th>\n",
" <th>Estimate3</th>\n",
" <th>Not1/21</th>\n",
" <th>Source1</th>\n",
" <th>Source2</th>\n",
" <th>Source3</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Abilene, TX</td>\n",
" <td>TX</td>\n",
" <td>US</td>\n",
" <td>200.0</td>\n",
" <td>200.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.reporternews.com/story/news/local/2...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Accident, MD</td>\n",
" <td>MD</td>\n",
" <td>US</td>\n",
" <td>54.0</td>\n",
" <td>54.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Twitter; on-site witness</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Adak, AK</td>\n",
" <td>AK</td>\n",
" <td>US</td>\n",
" <td>10.0</td>\n",
" <td>10.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>adn.com</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Adrian, MI</td>\n",
" <td>MI</td>\n",
" <td>US</td>\n",
" <td>130.0</td>\n",
" <td>150.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://www.facebook.com/events/847360115406578/</td>\n",
" <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Ajo, AZ</td>\n",
" <td>AZ</td>\n",
" <td>US</td>\n",
" <td>250.0</td>\n",
" <td>250.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://www.facebook.com/plugins/post.php?href...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Alameda, CA</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>8.0</td>\n",
" <td>8.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>FB</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Alamosa, CO</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>350.0</td>\n",
" <td>350.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/zepol/status/8232349739352...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Albany, CA</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>500.0</td>\n",
" <td>500.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/ben_silverman/status/82303...</td>\n",
" <td>Albany PD (reported via google form)</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Albany, NY</td>\n",
" <td>NY</td>\n",
" <td>US</td>\n",
" <td>7000.0</td>\n",
" <td>9000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.timesunion.com/local/article/Albany...</td>\n",
" <td>FB</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Alexandria, VA</td>\n",
" <td>VA</td>\n",
" <td>US</td>\n",
" <td>17.0</td>\n",
" <td>17.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/TinaPStacy/status/82322604...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Albuquerque, NM</td>\n",
" <td>NM</td>\n",
" <td>US</td>\n",
" <td>3000.0</td>\n",
" <td>20000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.koat.com/article/thousands-fill-civ...</td>\n",
" <td>https://twitter.com/PatDavisNM/status/82293149...</td>\n",
" <td>https://twitter.com/AthertonKD/status/82321516...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Almanor West, CA</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>4.0</td>\n",
" <td>4.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>eyewitness; picture</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Alpine, TX</td>\n",
" <td>TX</td>\n",
" <td>US</td>\n",
" <td>96.0</td>\n",
" <td>96.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/sarahmvasquez/status/82318...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Amarillo, TX</td>\n",
" <td>TX</td>\n",
" <td>US</td>\n",
" <td>600.0</td>\n",
" <td>600.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://www.texastribune.org/2017/01/21/thousa...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Amelia Island, FL</td>\n",
" <td>FL</td>\n",
" <td>US</td>\n",
" <td>700.0</td>\n",
" <td>1300.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.firstcoastnews.com/news/womens-marc...</td>\n",
" <td>https://twitter.com/wideofthepost/status/82307...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Anacortes, WA</td>\n",
" <td>WA</td>\n",
" <td>US</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>200.0</td>\n",
" <td>http://www.goskagit.com/skagit/hundreds-partic...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Anchorage, AK</td>\n",
" <td>AK</td>\n",
" <td>US</td>\n",
" <td>2000.0</td>\n",
" <td>3000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://www.adn.com/alaska-news/2017/01/21/lar...</td>\n",
" <td>https://twitter.com/julia_omalley/status/82290...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Ann Arbor, MI</td>\n",
" <td>MI</td>\n",
" <td>US</td>\n",
" <td>11000.0</td>\n",
" <td>11000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.mlive.com/news/ann-arbor/index.ssf/...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Annapolis, MD</td>\n",
" <td>MD</td>\n",
" <td>US</td>\n",
" <td>1600.0</td>\n",
" <td>1600.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.capitalgazette.com/news/annapolis/p...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Arlington, VA</td>\n",
" <td>VA</td>\n",
" <td>US</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Asbury Park, NJ</td>\n",
" <td>NJ</td>\n",
" <td>US</td>\n",
" <td>6000.0</td>\n",
" <td>6000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/JuliaJHobbs/status/8229551...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Asheville, NC</td>\n",
" <td>NC</td>\n",
" <td>US</td>\n",
" <td>7000.0</td>\n",
" <td>10000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
" <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Ashland, OR</td>\n",
" <td>OR</td>\n",
" <td>US</td>\n",
" <td>6000.0</td>\n",
" <td>8000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.mailtribune.com/news/20170121/voice...</td>\n",
" <td>http://ijpr.org/post/southern-oregon-womens-ma...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Aspen, CO</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>1000.0</td>\n",
" <td>1000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/SarahGoTrillIum/status/823...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Astoria, OR</td>\n",
" <td>OR</td>\n",
" <td>US</td>\n",
" <td>100.0</td>\n",
" <td>1000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.dailyastorian.com/Local_News/201701...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Athens, GA</td>\n",
" <td>GA</td>\n",
" <td>US</td>\n",
" <td>700.0</td>\n",
" <td>5000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://onlineathens.com/slideshow/2017-01-21/p...</td>\n",
" <td>FB</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Atlanta, GA</td>\n",
" <td>GA</td>\n",
" <td>US</td>\n",
" <td>60000.0</td>\n",
" <td>63000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.ajc.com/news/state--regional-govt--...</td>\n",
" <td>http://www.nbcnews.com/storyline/inauguration-...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Augusta, GA</td>\n",
" <td>GA</td>\n",
" <td>US</td>\n",
" <td>600.0</td>\n",
" <td>600.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://chronicle.augusta.com/news/2017-01-21/h...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Augusta, ME</td>\n",
" <td>ME</td>\n",
" <td>US</td>\n",
" <td>10000.0</td>\n",
" <td>10000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://bangordailynews.com/2017/01/21/news/sta...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Austin, TX</td>\n",
" <td>TX</td>\n",
" <td>US</td>\n",
" <td>30000.0</td>\n",
" <td>50000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://kut.org/post/tens-thousands-participate...</td>\n",
" <td>http://www.statesman.com/news/local/police-000...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>631</th>\n",
" <td>Saskatoon, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>800.0</td>\n",
" <td>1000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://thestarphoenix.com/storyline/hundreds-m...</td>\n",
" <td>https://twitter.com/m_cvb/status/8230754311967...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>632</th>\n",
" <td>North West River, Labrador, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>20.0</td>\n",
" <td>20.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/amybeatrice/status/8229007...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>633</th>\n",
" <td>Whitehorse, Yukon, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>100.0</td>\n",
" <td>300.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
" <td>https://twitter.com/dougrutherford/status/8229...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>634</th>\n",
" <td>Yellowknife, NWT, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>100.0</td>\n",
" <td>130.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
" <td>https://twitter.com/TheMooseCJCD/status/822924...</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>635</th>\n",
" <td>Osaka, Japan</td>\n",
" <td>NaN</td>\n",
" <td>Japan</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>90.0</td>\n",
" <td>via email (JP)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>636</th>\n",
" <td>Hanoi, Vietnam</td>\n",
" <td>NaN</td>\n",
" <td>Vietnam</td>\n",
" <td>27.0</td>\n",
" <td>27.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>via email (JP)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>637</th>\n",
" <td>Kassel, Germany</td>\n",
" <td>NaN</td>\n",
" <td>Germany</td>\n",
" <td>100.0</td>\n",
" <td>100.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://www.facebook.com/savkassel/photos/pcb....</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>638</th>\n",
" <td>Aachen, Germany</td>\n",
" <td>NaN</td>\n",
" <td>Germany</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>email/FB</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>639</th>\n",
" <td>Bremerhaven, Germany</td>\n",
" <td>NaN</td>\n",
" <td>Germany</td>\n",
" <td>30.0</td>\n",
" <td>30.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>email/FB</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>640</th>\n",
" <td>Huntsville, Ontario, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>30.0</td>\n",
" <td>30.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://doppleronline.ca/huntsville/sistermarc...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>641</th>\n",
" <td>Lilongwe, Malawi</td>\n",
" <td>NaN</td>\n",
" <td>Malawi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>642</th>\n",
" <td>Stavanger, Norway</td>\n",
" <td>NaN</td>\n",
" <td>Norway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>643</th>\n",
" <td>Isla Mujeres, Mexico</td>\n",
" <td>NaN</td>\n",
" <td>Mexico</td>\n",
" <td>5.0</td>\n",
" <td>5.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>headcount from FB photo</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>644</th>\n",
" <td>Cuenca, Ecuador</td>\n",
" <td>NaN</td>\n",
" <td>Ecuador</td>\n",
" <td>20.0</td>\n",
" <td>50.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://zeromagecuador.com/en/womens-march-in-c...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>645</th>\n",
" <td>Belfast, UK</td>\n",
" <td>NaN</td>\n",
" <td>UK</td>\n",
" <td>200.0</td>\n",
" <td>300.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/ferguskelly/status/8231580...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>646</th>\n",
" <td>Castlebar, Ireland</td>\n",
" <td>NaN</td>\n",
" <td>Ireland</td>\n",
" <td>120.0</td>\n",
" <td>120.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/ClearyConnolly/status/8232...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>647</th>\n",
" <td>Montpellier, France</td>\n",
" <td>NaN</td>\n",
" <td>France</td>\n",
" <td>500.0</td>\n",
" <td>3000.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.midilibre.fr/2017/01/21/montpellier...</td>\n",
" <td>https://twitter.com/marienoellewurm/status/823...</td>\n",
" <td>https://t.co/dYoxYWZ13q</td>\n",
" </tr>\n",
" <tr>\n",
" <th>648</th>\n",
" <td>Guelph, ON, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>545.0</td>\n",
" <td>545.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/l2m2d2/status/823146333095...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>649</th>\n",
" <td>Lusaka, Zambia</td>\n",
" <td>NaN</td>\n",
" <td>Zambia</td>\n",
" <td>140.0</td>\n",
" <td>140.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/ZamWomenMarch/status/82312...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>650</th>\n",
" <td>Songdo, South Korea</td>\n",
" <td>NaN</td>\n",
" <td>South Korea</td>\n",
" <td>25.0</td>\n",
" <td>25.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/jodikittle/status/82310507...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>651</th>\n",
" <td>Shipley, UK</td>\n",
" <td>NaN</td>\n",
" <td>UK</td>\n",
" <td>1400.0</td>\n",
" <td>1400.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/chickpeajones/status/82279...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>652</th>\n",
" <td>Maadi Degla, Cairo, Egypt</td>\n",
" <td>NaN</td>\n",
" <td>Egypt</td>\n",
" <td>4.0</td>\n",
" <td>4.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/ABHodgkins/status/82308134...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>653</th>\n",
" <td>Trondheim, Norway</td>\n",
" <td>NaN</td>\n",
" <td>Norway</td>\n",
" <td>260.0</td>\n",
" <td>260.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>654</th>\n",
" <td>Phnom Penh, Cambodia</td>\n",
" <td>NaN</td>\n",
" <td>Cambodia</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/TheFoolishFish/status/8231...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>655</th>\n",
" <td>Rabat, Morocco</td>\n",
" <td>NaN</td>\n",
" <td>Morocco</td>\n",
" <td>23.0</td>\n",
" <td>23.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>eyewitness onsite (also picture)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>656</th>\n",
" <td>Ajijic, Mexico</td>\n",
" <td>NaN</td>\n",
" <td>Mexico</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>657</th>\n",
" <td>San Pancho (San Francisco), Nayarit, Mexico</td>\n",
" <td>NaN</td>\n",
" <td>Mexico</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>658</th>\n",
" <td>Riga, Latvia</td>\n",
" <td>NaN</td>\n",
" <td>Latvia</td>\n",
" <td>200.0</td>\n",
" <td>200.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>http://www.lsm.lv/en/article/politics/women-ma...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>659</th>\n",
" <td>Oranjestad, Aruba</td>\n",
" <td>NaN</td>\n",
" <td>Aruba</td>\n",
" <td>1.0</td>\n",
" <td>1.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://twitter.com/rymey/status/8233040549358...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>660</th>\n",
" <td>Kingston, ON, Canada</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>661 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" Location State Country \\\n",
"0 Abilene, TX TX US \n",
"1 Accident, MD MD US \n",
"2 Adak, AK AK US \n",
"3 Adrian, MI MI US \n",
"4 Ajo, AZ AZ US \n",
"5 Alameda, CA CA US \n",
"6 Alamosa, CO CO US \n",
"7 Albany, CA CA US \n",
"8 Albany, NY NY US \n",
"9 Alexandria, VA VA US \n",
"10 Albuquerque, NM NM US \n",
"11 Almanor West, CA CA US \n",
"12 Alpine, TX TX US \n",
"13 Amarillo, TX TX US \n",
"14 Amelia Island, FL FL US \n",
"15 Anacortes, WA WA US \n",
"16 Anchorage, AK AK US \n",
"17 Ann Arbor, MI MI US \n",
"18 Annapolis, MD MD US \n",
"19 Arlington, VA VA US \n",
"20 Asbury Park, NJ NJ US \n",
"21 Asheville, NC NC US \n",
"22 Ashland, OR OR US \n",
"23 Aspen, CO CO US \n",
"24 Astoria, OR OR US \n",
"25 Athens, GA GA US \n",
"26 Atlanta, GA GA US \n",
"27 Augusta, GA GA US \n",
"28 Augusta, ME ME US \n",
"29 Austin, TX TX US \n",
".. ... ... ... \n",
"631 Saskatoon, Canada NaN Canada \n",
"632 North West River, Labrador, Canada NaN Canada \n",
"633 Whitehorse, Yukon, Canada NaN Canada \n",
"634 Yellowknife, NWT, Canada NaN Canada \n",
"635 Osaka, Japan NaN Japan \n",
"636 Hanoi, Vietnam NaN Vietnam \n",
"637 Kassel, Germany NaN Germany \n",
"638 Aachen, Germany NaN Germany \n",
"639 Bremerhaven, Germany NaN Germany \n",
"640 Huntsville, Ontario, Canada NaN Canada \n",
"641 Lilongwe, Malawi NaN Malawi \n",
"642 Stavanger, Norway NaN Norway \n",
"643 Isla Mujeres, Mexico NaN Mexico \n",
"644 Cuenca, Ecuador NaN Ecuador \n",
"645 Belfast, UK NaN UK \n",
"646 Castlebar, Ireland NaN Ireland \n",
"647 Montpellier, France NaN France \n",
"648 Guelph, ON, Canada NaN Canada \n",
"649 Lusaka, Zambia NaN Zambia \n",
"650 Songdo, South Korea NaN South Korea \n",
"651 Shipley, UK NaN UK \n",
"652 Maadi Degla, Cairo, Egypt NaN Egypt \n",
"653 Trondheim, Norway NaN Norway \n",
"654 Phnom Penh, Cambodia NaN Cambodia \n",
"655 Rabat, Morocco NaN Morocco \n",
"656 Ajijic, Mexico NaN Mexico \n",
"657 San Pancho (San Francisco), Nayarit, Mexico NaN Mexico \n",
"658 Riga, Latvia NaN Latvia \n",
"659 Oranjestad, Aruba NaN Aruba \n",
"660 Kingston, ON, Canada NaN Canada \n",
"\n",
" Estimate1 Estimate2 Estimate3 Not1/21 \\\n",
"0 200.0 200.0 NaN NaN \n",
"1 54.0 54.0 NaN NaN \n",
"2 10.0 10.0 NaN NaN \n",
"3 130.0 150.0 NaN NaN \n",
"4 250.0 250.0 NaN NaN \n",
"5 8.0 8.0 NaN NaN \n",
"6 350.0 350.0 NaN NaN \n",
"7 500.0 500.0 NaN NaN \n",
"8 7000.0 9000.0 NaN NaN \n",
"9 17.0 17.0 NaN NaN \n",
"10 3000.0 20000.0 NaN NaN \n",
"11 4.0 4.0 NaN NaN \n",
"12 96.0 96.0 NaN NaN \n",
"13 600.0 600.0 NaN NaN \n",
"14 700.0 1300.0 NaN NaN \n",
"15 NaN NaN NaN 200.0 \n",
"16 2000.0 3000.0 NaN NaN \n",
"17 11000.0 11000.0 NaN NaN \n",
"18 1600.0 1600.0 NaN NaN \n",
"19 NaN NaN NaN NaN \n",
"20 6000.0 6000.0 NaN NaN \n",
"21 7000.0 10000.0 NaN NaN \n",
"22 6000.0 8000.0 NaN NaN \n",
"23 1000.0 1000.0 NaN NaN \n",
"24 100.0 1000.0 NaN NaN \n",
"25 700.0 5000.0 NaN NaN \n",
"26 60000.0 63000.0 NaN NaN \n",
"27 600.0 600.0 NaN NaN \n",
"28 10000.0 10000.0 NaN NaN \n",
"29 30000.0 50000.0 NaN NaN \n",
".. ... ... ... ... \n",
"631 800.0 1000.0 NaN NaN \n",
"632 20.0 20.0 NaN NaN \n",
"633 100.0 300.0 NaN NaN \n",
"634 100.0 130.0 NaN NaN \n",
"635 NaN NaN NaN 90.0 \n",
"636 27.0 27.0 NaN NaN \n",
"637 100.0 100.0 NaN NaN \n",
"638 NaN NaN NaN NaN \n",
"639 30.0 30.0 NaN NaN \n",
"640 30.0 30.0 NaN NaN \n",
"641 NaN NaN NaN NaN \n",
"642 NaN NaN NaN NaN \n",
"643 5.0 5.0 NaN NaN \n",
"644 20.0 50.0 NaN NaN \n",
"645 200.0 300.0 NaN NaN \n",
"646 120.0 120.0 NaN NaN \n",
"647 500.0 3000.0 NaN NaN \n",
"648 545.0 545.0 NaN NaN \n",
"649 140.0 140.0 NaN NaN \n",
"650 25.0 25.0 NaN NaN \n",
"651 1400.0 1400.0 NaN NaN \n",
"652 4.0 4.0 NaN NaN \n",
"653 260.0 260.0 NaN NaN \n",
"654 NaN NaN NaN NaN \n",
"655 23.0 23.0 NaN NaN \n",
"656 NaN NaN NaN NaN \n",
"657 NaN NaN NaN NaN \n",
"658 200.0 200.0 NaN NaN \n",
"659 1.0 1.0 NaN NaN \n",
"660 NaN NaN NaN NaN \n",
"\n",
" Source1 \\\n",
"0 http://www.reporternews.com/story/news/local/2... \n",
"1 Twitter; on-site witness \n",
"2 adn.com \n",
"3 https://www.facebook.com/events/847360115406578/ \n",
"4 https://www.facebook.com/plugins/post.php?href... \n",
"5 FB \n",
"6 https://twitter.com/zepol/status/8232349739352... \n",
"7 https://twitter.com/ben_silverman/status/82303... \n",
"8 http://www.timesunion.com/local/article/Albany... \n",
"9 https://twitter.com/TinaPStacy/status/82322604... \n",
"10 http://www.koat.com/article/thousands-fill-civ... \n",
"11 eyewitness; picture \n",
"12 https://twitter.com/sarahmvasquez/status/82318... \n",
"13 https://www.texastribune.org/2017/01/21/thousa... \n",
"14 http://www.firstcoastnews.com/news/womens-marc... \n",
"15 http://www.goskagit.com/skagit/hundreds-partic... \n",
"16 https://www.adn.com/alaska-news/2017/01/21/lar... \n",
"17 http://www.mlive.com/news/ann-arbor/index.ssf/... \n",
"18 http://www.capitalgazette.com/news/annapolis/p... \n",
"19 NaN \n",
"20 https://twitter.com/JuliaJHobbs/status/8229551... \n",
"21 http://wlos.com/news/local/photo-gallery-the-w... \n",
"22 http://www.mailtribune.com/news/20170121/voice... \n",
"23 https://twitter.com/SarahGoTrillIum/status/823... \n",
"24 http://www.dailyastorian.com/Local_News/201701... \n",
"25 http://onlineathens.com/slideshow/2017-01-21/p... \n",
"26 http://www.ajc.com/news/state--regional-govt--... \n",
"27 http://chronicle.augusta.com/news/2017-01-21/h... \n",
"28 http://bangordailynews.com/2017/01/21/news/sta... \n",
"29 http://kut.org/post/tens-thousands-participate... \n",
".. ... \n",
"631 http://thestarphoenix.com/storyline/hundreds-m... \n",
"632 https://twitter.com/amybeatrice/status/8229007... \n",
"633 http://www.cbc.ca/news/canada/north/yellowknif... \n",
"634 http://www.cbc.ca/news/canada/north/yellowknif... \n",
"635 via email (JP) \n",
"636 via email (JP) \n",
"637 https://www.facebook.com/savkassel/photos/pcb.... \n",
"638 email/FB \n",
"639 email/FB \n",
"640 https://doppleronline.ca/huntsville/sistermarc... \n",
"641 NaN \n",
"642 NaN \n",
"643 headcount from FB photo \n",
"644 http://zeromagecuador.com/en/womens-march-in-c... \n",
"645 https://twitter.com/ferguskelly/status/8231580... \n",
"646 https://twitter.com/ClearyConnolly/status/8232... \n",
"647 http://www.midilibre.fr/2017/01/21/montpellier... \n",
"648 https://twitter.com/l2m2d2/status/823146333095... \n",
"649 https://twitter.com/ZamWomenMarch/status/82312... \n",
"650 https://twitter.com/jodikittle/status/82310507... \n",
"651 https://twitter.com/chickpeajones/status/82279... \n",
"652 https://twitter.com/ABHodgkins/status/82308134... \n",
"653 http://www.adressa.no/nyheter/trondheim/2017/0... \n",
"654 https://twitter.com/TheFoolishFish/status/8231... \n",
"655 eyewitness onsite (also picture) \n",
"656 NaN \n",
"657 NaN \n",
"658 http://www.lsm.lv/en/article/politics/women-ma... \n",
"659 https://twitter.com/rymey/status/8233040549358... \n",
"660 NaN \n",
"\n",
" Source2 \\\n",
"0 NaN \n",
"1 NaN \n",
"2 NaN \n",
"3 http://www.lenconnect.com/news/20170122/marche... \n",
"4 NaN \n",
"5 NaN \n",
"6 NaN \n",
"7 Albany PD (reported via google form) \n",
"8 FB \n",
"9 NaN \n",
"10 https://twitter.com/PatDavisNM/status/82293149... \n",
"11 NaN \n",
"12 NaN \n",
"13 NaN \n",
"14 https://twitter.com/wideofthepost/status/82307... \n",
"15 NaN \n",
"16 https://twitter.com/julia_omalley/status/82290... \n",
"17 NaN \n",
"18 NaN \n",
"19 NaN \n",
"20 NaN \n",
"21 http://wlos.com/news/local/photo-gallery-the-w... \n",
"22 http://ijpr.org/post/southern-oregon-womens-ma... \n",
"23 NaN \n",
"24 NaN \n",
"25 FB \n",
"26 http://www.nbcnews.com/storyline/inauguration-... \n",
"27 NaN \n",
"28 NaN \n",
"29 http://www.statesman.com/news/local/police-000... \n",
".. ... \n",
"631 https://twitter.com/m_cvb/status/8230754311967... \n",
"632 NaN \n",
"633 https://twitter.com/dougrutherford/status/8229... \n",
"634 https://twitter.com/TheMooseCJCD/status/822924... \n",
"635 NaN \n",
"636 NaN \n",
"637 NaN \n",
"638 NaN \n",
"639 NaN \n",
"640 NaN \n",
"641 NaN \n",
"642 NaN \n",
"643 NaN \n",
"644 NaN \n",
"645 NaN \n",
"646 NaN \n",
"647 https://twitter.com/marienoellewurm/status/823... \n",
"648 NaN \n",
"649 NaN \n",
"650 NaN \n",
"651 NaN \n",
"652 NaN \n",
"653 NaN \n",
"654 NaN \n",
"655 NaN \n",
"656 NaN \n",
"657 NaN \n",
"658 NaN \n",
"659 NaN \n",
"660 NaN \n",
"\n",
" Source3 \n",
"0 NaN \n",
"1 NaN \n",
"2 NaN \n",
"3 NaN \n",
"4 NaN \n",
"5 NaN \n",
"6 NaN \n",
"7 NaN \n",
"8 NaN \n",
"9 NaN \n",
"10 https://twitter.com/AthertonKD/status/82321516... \n",
"11 NaN \n",
"12 NaN \n",
"13 NaN \n",
"14 NaN \n",
"15 NaN \n",
"16 NaN \n",
"17 NaN \n",
"18 NaN \n",
"19 NaN \n",
"20 NaN \n",
"21 NaN \n",
"22 NaN \n",
"23 NaN \n",
"24 NaN \n",
"25 NaN \n",
"26 NaN \n",
"27 NaN \n",
"28 NaN \n",
"29 NaN \n",
".. ... \n",
"631 NaN \n",
"632 NaN \n",
"633 NaN \n",
"634 NaN \n",
"635 NaN \n",
"636 NaN \n",
"637 NaN \n",
"638 NaN \n",
"639 NaN \n",
"640 NaN \n",
"641 NaN \n",
"642 NaN \n",
"643 NaN \n",
"644 NaN \n",
"645 NaN \n",
"646 NaN \n",
"647 https://t.co/dYoxYWZ13q \n",
"648 NaN \n",
"649 NaN \n",
"650 NaN \n",
"651 NaN \n",
"652 NaN \n",
"653 NaN \n",
"654 NaN \n",
"655 NaN \n",
"656 NaN \n",
"657 NaN \n",
"658 NaN \n",
"659 NaN \n",
"660 NaN \n",
"\n",
"[661 rows x 10 columns]"
]
},
"execution_count": 73,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 74,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"5223475.0"
]
},
"execution_count": 74,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data['Estimate2'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 75,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"3859873.0"
]
},
"execution_count": 75,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 76,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"states = {\n",
" 'AK': 'Alaska',\n",
" 'AL': 'Alabama',\n",
" 'AR': 'Arkansas',\n",
" 'AS': 'American Samoa',\n",
" 'AZ': 'Arizona',\n",
" 'CA': 'California',\n",
" 'CO': 'Colorado',\n",
" 'CT': 'Connecticut',\n",
" 'DC': 'District of Columbia',\n",
" 'DE': 'Delaware',\n",
" 'FL': 'Florida',\n",
" 'GA': 'Georgia',\n",
" 'GU': 'Guam',\n",
" 'HI': 'Hawaii',\n",
" 'IA': 'Iowa',\n",
" 'ID': 'Idaho',\n",
" 'IL': 'Illinois',\n",
" 'IN': 'Indiana',\n",
" 'KS': 'Kansas',\n",
" 'KY': 'Kentucky',\n",
" 'LA': 'Louisiana',\n",
" 'MA': 'Massachusetts',\n",
" 'MD': 'Maryland',\n",
" 'ME': 'Maine',\n",
" 'MI': 'Michigan',\n",
" 'MN': 'Minnesota',\n",
" 'MO': 'Missouri',\n",
" 'MP': 'Northern Mariana Islands',\n",
" 'MS': 'Mississippi',\n",
" 'MT': 'Montana',\n",
" 'NA': 'National',\n",
" 'NC': 'North Carolina',\n",
" 'ND': 'North Dakota',\n",
" 'NE': 'Nebraska',\n",
" 'NH': 'New Hampshire',\n",
" 'NJ': 'New Jersey',\n",
" 'NM': 'New Mexico',\n",
" 'NV': 'Nevada',\n",
" 'NY': 'New York',\n",
" 'OH': 'Ohio',\n",
" 'OK': 'Oklahoma',\n",
" 'OR': 'Oregon',\n",
" 'PA': 'Pennsylvania',\n",
" 'PR': 'Puerto Rico',\n",
" 'RI': 'Rhode Island',\n",
" 'SC': 'South Carolina',\n",
" 'SD': 'South Dakota',\n",
" 'TN': 'Tennessee',\n",
" 'TX': 'Texas',\n",
" 'UT': 'Utah',\n",
" 'VA': 'Virginia',\n",
" 'VI': 'Virgin Islands',\n",
" 'VT': 'Vermont',\n",
" 'WA': 'Washington',\n",
" 'WI': 'Wisconsin',\n",
" 'WV': 'West Virginia',\n",
" 'WY': 'Wyoming'\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": 77,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"state\tcount\tcount (lower, upper)\n",
"AK\t20\t(8217.0,9501.0)\n",
"MS\t3\t(1500.0,5750.0)\n",
"SD\t3\t(4800.0,5800.0)\n",
"PR\t0\t(nan,nan)\n",
"FL\t19\t(76600.0,89600.0)\n",
"VI\t0\t(0,0)\n",
"WY\t6\t(4150.0,4950.0)\n",
"MO\t4\t(35000.0,35604.0)\n",
"IL\t9\t(259840.0,262350.0)\n",
"MN\t10\t(93089.0,103739.0)\n",
"SC\t4\t(6500.0,6500.0)\n",
"NM\t9\t(13798.0,37803.0)\n",
"MD\t7\t(7765.0,7765.0)\n",
"TN\t6\t(22450.0,35550.0)\n",
"GU\t0\t(0,0)\n",
"MT\t3\t(10093.0,10123.0)\n",
"KY\t3\t(10700.0,10800.0)\n",
"TX\t19\t(67396.0,94886.0)\n",
"ID\t8\t(12180.0,12380.0)\n",
"PA\t19\t(82183.0,82733.0)\n",
"NJ\t11\t(19170.0,20570.0)\n",
"ND\t3\t(1804.0,3804.0)\n",
"DE\t2\t(1450.0,1450.0)\n",
"WI\t15\t(78282.0,103482.0)\n",
"DC\t1\t(470000.0,680000.0)\n",
"NY\t23\t(447417.0,553737.0)\n",
"WV\t2\t(2895.0,3095.0)\n",
"LA\t2\t(10200.0,11000.0)\n",
"AZ\t9\t(39136.0,39151.0)\n",
"MP\t0\t(0,0)\n",
"CT\t7\t(16165.0,16180.0)\n",
"NA\t0\t(0,0)\n",
"OH\t10\t(25270.0,30830.0)\n",
"NH\t6\t(9934.0,11959.0)\n",
"NV\t3\t(15500.0,25500.0)\n",
"AS\t0\t(0,0)\n",
"VT\t2\t(15250.0,20250.0)\n",
"AR\t4\t(8302.0,8602.0)\n",
"HI\t6\t(10550.0,17250.0)\n",
"OK\t2\t(13000.0,13000.0)\n",
"GA\t6\t(62535.0,69835.0)\n",
"OR\t19\t(93856.0,130826.0)\n",
"VA\t11\t(11667.0,12467.0)\n",
"IA\t6\t(28700.0,29200.0)\n",
"MI\t19\t(33496.0,35573.0)\n",
"KS\t2\t(7000.0,7000.0)\n",
"UT\t6\t(9923.0,10198.0)\n",
"ME\t9\t(21048.0,21392.0)\n",
"CO\t17\t(216258.0,218187.0)\n",
"IN\t7\t(8327.0,14767.0)\n",
"WA\t25\t(156052.0,213871.0)\n",
"NE\t3\t(15100.0,18150.0)\n",
"MA\t9\t(180413.0,182913.0)\n",
"CA\t60\t(532190.0,1218192.0)\n",
"AL\t3\t(5950.0,11050.0)\n",
"RI\t1\t(7000.0,7000.0)\n",
"NC\t13\t(41908.0,51258.0)\n"
]
}
],
"source": [
"print(\"state\" + \"\\t\" + \"count\" + \"\\t\" + \"count (lower, upper)\")\n",
"for state in states:\n",
" count = data.loc[data['Location'].str.contains(state) == True]['Estimate1'].count()\n",
" crowd_lower = data.loc[data['State'] == state]['Estimate1'].sum()\n",
" crowd_upper = data.loc[data['State'] == state]['Estimate2'].sum()\n",
" print(state + \"\\t\" + str(count) + \"\\t\" + \"(\" + str(crowd_lower) + \",\" + str(crowd_upper) + \")\")"
]
},
{
"cell_type": "code",
"execution_count": 78,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"447417.0"
]
},
"execution_count": 78,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['State'] == 'NY']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 79,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"180413.0"
]
},
"execution_count": 79,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['State'] == 'MA']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 80,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"532190.0"
]
},
"execution_count": 80,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['State'] == 'CA']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 81,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"67396.0"
]
},
"execution_count": 81,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['State'] == 'TX']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 82,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"470000.0"
]
},
"execution_count": 82,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['State'] == 'DC']['Estimate1'].sum()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Countries"
]
},
{
"cell_type": "code",
"execution_count": 83,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"3333159.0"
]
},
"execution_count": 83,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"us_count1 = data.loc[data['Country'] == 'US']['Estimate1'].sum()\n",
"us_count1"
]
},
{
"cell_type": "code",
"execution_count": 84,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"4628723.0"
]
},
"execution_count": 84,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"us_count2 = data.loc[data['Country'] == 'US']['Estimate2'].sum()\n",
"us_count2"
]
},
{
"cell_type": "code",
"execution_count": 85,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"count 659\n",
"unique 52\n",
"top US\n",
"freq 544\n",
"Name: Country, dtype: object"
]
},
"execution_count": 85,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data['Country'].describe()"
]
},
{
"cell_type": "code",
"execution_count": 86,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"101236.0"
]
},
"execution_count": 86,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'Canada']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 87,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"25"
]
},
"execution_count": 87,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'Canada']['Estimate1'].count()"
]
},
{
"cell_type": "code",
"execution_count": 88,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"16000.0"
]
},
"execution_count": 88,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'Australia']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 89,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"107021.0"
]
},
"execution_count": 89,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'UK']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 90,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"8"
]
},
"execution_count": 90,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'UK']['Estimate1'].count()"
]
},
{
"cell_type": "code",
"execution_count": 91,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"500.0"
]
},
"execution_count": 91,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'Spain']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 92,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"3200.0"
]
},
"execution_count": 92,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.loc[data['Country'] == 'New Zealand']['Estimate1'].sum()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment