{
"cells": [
{
"cell_type": "markdown",
"id": "widespread-salvation",
"metadata": {},
"source": [
"## Exercise\n",
"\n",
"Load csv file with major cities from https://datahub.io/core/world-cities into a Pandas dataframe."
]
},
{
"cell_type": "code",
"execution_count": 1,
"id": "homeless-haven",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "known-powell",
"metadata": {},
"outputs": [],
"source": [
"cities = pd.read_csv('world-cities_csv.csv')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "elder-berkeley",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" name country subcountry geonameid\n",
"0 les Escaldes Andorra Escaldes-Engordany 3040051\n",
"1 Andorra la Vella Andorra Andorra la Vella 3041563\n",
"2 Umm al Qaywayn United Arab Emirates Umm al Qaywayn 290594\n",
"3 Ras al-Khaimah United Arab Emirates Raʼs al Khaymah 291074\n",
"4 Khawr Fakkān United Arab Emirates Ash Shāriqah 291696\n",
"... ... ... ... ...\n",
"23013 Bulawayo Zimbabwe Bulawayo 894701\n",
"23014 Bindura Zimbabwe Mashonaland Central 895061\n",
"23015 Beitbridge Zimbabwe Matabeleland South 895269\n",
"23016 Epworth Zimbabwe Harare 1085510\n",
"23017 Chitungwiza Zimbabwe Harare 1106542\n",
"\n",
"[23018 rows x 4 columns]\n"
]
}
],
"source": [
"print(cities)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "vulnerable-interface",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"pandas.core.frame.DataFrame"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"type(cities)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "unnecessary-ethics",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" les Escaldes | \n",
" Andorra | \n",
" Escaldes-Engordany | \n",
" 3040051 | \n",
"
\n",
" \n",
" 1 | \n",
" Andorra la Vella | \n",
" Andorra | \n",
" Andorra la Vella | \n",
" 3041563 | \n",
"
\n",
" \n",
" 2 | \n",
" Umm al Qaywayn | \n",
" United Arab Emirates | \n",
" Umm al Qaywayn | \n",
" 290594 | \n",
"
\n",
" \n",
" 3 | \n",
" Ras al-Khaimah | \n",
" United Arab Emirates | \n",
" Raʼs al Khaymah | \n",
" 291074 | \n",
"
\n",
" \n",
" 4 | \n",
" Khawr Fakkān | \n",
" United Arab Emirates | \n",
" Ash Shāriqah | \n",
" 291696 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 23013 | \n",
" Bulawayo | \n",
" Zimbabwe | \n",
" Bulawayo | \n",
" 894701 | \n",
"
\n",
" \n",
" 23014 | \n",
" Bindura | \n",
" Zimbabwe | \n",
" Mashonaland Central | \n",
" 895061 | \n",
"
\n",
" \n",
" 23015 | \n",
" Beitbridge | \n",
" Zimbabwe | \n",
" Matabeleland South | \n",
" 895269 | \n",
"
\n",
" \n",
" 23016 | \n",
" Epworth | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1085510 | \n",
"
\n",
" \n",
" 23017 | \n",
" Chitungwiza | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1106542 | \n",
"
\n",
" \n",
"
\n",
"
23018 rows × 4 columns
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"0 les Escaldes Andorra Escaldes-Engordany 3040051\n",
"1 Andorra la Vella Andorra Andorra la Vella 3041563\n",
"2 Umm al Qaywayn United Arab Emirates Umm al Qaywayn 290594\n",
"3 Ras al-Khaimah United Arab Emirates Raʼs al Khaymah 291074\n",
"4 Khawr Fakkān United Arab Emirates Ash Shāriqah 291696\n",
"... ... ... ... ...\n",
"23013 Bulawayo Zimbabwe Bulawayo 894701\n",
"23014 Bindura Zimbabwe Mashonaland Central 895061\n",
"23015 Beitbridge Zimbabwe Matabeleland South 895269\n",
"23016 Epworth Zimbabwe Harare 1085510\n",
"23017 Chitungwiza Zimbabwe Harare 1106542\n",
"\n",
"[23018 rows x 4 columns]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "plastic-pickup",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"pandas.core.series.Series"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"type(cities['name'])"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "developmental-southeast",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" les Escaldes | \n",
" Andorra | \n",
"
\n",
" \n",
" 1 | \n",
" Andorra la Vella | \n",
" Andorra | \n",
"
\n",
" \n",
" 2 | \n",
" Umm al Qaywayn | \n",
" United Arab Emirates | \n",
"
\n",
" \n",
" 3 | \n",
" Ras al-Khaimah | \n",
" United Arab Emirates | \n",
"
\n",
" \n",
" 4 | \n",
" Khawr Fakkān | \n",
" United Arab Emirates | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 23013 | \n",
" Bulawayo | \n",
" Zimbabwe | \n",
"
\n",
" \n",
" 23014 | \n",
" Bindura | \n",
" Zimbabwe | \n",
"
\n",
" \n",
" 23015 | \n",
" Beitbridge | \n",
" Zimbabwe | \n",
"
\n",
" \n",
" 23016 | \n",
" Epworth | \n",
" Zimbabwe | \n",
"
\n",
" \n",
" 23017 | \n",
" Chitungwiza | \n",
" Zimbabwe | \n",
"
\n",
" \n",
"
\n",
"
23018 rows × 2 columns
\n",
"
"
],
"text/plain": [
" name country\n",
"0 les Escaldes Andorra\n",
"1 Andorra la Vella Andorra\n",
"2 Umm al Qaywayn United Arab Emirates\n",
"3 Ras al-Khaimah United Arab Emirates\n",
"4 Khawr Fakkān United Arab Emirates\n",
"... ... ...\n",
"23013 Bulawayo Zimbabwe\n",
"23014 Bindura Zimbabwe\n",
"23015 Beitbridge Zimbabwe\n",
"23016 Epworth Zimbabwe\n",
"23017 Chitungwiza Zimbabwe\n",
"\n",
"[23018 rows x 2 columns]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities[['name', 'country']]"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "median-frontier",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 les Escaldes\n",
"1 Andorra la Vella\n",
"2 Umm al Qaywayn\n",
"3 Ras al-Khaimah\n",
"4 Khawr Fakkān\n",
" ... \n",
"23013 Bulawayo\n",
"23014 Bindura\n",
"23015 Beitbridge\n",
"23016 Epworth\n",
"23017 Chitungwiza\n",
"Name: name, Length: 23018, dtype: object"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.name"
]
},