In [41]:

    

import urllib2
import json
import csv
import io


    

In [18]:

    

def get_country_name(iso3):
    url = "http://restcountries.eu/rest/v1/alpha/" + iso3
    response = urllib2.urlopen(url).read()
    return json.loads(response)['name']


    

In [19]:

    

print get_country_name("gbr")
# url = "http://restcountries.eu/rest/v1/alpha/gbr"
# response = urllib2.urlopen(url)


    

    




United Kingdom

In [30]:

    

cnames = '''ABW Aruba 
AFG Afghanistan 
AGO Angola 
AIA Anguilla 
ALA Åland Islands 
ALB Albania 
AND Andorra 
ANT Netherlands Antilles 
ARE United Arab Emirates 
ARG Argentina 
ARM Armenia 
ASM American Samoa 
ATA Antarctica 
ATF French Southern Territories 
ATG Antigua and Barbuda 
AUS Australia 
AUT Austria 
AZE Azerbaijan 
BDI Burundi 
BEL Belgium 
BEN Benin 
BFA Burkina Faso 
BGD Bangladesh 
BGR Bulgaria 
BHR Bahrain 
BHS Bahamas 
BIH Bosnia and Herzegovina 
BLM Saint Barthélemy 
BLR Belarus 
BLZ Belize 
BMU Bermuda 
BOL Bolivia, Plurinational State of 
BRA Brazil 
BRB Barbados 
BRN Brunei Darussalam 
BTN Bhutan 
BVT Bouvet Island 
BWA Botswana 
CAF Central African Republic 
CAN Canada 
CCK Cocos (Keeling) Islands 
CHE Switzerland 
CHL Chile 
CHN China 
CIV Côte d'Ivoire 
CMR Cameroon 
COD Congo, the Democratic Republic of the 
COG Congo 
COK Cook Islands 
COL Colombia 
COM Comoros 
CPV Cape Verde 
CRI Costa Rica 
CUB Cuba 
CXR Christmas Island 
CYM Cayman Islands 
CYP Cyprus 
CZE Czech Republic 
DEU Germany 
DJI Djibouti 
DMA Dominica 
DNK Denmark 
DOM Dominican Republic 
DZA Algeria 
ECU Ecuador 
EGY Egypt 
ERI Eritrea 
ESH Western Sahara 
ESP Spain 
EST Estonia 
ETH Ethiopia 
FIN Finland 
FJI Fiji 
FLK Falkland Islands (Malvinas) 
FRA France 
FRO Faroe Islands 
FSM Micronesia, Federated States of 
GAB Gabon 
GBR United Kingdom 
GEO Georgia 
GGY Guernsey 
GHA Ghana 
GIB Gibraltar 
GIN Guinea 
GLP Guadeloupe 
GMB Gambia 
GNB Guinea-Bissau 
GNQ Equatorial Guinea 
GRC Greece 
GRD Grenada 
GRL Greenland 
GTM Guatemala 
GUF French Guiana 
GUM Guam 
GUY Guyana 
HKG Hong Kong 
HMD Heard Island and McDonald Islands 
HND Honduras 
HRV Croatia 
HTI Haiti 
HUN Hungary 
IDN Indonesia 
IMN Isle of Man 
IND India 
IOT British Indian Ocean Territory 
IRL Ireland 
IRN Iran, Islamic Republic of 
IRQ Iraq 
ISL Iceland 
ISR Israel 
ITA Italy 
JAM Jamaica 
JEY Jersey 
JOR Jordan 
JPN Japan 
KAZ Kazakhstan 
KEN Kenya 
KGZ Kyrgyzstan 
KHM Cambodia 
KIR Kiribati 
KNA Saint Kitts and Nevis 
KOR Korea, Republic of 
KWT Kuwait 
LAO Lao People's Democratic Republic 
LBN Lebanon 
LBR Liberia 
LBY Libyan Arab Jamahiriya 
LCA Saint Lucia 
LIE Liechtenstein 
LKA Sri Lanka 
LSO Lesotho 
LTU Lithuania 
LUX Luxembourg 
LVA Latvia 
MAC Macao 
MAF Saint Martin (French part) 
MAR Morocco 
MCO Monaco 
MDA Moldova, Republic of 
MDG Madagascar 
MDV Maldives 
MEX Mexico 
MHL Marshall Islands 
MKD Macedonia, the former Yugoslav Republic of 
MLI Mali 
MLT Malta 
MMR Myanmar 
MNE Montenegro 
MNG Mongolia 
MNP Northern Mariana Islands 
MOZ Mozambique 
MRT Mauritania 
MSR Montserrat 
MTQ Martinique 
MUS Mauritius 
MWI Malawi 
MYS Malaysia 
MYT Mayotte 
NAM Namibia 
NCL New Caledonia 
NER Niger 
NFK Norfolk Island 
NGA Nigeria 
NIC Nicaragua 
NIU Niue 
NLD Netherlands 
NOR Norway 
NPL Nepal 
NRU Nauru 
NZL New Zealand 
OMN Oman 
PAK Pakistan 
PAN Panama 
PCN Pitcairn 
PER Peru 
PHL Philippines 
PLW Palau 
PNG Papua New Guinea 
POL Poland 
PRI Puerto Rico 
PRK Korea, Democratic People's Republic of 
PRT Portugal 
PRY Paraguay 
PSE Palestinian Territory, Occupied 
PYF French Polynesia 
QAT Qatar 
REU Réunion 
ROU Romania 
RUS Russian Federation 
RWA Rwanda 
SAU Saudi Arabia 
SDN Sudan 
SEN Senegal 
SGP Singapore 
SGS South Georgia and the South Sandwich Islands 
SHN Saint Helena, Ascension and Tristan da Cunha 
SJM Svalbard and Jan Mayen 
SLB Solomon Islands 
SLE Sierra Leone 
SLV El Salvador 
SMR San Marino 
SOM Somalia 
SPM Saint Pierre and Miquelon 
SRB Serbia 
STP Sao Tome and Principe 
SUR Suriname 
SVK Slovakia 
SVN Slovenia 
SWE Sweden 
SWZ Swaziland 
SYC Seychelles 
SYR Syrian Arab Republic 
TCA Turks and Caicos Islands 
TCD Chad 
TGO Togo 
THA Thailand 
TJK Tajikistan 
TKL Tokelau 
TKM Turkmenistan 
TLS Timor-Leste 
TON Tonga 
TTO Trinidad and Tobago 
TUN Tunisia 
TUR Turkey 
TUV Tuvalu 
TWN Taiwan, Province of China 
TZA Tanzania, United Republic of 
UGA Uganda 
UKR Ukraine 
UMI United States Minor Outlying Islands 
URY Uruguay 
USA United States 
UZB Uzbekistan 
VAT Holy See (Vatican City State) 
VCT Saint Vincent and the Grenadines 
VEN Venezuela, Bolivarian Republic of 
VGB Virgin Islands, British 
VIR Virgin Islands, U.S. 
VNM Viet Nam 
VUT Vanuatu 
WLF Wallis and Futuna 
WSM Samoa 
YEM Yemen 
ZAF South Africa 
ZMB Zambia 
ZWE Zimbabwe'''.split("\n")

