{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Doha Amendment to the Kyoto Protocol"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"from pandas_datapackage_reader import read_datapackage"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"da = read_datapackage(\"https://github.com/openclimatedata/doha-amendment-entry-into-force\")"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Name | \n",
" Acceptance | \n",
"
\n",
" \n",
" Code | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" DZA | \n",
" Algeria | \n",
" 2015-09-28 | \n",
"
\n",
" \n",
" ATG | \n",
" Antigua and Barbuda | \n",
" 2016-09-23 | \n",
"
\n",
" \n",
" ARG | \n",
" Argentina | \n",
" 2015-12-01 | \n",
"
\n",
" \n",
" ARM | \n",
" Armenia | \n",
" 2017-03-31 | \n",
"
\n",
" \n",
" AUS | \n",
" Australia | \n",
" 2016-11-09 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Name Acceptance\n",
"Code \n",
"DZA Algeria 2015-09-28\n",
"ATG Antigua and Barbuda 2016-09-23\n",
"ARG Argentina 2015-12-01\n",
"ARM Armenia 2017-03-31\n",
"AUS Australia 2016-11-09"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"da.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Paris Agreement"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"pa = read_datapackage(\"https://github.com/openclimatedata/paris-agreement-entry-into-force\")"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Name | \n",
" Signature | \n",
" Ratification-Acceptance-Approval | \n",
" Kind | \n",
" Date-Of-Effect | \n",
" Emissions | \n",
" Percentage | \n",
" Year | \n",
"
\n",
" \n",
" Code | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AFG | \n",
" Afghanistan | \n",
" 2016-04-22 | \n",
" 2017-02-15 | \n",
" Ratification | \n",
" 2017-03-17 | \n",
" 19328 | \n",
" 0.05 | \n",
" 2005 | \n",
"
\n",
" \n",
" ALB | \n",
" Albania | \n",
" 2016-04-22 | \n",
" 2016-09-21 | \n",
" Ratification | \n",
" 2016-11-04 | \n",
" 6717 | \n",
" 0.02 | \n",
" 2000 | \n",
"
\n",
" \n",
" DZA | \n",
" Algeria | \n",
" 2016-04-22 | \n",
" 2016-10-20 | \n",
" Ratification | \n",
" 2016-11-19 | \n",
" 111023 | \n",
" 0.30 | \n",
" 2000 | \n",
"
\n",
" \n",
" AND | \n",
" Andorra | \n",
" 2016-04-22 | \n",
" 2017-03-24 | \n",
" Ratification | \n",
" 2017-04-23 | \n",
" 522 | \n",
" 0.00 | \n",
" 2011 | \n",
"
\n",
" \n",
" AGO | \n",
" Angola | \n",
" 2016-04-22 | \n",
" NaT | \n",
" NaN | \n",
" NaT | \n",
" 61611 | \n",
" 0.17 | \n",
" 2005 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Name Signature Ratification-Acceptance-Approval Kind \\\n",
"Code \n",
"AFG Afghanistan 2016-04-22 2017-02-15 Ratification \n",
"ALB Albania 2016-04-22 2016-09-21 Ratification \n",
"DZA Algeria 2016-04-22 2016-10-20 Ratification \n",
"AND Andorra 2016-04-22 2017-03-24 Ratification \n",
"AGO Angola 2016-04-22 NaT NaN \n",
"\n",
" Date-Of-Effect Emissions Percentage Year \n",
"Code \n",
"AFG 2017-03-17 19328 0.05 2005 \n",
"ALB 2016-11-04 6717 0.02 2000 \n",
"DZA 2016-11-19 111023 0.30 2000 \n",
"AND 2017-04-23 522 0.00 2011 \n",
"AGO NaT 61611 0.17 2005 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Combination of the two datasets"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"combined = pa.reset_index().merge(da.reset_index(), how=\"outer\").set_index('Code')\n",
"combined = combined.rename(columns={\n",
" \"Acceptance\": \"Doha\", \n",
" \"Ratification-Acceptance-Approval\": \"Paris\"\n",
"})\n",
"combined = combined[[\"Doha\", \"Paris\"]].dropna(how=\"all\")\n",
"combined = combined.join(pa.Name, how=\"left\")[[\"Name\", \"Doha\", \"Paris\"]]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Name 168\n",
"Doha 80\n",
"Paris 160\n",
"dtype: int64"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"combined.count()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Parties who so far ony accepted the Doha Amendment"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Name | \n",
" Doha | \n",
" Paris | \n",
"
\n",
" \n",
" Code | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" BTN | \n",
" Bhutan | \n",
" 2015-09-29 | \n",
" NaT | \n",
"
\n",
" \n",
" DOM | \n",
" Dominican Republic | \n",
" 2016-09-21 | \n",
" NaT | \n",
"
\n",
" \n",
" ECU | \n",
" Ecuador | \n",
" 2015-04-20 | \n",
" NaT | \n",
"
\n",
" \n",
" LBR | \n",
" Liberia | \n",
" 2015-08-17 | \n",
" NaT | \n",
"
\n",
" \n",
" LIE | \n",
" Liechtenstein | \n",
" 2015-02-23 | \n",
" NaT | \n",
"
\n",
" \n",
" SMR | \n",
" San Marino | \n",
" 2015-08-04 | \n",
" NaT | \n",
"
\n",
" \n",
" CHE | \n",
" Switzerland | \n",
" 2015-08-28 | \n",
" NaT | \n",
"
\n",
" \n",
" TTO | \n",
" Trinidad and Tobago | \n",
" 2015-08-06 | \n",
" NaT | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Name Doha Paris\n",
"Code \n",
"BTN Bhutan 2015-09-29 NaT\n",
"DOM Dominican Republic 2016-09-21 NaT\n",
"ECU Ecuador 2015-04-20 NaT\n",
"LBR Liberia 2015-08-17 NaT\n",
"LIE Liechtenstein 2015-02-23 NaT\n",
"SMR San Marino 2015-08-04 NaT\n",
"CHE Switzerland 2015-08-28 NaT\n",
"TTO Trinidad and Tobago 2015-08-06 NaT"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"only_doha = combined[combined.Paris.isnull()]\n",
"only_doha"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Parties who so far ony accepted the Paris Agreement"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Name | \n",
" Doha | \n",
" Paris | \n",
"
\n",
" \n",
" Code | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AFG | \n",
" Afghanistan | \n",
" NaT | \n",
" 2017-02-15 | \n",
"
\n",
" \n",
" ALB | \n",
" Albania | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" AND | \n",
" Andorra | \n",
" NaT | \n",
" 2017-03-24 | \n",
"
\n",
" \n",
" AUT | \n",
" Austria | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" BHR | \n",
" Bahrain | \n",
" NaT | \n",
" 2016-12-23 | \n",
"
\n",
" \n",
" BLR | \n",
" Belarus | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" BEL | \n",
" Belgium | \n",
" NaT | \n",
" 2017-04-06 | \n",
"
\n",
" \n",
" BLZ | \n",
" Belize | \n",
" NaT | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" BEN | \n",
" Benin | \n",
" NaT | \n",
" 2016-10-31 | \n",
"
\n",
" \n",
" BOL | \n",
" Bolivia (Plurinational State of) | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" BIH | \n",
" Bosnia and Herzegovina | \n",
" NaT | \n",
" 2017-03-16 | \n",
"
\n",
" \n",
" BRA | \n",
" Brazil | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" BGR | \n",
" Bulgaria | \n",
" NaT | \n",
" 2016-11-29 | \n",
"
\n",
" \n",
" CMR | \n",
" Cameroon | \n",
" NaT | \n",
" 2016-07-29 | \n",
"
\n",
" \n",
" CAN | \n",
" Canada | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" CAF | \n",
" Central African Republic | \n",
" NaT | \n",
" 2016-10-11 | \n",
"
\n",
" \n",
" TCD | \n",
" Chad | \n",
" NaT | \n",
" 2017-01-12 | \n",
"
\n",
" \n",
" COK | \n",
" Cook Islands | \n",
" NaT | \n",
" 2016-09-01 | \n",
"
\n",
" \n",
" HRV | \n",
" Croatia | \n",
" NaT | \n",
" 2017-05-24 | \n",
"
\n",
" \n",
" CIV | \n",
" Côte d'Ivoire | \n",
" NaT | \n",
" 2016-10-25 | \n",
"
\n",
" \n",
" PRK | \n",
" Democratic People's Republic of Korea | \n",
" NaT | \n",
" 2016-08-01 | \n",
"
\n",
" \n",
" DNK | \n",
" Denmark | \n",
" NaT | \n",
" 2016-11-01 | \n",
"
\n",
" \n",
" DMA | \n",
" Dominica | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" EGY | \n",
" Egypt | \n",
" NaT | \n",
" 2017-06-29 | \n",
"
\n",
" \n",
" SLV | \n",
" El Salvador | \n",
" NaT | \n",
" 2017-03-27 | \n",
"
\n",
" \n",
" EST | \n",
" Estonia | \n",
" NaT | \n",
" 2016-11-04 | \n",
"
\n",
" \n",
" EUU | \n",
" European Union | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" FJI | \n",
" Fiji | \n",
" NaT | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" FIN | \n",
" Finland | \n",
" NaT | \n",
" 2016-11-14 | \n",
"
\n",
" \n",
" FRA | \n",
" France | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" PRY | \n",
" Paraguay | \n",
" NaT | \n",
" 2016-10-14 | \n",
"
\n",
" \n",
" POL | \n",
" Poland | \n",
" NaT | \n",
" 2016-10-07 | \n",
"
\n",
" \n",
" PRT | \n",
" Portugal | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" QAT | \n",
" Qatar | \n",
" NaT | \n",
" 2017-06-23 | \n",
"
\n",
" \n",
" MDA | \n",
" Republic of Moldova | \n",
" NaT | \n",
" 2017-06-20 | \n",
"
\n",
" \n",
" STP | \n",
" Sao Tome and Principe | \n",
" NaT | \n",
" 2016-11-02 | \n",
"
\n",
" \n",
" SAU | \n",
" Saudi Arabia | \n",
" NaT | \n",
" 2016-11-03 | \n",
"
\n",
" \n",
" SEN | \n",
" Senegal | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" SLE | \n",
" Sierra Leone | \n",
" NaT | \n",
" 2016-11-01 | \n",
"
\n",
" \n",
" SVK | \n",
" Slovakia | \n",
" NaT | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" SVN | \n",
" Slovenia | \n",
" NaT | \n",
" 2016-12-16 | \n",
"
\n",
" \n",
" SOM | \n",
" Somalia | \n",
" NaT | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" ESP | \n",
" Spain | \n",
" NaT | \n",
" 2017-01-12 | \n",
"
\n",
" \n",
" LCA | \n",
" St. Lucia | \n",
" NaT | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" VCT | \n",
" St. Vincent and the Grenadines | \n",
" NaT | \n",
" 2016-06-29 | \n",
"
\n",
" \n",
" PSE | \n",
" State of Palestine | \n",
" NaT | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" SWE | \n",
" Sweden | \n",
" NaT | \n",
" 2016-10-13 | \n",
"
\n",
" \n",
" TJK | \n",
" Tajikistan | \n",
" NaT | \n",
" 2017-03-22 | \n",
"
\n",
" \n",
" TLS | \n",
" Timor-Leste | \n",
" NaT | \n",
" 2017-08-16 | \n",
"
\n",
" \n",
" TGO | \n",
" Togo | \n",
" NaT | \n",
" 2017-06-28 | \n",
"
\n",
" \n",
" TON | \n",
" Tonga | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" TUN | \n",
" Tunisia | \n",
" NaT | \n",
" 2017-02-10 | \n",
"
\n",
" \n",
" TKM | \n",
" Turkmenistan | \n",
" NaT | \n",
" 2016-10-20 | \n",
"
\n",
" \n",
" UKR | \n",
" Ukraine | \n",
" NaT | \n",
" 2016-09-19 | \n",
"
\n",
" \n",
" GBR | \n",
" United Kingdom of Great Britain and Northern I... | \n",
" NaT | \n",
" 2016-11-18 | \n",
"
\n",
" \n",
" USA | \n",
" United States of America | \n",
" NaT | \n",
" 2016-09-03 | \n",
"
\n",
" \n",
" URY | \n",
" Uruguay | \n",
" NaT | \n",
" 2016-10-19 | \n",
"
\n",
" \n",
" VUT | \n",
" Vanuatu | \n",
" NaT | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" VEN | \n",
" Venezuela (Bolivarian Republic of) | \n",
" NaT | \n",
" 2017-07-21 | \n",
"
\n",
" \n",
" ZMB | \n",
" Zambia | \n",
" NaT | \n",
" 2016-12-09 | \n",
"
\n",
" \n",
"
\n",
"
88 rows × 3 columns
\n",
"
"
],
"text/plain": [
" Name Doha Paris\n",
"Code \n",
"AFG Afghanistan NaT 2017-02-15\n",
"ALB Albania NaT 2016-09-21\n",
"AND Andorra NaT 2017-03-24\n",
"AUT Austria NaT 2016-10-05\n",
"BHR Bahrain NaT 2016-12-23\n",
"BLR Belarus NaT 2016-09-21\n",
"BEL Belgium NaT 2017-04-06\n",
"BLZ Belize NaT 2016-04-22\n",
"BEN Benin NaT 2016-10-31\n",
"BOL Bolivia (Plurinational State of) NaT 2016-10-05\n",
"BIH Bosnia and Herzegovina NaT 2017-03-16\n",
"BRA Brazil NaT 2016-09-21\n",
"BGR Bulgaria NaT 2016-11-29\n",
"CMR Cameroon NaT 2016-07-29\n",
"CAN Canada NaT 2016-10-05\n",
"CAF Central African Republic NaT 2016-10-11\n",
"TCD Chad NaT 2017-01-12\n",
"COK Cook Islands NaT 2016-09-01\n",
"HRV Croatia NaT 2017-05-24\n",
"CIV Côte d'Ivoire NaT 2016-10-25\n",
"PRK Democratic People's Republic of Korea NaT 2016-08-01\n",
"DNK Denmark NaT 2016-11-01\n",
"DMA Dominica NaT 2016-09-21\n",
"EGY Egypt NaT 2017-06-29\n",
"SLV El Salvador NaT 2017-03-27\n",
"EST Estonia NaT 2016-11-04\n",
"EUU European Union NaT 2016-10-05\n",
"FJI Fiji NaT 2016-04-22\n",
"FIN Finland NaT 2016-11-14\n",
"FRA France NaT 2016-10-05\n",
"... ... ... ...\n",
"PRY Paraguay NaT 2016-10-14\n",
"POL Poland NaT 2016-10-07\n",
"PRT Portugal NaT 2016-10-05\n",
"QAT Qatar NaT 2017-06-23\n",
"MDA Republic of Moldova NaT 2017-06-20\n",
"STP Sao Tome and Principe NaT 2016-11-02\n",
"SAU Saudi Arabia NaT 2016-11-03\n",
"SEN Senegal NaT 2016-09-21\n",
"SLE Sierra Leone NaT 2016-11-01\n",
"SVK Slovakia NaT 2016-10-05\n",
"SVN Slovenia NaT 2016-12-16\n",
"SOM Somalia NaT 2016-04-22\n",
"ESP Spain NaT 2017-01-12\n",
"LCA St. Lucia NaT 2016-04-22\n",
"VCT St. Vincent and the Grenadines NaT 2016-06-29\n",
"PSE State of Palestine NaT 2016-04-22\n",
"SWE Sweden NaT 2016-10-13\n",
"TJK Tajikistan NaT 2017-03-22\n",
"TLS Timor-Leste NaT 2017-08-16\n",
"TGO Togo NaT 2017-06-28\n",
"TON Tonga NaT 2016-09-21\n",
"TUN Tunisia NaT 2017-02-10\n",
"TKM Turkmenistan NaT 2016-10-20\n",
"UKR Ukraine NaT 2016-09-19\n",
"GBR United Kingdom of Great Britain and Northern I... NaT 2016-11-18\n",
"USA United States of America NaT 2016-09-03\n",
"URY Uruguay NaT 2016-10-19\n",
"VUT Vanuatu NaT 2016-09-21\n",
"VEN Venezuela (Bolivarian Republic of) NaT 2017-07-21\n",
"ZMB Zambia NaT 2016-12-09\n",
"\n",
"[88 rows x 3 columns]"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"only_paris = combined[combined.Doha.isnull()]\n",
"only_paris"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Parties who ratified the Paris Agreement and Doha Amendment"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Name | \n",
" Doha | \n",
" Paris | \n",
"
\n",
" \n",
" Code | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" DZA | \n",
" Algeria | \n",
" 2015-09-28 | \n",
" 2016-10-20 | \n",
"
\n",
" \n",
" ATG | \n",
" Antigua and Barbuda | \n",
" 2016-09-23 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" ARG | \n",
" Argentina | \n",
" 2015-12-01 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" ARM | \n",
" Armenia | \n",
" 2017-03-31 | \n",
" 2017-03-23 | \n",
"
\n",
" \n",
" AUS | \n",
" Australia | \n",
" 2016-11-09 | \n",
" 2016-11-09 | \n",
"
\n",
" \n",
" AZE | \n",
" Azerbaijan | \n",
" 2015-07-01 | \n",
" 2017-01-09 | \n",
"
\n",
" \n",
" BHS | \n",
" Bahamas | \n",
" 2015-11-04 | \n",
" 2016-08-22 | \n",
"
\n",
" \n",
" BGD | \n",
" Bangladesh | \n",
" 2013-11-13 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" BRB | \n",
" Barbados | \n",
" 2013-08-14 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" BWA | \n",
" Botswana | \n",
" 2016-03-07 | \n",
" 2016-11-11 | \n",
"
\n",
" \n",
" BRN | \n",
" Brunei Darussalam | \n",
" 2014-11-14 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" BFA | \n",
" Burkina Faso | \n",
" 2016-11-29 | \n",
" 2016-11-11 | \n",
"
\n",
" \n",
" KHM | \n",
" Cambodia | \n",
" 2015-11-17 | \n",
" 2017-02-06 | \n",
"
\n",
" \n",
" CHL | \n",
" Chile | \n",
" 2015-11-10 | \n",
" 2017-02-10 | \n",
"
\n",
" \n",
" CHN | \n",
" China | \n",
" 2014-06-02 | \n",
" 2016-09-03 | \n",
"
\n",
" \n",
" COM | \n",
" Comoros | \n",
" 2014-09-07 | \n",
" 2016-11-23 | \n",
"
\n",
" \n",
" COG | \n",
" Congo | \n",
" 2015-05-14 | \n",
" 2017-04-21 | \n",
"
\n",
" \n",
" CRI | \n",
" Costa Rica | \n",
" 2016-09-21 | \n",
" 2016-10-13 | \n",
"
\n",
" \n",
" CUB | \n",
" Cuba | \n",
" 2016-12-28 | \n",
" 2016-12-28 | \n",
"
\n",
" \n",
" CYP | \n",
" Cyprus | \n",
" 2015-12-10 | \n",
" 2017-01-04 | \n",
"
\n",
" \n",
" DJI | \n",
" Djibouti | \n",
" 2014-09-23 | \n",
" 2016-11-11 | \n",
"
\n",
" \n",
" ETH | \n",
" Ethiopia | \n",
" 2015-06-26 | \n",
" 2017-03-09 | \n",
"
\n",
" \n",
" GMB | \n",
" Gambia | \n",
" 2016-11-07 | \n",
" 2016-11-07 | \n",
"
\n",
" \n",
" GRD | \n",
" Grenada | \n",
" 2015-04-01 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" GIN | \n",
" Guinea | \n",
" 2016-04-06 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" GUY | \n",
" Guyana | \n",
" 2014-12-23 | \n",
" 2016-05-20 | \n",
"
\n",
" \n",
" HND | \n",
" Honduras | \n",
" 2014-04-11 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" HUN | \n",
" Hungary | \n",
" 2015-10-01 | \n",
" 2016-10-05 | \n",
"
\n",
" \n",
" ISL | \n",
" Iceland | \n",
" 2015-10-07 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" IND | \n",
" India | \n",
" 2017-08-08 | \n",
" 2016-10-02 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" FSM | \n",
" Micronesia (Federated States of) | \n",
" 2014-02-19 | \n",
" 2016-09-15 | \n",
"
\n",
" \n",
" MCO | \n",
" Monaco | \n",
" 2013-12-27 | \n",
" 2016-10-24 | \n",
"
\n",
" \n",
" MAR | \n",
" Morocco | \n",
" 2014-09-05 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" NAM | \n",
" Namibia | \n",
" 2015-02-17 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" NRU | \n",
" Nauru | \n",
" 2014-12-01 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" NZL | \n",
" New Zealand | \n",
" 2015-11-30 | \n",
" 2016-10-04 | \n",
"
\n",
" \n",
" NOR | \n",
" Norway | \n",
" 2014-06-12 | \n",
" 2016-06-20 | \n",
"
\n",
" \n",
" PLW | \n",
" Palau | \n",
" 2015-03-10 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" PAN | \n",
" Panama | \n",
" 2015-09-29 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" PER | \n",
" Peru | \n",
" 2014-09-24 | \n",
" 2016-07-25 | \n",
"
\n",
" \n",
" PHL | \n",
" Philippines | \n",
" 2016-04-13 | \n",
" 2017-03-23 | \n",
"
\n",
" \n",
" KOR | \n",
" Republic of Korea | \n",
" 2015-05-27 | \n",
" 2016-11-03 | \n",
"
\n",
" \n",
" ROU | \n",
" Romania | \n",
" 2016-05-03 | \n",
" 2017-06-01 | \n",
"
\n",
" \n",
" RWA | \n",
" Rwanda | \n",
" 2015-11-20 | \n",
" 2016-10-06 | \n",
"
\n",
" \n",
" WSM | \n",
" Samoa | \n",
" 2015-09-18 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" SRB | \n",
" Serbia | \n",
" 2017-06-30 | \n",
" 2017-07-25 | \n",
"
\n",
" \n",
" SYC | \n",
" Seychelles | \n",
" 2015-07-15 | \n",
" 2016-04-29 | \n",
"
\n",
" \n",
" SGP | \n",
" Singapore | \n",
" 2014-09-23 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" SLB | \n",
" Solomon Islands | \n",
" 2014-09-05 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" ZAF | \n",
" South Africa | \n",
" 2015-05-07 | \n",
" 2016-11-01 | \n",
"
\n",
" \n",
" LKA | \n",
" Sri Lanka | \n",
" 2015-12-02 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" KNA | \n",
" St. Kitts and Nevis | \n",
" 2016-10-25 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" SDN | \n",
" Sudan | \n",
" 2014-02-03 | \n",
" 2017-08-02 | \n",
"
\n",
" \n",
" SWZ | \n",
" Swaziland | \n",
" 2016-09-21 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" THA | \n",
" Thailand | \n",
" 2015-09-01 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" TUV | \n",
" Tuvalu | \n",
" 2014-12-04 | \n",
" 2016-04-22 | \n",
"
\n",
" \n",
" UGA | \n",
" Uganda | \n",
" 2015-07-08 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" ARE | \n",
" United Arab Emirates | \n",
" 2013-04-26 | \n",
" 2016-09-21 | \n",
"
\n",
" \n",
" VNM | \n",
" Viet Nam | \n",
" 2015-06-22 | \n",
" 2016-11-03 | \n",
"
\n",
" \n",
" ZWE | \n",
" Zimbabwe | \n",
" 2016-04-20 | \n",
" 2017-08-07 | \n",
"
\n",
" \n",
"
\n",
"
72 rows × 3 columns
\n",
"
"
],
"text/plain": [
" Name Doha Paris\n",
"Code \n",
"DZA Algeria 2015-09-28 2016-10-20\n",
"ATG Antigua and Barbuda 2016-09-23 2016-09-21\n",
"ARG Argentina 2015-12-01 2016-09-21\n",
"ARM Armenia 2017-03-31 2017-03-23\n",
"AUS Australia 2016-11-09 2016-11-09\n",
"AZE Azerbaijan 2015-07-01 2017-01-09\n",
"BHS Bahamas 2015-11-04 2016-08-22\n",
"BGD Bangladesh 2013-11-13 2016-09-21\n",
"BRB Barbados 2013-08-14 2016-04-22\n",
"BWA Botswana 2016-03-07 2016-11-11\n",
"BRN Brunei Darussalam 2014-11-14 2016-09-21\n",
"BFA Burkina Faso 2016-11-29 2016-11-11\n",
"KHM Cambodia 2015-11-17 2017-02-06\n",
"CHL Chile 2015-11-10 2017-02-10\n",
"CHN China 2014-06-02 2016-09-03\n",
"COM Comoros 2014-09-07 2016-11-23\n",
"COG Congo 2015-05-14 2017-04-21\n",
"CRI Costa Rica 2016-09-21 2016-10-13\n",
"CUB Cuba 2016-12-28 2016-12-28\n",
"CYP Cyprus 2015-12-10 2017-01-04\n",
"DJI Djibouti 2014-09-23 2016-11-11\n",
"ETH Ethiopia 2015-06-26 2017-03-09\n",
"GMB Gambia 2016-11-07 2016-11-07\n",
"GRD Grenada 2015-04-01 2016-04-22\n",
"GIN Guinea 2016-04-06 2016-09-21\n",
"GUY Guyana 2014-12-23 2016-05-20\n",
"HND Honduras 2014-04-11 2016-09-21\n",
"HUN Hungary 2015-10-01 2016-10-05\n",
"ISL Iceland 2015-10-07 2016-09-21\n",
"IND India 2017-08-08 2016-10-02\n",
"... ... ... ...\n",
"FSM Micronesia (Federated States of) 2014-02-19 2016-09-15\n",
"MCO Monaco 2013-12-27 2016-10-24\n",
"MAR Morocco 2014-09-05 2016-09-21\n",
"NAM Namibia 2015-02-17 2016-09-21\n",
"NRU Nauru 2014-12-01 2016-04-22\n",
"NZL New Zealand 2015-11-30 2016-10-04\n",
"NOR Norway 2014-06-12 2016-06-20\n",
"PLW Palau 2015-03-10 2016-04-22\n",
"PAN Panama 2015-09-29 2016-09-21\n",
"PER Peru 2014-09-24 2016-07-25\n",
"PHL Philippines 2016-04-13 2017-03-23\n",
"KOR Republic of Korea 2015-05-27 2016-11-03\n",
"ROU Romania 2016-05-03 2017-06-01\n",
"RWA Rwanda 2015-11-20 2016-10-06\n",
"WSM Samoa 2015-09-18 2016-04-22\n",
"SRB Serbia 2017-06-30 2017-07-25\n",
"SYC Seychelles 2015-07-15 2016-04-29\n",
"SGP Singapore 2014-09-23 2016-09-21\n",
"SLB Solomon Islands 2014-09-05 2016-09-21\n",
"ZAF South Africa 2015-05-07 2016-11-01\n",
"LKA Sri Lanka 2015-12-02 2016-09-21\n",
"KNA St. Kitts and Nevis 2016-10-25 2016-04-22\n",
"SDN Sudan 2014-02-03 2017-08-02\n",
"SWZ Swaziland 2016-09-21 2016-09-21\n",
"THA Thailand 2015-09-01 2016-09-21\n",
"TUV Tuvalu 2014-12-04 2016-04-22\n",
"UGA Uganda 2015-07-08 2016-09-21\n",
"ARE United Arab Emirates 2013-04-26 2016-09-21\n",
"VNM Viet Nam 2015-06-22 2016-11-03\n",
"ZWE Zimbabwe 2016-04-20 2017-08-07\n",
"\n",
"[72 rows x 3 columns]"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"both = combined[~combined.Paris.isnull() & ~combined.Doha.isnull()]\n",
"both"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Doha only: 8\n",
"Paris only: 88\n",
"Both Doha and Paris: 72\n"
]
}
],
"source": [
"print(\"Doha only: {}\\nParis only: {}\\nBoth Doha and Paris: {}\".format(len(only_doha), len(only_paris), len(both)))"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.1"
}
},
"nbformat": 4,
"nbformat_minor": 1
}