
{
"cell_type": "code",
"execution_count": 14,
"id": "italian-aside",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" les Escaldes | \n",
" Andorra | \n",
" Escaldes-Engordany | \n",
" 3040051 | \n",
"
\n",
" \n",
" 1 | \n",
" Andorra la Vella | \n",
" Andorra | \n",
" Andorra la Vella | \n",
" 3041563 | \n",
"
\n",
" \n",
" 2 | \n",
" Umm al Qaywayn | \n",
" United Arab Emirates | \n",
" Umm al Qaywayn | \n",
" 290594 | \n",
"
\n",
" \n",
" 3 | \n",
" Ras al-Khaimah | \n",
" United Arab Emirates | \n",
" Raʼs al Khaymah | \n",
" 291074 | \n",
"
\n",
" \n",
" 4 | \n",
" Khawr Fakkān | \n",
" United Arab Emirates | \n",
" Ash Shāriqah | \n",
" 291696 | \n",
"
\n",
" \n",
" 5 | \n",
" Dubai | \n",
" United Arab Emirates | \n",
" Dubai | \n",
" 292223 | \n",
"
\n",
" \n",
" 6 | \n",
" Dibba Al-Fujairah | \n",
" United Arab Emirates | \n",
" Al Fujayrah | \n",
" 292231 | \n",
"
\n",
" \n",
" 7 | \n",
" Dibba Al-Hisn | \n",
" United Arab Emirates | \n",
" Al Fujayrah | \n",
" 292239 | \n",
"
\n",
" \n",
" 8 | \n",
" Sharjah | \n",
" United Arab Emirates | \n",
" Ash Shāriqah | \n",
" 292672 | \n",
"
\n",
" \n",
" 9 | \n",
" Ar Ruways | \n",
" United Arab Emirates | \n",
" Abu Dhabi | \n",
" 292688 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"0 les Escaldes Andorra Escaldes-Engordany 3040051\n",
"1 Andorra la Vella Andorra Andorra la Vella 3041563\n",
"2 Umm al Qaywayn United Arab Emirates Umm al Qaywayn 290594\n",
"3 Ras al-Khaimah United Arab Emirates Raʼs al Khaymah 291074\n",
"4 Khawr Fakkān United Arab Emirates Ash Shāriqah 291696\n",
"5 Dubai United Arab Emirates Dubai 292223\n",
"6 Dibba Al-Fujairah United Arab Emirates Al Fujayrah 292231\n",
"7 Dibba Al-Hisn United Arab Emirates Al Fujayrah 292239\n",
"8 Sharjah United Arab Emirates Ash Shāriqah 292672\n",
"9 Ar Ruways United Arab Emirates Abu Dhabi 292688"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities[0:10]"
]
},
{
"cell_type": "code",
"execution_count": 36,
"id": "indonesian-diameter",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"name Århus\n",
"country Denmark\n",
"subcountry Central Jutland\n",
"geonameid 2624652\n",
"Name: 5409, dtype: object"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.iloc[5409]"
]
},
{
"cell_type": "code",
"execution_count": 23,
"id": "therapeutic-haiti",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'Århus'"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.at[5409, 'name']"
]
},
{
"cell_type": "code",
"execution_count": 25,
"id": "considerable-skirt",
"metadata": {},
"outputs": [],
"source": [
"geo = cities.set_index('geonameid')"
]
},
{
"cell_type": "code",
"execution_count": 38,
"id": "configured-cooperation",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
"
\n",
" \n",
" geonameid | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 2624652 | \n",
" Århus | \n",
" Denmark | \n",
" Central Jutland | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry\n",
"geonameid \n",
"2624652 Århus Denmark Central Jutland"
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"geo.loc[2624652:2624652]"
]
},
{
"cell_type": "code",
"execution_count": 44,
"id": "excessive-machine",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 5409 | \n",
" Århus | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2624652 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"5409 Århus Denmark Central Jutland 2624652"
]
},
"execution_count": 44,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.iloc[5409:5410]"
]
},
{
"cell_type": "code",
"execution_count": 51,
"id": "lightweight-netherlands",
"metadata": {},
"outputs": [],
"source": [
"subcountry = cities.set_index(['country', 'subcountry'])"
]
},
{
"cell_type": "code",
"execution_count": 55,
"id": "fourth-settlement",
"metadata": {},
"outputs": [],
"source": [
"dksub = subcountry.loc['Denmark']"
]
},