cname_dict = {}
for c in cnames:
    name = c[3:]
    cname_dict[c[:3]] = c[4:-1]


    

In [ ]:

    




    

In [44]:

    

newrows = []
with io.open('MMSI_countrycodes_iso3.csv', 'rU',encoding='utf-8',errors='ignore') as csvfile:
    countries = csv.reader(csvfile)
    for row in countries:
        if row[0] == "code":
            row = row + ['']
        else:
            try:
                row = row + [get_country_name(row[-1])]
            except:
                row = row + [cname_dict[row[-1]]]
        newrows.append(row)


    

In [52]:

    

for i in range(len(newrows)):
    print "\t".join(newrows[i])


    

    




code	country	continent	isEU	iso3	
201	Albania (Republic of)	Europe	FALSE	ALB	Albania
202	Andorra (Principality of)	Europe	FALSE	AND	Andorra
203	Austria	Europe	TRUE	AUT	Austria
204	Azores - Portugal	Europe	TRUE	PRT	Portugal
205	Belgium	Europe	TRUE	BEL	Belgium
206	Belarus (Republic of)	Europe	FALSE	BLR	Belarus
207	Bulgaria (Republic of)	Europe	TRUE	BGR	Bulgaria
208	Vatican City State	Europe	FALSE	VAT	Holy See (Vatican City State)
209	Cyprus (Republic of)	Europe	TRUE	CYP	Cyprus
210	Cyprus (Republic of)	Europe	TRUE	CYP	Cyprus
211	Germany (Federal Republic of)	Europe	TRUE	DEU	Germany
212	Cyprus (Republic of)	Europe	TRUE	CYP	Cyprus
213	Georgia	Asia	FALSE	GEO	Georgia
214	Moldova (Republic of)	Europe	FALSE	MDA	Moldova
215	Malta	Europe	TRUE	MLT	Malta
216	Armenia (Republic of)	Asia	FALSE	ARM	Armenia
218	Germany (Federal Republic of)	Europe	TRUE	DEU	Germany
219	Denmark	Europe	TRUE	DNK	Denmark
220	Denmark	Europe	TRUE	DNK	Denmark
224	Spain	Europe	TRUE	ESP	Spain
225	Spain	Europe	TRUE	ESP	Spain
226	France	Europe	TRUE	FRA	France
227	France	Europe	TRUE	FRA	France
228	France	Europe	TRUE	FRA	France
229	Malta	Europe	TRUE	MLT	Malta
230	Finland	Europe	TRUE	FIN	Finland
231	Faroe Islands - Denmark	Europe	FALSE	FRO	Faroe Islands
232	United Kingdom of Great Britain and Northern Ireland	Europe	TRUE	GBR	United Kingdom
233	United Kingdom of Great Britain and Northern Ireland	Europe	TRUE	GBR	United Kingdom
234	United Kingdom of Great Britain and Northern Ireland	Europe	TRUE	GBR	United Kingdom
235	United Kingdom of Great Britain and Northern Ireland	Europe	TRUE	GBR	United Kingdom
236	Gibraltar - United Kingdom of Great Britain and Northern Ireland	Europe	TRUE	GIB	Gibraltar
237	Greece	Europe	TRUE	GRC	Greece
238	Croatia (Republic of)	Europe	TRUE	HRV	Croatia
239	Greece	Europe	TRUE	GRC	Greece
240	Greece	Europe	TRUE	GRC	Greece
241	Greece	Europe	TRUE	GRC	Greece
242	Morocco (Kingdom of)	Africa	FALSE	MAR	Morocco
243	Hungary	Europe	TRUE	HUN	Hungary
244	Netherlands (Kingdom of the)	Europe	TRUE	NLD	Netherlands
245	Netherlands (Kingdom of the)	Europe	TRUE	NLD	Netherlands
246	Netherlands (Kingdom of the)	Europe	TRUE	NLD	Netherlands
247	Italy	Europe	TRUE	ITA	Italy
248	Malta	Europe	TRUE	MLT	Malta
249	Malta	Europe	TRUE	MLT	Malta
250	Ireland	Europe	TRUE	IRL	Republic of Ireland
251	Iceland	Europe	FALSE	ISL	Iceland
252	Liechtenstein (Principality of)	Europe	FALSE	LIE	Liechtenstein
253	Luxembourg	Europe	TRUE	LUX	Luxembourg
254	Monaco (Principality of)	Europe	FALSE	MCO	Monaco
540	New Caledonia - France	Oceania	FALSE	NCL	New Caledonia
256	Malta	Europe	TRUE	MLT	Malta
257	Norway	Europe	FALSE	NOR	Norway
258	Norway	Europe	FALSE	NOR	Norway
259	Norway	Europe	FALSE	NOR	Norway
261	Poland (Republic of)	Europe	TRUE	POL	Poland
262	Montenegro	Europe	FALSE	MNE	Montenegro
263	Portugal	Europe	TRUE	PRT	Portugal
264	Romania	Europe	TRUE	ROU	Romania
265	Sweden	Europe	TRUE	SWE	Sweden
266	Sweden	Europe	TRUE	SWE	Sweden
267	Slovak Republic	Europe	TRUE	SVK	Slovakia
268	San Marino (Republic of)	Europe	FALSE	SMR	San Marino
269	Switzerland (Confederation of)	Europe	FALSE	CHE	Switzerland
270	Czech Republic	Europe	TRUE	CZE	Czech Republic
271	Turkey	Asia	FALSE	TUR	Turkey
272	Ukraine	Europe	FALSE	UKR	Ukraine
273	Russian Federation	? 	FALSE	RUS	Russia
274	The Former Yugoslav Republic of Macedonia	Europe	FALSE	MKD	Republic of Macedonia
275	Latvia (Republic of)	Europe	TRUE	LVA	Latvia
276	Estonia (Republic of)	Europe	TRUE	EST	Estonia
277	Lithuania (Republic of)	Europe	TRUE	LTU	Lithuania
278	Slovenia (Republic of)	Europe	TRUE	SVN	Slovenia
279	Serbia (Republic of)	Europe	FALSE	SRB	Serbia
740	Falkland Islands (Malvinas) - United Kingdom of Great Britain and Northern Ireland	SA	TRUE	FLK	Falkland Islands
303	Alaska (State of) - United States of America	NA	FALSE	USA	United States
304	Antigua and Barbuda	NA	FALSE	ATG	Antigua and Barbuda
305	Antigua and Barbuda	NA	FALSE	ATG	Antigua and Barbuda
660	Reunion (French Department of) - France	Africa	TRUE	REU	Réunion
635	Kerguelen Islands - France	? Africa	FALSE	ATF	French Southern and Antarctic Lands
308	Bahamas (Commonwealth of the)	NA	FALSE	BHS	The Bahamas
309	Bahamas (Commonwealth of the)	NA	FALSE	BHS	The Bahamas
255	Madeira - Portugal	Africa	TRUE	PRT	Portugal
311	Bahamas (Commonwealth of the)	NA	FALSE	BHS	The Bahamas
312	Belize	NA	FALSE	BLZ	Belize
314	Barbados	NA	FALSE	BRB	Barbados
316	Canada	NA	FALSE	CAN	Canada
665	Saint Helena - United Kingdom of Great Britain and Northern Ireland	Africa	FALSE	SHN	Saint Helena
321	Costa Rica	NA	FALSE	CRI	Costa Rica
323	Cuba	NA	FALSE	CUB	Cuba
325	Dominica (Commonwealth of)	NA	FALSE	DMA	Dominica
327	Dominican Republic	NA	FALSE	DOM	Dominican Republic
329	Guadeloupe (French Department of) - France	NA	TRUE	GLP	Guadeloupe
330	Grenada	NA	FALSE	GRD	Grenada
331	Greenland - Denmark	Europe	FALSE	GRL	Greenland
332	Guatemala (Republic of)	NA	FALSE	GTM	Guatemala
334	Honduras (Republic of)	NA	FALSE	HND	Honduras
336	Haiti (Republic of)	NA	FALSE	HTI	Haiti
338	United States of America	NA	FALSE	USA	United States
339	Jamaica	NA	FALSE	JAM	Jamaica
341	Saint Kitts and Nevis (Federation of)	NA	FALSE	KNA	Saint Kitts and Nevis
343	Saint Lucia	NA	FALSE	LCA	Saint Lucia
345	Mexico	NA	FALSE	MEX	Mexico
347	Martinique (French Department of) - France	NA	FALSE	MTQ	Martinique
348	Montserrat - United Kingdom of Great Britain and Northern Ireland	NA	FALSE	MSR	Montserrat
350	Nicaragua	NA	FALSE	NIC	Nicaragua
351	Panama (Republic of)	NA	FALSE	PAN	Panama
352	Panama (Republic of)	NA	FALSE	PAN	Panama
353	Panama (Republic of)	NA	FALSE	PAN	Panama
354	Panama (Republic of)	NA	FALSE	PAN	Panama
355	Panama (Republic of)	NA	FALSE	PAN	Panama
356	Panama (Republic of)	NA	FALSE	PAN	Panama
357	Panama (Republic of)	NA	FALSE	PAN	Panama
358	Puerto Rico - United States of America	NA	FALSE	PRI	Puerto Rico
359	El Salvador (Republic of)	NA	FALSE	SLV	El Salvador
319	Cayman Islands - United Kingdom of Great Britain and Northern Ireland	NA	TRUE	CYM	Cayman Islands
362	Trinidad and Tobago	NA	FALSE	TTO	Trinidad and Tobago
618	Crozet Archipelago - France	? Africa	FALSE	ATF	French Southern and Antarctic Lands
366	United States of America	NA	FALSE	USA	United States
367	United States of America	NA	FALSE	USA	United States
368	United States of America	NA	FALSE	USA	United States
369	United States of America	NA	FALSE	USA	United States
370	Panama (Republic of)	NA	FALSE	PAN	Panama
371	Panama (Republic of)	NA	FALSE	PAN	Panama
372	Panama (Republic of)	NA	FALSE	PAN	Panama
373	Panama (Republic of)	NA	FALSE	PAN	Panama
375	Saint Vincent and the Grenadines	NA	FALSE	VCT	Saint Vincent and the Grenadines
376	Saint Vincent and the Grenadines	NA	FALSE	VCT	Saint Vincent and the Grenadines
377	Saint Vincent and the Grenadines	NA	FALSE	VCT	Saint Vincent and the Grenadines
546	French Polynesia - France	Oceania	FALSE	PYF	French Polynesia
379	United States Virgin Islands - United States of America	NA	FALSE	VIR	Virgin Islands, U.S.
401	Afghanistan	Asia	FALSE	AFG	Afghanistan
403	Saudi Arabia (Kingdom of)	Asia	FALSE	SAU	Saudi Arabia
405	Bangladesh (People's Republic of)	Asia	FALSE	BGD	Bangladesh
408	Bahrain (Kingdom of)	Asia	FALSE	BHR	Bahrain
410	Bhutan (Kingdom of)	Asia	FALSE	BTN	Bhutan
412	China (People's Republic of)	Asia	FALSE	CHN	China
413	China (People's Republic of)	Asia	FALSE	CHN	China
414	China (People's Republic of)	Asia	FALSE	CHN	China
416	Taiwan (Province of China) - China (People's Republic of)	Asia	FALSE	TWN	Taiwan
417	Sri Lanka (Democratic Socialist Republic of)	Asia	FALSE	LKA	Sri Lanka
419	India (Republic of)	Asia	FALSE	IND	India
422	Iran (Islamic Republic of)	Asia	FALSE	IRN	Iran
423	Azerbaijan (Republic of)	Asia	FALSE	AZE	Azerbaijan
425	Iraq (Republic of)	Asia	FALSE	IRQ	Iraq
428	Israel (State of)	Asia	FALSE	ISR	Israel
431	Japan	Asia	FALSE	JPN	Japan
432	Japan	Asia	FALSE	JPN	Japan
434	Turkmenistan	Asia	FALSE	TKM	Turkmenistan
436	Kazakhstan (Republic of)	Asia	FALSE	KAZ	Kazakhstan
437	Uzbekistan (Republic of)	Asia	FALSE	UZB	Uzbekistan
438	Jordan (Hashemite Kingdom of)	Asia	FALSE	JOR	Jordan
440	Korea (Republic of)	Asia	FALSE	KOR	South Korea
441	Korea (Republic of)	Asia	FALSE	KOR	South Korea
443	State of Palestine (In accordance with Resolution 99 Rev. Guadalajara, 2010)	Asia	FALSE	PSE	Palestine
445	Democratic People's Republic of Korea	Asia	FALSE	PRK	North Korea
447	Kuwait (State of)	Asia	FALSE	KWT	Kuwait
450	Lebanon	Asia	FALSE	LBN	Lebanon
451	Kyrgyz Republic	Asia	FALSE	KGZ	Kyrgyzstan
453	Macao (Special Administrative Region of China) - China (People's Republic of)	Asia	FALSE	MAC	Macau
455	Maldives (Republic of)	Asia	FALSE	MDV	Maldives
457	Mongolia	Asia	FALSE	MNG	Mongolia
459	Nepal (Federal Democratic Republic of)	Asia	FALSE	NPL	Nepal
461	Oman (Sultanate of)	Asia	FALSE	OMN	Oman
463	Pakistan (Islamic Republic of)	Asia	FALSE	PAK	Pakistan
466	Qatar (State of)	Asia	FALSE	QAT	Qatar
468	Syrian Arab Republic	Asia	FALSE	SYR	Syria
470	United Arab Emirates	Asia	FALSE	ARE	United Arab Emirates
472	Tajikistan (Republic of)	Asia	FALSE	TJK	Tajikistan
473	Yemen (Republic of)	Asia	FALSE	YEM	Yemen
475	Yemen (Republic of)	Asia	FALSE	YEM	Yemen
477	Hong Kong (Special Administrative Region of China) - China (People's Republic of)	Asia	FALSE	HKG	Hong Kong
478	Bosnia and Herzegovina	Europe	FALSE	BIH	Bosnia and Herzegovina
306	Anilles, Bonaire, Sint Eustatius and Saba - Netherlands (Kingdom of the)	NA	FALSE	BES	Bonaire
503	Australia	Oceania	FALSE	AUS	Australia
506	Myanmar (Union of)	Asia	FALSE	MMR	Myanmar
508	Brunei Darussalam	Asia	FALSE	BRN	Brunei
510	Micronesia (Federated States of)	Oceania	FALSE	FSM	Federated States of Micronesia
511	Palau (Republic of)	Oceania	FALSE	PLW	Palau
512	New Zealand	Oceania	FALSE	NZL	New Zealand
514	Cambodia (Kingdom of)	Asia	FALSE	KHM	Cambodia
515	Cambodia (Kingdom of)	Asia	FALSE	KHM	Cambodia
516	Christmas Island (Indian Ocean) - Australia	Oceania	FALSE	CXR	Christmas Island
518	Cook Islands - New Zealand	Oceania	FALSE	COK	Cook Islands
520	Fiji (Republic of)	Oceania	FALSE	FJI	Fiji
523	Cocos (Keeling) Islands - Australia	Oceania	FALSE	CCK	Cocos (Keeling) Islands
525	Indonesia (Republic of)	Asia	FALSE	IDN	Indonesia
529	Kiribati (Republic of)	Oceania	FALSE	KIR	Kiribati
531	Lao People's Democratic Republic	Asia	FALSE	LAO	Laos
533	Malaysia	Asia	FALSE	MYS	Malaysia
536	Northern Mariana Islands (Commonwealth of the) - United States of America	Oceania	FALSE	MNP	Northern Mariana Islands
538	Marshall Islands (Republic of the)	Oceania	FALSE	MHL	Marshall Islands
361	Saint Pierre and Miquelon (Territorial Collectivity of) - France	NA	FALSE	SPM	Saint Pierre and Miquelon
542	Niue - New Zealand	Oceania	FALSE	NIU	Niue
544	Nauru (Republic of)	Oceania	FALSE	NRU	Nauru
378	British Virgin Islands - United Kingdom of Great Britain and Northern Ireland	NA	TRUE	VGB	British Virgin Islands
548	Philippines (Republic of the)	Asia	FALSE	PHL	Philippines
553	Papua New Guinea	Oceania	FALSE	PNG	Papua New Guinea
745	Guiana (French Department of) - France	SA	TRUE	GUF	French Guiana
557	Solomon Islands	Oceania	FALSE	SLB	Solomon Islands
559	American Samoa - United States of America	Oceania	FALSE	ASM	American Samoa
561	Samoa (Independent State of)	Oceania	FALSE	WSM	Samoa
563	Singapore (Republic of)	Asia	FALSE	SGP	Singapore
564	Singapore (Republic of)	Asia	FALSE	SGP	Singapore
565	Singapore (Republic of)	Asia	FALSE	SGP	Singapore
566	Singapore (Republic of)	Asia	FALSE	SGP	Singapore
567	Thailand	Asia	FALSE	THA	Thailand
570	Tonga (Kingdom of)	Oceania	FALSE	TON	Tonga
572	Tuvalu	Oceania	FALSE	TUV	Tuvalu
574	Viet Nam (Socialist Republic of)	Asia	FALSE	VNM	Vietnam
576	Vanuatu (Republic of)	Oceania	FALSE	VUT	Vanuatu
577	Vanuatu (Republic of)	Oceania	FALSE	VUT	Vanuatu
301	Anguilla - United Kingdom of Great Britain and Northern Ireland	NA	TRUE	AIA	Anguilla
601	South Africa (Republic of)	Africa	FALSE	ZAF	South Africa
603	Angola (Republic of)	Africa	FALSE	AGO	Angola
605	Algeria (People's Democratic Republic of)	Africa	FALSE	DZA	Algeria
555	Pitcairn Island - United Kingdom of Great Britain and Northern Ireland	Oceania	FALSE	PCN	Pitcairn Islands
501	Adelie Land - France	? Antartica	FALSE	ATF	French Southern and Antarctic Lands
609	Burundi (Republic of)	Africa	FALSE	BDI	Burundi
610	Benin (Republic of)	Africa	FALSE	BEN	Benin
611	Botswana (Republic of)	Africa	FALSE	BWA	Botswana
612	Central African Republic	Africa	FALSE	CAF	Central African Republic
613	Cameroon (Republic of)	Africa	FALSE	CMR	Cameroon
615	Congo (Republic of the)	Africa	FALSE	COG	Republic of the Congo
616	Comoros (Union of the)	Africa	FALSE	COM	Comoros
617	Cabo Verde (Republic of)	Africa	FALSE	CPV	Cape Verde
307	Aruba - Netherlands (Kingdom of the)	NA	FALSE	ABW	Aruba
619	Cote d'Ivoire (Republic of)	Africa	FALSE	CIV	Ivory Coast
620	Comoros (Union of the)	Africa	FALSE	COM	Comoros
621	Djibouti (Republic of)	Africa	FALSE	DJI	Djibouti
622	Egypt (Arab Republic of)	Africa	FALSE	EGY	Egypt
624	Ethiopia (Federal Democratic Republic of)	Africa	FALSE	ETH	Ethiopia
625	Eritrea	Africa	FALSE	ERI	Eritrea
626	Gabonese Republic	Africa	FALSE	GAB	Gabon
627	Ghana	Africa	FALSE	GHA	Ghana
629	Gambia (Republic of the)	Africa	FALSE	GMB	The Gambia
630	Guinea-Bissau (Republic of)	Africa	FALSE	GNB	Guinea-Bissau
631	Equatorial Guinea (Republic of)	Africa	FALSE	GNQ	Equatorial Guinea
632	Guinea (Republic of)	Africa	FALSE	GIN	Guinea
633	Burkina Faso	Africa	FALSE	BFA	Burkina Faso
634	Kenya (Republic of)	Africa	FALSE	KEN	Kenya
310	Bermuda - United Kingdom of Great Britain and Northern Ireland	NA	FALSE	BMU	Bermuda
636	Liberia (Republic of)	Africa	FALSE	LBR	Liberia
637	Liberia (Republic of)	Africa	FALSE	LBR	Liberia
638	South Sudan (Republic of)	Africa	FALSE	SSD	South Sudan
642	Libya	Africa	FALSE	LBY	Libya
644	Lesotho (Kingdom of)	Africa	FALSE	LSO	Lesotho
645	Mauritius (Republic of)	Africa	FALSE	MUS	Mauritius
647	Madagascar (Republic of)	Africa	FALSE	MDG	Madagascar
649	Mali (Republic of)	Africa	FALSE	MLI	Mali
650	Mozambique (Republic of)	Africa	FALSE	MOZ	Mozambique
654	Mauritania (Islamic Republic of)	Africa	FALSE	MRT	Mauritania
655	Malawi	Africa	FALSE	MWI	Malawi
656	Niger (Republic of the)	Africa	FALSE	NER	Niger
657	Nigeria (Federal Republic of)	Africa	FALSE	NGA	Nigeria
659	Namibia (Republic of)	Africa	FALSE	NAM	Namibia
364	Turks and Caicos Islands - United Kingdom of Great Britain and Northern Ireland	NA	FALSE	TCA	Turks and Caicos Islands
661	Rwanda (Republic of)	Africa	FALSE	RWA	Rwanda
662	Sudan (Republic of the)	Africa	FALSE	SDN	Sudan
663	Senegal (Republic of)	Africa	FALSE	SEN	Senegal
664	Seychelles (Republic of)	Africa	FALSE	SYC	Seychelles
578	Wallis and Futuna Islands - France	Oceania	TRUE	WLF	Wallis and Futuna
666	Somalia (Federal Republic of)	Africa	FALSE	SOM	Somalia
667	Sierra Leone	Africa	FALSE	SLE	Sierra Leone
668	Sao Tome and Principe (Democratic Republic of)	Africa	FALSE	STP	São Tomé and Príncipe
669	Swaziland (Kingdom of)	Africa	FALSE	SWZ	Swaziland
670	Chad (Republic of)	Africa	FALSE	TCD	Chad
671	Togolese Republic	Africa	FALSE	TGO	Togo
672	Tunisia	Africa	FALSE	TUN	Tunisia
674	Tanzania (United Republic of)	Africa	FALSE	TZA	Tanzania
675	Uganda (Republic of)	Africa	FALSE	UGA	Uganda
676	Democratic Republic of the Congo	Africa	FALSE	COD	Democratic Republic of the Congo
677	Tanzania (United Republic of)	Africa	FALSE	TZA	Tanzania
678	Zambia (Republic of)	Africa	FALSE	ZMB	Zambia
679	Zimbabwe (Republic of)	Africa	FALSE	ZWE	Zimbabwe
701	Argentine Republic	SA	FALSE	ARG	Argentina
710	Brazil (Federative Republic of)	SA	FALSE	BRA	Brazil
720	Bolivia (Plurinational State of)	SA	FALSE	BOL	Bolivia
725	Chile	SA	FALSE	CHL	Chile
730	Colombia (Republic of)	SA	FALSE	COL	Colombia
735	Ecuador	SA	FALSE	ECU	Ecuador
607	Saint Paul and Amsterdam Islands - France	?	FALSE	ATF	French Southern and Antarctic Lands
608	Ascension Island - United Kingdom of Great Britain and Northern Ireland	Africa	TRUE	SHN	Saint Helena
750	Guyana	SA	FALSE	GUY	Guyana
755	Paraguay (Republic of)	SA	FALSE	PRY	Paraguay
760	Peru	SA	FALSE	PER	Peru
765	Suriname (Republic of)	SA	FALSE	SUR	Suriname
770	Uruguay (Eastern Republic of)	SA	FALSE	URY	Uruguay
775	Venezuela (Bolivarian Republic of)	SA	FALSE	VEN	Venezuela

In [55]:

    

newrows = []
with io.open('EEZs_iso3.csv', 'rU',encoding='utf-8',errors='ignore') as csvfile:
    countries = csv.reader(csvfile)
    for row in countries:
        if row[0] == "eez":
            row = row + ['name']
        else:
            try:
                row = row + [get_country_name(row[-1])]
            except:
                try: 
                    row = row + [cname_dict[row[-1]]]
                except:
                    pass
        newrows.append(row)


    

In [56]:

    

for i in range(len(newrows)):
    print "\t".join(newrows[i])


    

    




eez	iso3	name
EEZ:Albania	ALB	Albania
EEZ:Algeria	DZA	Algeria
EEZ:American Samoa	ASM	American Samoa
EEZ:Angola	AGO	Angola
EEZ:Anguilla	AIA	Anguilla
EEZ:Antarctica	ATA	Antarctica
EEZ:Antigua & Barbuda	ATG	Antigua and Barbuda
EEZ:Area of overlap Australia/Indonesia	AUS/IDN
EEZ:Argentina	ARG	Argentina
EEZ:Aruba	ABW	Aruba
EEZ:Australia	AUS	Australia
EEZ:Austria	AUT	Austria
EEZ:Azerbaijan	AZE	Azerbaijan
EEZ:Bahrain	BHR	Bahrain
EEZ:Bangladesh	BGD	Bangladesh
EEZ:Barbados	BRB	Barbados
EEZ:Belgium	BEL	Belgium
EEZ:Belize	BLZ	Belize
EEZ:Benin	BEN	Benin
EEZ:Bermuda	BMU	Bermuda
EEZ:Bonaire, Sint-Eustasius, Saba	BES	Bonaire
EEZ:Bosnia & Herzegovina	BIH	Bosnia and Herzegovina
EEZ:Bouvet I.	BVT	Bouvet Island
EEZ:Brazil	BRA	Brazil
EEZ:British Indian Ocean Territory	IOT	British Indian Ocean Territory
EEZ:Brunei	BRN	Brunei
EEZ:Bulgaria	BGR	Bulgaria
EEZ:Cambodia	KHM	Cambodia
EEZ:Cameroon	CMR	Cameroon
EEZ:Canada	CAN	Canada
EEZ:Cape Verde	CPV	Cape Verde
EEZ:Cayman Is.	CYM	Cayman Islands
EEZ:Chile	CHL	Chile
EEZ:China	CHN	China
EEZ:Christmas I.	CXR	Christmas Island
EEZ:Clipperton Island	CPT
EEZ:Cocos Is.	CCK	Cocos (Keeling) Islands
EEZ:Colombia	COL	Colombia
EEZ:Comoros	COM	Comoros
EEZ:Conflict zone China/Japan/Taiwan	CHN/JPN/TWN
EEZ:Conflict zone Japan/Russia	JPN/RUS
EEZ:Conflict zone Japan/South Korea	JPN/KOR
EEZ:Congo	COG	Republic of the Congo
EEZ:Congo, DRC	COD	Democratic Republic of the Congo
EEZ:Cook Is.	COK	Cook Islands
EEZ:Costa Rica	CRI	Costa Rica
EEZ:Cote d'Ivoire	CIV	Ivory Coast
EEZ:Croatia	HRV	Croatia
EEZ:Cuba	CUB	Cuba
EEZ:Curaao	CUW	Curaçao
EEZ:Cyprus	CYP	Cyprus
EEZ:Denmark	DNK	Denmark
EEZ:Disputed Barbados/Trinidad & Tobago	BRB/TTO
EEZ:Disputed Kenya/Somalia	KEN/SOM
EEZ:Disputed Western Sahara/Mauritania	ESH/MRT
EEZ:Djibouti	DJI	Djibouti
EEZ:Dominica	DMA	Dominica
EEZ:Dominican Republic	DOM	Dominican Republic
EEZ:Ecuador	ECU	Ecuador
EEZ:Egypt	EGY	Egypt
EEZ:El Salvador	SLV	El Salvador
EEZ:Equatorial Guinea	GNQ	Equatorial Guinea
EEZ:Eritrea	ERI	Eritrea
EEZ:Estonia	EST	Estonia
EEZ:Falkland Islands	FLK	Falkland Islands
EEZ:Faroe Is.	FRO	Faroe Islands
EEZ:Fiji	FJI	Fiji
EEZ:Finland	FIN	Finland
EEZ:France	FRA	France
EEZ:French Guiana	GUF	French Guiana
EEZ:French Polynesia	PYF	French Polynesia
EEZ:French Southern & Antarctic Lands	ATF	French Southern and Antarctic Lands
EEZ:Gabon	GAB	Gabon
EEZ:Georgia	GEO	Georgia
EEZ:Germany	DEU	Germany
EEZ:Ghana	GHA	Ghana
EEZ:Gibraltar	GIB	Gibraltar
EEZ:Greece	GRC	Greece
EEZ:Greenland	GRL	Greenland
EEZ:Grenada	GRD	Grenada
EEZ:Guadeloupe	GLP	Guadeloupe
EEZ:Guatemala	GTM	Guatemala
EEZ:Guernsey	GGY	Guernsey
EEZ:Guinea	GIN	Guinea
EEZ:Guinea-Bissau	GNB	Guinea-Bissau
EEZ:Guyana	GUY	Guyana
EEZ:Haiti	HTI	Haiti
EEZ:Heard I. & McDonald Is.	HMD	Heard Island and McDonald Islands
EEZ:Honduras	HND	Honduras
EEZ:Hungary	HUN	Hungary
EEZ:Iceland	ISL	Iceland
EEZ:India	IND	India
EEZ:Indonesia	IDN	Indonesia
EEZ:Iran	IRN	Iran
EEZ:Iraq	IRQ	Iraq
EEZ:Ireland	IRL	Republic of Ireland
EEZ:Israel	ISR	Israel
EEZ:Italy	ITA	Italy
EEZ:Jamaica	JAM	Jamaica
EEZ:Jan Mayen	SJM	Svalbard and Jan Mayen
EEZ:Japan	JPN	Japan
EEZ:Jersey	JEY	Jersey
EEZ:Joint development area Australia/East Timor	AUS/TLS
EEZ:Joint regime Colombia/Jamaica	COL/JAM
EEZ:Joint regime Japan/Korea	JPN/KOR
EEZ:Joint regime Nigeria/Sao Tome and Principe	NGA/STP
EEZ:Jordan	JOR	Jordan
EEZ:Kazakhstan	KAZ	Kazakhstan
EEZ:Kenya	KEN	Kenya
EEZ:Kiribati	KIR	Kiribati
EEZ:Kuwait	KWT	Kuwait
EEZ:Laos	LAO	Laos
EEZ:Latvia	LVA	Latvia
EEZ:Lebanon	LBN	Lebanon
EEZ:Liberia	LBR	Liberia
EEZ:Libya	LBY	Libya
EEZ:Lithuania	LTU	Lithuania
EEZ:Luxembourg	LUX	Luxembourg
EEZ:Madagascar	MDG	Madagascar
EEZ:Malaysia	MYS	Malaysia
EEZ:Maldives	MDV	Maldives
EEZ:Malta	MLT	Malta
EEZ:Marshall Is.	MHL	Marshall Islands
EEZ:Martinique	MTQ	Martinique
EEZ:Mauritania	MRT	Mauritania
EEZ:Mauritius	MUS	Mauritius
EEZ:Mayotte	MYT	Mayotte
EEZ:Mexico	MEX	Mexico
EEZ:Micronesia	FSM	Federated States of Micronesia
EEZ:Monaco	MCO	Monaco
EEZ:Montenegro	MNE	Montenegro
EEZ:Montserrat	MSR	Montserrat
EEZ:Morocco	MAR	Morocco
EEZ:Mozambique	MOZ	Mozambique
EEZ:Myanmar	MMR	Myanmar
EEZ:Namibia	NAM	Namibia
EEZ:Nauru	NRU	Nauru
EEZ:Netherlands	NLD	Netherlands
EEZ:Netherlands Antilles	ANT	Netherlands Antilles
EEZ:New Caledonia	NCL	New Caledonia
EEZ:New Zealand	NZL	New Zealand
EEZ:Nicaragua	NIC	Nicaragua
EEZ:Nigeria	NGA	Nigeria
EEZ:Niue	NIU	Niue
EEZ:Norfolk I.	NFK	Norfolk Island
EEZ:North Korea	PRK	North Korea
EEZ:Northern Marinana Islands-Guam	MNP	Northern Mariana Islands
EEZ:Norway	NOR	Norway
EEZ:Oman	OMN	Oman
EEZ:Pakistan	PAK	Pakistan
EEZ:Palau	PLW	Palau
EEZ:Panama	PAN	Panama
EEZ:Papua New Guinea	PNG	Papua New Guinea
EEZ:Paracel Islands	CHN/TWN
EEZ:Paraguay	PRY	Paraguay
EEZ:Peru	PER	Peru
EEZ:Philippines	PHL	Philippines
EEZ:Pitcairn Is.	PCN	Pitcairn Islands
EEZ:Poland	POL	Poland
EEZ:Portugal	PRT	Portugal
EEZ:Puerto Rico	PRI	Puerto Rico
EEZ:Qatar	QAT	Qatar
EEZ:Reunion	REU	Réunion
EEZ:Romania	ROU	Romania
EEZ:Russia	RUS	Russia
EEZ:Saint Helena, Ascension en Tristan da Cunha	SHN	Saint Helena
EEZ:Saint Martin	MAF	Saint Martin
EEZ:Saint Vincent and the Grenadines	VCT	Saint Vincent and the Grenadines
EEZ:Samoa	WSM	Samoa
EEZ:Sao Tome & Principe	STP	São Tomé and Príncipe
EEZ:Saudi Arabia	SAU	Saudi Arabia
EEZ:Senegal	SEN	Senegal
EEZ:Serbia	SRB	Serbia
EEZ:Seychelles	SYC	Seychelles
EEZ:Sierra Leone	SLE	Sierra Leone
EEZ:Singapore	SGP	Singapore
EEZ:Sint Maarten	SXM	Sint Maarten
EEZ:Slovakia	SVK	Slovakia
EEZ:Slovenia	SVN	Slovenia
EEZ:Solomon Is.	SLB	Solomon Islands
EEZ:Somalia	SOM	Somalia
EEZ:South Africa	ZAF	South Africa
EEZ:South Georgia & the South Sandwich Is.	SGS	South Georgia
EEZ:South Korea	KOR	South Korea
EEZ:Spain	ESP	Spain
EEZ:Spratly Islands	CHN/PHL/VNM/TWN/MYS
EEZ:Sri Lanka	LKA	Sri Lanka
EEZ:St. Kitts & Nevis	KNA	Saint Kitts and Nevis
EEZ:St. Lucia	LCA	Saint Lucia
EEZ:St. Pierre & Miquelon	SPM	Saint Pierre and Miquelon
EEZ:Sudan	SDN	Sudan
EEZ:Suriname	SUR	Suriname
EEZ:Svalbard	SJM	Svalbard and Jan Mayen
EEZ:Sweden	SWE	Sweden
EEZ:Switzerland	CHE	Switzerland
EEZ:Syria	SYR	Syria
EEZ:Taiwan	TWN	Taiwan
EEZ:Tanzania	TZA	Tanzania
EEZ:Thailand	THA	Thailand
EEZ:The Bahamas	BHS	The Bahamas
EEZ:The Gambia	GMB	The Gambia
EEZ:Timor-Leste	TLS	East Timor
EEZ:Togo	TGO	Togo
EEZ:Tokelau	TKL	Tokelau
EEZ:Tonga	TON	Tonga
EEZ:Trinidad & Tobago	TTO	Trinidad and Tobago
EEZ:Tunisia	TUN	Tunisia
EEZ:Turkey	TUR	Turkey
EEZ:Turkmenistan	TKM	Turkmenistan
EEZ:Turks & Caicos Is.	TCA	Turks and Caicos Islands
EEZ:Tuvalu	TUV	Tuvalu
EEZ:Ukraine	UKR	Ukraine
EEZ:United Arab Emirates	ARE	United Arab Emirates
EEZ:United Kingdom	GBR	United Kingdom
EEZ:United States	USA	United States
EEZ:United States Minor Outlying Islands	UMI	United States Minor Outlying Islands
EEZ:United States Virgin Islands	VIR	Virgin Islands, U.S.
EEZ:Uruguay	URY	Uruguay
EEZ:Vanuatu	VUT	Vanuatu
EEZ:Venezuela	VEN	Venezuela
EEZ:Vietnam	VNM	Vietnam
EEZ:Virgin Islands, British	VGB	British Virgin Islands
EEZ:Wallis & Futuna	WLF	Wallis and Futuna
EEZ:Western Sahara	ESH	Western Sahara
EEZ:Yemen	YEM	Yemen

In [ ]: