{ "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAcceptance
Code
DZAAlgeria2015-09-28
ATGAntigua and Barbuda2016-09-23
ARGArgentina2015-12-01
ARMArmenia2017-03-31
AUSAustralia2016-11-09
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameSignatureRatification-Acceptance-ApprovalKindDate-Of-EffectEmissionsPercentageYear
Code
AFGAfghanistan2016-04-222017-02-15Ratification2017-03-17193280.052005
ALBAlbania2016-04-222016-09-21Ratification2016-11-0467170.022000
DZAAlgeria2016-04-222016-10-20Ratification2016-11-191110230.302000
ANDAndorra2016-04-222017-03-24Ratification2017-04-235220.002011
AGOAngola2016-04-22NaTNaNNaT616110.172005
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameDohaParis
Code
BTNBhutan2015-09-29NaT
DOMDominican Republic2016-09-21NaT
ECUEcuador2015-04-20NaT
LBRLiberia2015-08-17NaT
LIELiechtenstein2015-02-23NaT
SMRSan Marino2015-08-04NaT
CHESwitzerland2015-08-28NaT
TTOTrinidad and Tobago2015-08-06NaT
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameDohaParis
Code
AFGAfghanistanNaT2017-02-15
ALBAlbaniaNaT2016-09-21
ANDAndorraNaT2017-03-24
AUTAustriaNaT2016-10-05
BHRBahrainNaT2016-12-23
BLRBelarusNaT2016-09-21
BELBelgiumNaT2017-04-06
BLZBelizeNaT2016-04-22
BENBeninNaT2016-10-31
BOLBolivia (Plurinational State of)NaT2016-10-05
BIHBosnia and HerzegovinaNaT2017-03-16
BRABrazilNaT2016-09-21
BGRBulgariaNaT2016-11-29
CMRCameroonNaT2016-07-29
CANCanadaNaT2016-10-05
CAFCentral African RepublicNaT2016-10-11
TCDChadNaT2017-01-12
COKCook IslandsNaT2016-09-01
HRVCroatiaNaT2017-05-24
CIVCôte d'IvoireNaT2016-10-25
PRKDemocratic People's Republic of KoreaNaT2016-08-01
DNKDenmarkNaT2016-11-01
DMADominicaNaT2016-09-21
EGYEgyptNaT2017-06-29
SLVEl SalvadorNaT2017-03-27
ESTEstoniaNaT2016-11-04
EUUEuropean UnionNaT2016-10-05
FJIFijiNaT2016-04-22
FINFinlandNaT2016-11-14
FRAFranceNaT2016-10-05
............
PRYParaguayNaT2016-10-14
POLPolandNaT2016-10-07
PRTPortugalNaT2016-10-05
QATQatarNaT2017-06-23
MDARepublic of MoldovaNaT2017-06-20
STPSao Tome and PrincipeNaT2016-11-02
SAUSaudi ArabiaNaT2016-11-03
SENSenegalNaT2016-09-21
SLESierra LeoneNaT2016-11-01
SVKSlovakiaNaT2016-10-05
SVNSloveniaNaT2016-12-16
SOMSomaliaNaT2016-04-22
ESPSpainNaT2017-01-12
LCASt. LuciaNaT2016-04-22
VCTSt. Vincent and the GrenadinesNaT2016-06-29
PSEState of PalestineNaT2016-04-22
SWESwedenNaT2016-10-13
TJKTajikistanNaT2017-03-22
TLSTimor-LesteNaT2017-08-16
TGOTogoNaT2017-06-28
TONTongaNaT2016-09-21
TUNTunisiaNaT2017-02-10
TKMTurkmenistanNaT2016-10-20
UKRUkraineNaT2016-09-19
GBRUnited Kingdom of Great Britain and Northern I...NaT2016-11-18
USAUnited States of AmericaNaT2016-09-03
URYUruguayNaT2016-10-19
VUTVanuatuNaT2016-09-21
VENVenezuela (Bolivarian Republic of)NaT2017-07-21
ZMBZambiaNaT2016-12-09
\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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameDohaParis
Code
DZAAlgeria2015-09-282016-10-20
ATGAntigua and Barbuda2016-09-232016-09-21
ARGArgentina2015-12-012016-09-21
ARMArmenia2017-03-312017-03-23
AUSAustralia2016-11-092016-11-09
AZEAzerbaijan2015-07-012017-01-09
BHSBahamas2015-11-042016-08-22
BGDBangladesh2013-11-132016-09-21
BRBBarbados2013-08-142016-04-22
BWABotswana2016-03-072016-11-11
BRNBrunei Darussalam2014-11-142016-09-21
BFABurkina Faso2016-11-292016-11-11
KHMCambodia2015-11-172017-02-06
CHLChile2015-11-102017-02-10
CHNChina2014-06-022016-09-03
COMComoros2014-09-072016-11-23
COGCongo2015-05-142017-04-21
CRICosta Rica2016-09-212016-10-13
CUBCuba2016-12-282016-12-28
CYPCyprus2015-12-102017-01-04
DJIDjibouti2014-09-232016-11-11
ETHEthiopia2015-06-262017-03-09
GMBGambia2016-11-072016-11-07
GRDGrenada2015-04-012016-04-22
GINGuinea2016-04-062016-09-21
GUYGuyana2014-12-232016-05-20
HNDHonduras2014-04-112016-09-21
HUNHungary2015-10-012016-10-05
ISLIceland2015-10-072016-09-21
INDIndia2017-08-082016-10-02
............
FSMMicronesia (Federated States of)2014-02-192016-09-15
MCOMonaco2013-12-272016-10-24
MARMorocco2014-09-052016-09-21
NAMNamibia2015-02-172016-09-21
NRUNauru2014-12-012016-04-22
NZLNew Zealand2015-11-302016-10-04
NORNorway2014-06-122016-06-20
PLWPalau2015-03-102016-04-22
PANPanama2015-09-292016-09-21
PERPeru2014-09-242016-07-25
PHLPhilippines2016-04-132017-03-23
KORRepublic of Korea2015-05-272016-11-03
ROURomania2016-05-032017-06-01
RWARwanda2015-11-202016-10-06
WSMSamoa2015-09-182016-04-22
SRBSerbia2017-06-302017-07-25
SYCSeychelles2015-07-152016-04-29
SGPSingapore2014-09-232016-09-21
SLBSolomon Islands2014-09-052016-09-21
ZAFSouth Africa2015-05-072016-11-01
LKASri Lanka2015-12-022016-09-21
KNASt. Kitts and Nevis2016-10-252016-04-22
SDNSudan2014-02-032017-08-02
SWZSwaziland2016-09-212016-09-21
THAThailand2015-09-012016-09-21
TUVTuvalu2014-12-042016-04-22
UGAUganda2015-07-082016-09-21
AREUnited Arab Emirates2013-04-262016-09-21
VNMViet Nam2015-06-222016-11-03
ZWEZimbabwe2016-04-202017-08-07
\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 }