
{
"cell_type": "code",
"execution_count": 59,
"id": "theoretical-perspective",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" geonameid | \n",
"
\n",
" \n",
" subcountry | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" South Denmark | \n",
" Aabenraa | \n",
" 2625070 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Aalborg | \n",
" 2624886 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Albertslund | \n",
" 2624906 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Ballerup | \n",
" 2624341 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Birkerød | \n",
" 2624112 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Charlottenlund | \n",
" 2623188 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Copenhagen | \n",
" 2618425 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Esbjerg | \n",
" 2622447 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Farum | \n",
" 2622306 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Fredericia | \n",
" 2621951 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Frederiksberg | \n",
" 2621942 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Frederikshavn | \n",
" 2621927 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Glostrup | \n",
" 2621356 | \n",
"
\n",
" \n",
" Zealand | \n",
" Greve | \n",
" 2621215 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Haderslev | \n",
" 2620964 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Helsingør | \n",
" 2620473 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Herning | \n",
" 2620425 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hillerød | \n",
" 2620320 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Hjørring | \n",
" 2620214 | \n",
"
\n",
" \n",
" Zealand | \n",
" Holbæk | \n",
" 2620147 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Holstebro | \n",
" 2620046 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Horsens | \n",
" 2619771 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hvidovre | \n",
" 2619528 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hørsholm | \n",
" 2619856 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Ishøj | \n",
" 2619377 | \n",
"
\n",
" \n",
" Zealand | \n",
" Kalundborg | \n",
" 2619154 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Kolding | \n",
" 2618528 | \n",
"
\n",
" \n",
" Zealand | \n",
" Korsør | \n",
" 2618361 | \n",
"
\n",
" \n",
" Zealand | \n",
" Køge | \n",
" 2618415 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Lillerød | \n",
" 2617658 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Nyborg | \n",
" 2616015 | \n",
"
\n",
" \n",
" Zealand | \n",
" Nykøbing Falster | \n",
" 2615961 | \n",
"
\n",
" \n",
" Zealand | \n",
" Næstved | \n",
" 2616038 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Nørresundby | \n",
" 2616235 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Odense | \n",
" 2615876 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Randers | \n",
" 2615006 | \n",
"
\n",
" \n",
" Zealand | \n",
" Ringsted | \n",
" 2614764 | \n",
"
\n",
" \n",
" Zealand | \n",
" Roskilde | \n",
" 2614481 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Rødovre | \n",
" 2614600 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Silkeborg | \n",
" 2614030 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Skive | \n",
" 2613731 | \n",
"
\n",
" \n",
" Zealand | \n",
" Slagelse | \n",
" 2613460 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Stenløse | \n",
" 2612629 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Svendborg | \n",
" 2612045 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Sønderborg | \n",
" 2613102 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Taastrup | \n",
" 2611828 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Vanløse | \n",
" 2610734 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Vejle | \n",
" 2610613 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Viborg | \n",
" 2610319 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Århus | \n",
" 2624652 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name geonameid\n",
"subcountry \n",
"South Denmark Aabenraa 2625070\n",
"North Denmark Aalborg 2624886\n",
"Capital Region Albertslund 2624906\n",
"Capital Region Ballerup 2624341\n",
"Capital Region Birkerød 2624112\n",
"Capital Region Charlottenlund 2623188\n",
"Capital Region Copenhagen 2618425\n",
"South Denmark Esbjerg 2622447\n",
"Capital Region Farum 2622306\n",
"South Denmark Fredericia 2621951\n",
"Capital Region Frederiksberg 2621942\n",
"North Denmark Frederikshavn 2621927\n",
"Capital Region Glostrup 2621356\n",
"Zealand Greve 2621215\n",
"South Denmark Haderslev 2620964\n",
"Capital Region Helsingør 2620473\n",
"Central Jutland Herning 2620425\n",
"Capital Region Hillerød 2620320\n",
"North Denmark Hjørring 2620214\n",
"Zealand Holbæk 2620147\n",
"Central Jutland Holstebro 2620046\n",
"Central Jutland Horsens 2619771\n",
"Capital Region Hvidovre 2619528\n",
"Capital Region Hørsholm 2619856\n",
"Capital Region Ishøj 2619377\n",
"Zealand Kalundborg 2619154\n",
"South Denmark Kolding 2618528\n",
"Zealand Korsør 2618361\n",
"Zealand Køge 2618415\n",
"Capital Region Lillerød 2617658\n",
"South Denmark Nyborg 2616015\n",
"Zealand Nykøbing Falster 2615961\n",
"Zealand Næstved 2616038\n",
"North Denmark Nørresundby 2616235\n",
"South Denmark Odense 2615876\n",
"Central Jutland Randers 2615006\n",
"Zealand Ringsted 2614764\n",
"Zealand Roskilde 2614481\n",
"Capital Region Rødovre 2614600\n",
"Central Jutland Silkeborg 2614030\n",
"Central Jutland Skive 2613731\n",
"Zealand Slagelse 2613460\n",
"Capital Region Stenløse 2612629\n",
"South Denmark Svendborg 2612045\n",
"South Denmark Sønderborg 2613102\n",
"Capital Region Taastrup 2611828\n",
"Capital Region Vanløse 2610734\n",
"South Denmark Vejle 2610613\n",
"Central Jutland Viborg 2610319\n",
"Central Jutland Århus 2624652"
]
},
"execution_count": 59,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dksub.sort_values('name')"
]
},
{
"cell_type": "code",
"execution_count": 60,
"id": "powered-horizontal",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" geonameid | \n",
"
\n",
" \n",
" subcountry | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" Capital Region | \n",
" Frederiksberg | \n",
" 2621942 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hørsholm | \n",
" 2619856 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hvidovre | \n",
" 2619528 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Ishøj | \n",
" 2619377 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Albertslund | \n",
" 2624906 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Helsingør | \n",
" 2620473 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Copenhagen | \n",
" 2618425 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Glostrup | \n",
" 2621356 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Lillerød | \n",
" 2617658 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Farum | \n",
" 2622306 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Rødovre | \n",
" 2614600 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Hillerød | \n",
" 2620320 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Ballerup | \n",
" 2624341 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Vanløse | \n",
" 2610734 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Taastrup | \n",
" 2611828 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Stenløse | \n",
" 2612629 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Birkerød | \n",
" 2624112 | \n",
"
\n",
" \n",
" Capital Region | \n",
" Charlottenlund | \n",
" 2623188 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Herning | \n",
" 2620425 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Holstebro | \n",
" 2620046 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Horsens | \n",
" 2619771 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Århus | \n",
" 2624652 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Viborg | \n",
" 2610319 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Skive | \n",
" 2613731 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Silkeborg | \n",
" 2614030 | \n",
"
\n",
" \n",
" Central Jutland | \n",
" Randers | \n",
" 2615006 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Nørresundby | \n",
" 2616235 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Frederikshavn | \n",
" 2621927 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Hjørring | \n",
" 2620214 | \n",
"
\n",
" \n",
" North Denmark | \n",
" Aalborg | \n",
" 2624886 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Fredericia | \n",
" 2621951 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Haderslev | \n",
" 2620964 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Esbjerg | \n",
" 2622447 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Aabenraa | \n",
" 2625070 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Kolding | \n",
" 2618528 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Nyborg | \n",
" 2616015 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Odense | \n",
" 2615876 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Sønderborg | \n",
" 2613102 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Svendborg | \n",
" 2612045 | \n",
"
\n",
" \n",
" South Denmark | \n",
" Vejle | \n",
" 2610613 | \n",
"
\n",
" \n",
" Zealand | \n",
" Køge | \n",
" 2618415 | \n",
"
\n",
" \n",
" Zealand | \n",
" Greve | \n",
" 2621215 | \n",
"
\n",
" \n",
" Zealand | \n",
" Korsør | \n",
" 2618361 | \n",
"
\n",
" \n",
" Zealand | \n",
" Næstved | \n",
" 2616038 | \n",
"
\n",
" \n",
" Zealand | \n",
" Nykøbing Falster | \n",
" 2615961 | \n",
"
\n",
" \n",
" Zealand | \n",
" Ringsted | \n",
" 2614764 | \n",
"
\n",
" \n",
" Zealand | \n",
" Roskilde | \n",
" 2614481 | \n",
"
\n",
" \n",
" Zealand | \n",
" Slagelse | \n",
" 2613460 | \n",
"
\n",
" \n",
" Zealand | \n",
" Holbæk | \n",
" 2620147 | \n",
"
\n",
" \n",
" Zealand | \n",
" Kalundborg | \n",
" 2619154 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name geonameid\n",
"subcountry \n",
"Capital Region Frederiksberg 2621942\n",
"Capital Region Hørsholm 2619856\n",
"Capital Region Hvidovre 2619528\n",
"Capital Region Ishøj 2619377\n",
"Capital Region Albertslund 2624906\n",
"Capital Region Helsingør 2620473\n",
"Capital Region Copenhagen 2618425\n",
"Capital Region Glostrup 2621356\n",
"Capital Region Lillerød 2617658\n",
"Capital Region Farum 2622306\n",
"Capital Region Rødovre 2614600\n",
"Capital Region Hillerød 2620320\n",
"Capital Region Ballerup 2624341\n",
"Capital Region Vanløse 2610734\n",
"Capital Region Taastrup 2611828\n",
"Capital Region Stenløse 2612629\n",
"Capital Region Birkerød 2624112\n",
"Capital Region Charlottenlund 2623188\n",
"Central Jutland Herning 2620425\n",
"Central Jutland Holstebro 2620046\n",
"Central Jutland Horsens 2619771\n",
"Central Jutland Århus 2624652\n",
"Central Jutland Viborg 2610319\n",
"Central Jutland Skive 2613731\n",
"Central Jutland Silkeborg 2614030\n",
"Central Jutland Randers 2615006\n",
"North Denmark Nørresundby 2616235\n",
"North Denmark Frederikshavn 2621927\n",
"North Denmark Hjørring 2620214\n",
"North Denmark Aalborg 2624886\n",
"South Denmark Fredericia 2621951\n",
"South Denmark Haderslev 2620964\n",
"South Denmark Esbjerg 2622447\n",
"South Denmark Aabenraa 2625070\n",
"South Denmark Kolding 2618528\n",
"South Denmark Nyborg 2616015\n",
"South Denmark Odense 2615876\n",
"South Denmark Sønderborg 2613102\n",
"South Denmark Svendborg 2612045\n",
"South Denmark Vejle 2610613\n",
"Zealand Køge 2618415\n",
"Zealand Greve 2621215\n",
"Zealand Korsør 2618361\n",
"Zealand Næstved 2616038\n",
"Zealand Nykøbing Falster 2615961\n",
"Zealand Ringsted 2614764\n",
"Zealand Roskilde 2614481\n",
"Zealand Slagelse 2613460\n",
"Zealand Holbæk 2620147\n",
"Zealand Kalundborg 2619154"
]
},
"execution_count": 60,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dksub.sort_index()"
]
},
{
"cell_type": "code",
"execution_count": 65,
"id": "economic-current",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 False\n",
"1 False\n",
"2 False\n",
"3 False\n",
"4 False\n",
" ... \n",
"23013 False\n",
"23014 False\n",
"23015 False\n",
"23016 False\n",
"23017 False\n",
"Name: country, Length: 23018, dtype: bool"
]
},
"execution_count": 65,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.country == 'Denmark'"
]
},
{
"cell_type": "code",
"execution_count": 66,
"id": "velvet-ordinance",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Counter({False: 22968, True: 50})"
]
},
"execution_count": 66,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from collections import Counter\n",
"Counter(cities.country == 'Denmark')"
]
},
{
"cell_type": "code",
"execution_count": 69,
"id": "curious-determination",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"[False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, True, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False, False]\n"
]
}
],
"source": [
"print(list(cities.country == 'Denmark'))"
]
},
{
"cell_type": "code",
"execution_count": 71,
"id": "packed-drive",
"metadata": {},
"outputs": [],
"source": [
"DK = cities[cities.country == 'Denmark']"
]
},
{
"cell_type": "code",
"execution_count": 72,
"id": "exceptional-cooling",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 5363 | \n",
" Viborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2610319 | \n",
"
\n",
" \n",
" 5364 | \n",
" Vejle | \n",
" Denmark | \n",
" South Denmark | \n",
" 2610613 | \n",
"
\n",
" \n",
" 5365 | \n",
" Vanløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2610734 | \n",
"
\n",
" \n",
" 5366 | \n",
" Taastrup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2611828 | \n",
"
\n",
" \n",
" 5367 | \n",
" Svendborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2612045 | \n",
"
\n",
" \n",
" 5368 | \n",
" Stenløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2612629 | \n",
"
\n",
" \n",
" 5369 | \n",
" Sønderborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2613102 | \n",
"
\n",
" \n",
" 5370 | \n",
" Slagelse | \n",
" Denmark | \n",
" Zealand | \n",
" 2613460 | \n",
"
\n",
" \n",
" 5371 | \n",
" Skive | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2613731 | \n",
"
\n",
" \n",
" 5372 | \n",
" Silkeborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2614030 | \n",
"
\n",
" \n",
" 5373 | \n",
" Roskilde | \n",
" Denmark | \n",
" Zealand | \n",
" 2614481 | \n",
"
\n",
" \n",
" 5374 | \n",
" Rødovre | \n",
" Denmark | \n",
" Capital Region | \n",
" 2614600 | \n",
"
\n",
" \n",
" 5375 | \n",
" Ringsted | \n",
" Denmark | \n",
" Zealand | \n",
" 2614764 | \n",
"
\n",
" \n",
" 5376 | \n",
" Randers | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2615006 | \n",
"
\n",
" \n",
" 5377 | \n",
" Odense | \n",
" Denmark | \n",
" South Denmark | \n",
" 2615876 | \n",
"
\n",
" \n",
" 5378 | \n",
" Nykøbing Falster | \n",
" Denmark | \n",
" Zealand | \n",
" 2615961 | \n",
"
\n",
" \n",
" 5379 | \n",
" Nyborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2616015 | \n",
"
\n",
" \n",
" 5380 | \n",
" Næstved | \n",
" Denmark | \n",
" Zealand | \n",
" 2616038 | \n",
"
\n",
" \n",
" 5381 | \n",
" Nørresundby | \n",
" Denmark | \n",
" North Denmark | \n",
" 2616235 | \n",
"
\n",
" \n",
" 5382 | \n",
" Lillerød | \n",
" Denmark | \n",
" Capital Region | \n",
" 2617658 | \n",
"
\n",
" \n",
" 5383 | \n",
" Korsør | \n",
" Denmark | \n",
" Zealand | \n",
" 2618361 | \n",
"
\n",
" \n",
" 5384 | \n",
" Køge | \n",
" Denmark | \n",
" Zealand | \n",
" 2618415 | \n",
"
\n",
" \n",
" 5385 | \n",
" Copenhagen | \n",
" Denmark | \n",
" Capital Region | \n",
" 2618425 | \n",
"
\n",
" \n",
" 5386 | \n",
" Kolding | \n",
" Denmark | \n",
" South Denmark | \n",
" 2618528 | \n",
"
\n",
" \n",
" 5387 | \n",
" Kalundborg | \n",
" Denmark | \n",
" Zealand | \n",
" 2619154 | \n",
"
\n",
" \n",
" 5388 | \n",
" Ishøj | \n",
" Denmark | \n",
" Capital Region | \n",
" 2619377 | \n",
"
\n",
" \n",
" 5389 | \n",
" Hvidovre | \n",
" Denmark | \n",
" Capital Region | \n",
" 2619528 | \n",
"
\n",
" \n",
" 5390 | \n",
" Horsens | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2619771 | \n",
"
\n",
" \n",
" 5391 | \n",
" Hørsholm | \n",
" Denmark | \n",
" Capital Region | \n",
" 2619856 | \n",
"
\n",
" \n",
" 5392 | \n",
" Holstebro | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2620046 | \n",
"
\n",
" \n",
" 5393 | \n",
" Holbæk | \n",
" Denmark | \n",
" Zealand | \n",
" 2620147 | \n",
"
\n",
" \n",
" 5394 | \n",
" Hjørring | \n",
" Denmark | \n",
" North Denmark | \n",
" 2620214 | \n",
"
\n",
" \n",
" 5395 | \n",
" Hillerød | \n",
" Denmark | \n",
" Capital Region | \n",
" 2620320 | \n",
"
\n",
" \n",
" 5396 | \n",
" Herning | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2620425 | \n",
"
\n",
" \n",
" 5397 | \n",
" Helsingør | \n",
" Denmark | \n",
" Capital Region | \n",
" 2620473 | \n",
"
\n",
" \n",
" 5398 | \n",
" Haderslev | \n",
" Denmark | \n",
" South Denmark | \n",
" 2620964 | \n",
"
\n",
" \n",
" 5399 | \n",
" Greve | \n",
" Denmark | \n",
" Zealand | \n",
" 2621215 | \n",
"
\n",
" \n",
" 5400 | \n",
" Glostrup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2621356 | \n",
"
\n",
" \n",
" 5401 | \n",
" Frederikshavn | \n",
" Denmark | \n",
" North Denmark | \n",
" 2621927 | \n",
"
\n",
" \n",
" 5402 | \n",
" Frederiksberg | \n",
" Denmark | \n",
" Capital Region | \n",
" 2621942 | \n",
"
\n",
" \n",
" 5403 | \n",
" Fredericia | \n",
" Denmark | \n",
" South Denmark | \n",
" 2621951 | \n",
"
\n",
" \n",
" 5404 | \n",
" Farum | \n",
" Denmark | \n",
" Capital Region | \n",
" 2622306 | \n",
"
\n",
" \n",
" 5405 | \n",
" Esbjerg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2622447 | \n",
"
\n",
" \n",
" 5406 | \n",
" Charlottenlund | \n",
" Denmark | \n",
" Capital Region | \n",
" 2623188 | \n",
"
\n",
" \n",
" 5407 | \n",
" Birkerød | \n",
" Denmark | \n",
" Capital Region | \n",
" 2624112 | \n",
"
\n",
" \n",
" 5408 | \n",
" Ballerup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2624341 | \n",
"
\n",
" \n",
" 5409 | \n",
" Århus | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2624652 | \n",
"
\n",
" \n",
" 5410 | \n",
" Aalborg | \n",
" Denmark | \n",
" North Denmark | \n",
" 2624886 | \n",
"
\n",
" \n",
" 5411 | \n",
" Albertslund | \n",
" Denmark | \n",
" Capital Region | \n",
" 2624906 | \n",
"
\n",
" \n",
" 5412 | \n",
" Aabenraa | \n",
" Denmark | \n",
" South Denmark | \n",
" 2625070 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"5363 Viborg Denmark Central Jutland 2610319\n",
"5364 Vejle Denmark South Denmark 2610613\n",
"5365 Vanløse Denmark Capital Region 2610734\n",
"5366 Taastrup Denmark Capital Region 2611828\n",
"5367 Svendborg Denmark South Denmark 2612045\n",
"5368 Stenløse Denmark Capital Region 2612629\n",
"5369 Sønderborg Denmark South Denmark 2613102\n",
"5370 Slagelse Denmark Zealand 2613460\n",
"5371 Skive Denmark Central Jutland 2613731\n",
"5372 Silkeborg Denmark Central Jutland 2614030\n",
"5373 Roskilde Denmark Zealand 2614481\n",
"5374 Rødovre Denmark Capital Region 2614600\n",
"5375 Ringsted Denmark Zealand 2614764\n",
"5376 Randers Denmark Central Jutland 2615006\n",
"5377 Odense Denmark South Denmark 2615876\n",
"5378 Nykøbing Falster Denmark Zealand 2615961\n",
"5379 Nyborg Denmark South Denmark 2616015\n",
"5380 Næstved Denmark Zealand 2616038\n",
"5381 Nørresundby Denmark North Denmark 2616235\n",
"5382 Lillerød Denmark Capital Region 2617658\n",
"5383 Korsør Denmark Zealand 2618361\n",
"5384 Køge Denmark Zealand 2618415\n",
"5385 Copenhagen Denmark Capital Region 2618425\n",
"5386 Kolding Denmark South Denmark 2618528\n",
"5387 Kalundborg Denmark Zealand 2619154\n",
"5388 Ishøj Denmark Capital Region 2619377\n",
"5389 Hvidovre Denmark Capital Region 2619528\n",
"5390 Horsens Denmark Central Jutland 2619771\n",
"5391 Hørsholm Denmark Capital Region 2619856\n",
"5392 Holstebro Denmark Central Jutland 2620046\n",
"5393 Holbæk Denmark Zealand 2620147\n",
"5394 Hjørring Denmark North Denmark 2620214\n",
"5395 Hillerød Denmark Capital Region 2620320\n",
"5396 Herning Denmark Central Jutland 2620425\n",
"5397 Helsingør Denmark Capital Region 2620473\n",
"5398 Haderslev Denmark South Denmark 2620964\n",
"5399 Greve Denmark Zealand 2621215\n",
"5400 Glostrup Denmark Capital Region 2621356\n",
"5401 Frederikshavn Denmark North Denmark 2621927\n",
"5402 Frederiksberg Denmark Capital Region 2621942\n",
"5403 Fredericia Denmark South Denmark 2621951\n",
"5404 Farum Denmark Capital Region 2622306\n",
"5405 Esbjerg Denmark South Denmark 2622447\n",
"5406 Charlottenlund Denmark Capital Region 2623188\n",
"5407 Birkerød Denmark Capital Region 2624112\n",
"5408 Ballerup Denmark Capital Region 2624341\n",
"5409 Århus Denmark Central Jutland 2624652\n",
"5410 Aalborg Denmark North Denmark 2624886\n",
"5411 Albertslund Denmark Capital Region 2624906\n",
"5412 Aabenraa Denmark South Denmark 2625070"
]
},
"execution_count": 72,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"DK"
]
},
{
"cell_type": "code",
"execution_count": 73,
"id": "streaming-costs",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 5363 | \n",
" Viborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2610319 | \n",
"
\n",
" \n",
" 5364 | \n",
" Vejle | \n",
" Denmark | \n",
" South Denmark | \n",
" 2610613 | \n",
"
\n",
" \n",
" 5365 | \n",
" Vanløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2610734 | \n",
"
\n",
" \n",
" 5366 | \n",
" Taastrup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2611828 | \n",
"
\n",
" \n",
" 5367 | \n",
" Svendborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2612045 | \n",
"
\n",
" \n",
" 5368 | \n",
" Stenløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2612629 | \n",
"
\n",
" \n",
" 5369 | \n",
" Sønderborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2613102 | \n",
"
\n",
" \n",
" 5370 | \n",
" Slagelse | \n",
" Denmark | \n",
" Zealand | \n",
" 2613460 | \n",
"
\n",
" \n",
" 5371 | \n",
" Skive | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2613731 | \n",
"
\n",
" \n",
" 5372 | \n",
" Silkeborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2614030 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"5363 Viborg Denmark Central Jutland 2610319\n",
"5364 Vejle Denmark South Denmark 2610613\n",
"5365 Vanløse Denmark Capital Region 2610734\n",
"5366 Taastrup Denmark Capital Region 2611828\n",
"5367 Svendborg Denmark South Denmark 2612045\n",
"5368 Stenløse Denmark Capital Region 2612629\n",
"5369 Sønderborg Denmark South Denmark 2613102\n",
"5370 Slagelse Denmark Zealand 2613460\n",
"5371 Skive Denmark Central Jutland 2613731\n",
"5372 Silkeborg Denmark Central Jutland 2614030"
]
},
"execution_count": 73,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"DK[:10]"
]
},
{
"cell_type": "code",
"execution_count": 74,
"id": "asian-plate",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 5363 | \n",
" Viborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2610319 | \n",
"
\n",
" \n",
" 5364 | \n",
" Vejle | \n",
" Denmark | \n",
" South Denmark | \n",
" 2610613 | \n",
"
\n",
" \n",
" 5365 | \n",
" Vanløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2610734 | \n",
"
\n",
" \n",
" 5366 | \n",
" Taastrup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2611828 | \n",
"
\n",
" \n",
" 5367 | \n",
" Svendborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2612045 | \n",
"
\n",
" \n",
" 5368 | \n",
" Stenløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2612629 | \n",
"
\n",
" \n",
" 5369 | \n",
" Sønderborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2613102 | \n",
"
\n",
" \n",
" 5370 | \n",
" Slagelse | \n",
" Denmark | \n",
" Zealand | \n",
" 2613460 | \n",
"
\n",
" \n",
" 5371 | \n",
" Skive | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2613731 | \n",
"
\n",
" \n",
" 5372 | \n",
" Silkeborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2614030 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"5363 Viborg Denmark Central Jutland 2610319\n",
"5364 Vejle Denmark South Denmark 2610613\n",
"5365 Vanløse Denmark Capital Region 2610734\n",
"5366 Taastrup Denmark Capital Region 2611828\n",
"5367 Svendborg Denmark South Denmark 2612045\n",
"5368 Stenløse Denmark Capital Region 2612629\n",
"5369 Sønderborg Denmark South Denmark 2613102\n",
"5370 Slagelse Denmark Zealand 2613460\n",
"5371 Skive Denmark Central Jutland 2613731\n",
"5372 Silkeborg Denmark Central Jutland 2614030"
]
},
"execution_count": 74,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"DK.iloc[:10]"
]
},
{
"cell_type": "code",
"execution_count": 77,
"id": "fifteen-success",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 5363 | \n",
" Viborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2610319 | \n",
"
\n",
" \n",
" 5364 | \n",
" Vejle | \n",
" Denmark | \n",
" South Denmark | \n",
" 2610613 | \n",
"
\n",
" \n",
" 5365 | \n",
" Vanløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2610734 | \n",
"
\n",
" \n",
" 5366 | \n",
" Taastrup | \n",
" Denmark | \n",
" Capital Region | \n",
" 2611828 | \n",
"
\n",
" \n",
" 5367 | \n",
" Svendborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2612045 | \n",
"
\n",
" \n",
" 5368 | \n",
" Stenløse | \n",
" Denmark | \n",
" Capital Region | \n",
" 2612629 | \n",
"
\n",
" \n",
" 5369 | \n",
" Sønderborg | \n",
" Denmark | \n",
" South Denmark | \n",
" 2613102 | \n",
"
\n",
" \n",
" 5370 | \n",
" Slagelse | \n",
" Denmark | \n",
" Zealand | \n",
" 2613460 | \n",
"
\n",
" \n",
" 5371 | \n",
" Skive | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2613731 | \n",
"
\n",
" \n",
" 5372 | \n",
" Silkeborg | \n",
" Denmark | \n",
" Central Jutland | \n",
" 2614030 | \n",
"
\n",
" \n",
" 5373 | \n",
" Roskilde | \n",
" Denmark | \n",
" Zealand | \n",
" 2614481 | \n",
"
\n",
" \n",
" 5374 | \n",
" Rødovre | \n",
" Denmark | \n",
" Capital Region | \n",
" 2614600 | \n",
"
\n",
" \n",
" 5375 | \n",
" Ringsted | \n",
" Denmark | \n",
" Zealand | \n",
" 2614764 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"5363 Viborg Denmark Central Jutland 2610319\n",
"5364 Vejle Denmark South Denmark 2610613\n",
"5365 Vanløse Denmark Capital Region 2610734\n",
"5366 Taastrup Denmark Capital Region 2611828\n",
"5367 Svendborg Denmark South Denmark 2612045\n",
"5368 Stenløse Denmark Capital Region 2612629\n",
"5369 Sønderborg Denmark South Denmark 2613102\n",
"5370 Slagelse Denmark Zealand 2613460\n",
"5371 Skive Denmark Central Jutland 2613731\n",
"5372 Silkeborg Denmark Central Jutland 2614030\n",
"5373 Roskilde Denmark Zealand 2614481\n",
"5374 Rødovre Denmark Capital Region 2614600\n",
"5375 Ringsted Denmark Zealand 2614764"
]
},
"execution_count": 77,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"DK.loc[:5375]"
]
},
{
"cell_type": "code",
"execution_count": 102,
"id": "cognitive-atlantic",
"metadata": {},
"outputs": [],
"source": [
"cities['some_value'] = cities.geonameid ** 2"
]
},
{
"cell_type": "code",
"execution_count": 103,
"id": "surprising-twenty",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
" some_value | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" les Escaldes | \n",
" Andorra | \n",
" Escaldes-Engordany | \n",
" 3040051 | \n",
" 9241910082601 | \n",
"
\n",
" \n",
" 1 | \n",
" Andorra la Vella | \n",
" Andorra | \n",
" Andorra la Vella | \n",
" 3041563 | \n",
" 9251105482969 | \n",
"
\n",
" \n",
" 2 | \n",
" Umm al Qaywayn | \n",
" United Arab Emirates | \n",
" Umm al Qaywayn | \n",
" 290594 | \n",
" 84444872836 | \n",
"
\n",
" \n",
" 3 | \n",
" Ras al-Khaimah | \n",
" United Arab Emirates | \n",
" Raʼs al Khaymah | \n",
" 291074 | \n",
" 84724073476 | \n",
"
\n",
" \n",
" 4 | \n",
" Khawr Fakkān | \n",
" United Arab Emirates | \n",
" Ash Shāriqah | \n",
" 291696 | \n",
" 85086556416 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 23013 | \n",
" Bulawayo | \n",
" Zimbabwe | \n",
" Bulawayo | \n",
" 894701 | \n",
" 800489879401 | \n",
"
\n",
" \n",
" 23014 | \n",
" Bindura | \n",
" Zimbabwe | \n",
" Mashonaland Central | \n",
" 895061 | \n",
" 801134193721 | \n",
"
\n",
" \n",
" 23015 | \n",
" Beitbridge | \n",
" Zimbabwe | \n",
" Matabeleland South | \n",
" 895269 | \n",
" 801506582361 | \n",
"
\n",
" \n",
" 23016 | \n",
" Epworth | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1085510 | \n",
" 1178331960100 | \n",
"
\n",
" \n",
" 23017 | \n",
" Chitungwiza | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1106542 | \n",
" 1224435197764 | \n",
"
\n",
" \n",
"
\n",
"
23018 rows × 5 columns
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid \\\n",
"0 les Escaldes Andorra Escaldes-Engordany 3040051 \n",
"1 Andorra la Vella Andorra Andorra la Vella 3041563 \n",
"2 Umm al Qaywayn United Arab Emirates Umm al Qaywayn 290594 \n",
"3 Ras al-Khaimah United Arab Emirates Raʼs al Khaymah 291074 \n",
"4 Khawr Fakkān United Arab Emirates Ash Shāriqah 291696 \n",
"... ... ... ... ... \n",
"23013 Bulawayo Zimbabwe Bulawayo 894701 \n",
"23014 Bindura Zimbabwe Mashonaland Central 895061 \n",
"23015 Beitbridge Zimbabwe Matabeleland South 895269 \n",
"23016 Epworth Zimbabwe Harare 1085510 \n",
"23017 Chitungwiza Zimbabwe Harare 1106542 \n",
"\n",
" some_value \n",
"0 9241910082601 \n",
"1 9251105482969 \n",
"2 84444872836 \n",
"3 84724073476 \n",
"4 85086556416 \n",
"... ... \n",
"23013 800489879401 \n",
"23014 801134193721 \n",
"23015 801506582361 \n",
"23016 1178331960100 \n",
"23017 1224435197764 \n",
"\n",
"[23018 rows x 5 columns]"
]
},
"execution_count": 103,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities"
]
},
{
"cell_type": "code",
"execution_count": 96,
"id": "tight-buffer",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method drop in module pandas.core.frame:\n",
"\n",
"drop(labels=None, axis=0, index=None, columns=None, level=None, inplace=False, errors='raise') method of pandas.core.frame.DataFrame instance\n",
" Drop specified labels from rows or columns.\n",
" \n",
" Remove rows or columns by specifying label names and corresponding\n",
" axis, or by specifying directly index or column names. When using a\n",
" multi-index, labels on different levels can be removed by specifying\n",
" the level.\n",
" \n",
" Parameters\n",
" ----------\n",
" labels : single label or list-like\n",
" Index or column labels to drop.\n",
" axis : {0 or 'index', 1 or 'columns'}, default 0\n",
" Whether to drop labels from the index (0 or 'index') or\n",
" columns (1 or 'columns').\n",
" index : single label or list-like\n",
" Alternative to specifying axis (``labels, axis=0``\n",
" is equivalent to ``index=labels``).\n",
" columns : single label or list-like\n",
" Alternative to specifying axis (``labels, axis=1``\n",
" is equivalent to ``columns=labels``).\n",
" level : int or level name, optional\n",
" For MultiIndex, level from which the labels will be removed.\n",
" inplace : bool, default False\n",
" If False, return a copy. Otherwise, do operation\n",
" inplace and return None.\n",
" errors : {'ignore', 'raise'}, default 'raise'\n",
" If 'ignore', suppress error and only existing labels are\n",
" dropped.\n",
" \n",
" Returns\n",
" -------\n",
" DataFrame or None\n",
" DataFrame without the removed index or column labels or\n",
" None if ``inplace=True``.\n",
" \n",
" Raises\n",
" ------\n",
" KeyError\n",
" If any of the labels is not found in the selected axis.\n",
" \n",
" See Also\n",
" --------\n",
" DataFrame.loc : Label-location based indexer for selection by label.\n",
" DataFrame.dropna : Return DataFrame with labels on given axis omitted\n",
" where (all or any) data are missing.\n",
" DataFrame.drop_duplicates : Return DataFrame with duplicate rows\n",
" removed, optionally only considering certain columns.\n",
" Series.drop : Return Series with specified index labels removed.\n",
" \n",
" Examples\n",
" --------\n",
" >>> df = pd.DataFrame(np.arange(12).reshape(3, 4),\n",
" ... columns=['A', 'B', 'C', 'D'])\n",
" >>> df\n",
" A B C D\n",
" 0 0 1 2 3\n",
" 1 4 5 6 7\n",
" 2 8 9 10 11\n",
" \n",
" Drop columns\n",
" \n",
" >>> df.drop(['B', 'C'], axis=1)\n",
" A D\n",
" 0 0 3\n",
" 1 4 7\n",
" 2 8 11\n",
" \n",
" >>> df.drop(columns=['B', 'C'])\n",
" A D\n",
" 0 0 3\n",
" 1 4 7\n",
" 2 8 11\n",
" \n",
" Drop a row by index\n",
" \n",
" >>> df.drop([0, 1])\n",
" A B C D\n",
" 2 8 9 10 11\n",
" \n",
" Drop columns and/or rows of MultiIndex DataFrame\n",
" \n",
" >>> midx = pd.MultiIndex(levels=[['lama', 'cow', 'falcon'],\n",
" ... ['speed', 'weight', 'length']],\n",
" ... codes=[[0, 0, 0, 1, 1, 1, 2, 2, 2],\n",
" ... [0, 1, 2, 0, 1, 2, 0, 1, 2]])\n",
" >>> df = pd.DataFrame(index=midx, columns=['big', 'small'],\n",
" ... data=[[45, 30], [200, 100], [1.5, 1], [30, 20],\n",
" ... [250, 150], [1.5, 0.8], [320, 250],\n",
" ... [1, 0.8], [0.3, 0.2]])\n",
" >>> df\n",
" big small\n",
" lama speed 45.0 30.0\n",
" weight 200.0 100.0\n",
" length 1.5 1.0\n",
" cow speed 30.0 20.0\n",
" weight 250.0 150.0\n",
" length 1.5 0.8\n",
" falcon speed 320.0 250.0\n",
" weight 1.0 0.8\n",
" length 0.3 0.2\n",
" \n",
" >>> df.drop(index='cow', columns='small')\n",
" big\n",
" lama speed 45.0\n",
" weight 200.0\n",
" length 1.5\n",
" falcon speed 320.0\n",
" weight 1.0\n",
" length 0.3\n",
" \n",
" >>> df.drop(index='length', level=1)\n",
" big small\n",
" lama speed 45.0 30.0\n",
" weight 200.0 100.0\n",
" cow speed 30.0 20.0\n",
" weight 250.0 150.0\n",
" falcon speed 320.0 250.0\n",
" weight 1.0 0.8\n",
"\n"
]
}
],
"source": [
"help(cities.drop)"
]
},
{
"cell_type": "code",
"execution_count": 104,
"id": "serial-funeral",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" country | \n",
" subcountry | \n",
" geonameid | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" les Escaldes | \n",
" Andorra | \n",
" Escaldes-Engordany | \n",
" 3040051 | \n",
"
\n",
" \n",
" 1 | \n",
" Andorra la Vella | \n",
" Andorra | \n",
" Andorra la Vella | \n",
" 3041563 | \n",
"
\n",
" \n",
" 2 | \n",
" Umm al Qaywayn | \n",
" United Arab Emirates | \n",
" Umm al Qaywayn | \n",
" 290594 | \n",
"
\n",
" \n",
" 3 | \n",
" Ras al-Khaimah | \n",
" United Arab Emirates | \n",
" Raʼs al Khaymah | \n",
" 291074 | \n",
"
\n",
" \n",
" 4 | \n",
" Khawr Fakkān | \n",
" United Arab Emirates | \n",
" Ash Shāriqah | \n",
" 291696 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 23013 | \n",
" Bulawayo | \n",
" Zimbabwe | \n",
" Bulawayo | \n",
" 894701 | \n",
"
\n",
" \n",
" 23014 | \n",
" Bindura | \n",
" Zimbabwe | \n",
" Mashonaland Central | \n",
" 895061 | \n",
"
\n",
" \n",
" 23015 | \n",
" Beitbridge | \n",
" Zimbabwe | \n",
" Matabeleland South | \n",
" 895269 | \n",
"
\n",
" \n",
" 23016 | \n",
" Epworth | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1085510 | \n",
"
\n",
" \n",
" 23017 | \n",
" Chitungwiza | \n",
" Zimbabwe | \n",
" Harare | \n",
" 1106542 | \n",
"
\n",
" \n",
"
\n",
"
23018 rows × 4 columns
\n",
"
"
],
"text/plain": [
" name country subcountry geonameid\n",
"0 les Escaldes Andorra Escaldes-Engordany 3040051\n",
"1 Andorra la Vella Andorra Andorra la Vella 3041563\n",
"2 Umm al Qaywayn United Arab Emirates Umm al Qaywayn 290594\n",
"3 Ras al-Khaimah United Arab Emirates Raʼs al Khaymah 291074\n",
"4 Khawr Fakkān United Arab Emirates Ash Shāriqah 291696\n",
"... ... ... ... ...\n",
"23013 Bulawayo Zimbabwe Bulawayo 894701\n",
"23014 Bindura Zimbabwe Mashonaland Central 895061\n",
"23015 Beitbridge Zimbabwe Matabeleland South 895269\n",
"23016 Epworth Zimbabwe Harare 1085510\n",
"23017 Chitungwiza Zimbabwe Harare 1106542\n",
"\n",
"[23018 rows x 4 columns]"
]
},
"execution_count": 104,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities = cities.drop(columns='some_value')\n",
"cities"
]
},
{
"cell_type": "code",
"execution_count": 82,
"id": "optimum-chapel",
"metadata": {},
"outputs": [],
"source": [
"cities.loc[5409].name = 'Aarhus'"
]
},
{
"cell_type": "code",
"execution_count": 84,
"id": "grave-consensus",
"metadata": {},
"outputs": [],
"source": [
"cities.at[5409, 'name'] = 'Aarhus'"
]
},
{
"cell_type": "code",
"execution_count": 85,
"id": "associate-dinner",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"name Aarhus\n",
"country Denmark\n",
"subcountry Central Jutland\n",
"geonameid 2624652\n",
"Name: 5409, dtype: object"
]
},
"execution_count": 85,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cities.loc[5409]"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "fantastic-shift",
"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.9.4"
}
},
"nbformat": 4,
"nbformat_minor": 5
}