pax_global_header 0000666 0000000 0000000 00000000064 13376003704 0014515 g ustar 00root root 0000000 0000000 52 comment=51c7814f22bdf5809f1e38d562f312c29f99a16e
akon-experiments-51c7814f22bdf5809f1e38d562f312c29f99a16e/ 0000775 0000000 0000000 00000000000 13376003704 0021667 5 ustar 00root root 0000000 0000000 akon-experiments-51c7814f22bdf5809f1e38d562f312c29f99a16e/AKON Data Overview.ipynb 0000664 0000000 0000000 00000160207 13376003704 0026111 0 ustar 00root root 0000000 0000000 {
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# AKON Metadata - Data Overview"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"*Get a first impression of the postcard metadata*"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Setup"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Using the [Pandas Python Data Analysis Library](https://pandas.pydata.org/).\n",
"\n",
"For an intro to pandas feel free to take a look at this [Workshop for CBioVikings](https://github.com/dblyon/PandasIntro) by David Lyon."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Load Data"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"`df` stands for *Data Frame*"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_csv('akon_postcards_public_domain.csv.bz2')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## View Data"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Rough Overview"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"How much datasets are in there?"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"28882"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"What does a dataset look like?\n",
"Show me the first one!"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" ... | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" AK111_024 | \n",
" 74685 | \n",
" NaN | \n",
" NaN | \n",
" Kierling | \n",
" True | \n",
" 1908 | \n",
" NaN | \n",
" NaN | \n",
" ... | \n",
" gelaufen 1908 | \n",
" P | \n",
" PPL | \n",
" 2774449.0 | \n",
" 48.30997 | \n",
" 16.27616 | \n",
" Kierling | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
1 rows × 29 columns
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city color comment \\\n",
"0 0 AK111_024 74685 NaN NaN Kierling True 1908 \n",
"\n",
" mountain other ... date feature_class feature_code \\\n",
"0 NaN NaN ... gelaufen 1908 P PPL \n",
"\n",
" geoname_id latitude longitude name country_id admin_name_1 \\\n",
"0 2774449.0 48.30997 16.27616 Kierling AT NaN \n",
"\n",
" admin_code_1 \n",
"0 NaN \n",
"\n",
"[1 rows x 29 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head(1)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"There seem to be a few columns missing from the output. Let's fix that by setting pandas output options:"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"pd.set_option('display.max_columns', 100)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's try again:"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" photographer | \n",
" publisher | \n",
" publisher_place | \n",
" region | \n",
" water_body | \n",
" year | \n",
" inventory_number | \n",
" signature | \n",
" revision_date | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" AK111_024 | \n",
" 74685 | \n",
" NaN | \n",
" NaN | \n",
" Kierling | \n",
" True | \n",
" 1908 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Geogr. Topogr. Bilder-Samml. 1944, 6380 | \n",
" 2014-09-05 10:13:12.536 | \n",
" gelaufen 1908 | \n",
" P | \n",
" PPL | \n",
" 2774449.0 | \n",
" 48.30997 | \n",
" 16.27616 | \n",
" Kierling | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city color comment \\\n",
"0 0 AK111_024 74685 NaN NaN Kierling True 1908 \n",
"\n",
" mountain other photographer publisher publisher_place region water_body \\\n",
"0 NaN NaN NaN NaN NaN NaN NaN \n",
"\n",
" year inventory_number signature \\\n",
"0 NaN NaN Geogr. Topogr. Bilder-Samml. 1944, 6380 \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"0 2014-09-05 10:13:12.536 gelaufen 1908 P PPL \n",
"\n",
" geoname_id latitude longitude name country_id admin_name_1 \\\n",
"0 2774449.0 48.30997 16.27616 Kierling AT NaN \n",
"\n",
" admin_code_1 \n",
"0 NaN "
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head(1)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now we see all columns."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"What are all the columns called again?"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Index(['Unnamed: 0', 'akon_id', 'id', 'altitude', 'building', 'city', 'color',\n",
" 'comment', 'mountain', 'other', 'photographer', 'publisher',\n",
" 'publisher_place', 'region', 'water_body', 'year', 'inventory_number',\n",
" 'signature', 'revision_date', 'date', 'feature_class', 'feature_code',\n",
" 'geoname_id', 'latitude', 'longitude', 'name', 'country_id',\n",
" 'admin_name_1', 'admin_code_1'],\n",
" dtype='object')"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.columns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Show Random Entries"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Show me 3 random entries:"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" photographer | \n",
" publisher | \n",
" publisher_place | \n",
" region | \n",
" water_body | \n",
" year | \n",
" inventory_number | \n",
" signature | \n",
" revision_date | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 458 | \n",
" 458 | \n",
" AK114_189 | \n",
" 76614 | \n",
" NaN | \n",
" NaN | \n",
" Airolo | \n",
" True | \n",
" 1909 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Geogr. Topogr. Bilder-Samml. 1944, 27 | \n",
" 2014-09-09 08:50:37.905 | \n",
" gelaufen 1909 | \n",
" P | \n",
" PPL | \n",
" 2661830.0 | \n",
" 46.52847 | \n",
" 8.60881 | \n",
" Airolo | \n",
" CH | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 24510 | \n",
" 24510 | \n",
" AK075_467 | \n",
" 46922 | \n",
" NaN | \n",
" NaN | \n",
" Klausen | \n",
" False | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1913.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-21 10:05:32.779 | \n",
" 1913 | \n",
" P | \n",
" PPLA3 | \n",
" 3178764.0 | \n",
" 46.64001 | \n",
" 11.56573 | \n",
" Klausen | \n",
" IT | \n",
" Südtirol | \n",
" 17 | \n",
"
\n",
" \n",
" 18564 | \n",
" 18564 | \n",
" AK082_546 | \n",
" 51980 | \n",
" NaN | \n",
" NaN | \n",
" Velsen | \n",
" False | \n",
" v 1905 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-25 17:46:23.417 | \n",
" vor 1905 | \n",
" P | \n",
" PPL | \n",
" 2745673.0 | \n",
" 52.46000 | \n",
" 4.65000 | \n",
" Velsen | \n",
" NL | \n",
" Nord-Holland | \n",
" 07 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city color \\\n",
"458 458 AK114_189 76614 NaN NaN Airolo True \n",
"24510 24510 AK075_467 46922 NaN NaN Klausen False \n",
"18564 18564 AK082_546 51980 NaN NaN Velsen False \n",
"\n",
" comment mountain other photographer publisher publisher_place region \\\n",
"458 1909 gel NaN NaN NaN NaN NaN NaN \n",
"24510 NaN NaN NaN NaN NaN NaN NaN \n",
"18564 v 1905 NaN NaN NaN NaN NaN NaN \n",
"\n",
" water_body year inventory_number \\\n",
"458 NaN NaN NaN \n",
"24510 NaN 1913.0 NaN \n",
"18564 NaN NaN NaN \n",
"\n",
" signature revision_date \\\n",
"458 Geogr. Topogr. Bilder-Samml. 1944, 27 2014-09-09 08:50:37.905 \n",
"24510 NaN 2014-08-21 10:05:32.779 \n",
"18564 NaN 2014-08-25 17:46:23.417 \n",
"\n",
" date feature_class feature_code geoname_id latitude \\\n",
"458 gelaufen 1909 P PPL 2661830.0 46.52847 \n",
"24510 1913 P PPLA3 3178764.0 46.64001 \n",
"18564 vor 1905 P PPL 2745673.0 52.46000 \n",
"\n",
" longitude name country_id admin_name_1 admin_code_1 \n",
"458 8.60881 Airolo CH NaN NaN \n",
"24510 11.56573 Klausen IT Südtirol 17 \n",
"18564 4.65000 Velsen NL Nord-Holland 07 "
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.sample(3)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Calling `sample` again yields different entries:"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" photographer | \n",
" publisher | \n",
" publisher_place | \n",
" region | \n",
" water_body | \n",
" year | \n",
" inventory_number | \n",
" signature | \n",
" revision_date | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 27658 | \n",
" 27658 | \n",
" AK097_351 | \n",
" 62277 | \n",
" NaN | \n",
" Station Brenner | \n",
" Steinach am Brenner | \n",
" False | \n",
" 1905 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-02 11:15:45.988 | \n",
" vor 1905 | \n",
" P | \n",
" PPLA3 | \n",
" 2764557.0 | \n",
" 47.08333 | \n",
" 11.46667 | \n",
" Steinach am Brenner | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 14993 | \n",
" 14993 | \n",
" AK021_515 | \n",
" 12604 | \n",
" NaN | \n",
" NaN | \n",
" Gross-Pöchlarn, Klein-Pöchlarn | \n",
" False | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1917.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.136 | \n",
" 1917 | \n",
" P | \n",
" PPLA3 | \n",
" 2768627.0 | \n",
" 48.20000 | \n",
" 15.20000 | \n",
" Pöchlarn | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 15934 | \n",
" 15934 | \n",
" AK025_596 | \n",
" 15102 | \n",
" NaN | \n",
" Pfarrkirche | \n",
" Mondsee | \n",
" False | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1914.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.187 | \n",
" 1914 | \n",
" P | \n",
" PPLA3 | \n",
" 2771277.0 | \n",
" 47.85648 | \n",
" 13.34908 | \n",
" Mondsee | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building \\\n",
"27658 27658 AK097_351 62277 NaN Station Brenner \n",
"14993 14993 AK021_515 12604 NaN NaN \n",
"15934 15934 AK025_596 15102 NaN Pfarrkirche \n",
"\n",
" city color comment mountain other \\\n",
"27658 Steinach am Brenner False 1905 gel NaN NaN \n",
"14993 Gross-Pöchlarn, Klein-Pöchlarn False NaN NaN NaN \n",
"15934 Mondsee False NaN NaN NaN \n",
"\n",
" photographer publisher publisher_place region water_body year \\\n",
"27658 NaN NaN NaN NaN NaN NaN \n",
"14993 NaN Ledermann Wien NaN NaN 1917.0 \n",
"15934 NaN NaN NaN NaN NaN 1914.0 \n",
"\n",
" inventory_number signature revision_date date \\\n",
"27658 NaN NaN 2014-09-02 11:15:45.988 vor 1905 \n",
"14993 NaN NaN 2014-08-04 07:59:10.136 1917 \n",
"15934 NaN NaN 2014-08-04 07:59:10.187 1914 \n",
"\n",
" feature_class feature_code geoname_id latitude longitude \\\n",
"27658 P PPLA3 2764557.0 47.08333 11.46667 \n",
"14993 P PPLA3 2768627.0 48.20000 15.20000 \n",
"15934 P PPLA3 2771277.0 47.85648 13.34908 \n",
"\n",
" name country_id admin_name_1 admin_code_1 \n",
"27658 Steinach am Brenner AT NaN NaN \n",
"14993 Pöchlarn AT NaN NaN \n",
"15934 Mondsee AT NaN NaN "
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.sample(3)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Count Things"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"How many entries show things in Italy?\n",
"\n",
"Let's use the `country_id` for this question:"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"df_in_italy = df[df['country_id'] == 'IT']"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"2983"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df_in_italy)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"How many postcards are in color?"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [],
"source": [
"df_in_color = df[df['color'] == True]"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"7075"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df_in_color)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Can I do this in one line?"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"7075"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df[df['color'] == True])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"How many different publisher places are in the data set?"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"1324"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df['publisher_place'].unique())"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Show me some!"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"ename": "AttributeError",
"evalue": "'numpy.ndarray' object has no attribute 'sample'",
"output_type": "error",
"traceback": [
"\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m Traceback (most recent call last)",
"\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'publisher_place'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munique\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msample\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m10\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m: 'numpy.ndarray' object has no attribute 'sample'"
]
}
],
"source": [
"df['publisher_place'].unique().sample(10)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Oh, that doesn't work. Let's wrap it in a pandas DataFrame, step by step:"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [],
"source": [
"publisher_places = df['publisher_place'].unique()"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([nan, 'Kierling', 'Kindberg', ..., 'Straßburg i./E.', 'Detmold',\n",
" 'Furth i. W.'], dtype=object)"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"publisher_places"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {},
"outputs": [],
"source": [
"pp = pd.DataFrame(publisher_places)"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" NaN | \n",
"
\n",
" \n",
" 1 | \n",
" Kierling | \n",
"
\n",
" \n",
" 2 | \n",
" Kindberg | \n",
"
\n",
" \n",
" 3 | \n",
" Kirchau | \n",
"
\n",
" \n",
" 4 | \n",
" Wien | \n",
"
\n",
" \n",
" 5 | \n",
" Kirchhain | \n",
"
\n",
" \n",
" 6 | \n",
" München | \n",
"
\n",
" \n",
" 7 | \n",
" Kitzbühel | \n",
"
\n",
" \n",
" 8 | \n",
" Klagenfurt | \n",
"
\n",
" \n",
" 9 | \n",
" Grein a/D. | \n",
"
\n",
" \n",
" 10 | \n",
" Bozen | \n",
"
\n",
" \n",
" 11 | \n",
" Znaim | \n",
"
\n",
" \n",
" 12 | \n",
" Graz | \n",
"
\n",
" \n",
" 13 | \n",
" Heidelberg | \n",
"
\n",
" \n",
" 14 | \n",
" Komotau | \n",
"
\n",
" \n",
" 15 | \n",
" Köln | \n",
"
\n",
" \n",
" 16 | \n",
" Bodenbach a. d. Elbe | \n",
"
\n",
" \n",
" 17 | \n",
" Meissen | \n",
"
\n",
" \n",
" 18 | \n",
" Leipzig | \n",
"
\n",
" \n",
" 19 | \n",
" Konstanz | \n",
"
\n",
" \n",
" 20 | \n",
" Korneuburg | \n",
"
\n",
" \n",
" 21 | \n",
" Brașov | \n",
"
\n",
" \n",
" 22 | \n",
" Mürzzuschlag | \n",
"
\n",
" \n",
" 23 | \n",
" Salzburg | \n",
"
\n",
" \n",
" 24 | \n",
" Frankfurt a. M. | \n",
"
\n",
" \n",
" 25 | \n",
" Arys | \n",
"
\n",
" \n",
" 26 | \n",
" Tegernsee | \n",
"
\n",
" \n",
" 27 | \n",
" Garmisch | \n",
"
\n",
" \n",
" 28 | \n",
" Partenkirchen-Garmisch | \n",
"
\n",
" \n",
" 29 | \n",
" Zürich | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 1294 | \n",
" Neugersdorf | \n",
"
\n",
" \n",
" 1295 | \n",
" Friedau | \n",
"
\n",
" \n",
" 1296 | \n",
" Freystadt | \n",
"
\n",
" \n",
" 1297 | \n",
" Gießhübl | \n",
"
\n",
" \n",
" 1298 | \n",
" Gams | \n",
"
\n",
" \n",
" 1299 | \n",
" Schlossberg | \n",
"
\n",
" \n",
" 1300 | \n",
" Frakfurt a. Oder | \n",
"
\n",
" \n",
" 1301 | \n",
" Casale Monferrato | \n",
"
\n",
" \n",
" 1302 | \n",
" Sternberg | \n",
"
\n",
" \n",
" 1303 | \n",
" Stössing | \n",
"
\n",
" \n",
" 1304 | \n",
" Mauterndorf | \n",
"
\n",
" \n",
" 1305 | \n",
" Thörl | \n",
"
\n",
" \n",
" 1306 | \n",
" Traismauer | \n",
"
\n",
" \n",
" 1307 | \n",
" Trebnitz | \n",
"
\n",
" \n",
" 1308 | \n",
" Voitsberg | \n",
"
\n",
" \n",
" 1309 | \n",
" Daun | \n",
"
\n",
" \n",
" 1310 | \n",
" Kilchberg-Züich | \n",
"
\n",
" \n",
" 1311 | \n",
" Strassburg i. Els. | \n",
"
\n",
" \n",
" 1312 | \n",
" Mühlhausen | \n",
"
\n",
" \n",
" 1313 | \n",
" Eschwege | \n",
"
\n",
" \n",
" 1314 | \n",
" Tabarz | \n",
"
\n",
" \n",
" 1315 | \n",
" Weimar | \n",
"
\n",
" \n",
" 1316 | \n",
" Coburg | \n",
"
\n",
" \n",
" 1317 | \n",
" Friedrichsroda i. Th. | \n",
"
\n",
" \n",
" 1318 | \n",
" Leipa i. B. | \n",
"
\n",
" \n",
" 1319 | \n",
" Schumburg a. D. | \n",
"
\n",
" \n",
" 1320 | \n",
" Pisa | \n",
"
\n",
" \n",
" 1321 | \n",
" Straßburg i./E. | \n",
"
\n",
" \n",
" 1322 | \n",
" Detmold | \n",
"
\n",
" \n",
" 1323 | \n",
" Furth i. W. | \n",
"
\n",
" \n",
"
\n",
"
1324 rows × 1 columns
\n",
"
"
],
"text/plain": [
" 0\n",
"0 NaN\n",
"1 Kierling\n",
"2 Kindberg\n",
"3 Kirchau\n",
"4 Wien\n",
"5 Kirchhain\n",
"6 München\n",
"7 Kitzbühel\n",
"8 Klagenfurt\n",
"9 Grein a/D.\n",
"10 Bozen\n",
"11 Znaim\n",
"12 Graz\n",
"13 Heidelberg\n",
"14 Komotau\n",
"15 Köln\n",
"16 Bodenbach a. d. Elbe\n",
"17 Meissen\n",
"18 Leipzig\n",
"19 Konstanz\n",
"20 Korneuburg\n",
"21 Brașov\n",
"22 Mürzzuschlag\n",
"23 Salzburg\n",
"24 Frankfurt a. M.\n",
"25 Arys\n",
"26 Tegernsee\n",
"27 Garmisch\n",
"28 Partenkirchen-Garmisch\n",
"29 Zürich\n",
"... ...\n",
"1294 Neugersdorf\n",
"1295 Friedau\n",
"1296 Freystadt\n",
"1297 Gießhübl\n",
"1298 Gams\n",
"1299 Schlossberg\n",
"1300 Frakfurt a. Oder\n",
"1301 Casale Monferrato\n",
"1302 Sternberg\n",
"1303 Stössing\n",
"1304 Mauterndorf\n",
"1305 Thörl\n",
"1306 Traismauer\n",
"1307 Trebnitz\n",
"1308 Voitsberg\n",
"1309 Daun\n",
"1310 Kilchberg-Züich\n",
"1311 Strassburg i. Els.\n",
"1312 Mühlhausen\n",
"1313 Eschwege\n",
"1314 Tabarz\n",
"1315 Weimar\n",
"1316 Coburg\n",
"1317 Friedrichsroda i. Th.\n",
"1318 Leipa i. B.\n",
"1319 Schumburg a. D.\n",
"1320 Pisa\n",
"1321 Straßburg i./E.\n",
"1322 Detmold\n",
"1323 Furth i. W.\n",
"\n",
"[1324 rows x 1 columns]"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Better. Now show me some randomly:"
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 830 | \n",
" Friedberg | \n",
"
\n",
" \n",
" 993 | \n",
" Kreisbach | \n",
"
\n",
" \n",
" 743 | \n",
" Neustadt a. d. D. | \n",
"
\n",
" \n",
" 70 | \n",
" Halberstadt | \n",
"
\n",
" \n",
" 344 | \n",
" Kastelruth | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" 0\n",
"830 Friedberg\n",
"993 Kreisbach\n",
"743 Neustadt a. d. D.\n",
"70 Halberstadt\n",
"344 Kastelruth"
]
},
"execution_count": 33,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.sample(5)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Sort Things"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Just sort the sample, please:"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 953 | \n",
" Arnsdorf | \n",
"
\n",
" \n",
" 1293 | \n",
" Bad Neuhaus | \n",
"
\n",
" \n",
" 309 | \n",
" Bad Pyrmont | \n",
"
\n",
" \n",
" 545 | \n",
" Bellegarde | \n",
"
\n",
" \n",
" 1300 | \n",
" Frakfurt a. Oder | \n",
"
\n",
" \n",
" 301 | \n",
" Ischl | \n",
"
\n",
" \n",
" 3 | \n",
" Kirchau | \n",
"
\n",
" \n",
" 984 | \n",
" Mönichkirchen | \n",
"
\n",
" \n",
" 744 | \n",
" Ramsau | \n",
"
\n",
" \n",
" 391 | \n",
" Roustchouk | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" 0\n",
"953 Arnsdorf\n",
"1293 Bad Neuhaus\n",
"309 Bad Pyrmont\n",
"545 Bellegarde\n",
"1300 Frakfurt a. Oder\n",
"301 Ischl\n",
"3 Kirchau\n",
"984 Mönichkirchen\n",
"744 Ramsau\n",
"391 Roustchouk"
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.sample(10).sort_values(0)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Why the '0' in `sort_values(0)`? That's the name of the column to sort by."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Sort the whole thing:"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 1053 | \n",
" Békéscsaba | \n",
"
\n",
" \n",
" 1102 | \n",
" Łuck | \n",
"
\n",
" \n",
" 359 | \n",
" # | \n",
"
\n",
" \n",
" 1268 | \n",
" A B. | \n",
"
\n",
" \n",
" 1044 | \n",
" A. | \n",
"
\n",
" \n",
" 1194 | \n",
" Aachen | \n",
"
\n",
" \n",
" 434 | \n",
" Abbazia | \n",
"
\n",
" \n",
" 1083 | \n",
" Abbazia-Lovrana | \n",
"
\n",
" \n",
" 291 | \n",
" Absam b. Innsbruck | \n",
"
\n",
" \n",
" 997 | \n",
" Abtenau | \n",
"
\n",
" \n",
" 637 | \n",
" Achensee | \n",
"
\n",
" \n",
" 1257 | \n",
" Adelsberg | \n",
"
\n",
" \n",
" 314 | \n",
" Admont | \n",
"
\n",
" \n",
" 326 | \n",
" Aeuckens | \n",
"
\n",
" \n",
" 287 | \n",
" Aflenz | \n",
"
\n",
" \n",
" 840 | \n",
" Aggsbach | \n",
"
\n",
" \n",
" 824 | \n",
" Aigen | \n",
"
\n",
" \n",
" 413 | \n",
" Albendorf | \n",
"
\n",
" \n",
" 50 | \n",
" Alexandria | \n",
"
\n",
" \n",
" 685 | \n",
" Alland II | \n",
"
\n",
" \n",
" 902 | \n",
" Allentsteig | \n",
"
\n",
" \n",
" 366 | \n",
" Alsfeld | \n",
"
\n",
" \n",
" 646 | \n",
" Alt Lengbach | \n",
"
\n",
" \n",
" 1151 | \n",
" Altaussee | \n",
"
\n",
" \n",
" 820 | \n",
" Altenberg | \n",
"
\n",
" \n",
" 417 | \n",
" Altenburg | \n",
"
\n",
" \n",
" 861 | \n",
" Altenmarkt | \n",
"
\n",
" \n",
" 1034 | \n",
" Altenmarkt a. d. Tr. | \n",
"
\n",
" \n",
" 869 | \n",
" Altenmarkt a. d. Ysper | \n",
"
\n",
" \n",
" 645 | \n",
" Altenmarkt a.d. Trst. | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 839 | \n",
" Wr. Neustadt | \n",
"
\n",
" \n",
" 885 | \n",
" Wr.-Neustadt | \n",
"
\n",
" \n",
" 46 | \n",
" Wunsiedel | \n",
"
\n",
" \n",
" 384 | \n",
" Wurtsboro, N. Y. | \n",
"
\n",
" \n",
" 1079 | \n",
" Wöllan | \n",
"
\n",
" \n",
" 1274 | \n",
" Wörgl | \n",
"
\n",
" \n",
" 370 | \n",
" Wörishofen | \n",
"
\n",
" \n",
" 860 | \n",
" Wörschach | \n",
"
\n",
" \n",
" 597 | \n",
" Ybbs | \n",
"
\n",
" \n",
" 581 | \n",
" Ypres | \n",
"
\n",
" \n",
" 697 | \n",
" Ypser | \n",
"
\n",
" \n",
" 1266 | \n",
" Ysper | \n",
"
\n",
" \n",
" 977 | \n",
" Zakopane | \n",
"
\n",
" \n",
" 1054 | \n",
" Zantan | \n",
"
\n",
" \n",
" 582 | \n",
" Zara | \n",
"
\n",
" \n",
" 756 | \n",
" Zbiroh | \n",
"
\n",
" \n",
" 880 | \n",
" Zell a. See | \n",
"
\n",
" \n",
" 40 | \n",
" Zell am See | \n",
"
\n",
" \n",
" 918 | \n",
" Zistersdorf | \n",
"
\n",
" \n",
" 33 | \n",
" Zittau | \n",
"
\n",
" \n",
" 11 | \n",
" Znaim | \n",
"
\n",
" \n",
" 1169 | \n",
" Zuckmantel | \n",
"
\n",
" \n",
" 496 | \n",
" Zurigo | \n",
"
\n",
" \n",
" 1170 | \n",
" Zwettl | \n",
"
\n",
" \n",
" 1184 | \n",
" Zwiesel | \n",
"
\n",
" \n",
" 29 | \n",
" Zürich | \n",
"
\n",
" \n",
" 673 | \n",
" spitz | \n",
"
\n",
" \n",
" 1103 | \n",
" Łuck | \n",
"
\n",
" \n",
" 766 | \n",
" Šibenik | \n",
"
\n",
" \n",
" 0 | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
1324 rows × 1 columns
\n",
"
"
],
"text/plain": [
" 0\n",
"1053 Békéscsaba \n",
"1102 Łuck\n",
"359 #\n",
"1268 A B.\n",
"1044 A.\n",
"1194 Aachen\n",
"434 Abbazia\n",
"1083 Abbazia-Lovrana\n",
"291 Absam b. Innsbruck\n",
"997 Abtenau\n",
"637 Achensee\n",
"1257 Adelsberg\n",
"314 Admont\n",
"326 Aeuckens\n",
"287 Aflenz\n",
"840 Aggsbach\n",
"824 Aigen\n",
"413 Albendorf\n",
"50 Alexandria\n",
"685 Alland II\n",
"902 Allentsteig\n",
"366 Alsfeld\n",
"646 Alt Lengbach\n",
"1151 Altaussee\n",
"820 Altenberg\n",
"417 Altenburg\n",
"861 Altenmarkt\n",
"1034 Altenmarkt a. d. Tr.\n",
"869 Altenmarkt a. d. Ysper\n",
"645 Altenmarkt a.d. Trst.\n",
"... ...\n",
"839 Wr. Neustadt\n",
"885 Wr.-Neustadt\n",
"46 Wunsiedel\n",
"384 Wurtsboro, N. Y.\n",
"1079 Wöllan\n",
"1274 Wörgl\n",
"370 Wörishofen\n",
"860 Wörschach\n",
"597 Ybbs\n",
"581 Ypres\n",
"697 Ypser\n",
"1266 Ysper\n",
"977 Zakopane\n",
"1054 Zantan\n",
"582 Zara\n",
"756 Zbiroh\n",
"880 Zell a. See\n",
"40 Zell am See\n",
"918 Zistersdorf\n",
"33 Zittau\n",
"11 Znaim\n",
"1169 Zuckmantel\n",
"496 Zurigo\n",
"1170 Zwettl\n",
"1184 Zwiesel\n",
"29 Zürich\n",
"673 spitz\n",
"1103 Łuck\n",
"766 Šibenik\n",
"0 NaN\n",
"\n",
"[1324 rows x 1 columns]"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.sort_values(0)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"It seems like there's something weird going on with 'Békéscsaba', it doesn't sort right. What is wrong?"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's extract the datum:"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 Békéscsaba \n",
"Name: 1053, dtype: object"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.iloc[1053]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"More specifically the column '0':"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"' Békéscsaba '"
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.iloc[1053][0]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Seems there's a space in front of the 'B'. That's why it sorts wrong."
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 User Default",
"language": "python",
"name": "python_3_user_default"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
akon-experiments-51c7814f22bdf5809f1e38d562f312c29f99a16e/All the Mountains.ipynb 0000664 0000000 0000000 00000242403 13376003704 0026146 0 ustar 00root root 0000000 0000000 {
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# All the Mountains"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"*Extract all postcards depicting a mountain*"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"*(as far as we know from the metadata)*"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Setup"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"pd.set_option('display.max_columns', 100) # Output up to 100 columns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Load Data"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_csv('akon_postcards_public_domain.csv.bz2')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## View Data"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" photographer | \n",
" publisher | \n",
" publisher_place | \n",
" region | \n",
" water_body | \n",
" year | \n",
" inventory_number | \n",
" signature | \n",
" revision_date | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 19813 | \n",
" 19813 | \n",
" AK044_441 | \n",
" 26376 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" True | \n",
" NaN | \n",
" Oetscher | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1909.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.347 | \n",
" 1909 | \n",
" T | \n",
" MT | \n",
" 2769364.0 | \n",
" 47.86185 | \n",
" 15.20246 | \n",
" Ötscher | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 4622 | \n",
" 4622 | \n",
" AK059_111 | \n",
" 35163 | \n",
" NaN | \n",
" NaN | \n",
" St. Michael | \n",
" False | \n",
" 1917 gelaufen | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2015-07-31 09:41:19.356 | \n",
" gelaufen 1917 | \n",
" P | \n",
" PPLA3 | \n",
" 2766495.0 | \n",
" 47.33333 | \n",
" 15.00000 | \n",
" Sankt Michael in Obersteiermark | \n",
" AT | \n",
" Steiermark | \n",
" 06 | \n",
"
\n",
" \n",
" 1733 | \n",
" 1733 | \n",
" AK118_380 | \n",
" 65140 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" True | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Grundlsee | \n",
" 1910.0 | \n",
" 13/41 G. KA. | \n",
" Geographisch-topographische Bildersammlung 882... | \n",
" 2014-09-10 07:51:33.802 | \n",
" 1910 | \n",
" H | \n",
" LK | \n",
" 2777424.0 | \n",
" 47.63333 | \n",
" 13.86667 | \n",
" Grundlsee | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 12871 | \n",
" 12871 | \n",
" AK010_403 | \n",
" 5848 | \n",
" NaN | \n",
" Hrad Pernštýn | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Beran | \n",
" Bystrice | \n",
" NaN | \n",
" NaN | \n",
" 1908.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:09.951 | \n",
" 1908 | \n",
" P | \n",
" PPL | \n",
" 3068420.0 | \n",
" 49.44929 | \n",
" 16.30180 | \n",
" Pernštejn | \n",
" CZ | \n",
" Südmährische Region | \n",
" 78 | \n",
"
\n",
" \n",
" 15832 | \n",
" 15832 | \n",
" AK025_269 | \n",
" 14775 | \n",
" NaN | \n",
" NaN | \n",
" Borosznó | \n",
" False | \n",
" 1915 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.181 | \n",
" gelaufen 1915 | \n",
" P | \n",
" PPL | \n",
" 3060917.0 | \n",
" 48.79238 | \n",
" 19.38220 | \n",
" Brusno | \n",
" SK | \n",
" Banskobystrický | \n",
" 01 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city \\\n",
"19813 19813 AK044_441 26376 NaN NaN NaN \n",
"4622 4622 AK059_111 35163 NaN NaN St. Michael \n",
"1733 1733 AK118_380 65140 NaN NaN NaN \n",
"12871 12871 AK010_403 5848 NaN Hrad Pernštýn NaN \n",
"15832 15832 AK025_269 14775 NaN NaN Borosznó \n",
"\n",
" color comment mountain other photographer publisher \\\n",
"19813 True NaN Oetscher NaN NaN Ledermann \n",
"4622 False 1917 gelaufen NaN NaN NaN NaN \n",
"1733 True NaN NaN NaN NaN NaN \n",
"12871 False NaN NaN NaN NaN Beran \n",
"15832 False 1915 gel NaN NaN NaN NaN \n",
"\n",
" publisher_place region water_body year inventory_number \\\n",
"19813 Wien NaN NaN 1909.0 NaN \n",
"4622 NaN NaN NaN NaN NaN \n",
"1733 NaN NaN Grundlsee 1910.0 13/41 G. KA. \n",
"12871 Bystrice NaN NaN 1908.0 NaN \n",
"15832 NaN NaN NaN NaN NaN \n",
"\n",
" signature \\\n",
"19813 NaN \n",
"4622 NaN \n",
"1733 Geographisch-topographische Bildersammlung 882... \n",
"12871 NaN \n",
"15832 NaN \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"19813 2014-08-04 07:59:10.347 1909 T MT \n",
"4622 2015-07-31 09:41:19.356 gelaufen 1917 P PPLA3 \n",
"1733 2014-09-10 07:51:33.802 1910 H LK \n",
"12871 2014-08-04 07:59:09.951 1908 P PPL \n",
"15832 2014-08-04 07:59:10.181 gelaufen 1915 P PPL \n",
"\n",
" geoname_id latitude longitude name \\\n",
"19813 2769364.0 47.86185 15.20246 Ötscher \n",
"4622 2766495.0 47.33333 15.00000 Sankt Michael in Obersteiermark \n",
"1733 2777424.0 47.63333 13.86667 Grundlsee \n",
"12871 3068420.0 49.44929 16.30180 Pernštejn \n",
"15832 3060917.0 48.79238 19.38220 Brusno \n",
"\n",
" country_id admin_name_1 admin_code_1 \n",
"19813 AT NaN NaN \n",
"4622 AT Steiermark 06 \n",
"1733 AT NaN NaN \n",
"12871 CZ Südmährische Region 78 \n",
"15832 SK Banskobystrický 01 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.sample(5)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Filter Mountains"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Rows without an identified mountain have `'NaN'` in the column `'mountain'`"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We can filter by those having NaN by using `'isnull'`:"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"28882"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"24438"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df[ df['mountain'].isnull() ])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"and reverse the filter, so we get all rows where the 'mountain' entry *is not NaN*.\n",
"\n",
"Note that `'~'` means a logical *not*.\n",
"\n",
"Also note that the filter has to be inside parentheses."
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"4444"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df[ ~ (df['mountain'].isnull()) ])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"And now let's save the result."
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"mountains = df[ ~ (df['mountain'].isnull()) ]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Take a look at the data"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" akon_id | \n",
" id | \n",
" altitude | \n",
" building | \n",
" city | \n",
" color | \n",
" comment | \n",
" mountain | \n",
" other | \n",
" photographer | \n",
" publisher | \n",
" publisher_place | \n",
" region | \n",
" water_body | \n",
" year | \n",
" inventory_number | \n",
" signature | \n",
" revision_date | \n",
" date | \n",
" feature_class | \n",
" feature_code | \n",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
"
\n",
" \n",
" \n",
" \n",
" 12246 | \n",
" 12246 | \n",
" AK009_069 | \n",
" 4907 | \n",
" NaN | \n",
" Vajolethütten | \n",
" NaN | \n",
" True | \n",
" 1911 | \n",
" Rosengarten-Dolomiten | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-02 14:38:20.426 | \n",
" gelaufen 1911 | \n",
" T | \n",
" MT | \n",
" 6695336.0 | \n",
" 46.47431 | \n",
" 11.64373 | \n",
" Catinaccio d'Antermoia | \n",
" IT | \n",
" Venetien | \n",
" 20 | \n",
"
\n",
" \n",
" 19221 | \n",
" 19221 | \n",
" AK041_447 | \n",
" 24574 | \n",
" NaN | \n",
" Kesselfall-Hotel | \n",
" Kaprunerthal | \n",
" False | \n",
" vor 1905 | \n",
" Schmittenhöhe | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-16 09:04:43.529 | \n",
" vor 1905 | \n",
" T | \n",
" VAL | \n",
" 2774756.0 | \n",
" 47.21667 | \n",
" 12.71667 | \n",
" Kaprunertal | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 21207 | \n",
" 21207 | \n",
" AK050_296 | \n",
" 29843 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Hallermauern | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1910.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.375 | \n",
" 1910 | \n",
" T | \n",
" RDGE | \n",
" 2598498.0 | \n",
" 47.65000 | \n",
" 14.45000 | \n",
" Haller Mauern | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 16741 | \n",
" 16741 | \n",
" AK029_210 | \n",
" 17125 | \n",
" NaN | \n",
" Alpenhotel Wiesenegg | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Radstädter Tauern | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1911.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-16 08:51:54.544 | \n",
" 1911 | \n",
" T | \n",
" MT | \n",
" 2768097.0 | \n",
" 47.25000 | \n",
" 13.40000 | \n",
" Radstädter Tauern | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 15131 | \n",
" 15131 | \n",
" AK022_473 | \n",
" 13167 | \n",
" NaN | \n",
" NaN | \n",
" Windischgarsten | \n",
" False | \n",
" NaN | \n",
" Totes Gebirge | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1910.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.150 | \n",
" 1910 | \n",
" P | \n",
" PPL | \n",
" 2761096.0 | \n",
" 47.72223 | \n",
" 14.32755 | \n",
" Windischgarsten | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 16551 | \n",
" 16551 | \n",
" AK028_357 | \n",
" 16670 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Backenstein | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" Alt-Ausseer-See | \n",
" 1906.0 | \n",
" NaN | \n",
" NaN | \n",
" 2015-08-03 11:52:38.999 | \n",
" 1906 | \n",
" P | \n",
" PPLA3 | \n",
" 2782724.0 | \n",
" 47.63844 | \n",
" 13.76278 | \n",
" Altaussee | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 18996 | \n",
" 18996 | \n",
" AK039_526 | \n",
" 23451 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Beilstein-Mauern, Hintstein, Kreuzmauer, Hohe ... | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1915.0 | \n",
" NaN | \n",
" NaN | \n",
" 2015-04-16 16:42:15.579 | \n",
" 1915 | \n",
" P | \n",
" PPL | \n",
" 2776208.0 | \n",
" 47.85000 | \n",
" 14.63333 | \n",
" Hintstein | \n",
" AT | \n",
" Oberösterreich | \n",
" 04 | \n",
"
\n",
" \n",
" 16479 | \n",
" 16479 | \n",
" AK028_284 | \n",
" 16597 | \n",
" NaN | \n",
" Schutzhaus | \n",
" NaN | \n",
" True | \n",
" NaN | \n",
" Schöpfl | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1907.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.215 | \n",
" 1907 | \n",
" T | \n",
" MT | \n",
" 2765653.0 | \n",
" 48.08758 | \n",
" 15.91409 | \n",
" Schöpfl | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 10080 | \n",
" 10080 | \n",
" AK101_402 | \n",
" 66170 | \n",
" NaN | \n",
" NaN | \n",
" Rosenlaui, Rosenlauigletscher | \n",
" False | \n",
" v. 1907 | \n",
" Wellhorn | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 79/66 G | \n",
" NaN | \n",
" 2014-09-03 08:57:40.254 | \n",
" vor 1907 | \n",
" P | \n",
" PPL | \n",
" 8533561.0 | \n",
" 46.67959 | \n",
" 8.15389 | \n",
" Rosenlaui | \n",
" CH | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" 28142 | \n",
" 28142 | \n",
" AK070_499 | \n",
" 43332 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Zinken | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1912.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-18 10:39:11.258 | \n",
" 1912 | \n",
" T | \n",
" MT | \n",
" 2760557.0 | \n",
" 47.33333 | \n",
" 14.73333 | \n",
" Seckauer Zinken | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building \\\n",
"12246 12246 AK009_069 4907 NaN Vajolethütten \n",
"19221 19221 AK041_447 24574 NaN Kesselfall-Hotel \n",
"21207 21207 AK050_296 29843 NaN NaN \n",
"16741 16741 AK029_210 17125 NaN Alpenhotel Wiesenegg \n",
"15131 15131 AK022_473 13167 NaN NaN \n",
"16551 16551 AK028_357 16670 NaN NaN \n",
"18996 18996 AK039_526 23451 NaN NaN \n",
"16479 16479 AK028_284 16597 NaN Schutzhaus \n",
"10080 10080 AK101_402 66170 NaN NaN \n",
"28142 28142 AK070_499 43332 NaN NaN \n",
"\n",
" city color comment \\\n",
"12246 NaN True 1911 \n",
"19221 Kaprunerthal False vor 1905 \n",
"21207 NaN False NaN \n",
"16741 NaN False NaN \n",
"15131 Windischgarsten False NaN \n",
"16551 NaN False NaN \n",
"18996 NaN False NaN \n",
"16479 NaN True NaN \n",
"10080 Rosenlaui, Rosenlauigletscher False v. 1907 \n",
"28142 NaN False NaN \n",
"\n",
" mountain other photographer \\\n",
"12246 Rosengarten-Dolomiten NaN NaN \n",
"19221 Schmittenhöhe NaN NaN \n",
"21207 Hallermauern NaN NaN \n",
"16741 Radstädter Tauern NaN NaN \n",
"15131 Totes Gebirge NaN NaN \n",
"16551 Backenstein NaN NaN \n",
"18996 Beilstein-Mauern, Hintstein, Kreuzmauer, Hohe ... NaN NaN \n",
"16479 Schöpfl NaN NaN \n",
"10080 Wellhorn NaN NaN \n",
"28142 Zinken NaN NaN \n",
"\n",
" publisher publisher_place region water_body year \\\n",
"12246 NaN NaN NaN NaN NaN \n",
"19221 NaN NaN NaN NaN NaN \n",
"21207 Ledermann Wien NaN NaN 1910.0 \n",
"16741 NaN NaN NaN NaN 1911.0 \n",
"15131 NaN NaN NaN NaN 1910.0 \n",
"16551 Ledermann Wien NaN Alt-Ausseer-See 1906.0 \n",
"18996 NaN NaN NaN NaN 1915.0 \n",
"16479 Ledermann Wien NaN NaN 1907.0 \n",
"10080 NaN NaN NaN NaN NaN \n",
"28142 NaN NaN NaN NaN 1912.0 \n",
"\n",
" inventory_number signature revision_date date \\\n",
"12246 NaN NaN 2014-09-02 14:38:20.426 gelaufen 1911 \n",
"19221 NaN NaN 2014-09-16 09:04:43.529 vor 1905 \n",
"21207 NaN NaN 2014-08-04 07:59:10.375 1910 \n",
"16741 NaN NaN 2014-09-16 08:51:54.544 1911 \n",
"15131 NaN NaN 2014-08-04 07:59:10.150 1910 \n",
"16551 NaN NaN 2015-08-03 11:52:38.999 1906 \n",
"18996 NaN NaN 2015-04-16 16:42:15.579 1915 \n",
"16479 NaN NaN 2014-08-04 07:59:10.215 1907 \n",
"10080 79/66 G NaN 2014-09-03 08:57:40.254 vor 1907 \n",
"28142 NaN NaN 2014-08-18 10:39:11.258 1912 \n",
"\n",
" feature_class feature_code geoname_id latitude longitude \\\n",
"12246 T MT 6695336.0 46.47431 11.64373 \n",
"19221 T VAL 2774756.0 47.21667 12.71667 \n",
"21207 T RDGE 2598498.0 47.65000 14.45000 \n",
"16741 T MT 2768097.0 47.25000 13.40000 \n",
"15131 P PPL 2761096.0 47.72223 14.32755 \n",
"16551 P PPLA3 2782724.0 47.63844 13.76278 \n",
"18996 P PPL 2776208.0 47.85000 14.63333 \n",
"16479 T MT 2765653.0 48.08758 15.91409 \n",
"10080 P PPL 8533561.0 46.67959 8.15389 \n",
"28142 T MT 2760557.0 47.33333 14.73333 \n",
"\n",
" name country_id admin_name_1 admin_code_1 \n",
"12246 Catinaccio d'Antermoia IT Venetien 20 \n",
"19221 Kaprunertal AT NaN NaN \n",
"21207 Haller Mauern AT NaN NaN \n",
"16741 Radstädter Tauern AT NaN NaN \n",
"15131 Windischgarsten AT NaN NaN \n",
"16551 Altaussee AT NaN NaN \n",
"18996 Hintstein AT Oberösterreich 04 \n",
"16479 Schöpfl AT NaN NaN \n",
"10080 Rosenlaui CH NaN NaN \n",
"28142 Seckauer Zinken AT NaN NaN "
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"mountains.sample(10)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Looks about right."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Extract Identifiers"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"To create a collection with SACHA, let's extract all the AKON ids."
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'AK111_048, AK111_080, AK111_096, AK111_131, AK111_193, AK111_149, AK111_169, AK111_241, AK111_242, AK111_287, AK111_332, AK111_333, AK111_470, AK111_476, AK111_551, AK111_549, AK111_559, AK111_560, AK111_562, AK111_565, AK116_227, AK111_581, AK111_582, AK111_598, AK112_015, AK006_118, AK112_598, AK003_200, AK113_022, AK113_030, AK113_283, AK113_311, AK113_511, AK113_518, AK113_524, AK113_559, AK113_561, AK113_562, AK113_563, AK033_564, AK074_435, AK033_541, AK114_261, AK114_302, AK114_303, AK114_391, AK114_449, AK059_222, AK114_453, AK114_454, AK114_458, AK061_243, AK114_509, AK114_544, AK114_554, AK114_562, AK114_566, AK114_579, AK114_601, AK115_003, AK115_009, AK115_017, AK115_029, AK115_030, AK115_042, AK115_049, AK115_051, AK115_056, AK115_057, AK115_077, AK115_133, AK115_135, AK115_143, AK115_145, AK115_149, AK115_151, AK115_157, AK115_162, AK115_163, AK115_170, AK115_174, AK115_175, AK115_176, AK115_180, AK115_182, AK115_183, AK115_188, AK115_192, AK115_199, AK115_205, AK115_207, AK115_208, AK115_209, AK115_240, AK115_251, AK115_262, AK115_278, AK115_285, AK115_372, AK115_381, AK115_386, AK115_393, AK115_423, AK115_424, AK115_436, AK115_438, AK115_442, AK115_447, AK115_470, AK115_504, AK115_505, AK115_506, AK115_507, AK115_509, AK115_511, AK115_514, AK115_515, AK115_516, AK115_517, AK115_518, AK115_519, AK115_520, AK115_521, AK115_522, AK115_524, AK115_526, AK115_528, AK115_531, AK115_532, AK115_533, AK115_587, AK115_588, AK115_589, AK115_590, AK115_593, AK116_091, AK116_092, AK116_094, AK116_100, AK116_103, AK116_109, AK116_132, AK116_158, AK116_159, AK116_221, AK116_222, AK116_223, AK116_225, AK116_228, AK074_313, AK116_266, AK116_270, AK116_279, AK116_282, AK116_298, AK116_303, AK116_306, AK116_307, AK116_317, AK116_318, AK116_328, AK116_355, AK116_362, AK082_325, AK116_421, AK116_428, AK116_430, AK116_482, AK116_518, AK116_507, AK116_515, AK116_584, AK116_597, AK117_021, AK117_041, AK117_058, AK117_080, AK117_093, AK117_113, AK117_122, AK117_123, AK117_129, AK117_139, AK117_184, AK117_185, AK117_186, AK117_203, AK117_209, AK117_216, AK118_077, AK117_297, AK117_336, AK117_345, AK117_355, AK117_361, AK117_365, AK117_374, AK117_398, AK117_400, AK117_407, AK117_409, AK117_411, AK117_421, AK117_423, AK117_428, AK117_430, AK117_447, AK117_451, AK117_452, AK117_459, AK117_465, AK117_468, AK117_471, AK117_475, AK117_541, AK117_580, AK117_598, AK118_012, AK118_014, AK118_016, AK118_017, AK118_018, AK118_026, AK118_049, AK118_051, AK118_020, AK118_060, AK118_068, AK118_070, AK118_073, AK118_074, AK118_099, AK118_096, AK118_126, AK118_128, AK118_131, AK118_132, AK118_134, AK118_141, AK118_148, AK118_150, AK118_151, AK118_152, AK118_159, AK118_176, AK118_178, AK118_239, AK118_258, AK118_261, AK118_262, AK118_263, AK118_264, AK118_265, AK118_267, AK118_286, AK118_343, AK118_359, AK118_392, AK118_426, AK118_427, AK118_462, AK118_474, AK118_504, AK118_509, AK118_533, AK118_536, AK118_544, AK118_552, AK118_555, AK118_588, AK064_015, AK064_018, AK064_019, AK064_020, AK119_021, AK119_040, AK119_055, AK119_064, AK119_087, AK119_123, AK119_224, AK114_236, AK119_341, AK119_374, AK119_382, AK119_418, AK119_439, AK119_444, AK119_561, AK119_563, AK119_564, AK119_589, AK119_590, AK120_005, AK120_012, AK120_020, AK064_026, AK012_473, AK012_471, AK120_094, AK120_106, AK120_110, AK120_127, AK120_239, AK120_226, AK120_477, AK120_229, AK120_240, AK120_242, AK120_252, AK117_597, AK120_314, AK120_315, AK120_478, AK120_328, AK120_346, AK120_356, AK120_357, AK120_358, AK120_360, AK120_361, AK120_362, AK120_363, AK120_364, AK120_365, AK120_370, AK120_404, AK120_406, AK120_407, AK120_408, AK120_409, AK120_410, AK120_411, AK120_412, AK120_415, AK120_416, AK120_417, AK120_418, AK120_420, AK120_421, AK120_422, AK120_423, AK120_424, AK120_425, AK120_427, AK120_428, AK120_429, AK120_430, AK120_431, AK120_432, AK120_433, AK120_434, AK120_437, AK120_438, AK120_439, AK120_440, AK120_441, AK120_442, AK120_443, AK120_444, AK120_448, AK120_452, AK120_453, AK120_454, AK120_455, AK120_467, AK120_468, AK120_469, AK120_471, AK120_472, AK120_473, AK120_474, AK120_475, AK120_479, AK120_480, AK120_481, AK120_494, AK086_058, AK086_113, AK121_028, AK121_069, AK121_086, AK121_105, AK121_106, AK121_107, AK121_123, AK121_127, AK121_132, AK121_172, AK121_173, AK121_227, AK121_230, AK121_246, AK121_247, AK121_248, AK121_249, AK121_235, AK121_233, AK121_251, AK121_253, AK121_254, AK121_257, AK121_258, AK121_259, AK121_264, AK121_266, AK121_268, AK121_269, AK121_270, AK121_271, AK121_272, AK121_274, AK121_279, AK104_524, AK104_525, AK104_526, AK121_281, AK121_283, AK121_396, AK121_413, AK121_423, AK121_444, AK121_468, AK048_419, AK104_530, AK121_601, AK122_027, AK087_072, AK122_055, AK122_177, AK122_179, AK122_180, AK122_185, AK122_186, AK122_187, AK122_188, AK122_228, AK122_232, AK122_244, AK122_247, AK122_265, AK122_286, AK122_287, AK122_288, AK122_312, AK122_319, AK122_349, AK122_356, AK122_355, AK122_354, AK122_351, AK122_359, AK122_362, AK122_376, AK122_464, AK122_528, AK074_345, AK122_578, AK067_458, AK123_037, AK123_039, AK123_049, AK104_531, AK123_364, AK074_428, AK123_553, AK123_555, AK123_556, AK123_560, AK027_234, AK122_544, AK074_436, AK124_187, AK124_194, AK124_270, AK124_303, AK124_462, AK124_463, AK124_467, AK124_468, AK124_483, AK124_484, AK124_496, AK124_505, AK124_574, AK125_040, AK125_035, AK125_051, AK125_052, AK125_054, AK125_077, AK125_091, AK125_095, AK125_136, AK125_139, AK125_155, AK125_157, AK125_162, AK125_172, AK125_185, AK125_186, AK125_192, AK125_193, AK125_210, AK125_211, AK125_212, AK125_215, AK125_219, AK125_239, AK125_305, AK125_317, AK125_318, AK125_344, AK125_345, AK125_370, AK125_376, AK125_378, AK125_403, AK125_425, AK125_435, AK125_438, AK125_440, AK125_441, AK125_444, AK125_446, AK125_447, AK125_421, AK125_454, AK125_460, AK125_462, AK125_472, AK125_483, AK104_567, AK070_588, AK081_017, AK028_125, AK082_007, AK096_300, AK109_512, AK114_578, AK115_206, AK116_154, AK116_420, AK115_523, AK118_142, AK120_236, AK120_435, AK120_446, AK123_041, AK123_044, AK074_452, AK125_476, AK125_499, AK125_502, AK058_194, AK045_459, AK058_234, AK058_273, AK049_122, AK003_566, AK018_142, AK118_076, AK045_062, AK045_460, AK045_461, AK046_576, AK046_579, AK065_156, AK065_157, AK066_390, AK052_437, AK014_335, AK017_080, AK017_083, AK017_084, AK017_386, AK017_387, AK022_087, AK022_096, AK022_097, AK022_099, AK022_101, AK022_102, AK022_109, AK022_258, AK022_266, AK052_438, AK063_424, AK028_320, AK030_042, AK030_054, AK030_362, AK033_116, AK033_113, AK033_118, AK033_262, AK033_279, AK033_406, AK033_427, AK033_519, AK035_412, AK044_100, AK044_190, AK044_449, AK044_467, AK044_545, AK044_543, AK044_544, AK045_162, AK045_319, AK045_320, AK045_474, AK046_210, AK046_215, AK046_264, AK046_595, AK047_465, AK048_596, AK048_591, AK048_592, AK048_594, AK048_595, AK048_597, AK048_598, AK048_599, AK048_602, AK048_600, AK048_603, AK048_381, AK048_393, AK048_394, AK048_396, AK048_398, AK048_401, AK048_407, AK048_399, AK048_408, AK048_423, AK048_426, AK048_449, AK048_451, AK048_457, AK048_411, AK048_412, AK048_417, AK048_418, AK048_461, AK048_462, AK048_464, AK050_250, AK050_247, AK063_427, AK054_356, AK048_400, AK048_402, AK048_406, AK048_409, AK048_410, AK048_413, AK048_478, AK049_001, AK052_077, AK052_078, AK059_355, AK059_359, AK063_140, AK061_482, AK063_141, AK069_324, AK066_398, AK070_233, AK048_434, AK048_438, AK048_440, AK048_481, AK048_405, AK048_414, AK037_242, AK032_498, AK001_525, AK014_152, AK064_197, AK024_316, AK028_119, AK108_041, AK025_119, AK091_167, AK114_190, AK065_462, AK065_478, AK068_302, AK068_325, AK068_331, AK113_566, AK113_569, AK113_570, AK010_418, AK099_400, AK105_350, AK050_154, AK065_461, AK059_234, AK031_209, AK118_028, AK045_020, AK045_021, AK069_175, AK091_518, AK021_318, AK096_449, AK096_453, AK096_455, AK096_457, AK096_458, AK065_183, AK065_188, AK096_452, AK068_477, AK068_478, AK068_479, AK068_480, AK068_481, AK069_568, AK058_312, AK063_231, AK044_125, AK070_584, AK081_375, AK081_427, AK027_311, AK096_495, AK068_073, AK063_018, AK070_352, AK070_353, AK017_197, AK107_400, AK125_493, AK036_444, AK036_445, AK060_112, AK060_107, AK060_101, AK021_404, AK021_408, AK021_412, AK021_420, AK021_422, AK021_428, AK021_433, AK021_481, AK085_106, AK021_483, AK021_487, AK021_491, AK021_492, AK058_397, AK058_386, AK021_493, AK054_583, AK054_584, AK054_586, AK054_589, AK060_385, AK060_377, AK060_386, AK026_410, AK026_413, AK026_432, AK026_435, AK026_040, AK026_050, AK026_051, AK074_347, AK019_414, AK060_245, AK066_377, AK064_509, AK067_256, AK086_488, AK086_489, AK086_490, AK108_047, AK100_513, AK121_236, AK102_486, AK125_075, AK125_374, AK067_510, AK115_050, AK075_444, AK115_148, AK117_559, AK121_397, AK121_476, AK009_039, AK104_581, AK118_050, AK075_266, AK075_286, AK075_289, AK075_317, AK075_321, AK081_109, AK081_013, AK081_076, AK075_479, AK075_483, AK075_484, AK075_500, AK105_196, AK075_499, AK075_539, AK075_540, AK075_566, AK076_023, AK076_024, AK076_056, AK076_097, AK076_113, AK076_186, AK076_187, AK105_294, AK105_295, AK105_379, AK076_447, AK076_454, AK078_396, AK076_512, AK076_524, AK076_525, AK076_549, AK105_388, AK105_397, AK105_391, AK048_430, AK055_240, AK003_371, AK003_467, AK077_243, AK077_393, AK077_394, AK077_397, AK077_419, AK077_420, AK077_421, AK077_432, AK077_434, AK077_436, AK077_444, AK077_474, AK077_495, AK077_503, AK078_079, AK078_077, AK078_086, AK078_096, AK078_099, AK063_317, AK063_324, AK063_331, AK006_055, AK006_271, AK078_436, AK078_451, AK108_044, AK086_179, AK106_065, AK078_549, AK120_539, AK120_540, AK079_056, AK079_077, AK079_078, AK079_079, AK008_546, AK019_488, AK019_554, AK063_380, AK063_339, AK063_352, AK063_337, AK063_396, AK063_409, AK063_410, AK063_414, AK079_195, AK010_194, AK010_144, AK010_193, AK010_195, AK010_108, AK079_361, AK079_364, AK079_365, AK079_376, AK079_404, AK079_422, AK106_210, AK106_211, AK079_496, AK079_502, AK114_323, AK106_248, AK080_202, AK012_271, AK080_418, AK080_420, AK022_223, AK080_431, AK080_438, AK080_442, AK080_544, AK080_545, AK080_568, AK080_575, AK082_011, AK082_020, AK082_048, AK082_058, AK082_061, AK082_064, AK082_065, AK082_067, AK082_074, AK082_078, AK082_080, AK082_107, AK082_090, AK082_106, AK013_599, AK050_520, AK082_348, AK082_352, AK082_469, AK082_475, AK011_310, AK106_347, AK083_020, AK083_038, AK083_074, AK116_277, AK097_185, AK106_392, AK083_221, AK083_220, AK083_230, AK083_270, AK083_282, AK106_445, AK106_447, AK083_363, AK015_262, AK083_406, AK083_474, AK015_447, AK015_454, AK101_133, AK084_016, AK084_098, AK084_082, AK084_195, AK084_234, AK084_239, AK084_243, AK016_495, AK084_275, AK084_289, AK084_291, AK084_297, AK084_298, AK084_299, AK084_303, AK084_463, AK084_585, AK084_590, AK085_144, AK019_299, AK019_298, AK085_330, AK085_384, AK085_388, AK085_389, AK085_449, AK106_569, AK086_066, AK086_064, AK086_068, AK086_071, AK086_110, AK086_112, AK086_115, AK086_118, AK086_121, AK086_124, AK086_178, AK021_019, AK086_187, AK086_188, AK086_198, AK050_541, AK086_190, AK086_196, AK086_202, AK086_209, AK086_211, AK086_212, AK086_214, AK086_215, AK086_217, AK086_227, AK086_229, AK086_232, AK086_245, AK086_274, AK086_283, AK086_286, AK086_287, AK086_331, AK086_320, AK086_321, AK086_323, AK086_324, AK022_565, AK086_426, AK086_472, AK086_485, AK108_045, AK086_476, AK086_478, AK086_479, AK086_486, AK086_504, AK086_505, AK086_487, AK086_570, AK107_002, AK087_349, AK087_496, AK087_554, AK095_232, AK087_562, AK087_574, AK088_282, AK061_192, AK107_043, AK088_496, AK088_497, AK026_374, AK026_373, AK026_372, AK088_526, AK088_549, AK089_095, AK089_096, AK089_116, AK089_365, AK107_054, AK089_234, AK089_235, AK089_237, AK089_262, AK089_321, AK089_291, AK089_346, AK089_319, AK089_366, AK089_367, AK089_368, AK089_371, AK089_484, AK089_499, AK090_006, AK090_012, AK090_014, AK090_016, AK090_130, AK090_135, AK090_153, AK090_176, AK090_177, AK107_116, AK090_428, AK090_483, AK090_497, AK090_566, AK091_007, AK091_169, AK091_345, AK091_352, AK091_355, AK091_357, AK091_358, AK091_359, AK091_407, AK091_410, AK091_411, AK091_525, AK092_026, AK002_419, AK092_209, AK092_213, AK092_219, AK092_220, AK092_222, AK092_225, AK092_250, AK032_568, AK092_300, AK041_087, AK041_203, AK041_219, AK041_234, AK041_311, AK041_323, AK041_324, AK041_326, AK041_329, AK041_332, AK041_534, AK041_554, AK041_604, AK041_587, AK041_588, AK041_274, AK041_279, AK074_041, AK107_272, AK092_386, AK092_387, AK092_554, AK092_574, AK092_576, AK093_063, AK093_083, AK093_096, AK093_273, AK093_325, AK093_338, AK117_539, AK093_346, AK093_377, AK093_378, AK093_455, AK093_461, AK096_546, AK096_547, AK096_548, AK096_554, AK096_556, AK093_531, AK093_564, AK093_567, AK094_117, AK094_146, AK094_167, AK107_390, AK107_391, AK107_393, AK094_240, AK094_261, AK094_264, AK094_294, AK094_347, AK094_349, AK094_348, AK094_350, AK094_351, AK094_485, AK094_486, AK094_489, AK094_496, AK094_497, AK094_504, AK107_453, AK107_460, AK095_103, AK095_120, AK095_230, AK095_231, AK095_233, AK034_491, AK107_502, AK095_410, AK095_411, AK081_122, AK095_449, AK107_519, AK107_524, AK001_011, AK107_533, AK001_019, AK096_297, AK096_298, AK096_301, AK096_305, AK096_304, AK096_309, AK069_411, AK001_079, AK069_462, AK069_468, AK001_080, AK001_087, AK035_428, AK069_499, AK097_105, AK097_112, AK097_114, AK097_131, AK097_183, AK097_281, AK097_338, AK097_350, AK097_356, AK097_357, AK097_359, AK097_360, AK097_361, AK097_362, AK097_363, AK097_443, AK097_444, AK097_445, AK097_446, AK097_460, AK097_466, AK097_552, AK097_553, AK097_555, AK097_560, AK097_598, AK097_599, AK098_037, AK098_051, AK108_039, AK098_097, AK098_139, AK108_040, AK108_042, AK108_043, AK108_046, AK098_191, AK098_280, AK098_281, AK098_283, AK098_288, AK108_068, AK098_378, AK098_397, AK098_482, AK099_002, AK001_198, AK001_201, AK001_210, AK099_042, AK099_060, AK099_062, AK099_090, AK099_106, AK108_117, AK108_129, AK108_141, AK099_208, AK099_262, AK099_287, AK099_296, AK099_356, AK099_376, AK099_392, AK099_393, AK099_428, AK099_439, AK099_440, AK001_287, AK099_441, AK099_487, AK037_005, AK099_510, AK099_537, AK099_538, AK099_539, AK100_180, AK100_158, AK100_381, AK001_315, AK001_322, AK001_323, AK001_324, AK001_332, AK100_414, AK100_418, AK100_419, AK001_326, AK001_331, AK100_445, AK100_479, AK100_488, AK108_186, AK108_188, AK108_190, AK100_516, AK100_517, AK100_572, AK100_571, AK101_066, AK101_079, AK101_087, AK101_143, AK101_144, AK101_147, AK101_272, AK101_273, AK101_275, AK101_281, AK101_305, AK101_313, AK001_427, AK001_429, AK001_431, AK001_434, AK001_451, AK001_436, AK001_435, AK001_437, AK001_439, AK001_440, AK001_450, AK001_586, AK001_589, AK001_591, AK001_595, AK101_402, AK002_013, AK002_012, AK002_042, AK002_041, AK002_047, AK002_103, AK002_107, AK002_123, AK002_150, AK002_157, AK101_468, AK101_474, AK002_211, AK101_485, AK002_250, AK002_253, AK002_255, AK002_257, AK101_492, AK002_281, AK002_302, AK002_356, AK002_357, AK002_369, AK002_390, AK002_395, AK002_393, AK002_394, AK002_401, AK002_402, AK002_398, AK102_040, AK102_045, AK002_435, AK002_438, AK002_439, AK002_451, AK102_051, AK102_059, AK002_465, AK002_475, AK102_084, AK102_085, AK002_542, AK002_536, AK003_002, AK108_316, AK108_318, AK102_166, AK102_244, AK102_245, AK102_250, AK102_257, AK102_255, AK003_191, AK003_195, AK003_196, AK003_202, AK102_264, AK102_274, AK102_284, AK003_227, AK003_229, AK003_230, AK003_233, AK102_289, AK102_295, AK102_297, AK102_301, AK003_239, AK003_244, AK003_245, AK003_247, AK003_258, AK003_252, AK003_253, AK003_287, AK003_286, AK003_280, AK003_282, AK003_284, AK003_285, AK003_292, AK003_290, AK003_395, AK003_380, AK003_384, AK003_396, AK003_397, AK003_394, AK003_398, AK003_402, AK003_406, AK003_407, AK003_408, AK102_354, AK003_399, AK003_419, AK003_429, AK003_434, AK003_440, AK003_486, AK003_487, AK003_462, AK003_542, AK108_344, AK003_557, AK040_304, AK003_567, AK102_445, AK003_568, AK003_582, AK102_458, AK102_460, AK102_461, AK004_022, AK004_023, AK004_040, AK004_032, AK102_487, AK102_488, AK004_135, AK004_180, AK004_181, AK004_196, AK004_199, AK004_200, AK004_201, AK102_552, AK102_554, AK102_557, AK102_561, AK018_013, AK004_231, AK004_240, AK004_251, AK004_272, AK004_273, AK004_278, AK004_284, AK004_263, AK004_286, AK102_577, AK102_579, AK004_308, AK004_301, AK004_295, AK004_300, AK004_296, AK004_299, AK004_323, AK004_352, AK103_057, AK103_058, AK103_064, AK103_066, AK103_067, AK103_068, AK103_076, AK108_362, AK108_363, AK108_367, AK108_368, AK103_093, AK108_371, AK108_372, AK108_373, AK103_136, AK108_376, AK108_374, AK108_375, AK108_377, AK108_381, AK108_383, AK005_062, AK005_063, AK005_065, AK005_069, AK005_070, AK005_072, AK108_385, AK005_128, AK005_174, AK103_267, AK005_175, AK103_266, AK005_190, AK005_191, AK005_193, AK005_194, AK005_202, AK005_216, AK005_258, AK005_262, AK108_386, AK005_273, AK005_303, AK005_304, AK005_308, AK005_309, AK005_316, AK005_317, AK103_383, AK005_482, AK005_539, AK005_543, AK005_544, AK005_521, AK005_522, AK005_546, AK005_545, AK005_568, AK005_567, AK006_017, AK006_027, AK103_544, AK103_545, AK103_550, AK006_063, AK006_075, AK006_097, AK006_085, AK006_100, AK006_117, AK006_134, AK006_130, AK006_119, AK006_126, AK006_129, AK006_135, AK006_157, AK006_159, AK006_160, AK006_178, AK006_183, AK006_191, AK006_236, AK006_248, AK006_246, AK006_247, AK006_238, AK006_239, AK104_129, AK006_314, AK006_321, AK006_322, AK006_341, AK006_344, AK006_345, AK006_348, AK104_185, AK006_444, AK006_454, AK006_470, AK006_466, AK006_481, AK006_474, AK006_476, AK006_511, AK006_515, AK006_518, AK006_523, AK006_561, AK006_547, AK006_562, AK104_301, AK045_288, AK007_076, AK007_078, AK104_370, AK104_380, AK104_385, AK007_150, AK007_155, AK007_188, AK007_221, AK007_224, AK007_219, AK007_223, AK108_425, AK007_227, AK007_230, AK007_233, AK007_234, AK007_235, AK108_428, AK007_240, AK007_257, AK108_446, AK007_319, AK108_454, AK007_320, AK007_327, AK108_461, AK108_474, AK007_339, AK007_344, AK007_343, AK007_342, AK007_345, AK007_353, AK007_362, AK007_363, AK007_356, AK007_360, AK007_365, AK007_366, AK007_367, AK007_373, AK007_396, AK007_383, AK007_397, AK007_399, AK007_402, AK007_479, AK108_516, AK108_517, AK108_520, AK108_529, AK001_556, AK108_533, AK007_533, AK007_550, AK108_582, AK108_574, AK108_592, AK109_007, AK008_088, AK008_089, AK008_090, AK008_095, AK008_124, AK008_142, AK008_145, AK008_146, AK008_149, AK109_037, AK109_056, AK109_061, AK008_185, AK008_186, AK008_190, AK008_194, AK008_198, AK008_200, AK008_201, AK109_075, AK109_102, AK109_106, AK109_107, AK008_440, AK001_566, AK109_166, AK109_167, AK109_170, AK109_180, AK109_183, AK109_184, AK008_461, AK008_463, AK109_188, AK008_559, AK109_226, AK009_013, AK009_001, AK009_007, AK009_030, AK009_036, AK009_054, AK009_069, AK109_258, AK009_117, AK009_118, AK009_138, AK009_176, AK009_154, AK009_160, AK009_178, AK009_185, AK009_187, AK009_188, AK009_189, AK009_202, AK009_205, AK009_206, AK009_226, AK009_190, AK009_249, AK109_320, AK009_242, AK109_327, AK009_247, AK009_248, AK009_250, AK009_257, AK009_274, AK109_347, AK109_348, AK009_268, AK109_345, AK009_301, AK009_276, AK009_277, AK009_278, AK009_280, AK009_310, AK009_316, AK001_570, AK009_344, AK009_363, AK009_364, AK001_571, AK109_439, AK009_467, AK009_472, AK009_468, AK009_466, AK009_505, AK009_516, AK009_535, AK109_498, AK009_583, AK009_584, AK109_511, AK109_523, AK109_525, AK109_526, AK009_604, AK109_528, AK109_530, AK109_531, AK109_532, AK109_535, AK109_536, AK109_541, AK010_101, AK010_098, AK010_099, AK010_094, AK010_095, AK010_097, AK010_109, AK010_130, AK010_132, AK010_134, AK110_017, AK110_031, AK010_141, AK010_142, AK010_145, AK010_180, AK010_179, AK110_057, AK110_062, AK110_076, AK110_080, AK110_085, AK010_258, AK010_263, AK001_199, AK001_073, AK002_303, AK110_144, AK110_141, AK005_298, AK001_283, AK007_228, AK110_226, AK110_250, AK003_565, AK002_436, AK001_088, AK010_421, AK010_451, AK010_568, AK011_001, AK011_018, AK011_049, AK011_051, AK011_056, AK011_045, AK011_077, AK011_087, AK011_070, AK011_084, AK011_096, AK011_132, AK011_133, AK110_384, AK011_181, AK011_183, AK011_209, AK011_250, AK011_272, AK011_406, AK011_407, AK011_430, AK011_563, AK011_561, AK054_472, AK054_491, AK110_526, AK110_527, AK011_579, AK001_065, AK011_598, AK059_185, AK011_361, AK011_355, AK011_356, AK011_362, AK011_393, AK011_307, AK011_308, AK012_001, AK012_055, AK012_070, AK012_082, AK012_085, AK012_086, AK012_090, AK012_098, AK012_102, AK005_074, AK012_129, AK012_139, AK012_140, AK012_153, AK012_146, AK012_147, AK012_156, AK012_159, AK012_160, AK012_161, AK012_173, AK012_367, AK012_371, AK012_405, AK012_374, AK012_375, AK012_401, AK012_402, AK012_425, AK012_474, AK012_528, AK012_521, AK012_522, AK012_524, AK012_529, AK012_544, AK012_533, AK012_556, AK012_585, AK013_012, AK013_019, AK013_020, AK013_022, AK013_023, AK013_028, AK013_036, AK013_039, AK013_058, AK013_071, AK013_075, AK013_164, AK013_183, AK013_235, AK013_258, AK013_259, AK013_333, AK013_334, AK013_344, AK013_389, AK013_413, AK014_056, AK014_062, AK014_073, AK014_111, AK014_112, AK014_120, AK014_123, AK014_130, AK014_150, AK014_221, AK014_210, AK014_230, AK014_320, AK014_302, AK014_301, AK014_304, AK014_332, AK014_331, AK014_333, AK014_352, AK014_368, AK014_373, AK014_399, AK014_429, AK014_431, AK014_432, AK014_433, AK014_447, AK014_480, AK014_481, AK014_482, AK014_483, AK015_015, AK015_017, AK015_028, AK015_127, AK015_140, AK015_178, AK015_169, AK015_180, AK015_182, AK015_219, AK015_283, AK015_244, AK015_287, AK015_288, AK015_301, AK015_302, AK015_303, AK015_295, AK015_333, AK015_334, AK015_356, AK015_367, AK015_432, AK015_434, AK015_435, AK015_425, AK015_446, AK015_469, AK015_472, AK015_473, AK015_503, AK015_506, AK016_073, AK037_100, AK016_118, AK016_125, AK016_126, AK016_128, AK016_130, AK016_132, AK016_164, AK016_176, AK016_201, AK016_178, AK016_179, AK016_180, AK016_182, AK016_211, AK016_275, AK016_281, AK016_282, AK016_286, AK016_309, AK016_310, AK016_330, AK016_368, AK016_365, AK016_369, AK016_370, AK016_393, AK016_382, AK016_403, AK016_404, AK016_405, AK016_414, AK016_436, AK016_492, AK016_497, AK016_527, AK016_530, AK016_531, AK016_532, AK016_533, AK016_536, AK016_562, AK016_563, AK016_578, AK017_002, AK017_003, AK017_021, AK017_022, AK017_001, AK017_007, AK017_016, AK017_017, AK017_018, AK017_027, AK017_024, AK017_065, AK017_066, AK017_068, AK017_069, AK017_073, AK017_079, AK017_087, AK017_090, AK017_091, AK017_110, AK017_100, AK017_113, AK017_114, AK017_115, AK017_128, AK017_168, AK017_229, AK017_230, AK017_252, AK017_236, AK017_237, AK017_238, AK017_239, AK017_240, AK017_242, AK017_244, AK017_248, AK017_264, AK017_265, AK017_322, AK017_323, AK017_320, AK017_321, AK017_347, AK017_369, AK017_393, AK018_014, AK018_015, AK018_010, AK018_088, AK018_097, AK018_155, AK018_178, AK018_179, AK018_167, AK018_175, AK018_176, AK018_177, AK018_180, AK018_188, AK018_193, AK018_194, AK018_255, AK018_256, AK018_298, AK018_297, AK018_449, AK018_450, AK018_436, AK018_445, AK018_464, AK018_465, AK018_480, AK018_481, AK018_482, AK018_483, AK018_484, AK018_485, AK018_544, AK018_545, AK018_546, AK018_547, AK018_549, AK018_550, AK018_552, AK018_553, AK018_554, AK018_551, AK018_561, AK019_010, AK018_592, AK019_038, AK019_041, AK019_042, AK019_043, AK019_044, AK019_046, AK019_107, AK019_109, AK019_110, AK019_179, AK019_180, AK019_181, AK019_182, AK019_183, AK019_256, AK019_257, AK019_258, AK019_247, AK019_248, AK019_252, AK019_255, AK019_262, AK019_263, AK019_264, AK019_269, AK019_274, AK019_277, AK019_279, AK019_280, AK019_281, AK019_293, AK019_295, AK019_296, AK019_297, AK019_302, AK019_303, AK019_276, AK019_328, AK019_346, AK019_362, AK019_397, AK019_399, AK019_401, AK019_406, AK019_418, AK019_436, AK019_441, AK019_455, AK019_457, AK019_461, AK019_474, AK019_478, AK019_481, AK019_483, AK019_485, AK019_487, AK019_492, AK019_496, AK019_537, AK019_539, AK019_541, AK019_542, AK019_561, AK019_563, AK019_582, AK024_454, AK020_040, AK020_041, AK020_124, AK020_130, AK020_170, AK020_179, AK020_180, AK020_181, AK020_189, AK020_198, AK020_236, AK020_338, AK020_448, AK020_454, AK020_455, AK020_494, AK020_498, AK020_509, AK020_496, AK020_546, AK020_549, AK021_002, AK021_060, AK021_061, AK021_129, AK021_276, AK021_390, AK021_393, AK021_397, AK021_398, AK021_403, AK021_490, AK021_450, AK021_476, AK021_495, AK021_520, AK021_538, AK021_536, AK021_579, AK021_582, AK022_071, AK022_079, AK022_081, AK022_077, AK022_080, AK022_082, AK022_116, AK022_189, AK022_191, AK022_187, AK022_190, AK022_193, AK022_192, AK022_194, AK022_195, AK022_196, AK022_197, AK022_199, AK022_200, AK022_201, AK022_202, AK022_204, AK022_198, AK022_205, AK022_213, AK022_216, AK022_217, AK022_221, AK022_222, AK022_224, AK022_232, AK022_252, AK022_264, AK022_314, AK022_452, AK022_473, AK022_476, AK022_477, AK022_547, AK022_569, AK023_005, AK023_105, AK023_114, AK023_115, AK023_111, AK023_131, AK023_136, AK023_145, AK023_188, AK023_193, AK023_187, AK023_233, AK023_251, AK023_252, AK023_254, AK023_257, AK023_277, AK023_280, AK051_311, AK023_306, AK023_307, AK023_308, AK052_559, AK052_577, AK023_415, AK023_416, AK023_420, AK023_421, AK023_429, AK023_441, AK023_453, AK023_454, AK023_446, AK023_488, AK023_504, AK023_522, AK023_511, AK052_436, AK063_425, AK063_426, AK052_122, AK053_076, AK063_472, AK053_164, AK063_496, AK063_497, AK024_037, AK024_058, AK063_522, AK024_065, AK053_433, AK054_132, AK024_248, AK024_250, AK024_256, AK024_285, AK024_311, AK024_312, AK024_313, AK024_332, AK024_337, AK024_366, AK024_379, AK063_566, AK054_355, AK024_381, AK024_433, AK055_096, AK024_443, AK024_447, AK024_450, AK055_086, AK024_445, AK024_446, AK024_448, AK024_449, AK024_451, AK024_452, AK024_453, AK024_455, AK024_456, AK024_457, AK024_459, AK024_465, AK025_009, AK025_041, AK025_046, AK025_048, AK025_073, AK055_565, AK025_092, AK025_111, AK025_128, AK025_132, AK025_137, AK025_134, AK025_139, AK025_140, AK025_141, AK025_142, AK025_143, AK025_148, AK025_149, AK025_153, AK025_155, AK025_156, AK025_178, AK025_198, AK025_207, AK025_205, AK025_206, AK025_213, AK025_230, AK025_240, AK025_241, AK025_242, AK025_251, AK025_266, AK056_371, AK056_421, AK025_325, AK025_334, AK025_340, AK025_341, AK025_343, AK025_358, AK025_362, AK025_385, AK025_402, AK025_403, AK025_412, AK025_427, AK025_483, AK025_466, AK025_474, AK025_533, AK025_501, AK025_593, AK026_001, AK025_561, AK025_587, AK025_588, AK026_005, AK026_042, AK026_053, AK026_113, AK026_098, AK026_097, AK026_112, AK026_116, AK026_119, AK026_123, AK026_155, AK026_156, AK026_154, AK026_161, AK026_259, AK026_332, AK026_381, AK026_484, AK059_329, AK059_346, AK026_493, AK026_494, AK026_496, AK026_497, AK059_420, AK059_434, AK059_441, AK059_442, AK059_468, AK026_572, AK027_043, AK027_118, AK027_173, AK027_184, AK027_188, AK027_208, AK027_217, AK064_009, AK027_301, AK060_403, AK027_300, AK027_314, AK064_168, AK064_072, AK027_335, AK027_346, AK027_350, AK027_380, AK027_389, AK027_415, AK064_222, AK027_458, AK027_459, AK027_460, AK027_476, AK027_469, AK027_471, AK027_472, AK027_473, AK028_029, AK028_040, AK028_043, AK028_044, AK028_062, AK028_093, AK028_077, AK028_080, AK028_100, AK028_104, AK028_117, AK028_126, AK028_187, AK028_188, AK028_179, AK028_180, AK028_184, AK028_189, AK028_198, AK028_199, AK028_216, AK028_268, AK028_269, AK062_168, AK062_170, AK028_284, AK028_288, AK028_318, AK028_295, AK028_321, AK028_294, AK028_319, AK028_322, AK028_336, AK028_356, AK028_362, AK028_357, AK028_358, AK028_361, AK028_373, AK028_374, AK028_376, AK028_385, AK028_386, AK028_382, AK028_383, AK028_384, AK028_391, AK028_393, AK028_397, AK028_409, AK028_444, AK028_449, AK028_455, AK028_464, AK028_478, AK028_479, AK028_482, AK028_485, AK028_486, AK028_487, AK028_494, AK064_234, AK028_515, AK028_526, AK064_240, AK064_246, AK028_543, AK028_559, AK029_005, AK028_592, AK063_230, AK029_009, AK029_044, AK029_041, AK029_043, AK029_045, AK029_067, AK029_083, AK029_069, AK029_073, AK029_080, AK029_084, AK029_088, AK029_089, AK029_102, AK029_114, AK029_123, AK029_133, AK029_139, AK029_140, AK029_141, AK029_142, AK029_143, AK029_144, AK029_155, AK029_157, AK029_159, AK029_160, AK029_185, AK029_186, AK029_202, AK029_180, AK029_210, AK029_206, AK029_203, AK029_208, AK029_209, AK029_214, AK029_218, AK029_205, AK029_228, AK029_233, AK029_260, AK029_237, AK029_238, AK029_239, AK029_240, AK029_241, AK029_245, AK029_330, AK029_354, AK029_371, AK029_378, AK029_397, AK030_014, AK030_012, AK030_041, AK030_060, AK030_063, AK030_210, AK030_223, AK030_226, AK030_255, AK030_245, AK030_283, AK067_095, AK030_299, AK030_302, AK030_305, AK030_320, AK030_321, AK030_323, AK030_322, AK030_325, AK030_340, AK030_342, AK030_352, AK030_357, AK030_360, AK030_361, AK030_356, AK030_372, AK030_367, AK030_368, AK030_376, AK030_408, AK030_409, AK030_455, AK030_468, AK030_471, AK030_482, AK030_533, AK030_540, AK030_541, AK030_542, AK030_575, AK030_581, AK030_586, AK030_587, AK016_181, AK031_168, AK031_185, AK031_216, AK031_217, AK031_234, AK031_240, AK031_325, AK031_321, AK031_323, AK031_324, AK031_361, AK031_366, AK031_372, AK031_360, AK031_365, AK031_402, AK031_404, AK032_011, AK032_015, AK032_067, AK032_073, AK032_089, AK032_090, AK032_128, AK032_129, AK032_164, AK032_165, AK032_166, AK032_167, AK032_180, AK032_181, AK032_291, AK032_282, AK032_364, AK032_584, AK032_461, AK032_500, AK050_560, AK033_019, AK033_020, AK033_068, AK033_069, AK077_384, AK033_227, AK033_228, AK033_235, AK033_251, AK033_258, AK033_278, AK033_385, AK033_404, AK033_429, AK033_430, AK033_432, AK033_433, AK033_516, AK033_525, AK033_574, AK033_587, AK033_591, AK034_007, AK034_066, AK034_080, AK034_135, AK034_136, AK034_142, AK034_159, AK034_160, AK034_163, AK034_174, AK034_181, AK034_193, AK034_218, AK034_239, AK034_271, AK034_273, AK034_274, AK034_275, AK034_277, AK034_278, AK034_279, AK034_280, AK034_283, AK034_284, AK034_285, AK034_287, AK034_288, AK034_289, AK034_292, AK034_293, AK034_286, AK034_290, AK034_291, AK034_300, AK034_301, AK034_302, AK034_338, AK034_340, AK034_337, AK034_345, AK034_347, AK034_350, AK034_373, AK034_372, AK034_439, AK034_452, AK034_468, AK034_476, AK035_010, AK034_580, AK035_017, AK035_039, AK035_044, AK035_082, AK035_089, AK035_086, AK035_109, AK035_132, AK035_151, AK035_134, AK035_142, AK035_150, AK035_159, AK035_147, AK035_149, AK035_158, AK035_169, AK035_170, AK035_179, AK035_180, AK035_181, AK035_330, AK035_377, AK035_380, AK035_393, AK035_413, AK035_411, AK035_422, AK035_423, AK035_424, AK035_434, AK035_445, AK035_449, AK035_463, AK035_469, AK035_471, AK035_483, AK035_487, AK035_495, AK035_509, AK035_514, AK035_563, AK035_567, AK035_600, AK036_079, AK036_075, AK036_084, AK036_087, AK036_104, AK036_129, AK036_131, AK036_132, AK036_153, AK036_272, AK036_276, AK036_274, AK036_273, AK036_277, AK036_303, AK036_308, AK036_305, AK036_381, AK036_405, AK036_406, AK036_418, AK036_427, AK036_438, AK036_440, AK036_556, AK036_557, AK036_559, AK036_560, AK036_601, AK036_602, AK037_006, AK037_004, AK037_008, AK037_025, AK037_032, AK037_033, AK037_031, AK037_035, AK037_114, AK037_134, AK037_249, AK037_246, AK037_251, AK037_256, AK037_278, AK037_306, AK037_305, AK037_309, AK037_313, AK037_340, AK037_351, AK037_359, AK037_371, AK037_375, AK037_376, AK037_392, AK037_442, AK037_443, AK037_416, AK037_491, AK037_490, AK037_493, AK037_510, AK037_504, AK037_533, AK037_517, AK037_527, AK037_534, AK037_549, AK037_550, AK037_557, AK037_564, AK038_088, AK038_101, AK038_102, AK038_103, AK038_106, AK038_137, AK038_483, AK038_325, AK038_416, AK038_420, AK038_427, AK038_428, AK038_431, AK038_436, AK038_575, AK039_004, AK039_020, AK039_044, AK039_045, AK039_058, AK039_061, AK039_035, AK039_074, AK039_087, AK039_094, AK039_114, AK039_125, AK039_131, AK039_133, AK039_135, AK039_152, AK039_134, AK039_162, AK039_161, AK039_167, AK039_213, AK039_211, AK039_205, AK039_244, AK039_242, AK039_251, AK035_100, AK033_405, AK036_437, AK039_306, AK039_390, AK039_381, AK039_383, AK039_384, AK039_385, AK039_414, AK039_423, AK039_478, AK039_477, AK039_483, AK039_526, AK040_049, AK040_083, AK040_085, AK040_134, AK040_147, AK040_225, AK040_222, AK040_232, AK040_238, AK040_244, AK040_264, AK040_255, AK040_271, AK040_288, AK040_286, AK040_290, AK040_303, AK040_391, AK040_399, AK040_489, AK040_499, AK040_508, AK040_509, AK040_494, AK040_511, AK040_505, AK040_502, AK040_528, AK040_543, AK040_542, AK040_575, AK041_033, AK041_032, AK041_036, AK041_136, AK041_138, AK041_139, AK041_140, AK041_212, AK041_213, AK041_382, AK041_423, AK041_427, AK041_428, AK041_442, AK041_447, AK041_448, AK041_450, AK041_492, AK041_560, AK041_563, AK041_556, AK041_564, AK041_581, AK042_008, AK041_592, AK041_595, AK042_036, AK042_047, AK042_069, AK042_085, AK042_154, AK042_268, AK042_296, AK042_365, AK042_377, AK042_361, AK042_410, AK042_413, AK042_435, AK042_436, AK042_455, AK042_460, AK042_493, AK042_485, AK091_178, AK091_179, AK042_517, AK042_525, AK042_526, AK042_531, AK043_055, AK043_057, AK043_091, AK043_092, AK043_120, AK110_028, AK043_247, AK043_292, AK043_313, AK043_311, AK043_330, AK043_332, AK043_333, AK043_335, AK043_425, AK043_482, AK043_484, AK043_485, AK043_498, AK043_497, AK043_494, AK043_495, AK043_502, AK043_505, AK043_506, AK049_146, AK043_519, AK043_562, AK043_568, AK043_569, AK043_570, AK044_003, AK044_004, AK044_052, AK044_046, AK044_080, AK044_500, AK044_154, AK044_173, AK044_188, AK044_208, AK044_211, AK044_212, AK044_229, AK044_230, AK044_231, AK044_232, AK044_260, AK044_275, AK044_276, AK044_290, AK044_293, AK044_294, AK044_327, AK044_341, AK044_337, AK044_359, AK044_377, AK044_386, AK044_391, AK044_397, AK044_420, AK044_432, AK044_441, AK044_443, AK044_444, AK044_457, AK044_464, AK044_465, AK044_506, AK044_516, AK044_485, AK044_513, AK044_497, AK044_510, AK044_494, AK044_502, AK044_511, AK045_025, AK045_024, AK045_001, AK045_087, AK045_121, AK045_153, AK045_170, AK060_493, AK045_184, AK045_189, AK045_305, AK045_306, AK045_311, AK045_313, AK045_363, AK045_365, AK045_398, AK045_401, AK045_404, AK045_430, AK045_436, AK045_424, AK116_573, AK045_431, AK045_434, AK045_437, AK045_449, AK045_450, AK117_084, AK045_515, AK045_516, AK045_517, AK045_519, AK045_542, AK045_541, AK045_544, AK045_559, AK045_561, AK045_562, AK045_601, AK046_175, AK118_257, AK046_209, AK046_220, AK046_202, AK046_222, AK046_233, AK046_234, AK046_236, AK046_237, AK046_253, AK046_256, AK046_259, AK046_260, AK046_268, AK046_310, AK046_308, AK046_309, AK046_577, AK047_010, AK047_040, AK047_060, AK047_149, AK047_150, AK047_158, AK047_163, AK047_292, AK047_316, AK047_368, AK047_369, AK047_371, AK047_434, AK047_510, AK047_521, AK047_509, AK047_552, AK047_544, AK047_559, AK047_571, AK048_510, AK048_028, AK048_030, AK048_038, AK048_066, AK048_075, AK048_147, AK048_156, AK048_150, AK048_138, AK048_146, AK048_148, AK048_153, AK048_155, AK048_157, AK048_167, AK048_168, AK048_182, AK048_175, AK048_178, AK048_179, AK048_183, AK063_397, AK048_221, AK048_287, AK048_305, AK048_397, AK048_482, AK048_480, AK048_463, AK049_117, AK049_118, AK049_135, AK049_130, AK049_138, AK003_324, AK006_149, AK007_471, AK009_008, AK012_439, AK049_148, AK049_200, AK049_154, AK049_155, AK049_187, AK016_284, AK018_195, AK019_011, AK020_043, AK021_453, AK024_408, AK027_289, AK027_354, AK027_358, AK032_342, AK035_376, AK041_199, AK041_567, AK041_449, AK042_329, AK052_507, AK052_516, AK064_247, AK064_249, AK064_250, AK064_261, AK064_268, AK064_280, AK064_258, AK064_260, AK065_116, AK054_140, AK067_472, AK004_281, AK006_061, AK006_279, AK014_071, AK049_373, AK049_372, AK049_371, AK049_369, AK049_370, AK049_376, AK049_377, AK049_379, AK049_512, AK014_418, AK016_200, AK017_169, AK017_170, AK018_427, AK018_444, AK018_448, AK019_005, AK019_040, AK019_008, AK019_037, AK019_039, AK019_367, AK020_432, AK022_086, AK021_448, AK024_501, AK026_107, AK026_108, AK027_369, AK028_115, AK028_398, AK028_401, AK028_404, AK004_400, AK009_110, AK010_112, AK030_309, AK031_166, AK031_287, AK034_342, AK034_147, AK034_346, AK034_344, AK034_343, AK038_121, AK039_053, AK039_173, AK039_398, AK033_480, AK042_046, AK044_503, AK045_472, AK034_222, AK050_121, AK050_133, AK050_113, AK050_147, AK050_123, AK050_115, AK050_134, AK050_140, AK050_184, AK050_190, AK050_191, AK050_189, AK050_254, AK052_501, AK050_270, AK050_271, AK052_572, AK052_573, AK050_276, AK050_293, AK050_297, AK050_296, AK050_300, AK050_301, AK050_303, AK050_319, AK050_329, AK050_336, AK052_413, AK044_101, AK044_107, AK044_108, AK044_117, AK044_099, AK052_418, AK052_440, AK044_120, AK052_494, AK052_490, AK052_495, AK044_128, AK044_144, AK064_336, AK062_137, AK064_399, AK064_401, AK064_524, AK064_560, AK055_530, AK057_096, AK058_332, AK065_119, AK065_122, AK059_075, AK060_243, AK062_177, AK063_097, AK050_416, AK050_436, AK050_437, AK050_424, AK050_428, AK050_440, AK099_375, AK050_445, AK050_443, AK110_103, AK001_067, AK050_488, AK050_489, AK050_490, AK050_491, AK050_494, AK050_496, AK050_472, AK050_471, AK050_574, AK051_023, AK051_022, AK051_024, AK051_042, AK051_043, AK051_044, AK051_045, AK051_057, AK051_087, AK051_110, AK051_102, AK051_109, AK051_136, AK051_215, AK051_219, AK051_220, AK051_227, AK051_236, AK051_286, AK051_273, AK051_270, AK051_300, AK052_514, AK052_007, AK052_563, AK052_039, AK068_470, AK052_144, AK052_111, AK052_132, AK052_125, AK052_143, AK052_147, AK052_148, AK052_150, AK052_230, AK052_228, AK052_233, AK052_309, AK052_315, AK052_357, AK052_358, AK052_414, AK052_396, AK052_397, AK052_379, AK052_422, AK052_423, AK052_424, AK052_443, AK052_439, AK052_489, AK053_171, AK053_173, AK053_193, AK053_196, AK053_236, AK053_280, AK053_281, AK053_318, AK053_354, AK053_355, AK053_356, AK053_428, AK054_162, AK054_357, AK054_361, AK054_362, AK054_363, AK054_364, AK054_365, AK054_366, AK054_367, AK054_368, AK054_369, AK054_370, AK054_371, AK054_372, AK054_359, AK054_360, AK054_411, AK054_438, AK054_451, AK054_388, AK054_468, AK054_473, AK054_474, AK054_476, AK054_477, AK054_478, AK054_479, AK054_484, AK054_489, AK054_558, AK054_559, AK054_560, AK054_561, AK054_553, AK054_551, AK054_566, AK054_577, AK054_581, AK054_590, AK054_591, AK055_087, AK055_088, AK055_089, AK055_090, AK055_091, AK055_092, AK055_095, AK055_099, AK055_101, AK055_108, AK055_111, AK055_114, AK055_115, AK055_116, AK055_117, AK055_184, AK055_348, AK055_359, AK055_375, AK055_376, AK055_377, AK055_378, AK055_357, AK055_403, AK055_476, AK055_478, AK055_519, AK055_531, AK055_532, AK056_113, AK056_121, AK056_131, AK056_130, AK056_204, AK056_206, AK056_320, AK056_397, AK056_535, AK057_094, AK057_214, AK057_290, AK057_291, AK057_292, AK057_309, AK057_310, AK057_348, AK057_350, AK057_355, AK057_390, AK057_435, AK057_439, AK057_452, AK057_476, AK057_484, AK057_485, AK057_497, AK057_560, AK057_579, AK057_576, AK057_591, AK058_094, AK058_099, AK058_116, AK058_145, AK058_146, AK058_161, AK058_160, AK058_309, AK058_320, AK058_321, AK058_408, AK058_419, AK058_455, AK058_457, AK058_483, AK058_489, AK058_537, AK058_541, AK058_546, AK058_549, AK059_005, AK059_021, AK059_027, AK059_062, AK059_067, AK059_091, AK059_115, AK059_141, AK059_175, AK059_187, AK059_189, AK059_207, AK059_208, AK059_221, AK059_228, AK059_231, AK059_232, AK059_238, AK059_257, AK059_259, AK059_269, AK059_270, AK059_278, AK059_279, AK059_282, AK059_287, AK059_298, AK059_306, AK059_308, AK059_309, AK059_318, AK059_323, AK059_330, AK059_357, AK059_369, AK059_387, AK059_388, AK059_389, AK059_395, AK059_390, AK059_396, AK059_416, AK059_418, AK059_419, AK059_421, AK059_422, AK059_428, AK059_432, AK059_433, AK059_479, AK059_435, AK059_437, AK059_440, AK059_444, AK059_445, AK059_446, AK059_450, AK059_474, AK059_475, AK059_476, AK059_477, AK059_478, AK059_480, AK059_482, AK059_484, AK059_485, AK059_503, AK059_504, AK059_514, AK059_519, AK059_522, AK059_528, AK059_520, AK059_543, AK059_544, AK059_565, AK059_534, AK060_005, AK060_039, AK060_040, AK060_044, AK060_051, AK060_108, AK060_056, AK060_125, AK103_385, AK060_137, AK060_238, AK060_240, AK060_306, AK060_321, AK060_322, AK060_451, AK060_476, AK060_486, AK060_499, AK060_531, AK060_546, AK060_581, AK061_004, AK061_021, AK061_022, AK061_039, AK061_080, AK061_089, AK061_120, AK061_115, AK061_116, AK061_117, AK061_126, AK061_127, AK061_150, AK061_169, AK061_170, AK061_171, AK061_173, AK061_174, AK061_175, AK061_172, AK061_210, AK061_212, AK061_253, AK061_280, AK061_252, AK061_323, AK061_305, AK061_363, AK061_404, AK061_414, AK061_437, AK061_459, AK061_492, AK061_493, AK061_494, AK061_495, AK062_037, AK062_038, AK062_043, AK062_044, AK062_147, AK062_148, AK062_131, AK063_012, AK062_204, AK062_220, AK062_223, AK062_226, AK062_224, AK062_252, AK062_302, AK062_322, AK062_326, AK062_327, AK062_386, AK062_466, AK062_467, AK062_431, AK062_541, AK062_570, AK106_416, AK063_036, AK063_029, AK063_087, AK063_138, AK063_153, AK063_157, AK063_213, AK063_214, AK063_221, AK063_235, AK063_237, AK063_238, AK063_239, AK063_265, AK063_262, AK063_264, AK063_204, AK063_341, AK063_342, AK063_357, AK063_335, AK063_378, AK063_379, AK063_383, AK063_399, AK063_386, AK063_420, AK063_439, AK063_484, AK063_490, AK063_494, AK063_495, AK063_488, AK063_493, AK063_498, AK063_499, AK063_564, AK063_531, AK063_557, AK064_005, AK064_030, AK064_031, AK064_037, AK064_045, AK093_280, AK064_063, AK064_041, AK064_043, AK064_102, AK064_092, AK064_093, AK064_202, AK064_303, AK064_304, AK064_388, AK064_310, AK064_311, AK064_295, AK064_382, AK064_397, AK064_402, AK064_403, AK064_406, AK064_438, AK064_453, AK064_454, AK064_513, AK064_497, AK064_503, AK064_546, AK064_566, AK065_114, AK065_002, AK065_017, AK065_019, AK065_307, AK065_316, AK065_339, AK065_361, AK065_335, AK065_450, AK065_597, AK065_598, AK066_002, AK066_008, AK066_010, AK066_032, AK066_056, AK066_089, AK066_098, AK066_100, AK066_104, AK066_140, AK066_149, AK066_193, AK066_226, AK066_289, AK066_388, AK066_395, AK066_459, AK066_534, AK066_520, AK066_563, AK066_572, AK067_022, AK066_577, AK066_556, AK067_062, AK067_302, AK067_312, AK067_347, AK067_446, AK067_514, AK067_488, AK067_489, AK067_497, AK067_519, AK067_520, AK067_546, AK067_589, AK068_009, AK068_012, AK068_021, AK068_011, AK068_089, AK068_136, AK068_115, AK068_141, AK068_240, AK068_242, AK068_259, AK068_260, AK068_301, AK068_294, AK068_316, AK068_323, AK068_393, AK068_356, AK068_453, AK068_403, AK068_494, AK068_505, AK068_532, AK068_559, AK068_565, AK068_566, AK068_567, AK068_568, AK068_569, AK069_044, AK069_046, AK069_047, AK069_013, AK069_020, AK069_069, AK069_154, AK069_300, AK069_354, AK069_356, AK069_380, AK069_404, AK069_405, AK069_407, AK069_558, AK070_002, AK070_003, AK070_004, AK070_020, AK070_035, AK070_037, AK070_054, AK070_144, AK070_133, AK070_244, AK070_235, AK112_016, AK070_363, AK070_366, AK070_382, AK070_383, AK070_384, AK070_417, AK070_422, AK070_457, AK070_458, AK070_460, AK070_484, AK070_503, AK070_506, AK070_564, AK070_586, AK071_074, AK071_140, AK071_167, AK071_229, AK071_285, AK071_295, AK071_298, AK071_324, AK071_328, AK071_329, AK071_327, AK071_334, AK114_259, AK071_357, AK071_414, AK071_467, AK071_477, AK071_479, AK071_474, AK071_513, AK071_544, AK071_565, AK071_599, AK072_027, AK072_008, AK072_051, AK072_070, AK072_075, AK072_098, AK072_105, AK072_110, AK072_111, AK072_153, AK072_205, AK072_314, AK072_523, AK073_425, AK074_026, AK075_337, AK075_350, AK075_456, AK075_458, AK076_461, AK077_475, AK077_477, AK077_476, AK077_489, AK078_100, AK078_106, AK078_111, AK078_113, AK078_409, AK079_262, AK079_265, AK079_362, AK079_370, AK081_045, AK081_077, AK081_234, AK081_316, AK081_596, AK082_008, AK082_119, AK083_089, AK083_301, AK083_320, AK083_326, AK083_448, AK083_517, AK083_578, AK084_202, AK085_028, AK085_385, AK085_447, AK085_450, AK086_200, AK086_193, AK086_356, AK086_599, AK087_147, AK087_151, AK087_525, AK088_031, AK088_269, AK088_257, AK088_265, AK088_266, AK088_581, AK089_314, AK089_320, AK089_500, AK100_510, AK090_245, AK090_496, AK090_495, AK090_564, AK090_565, AK090_569, AK115_155, AK091_067, AK091_091, AK091_094, AK091_168, AK091_117, AK091_560, AK092_017, AK092_022, AK092_530, AK093_205, AK093_209, AK093_232, AK093_253, AK093_266, AK093_267, AK093_353, AK093_357, AK093_362, AK094_223, AK094_460, AK095_122, AK095_292, AK095_295, AK095_454, AK097_366, AK096_484, AK096_504, AK096_505, AK096_511, AK096_520, AK096_521, AK097_138, AK097_139, AK097_175, AK097_140, AK097_160, AK097_154, AK097_156, AK097_204, AK097_193, AK097_191, AK097_364, AK097_365, AK097_367, AK097_370, AK097_373, AK097_375, AK098_024, AK098_029, AK098_159, AK098_395, AK098_420, AK098_432, AK098_600, AK098_601, AK099_181, AK100_038, AK100_376, AK100_377, AK100_443, AK100_444, AK100_502, AK100_503, AK100_505, AK125_084, AK101_238, AK101_239, AK101_309, AK101_400, AK101_602, AK102_060, AK102_450, AK103_012, AK103_386, AK106_247, AK106_192, AK106_414, AK106_421, AK107_006, AK107_102, AK107_559, AK108_054, AK108_313, AK108_314, AK108_361, AK108_420, AK108_552, AK109_085, AK109_190, AK109_204, AK109_317, AK110_027, AK110_032, AK110_030, AK110_174, AK112_271, AK112_306, AK114_021, AK114_022, AK114_604, AK116_196, AK116_358, AK117_115, AK117_557, AK117_554, AK117_558, AK117_600, AK121_124, AK122_142, AK122_346, AK123_045, AK123_046, AK064_601, AK069_426, AK066_092, AK066_166, AK066_224, AK066_228, AK066_272, AK066_276, AK066_285, AK066_292, AK084_248, AK066_349, AK097_358, AK066_393, AK066_296, AK066_306, AK066_446, AK066_571, AK067_002, AK066_539, AK066_540, AK067_063, AK067_086, AK067_077, AK067_183, AK067_186, AK079_483, AK070_254, AK086_285, AK090_033, AK093_361, AK110_147, AK067_422, AK067_417, AK067_445, AK067_539, AK068_069, AK068_083, AK068_091, AK068_129, AK068_132, AK068_149, AK068_248, AK098_396, AK063_412, AK063_523, AK064_027, AK038_574, AK038_596, AK039_170, AK039_175, AK041_263, AK041_269, AK064_263, AK049_368, AK049_570, AK049_571, AK050_149, AK050_192, AK050_475, AK050_587, AK051_326, AK052_227, AK052_146, AK052_237, AK052_354, AK052_435, AK052_361, AK052_305, AK053_485, AK054_054, AK054_055, AK054_056, AK054_059, AK054_064, AK054_066, AK054_072, AK054_073, AK054_106, AK054_123, AK054_138, AK054_253, AK054_304, AK054_305, AK054_306, AK054_307, AK054_309, AK054_310, AK054_326, AK054_327, AK054_485, AK054_486, AK054_487, AK054_469, AK055_097, AK054_570, AK054_571, AK054_597, AK055_123, AK055_217, AK055_223, AK055_248, AK055_247, AK055_370, AK055_371, AK056_084, AK056_418, AK057_095, AK057_587, AK057_589, AK058_303, AK058_306, AK058_417, AK058_420, AK059_066, AK059_069, AK059_073, AK059_092, AK059_120, AK059_155, AK059_156, AK059_302, AK059_402, AK059_463, AK059_561, AK059_570, AK060_092, AK060_093, AK060_095, AK059_513, AK060_104, AK059_536, AK060_113, AK060_135, AK060_143, AK060_281, AK060_436, AK060_460, AK060_477, AK060_478, AK061_054, AK061_119, AK061_131, AK061_314, AK061_422, AK061_423, AK062_040, AK062_041, AK062_042, AK062_053, AK062_141, AK062_173, AK062_411, AK063_227, AK063_236, AK065_340, AK068_461, AK068_491, AK068_577, AK068_578, AK069_196, AK069_544, AK070_164, AK070_449, AK071_046, AK070_498, AK071_002, AK071_217, AK071_227, AK071_581, AK071_596, AK072_081, AK072_154, AK075_598, AK076_442, AK077_050, AK077_253, AK078_442, AK079_005, AK079_018, AK082_006, AK084_300, AK083_465, AK088_589, AK090_423, AK091_462, AK091_575, AK092_479, AK094_215, AK094_440, AK095_291, AK094_492, AK097_339, AK097_368, AK097_369, AK097_371, AK097_374, AK102_180, AK099_143, AK098_531, AK099_157, AK099_177, AK099_299, AK103_063, AK107_553, AK107_459, AK107_554, AK108_138, AK115_137, AK115_138, AK070_078, AK066_053, AK066_394, AK067_078, AK067_255, AK067_305, AK067_526, AK067_545, AK068_087, AK068_422, AK068_429, AK068_476, AK068_542, AK068_557, AK068_558, AK068_572, AK068_591, AK068_592, AK068_593, AK069_033, AK069_145, AK069_146, AK069_147, AK069_148, AK069_156, AK069_172, AK069_173, AK069_174, AK069_190, AK069_261, AK069_396, AK069_536, AK069_569, AK070_253, AK070_345, AK070_361, AK063_076, AK009_372, AK009_356, AK009_357, AK070_385, AK070_400, AK070_425, AK070_459, AK070_499, AK071_050, AK071_060, AK071_081, AK071_160, AK071_196, AK071_198, AK071_251, AK071_331, AK071_294, AK071_296, AK071_297, AK071_301, AK071_303, AK071_304, AK071_305, AK071_306, AK071_307, AK071_308, AK071_309, AK071_325, AK071_326, AK071_419, AK071_583, AK071_584, AK001_587, AK024_380, AK059_469, AK028_271, AK028_272, AK049_124, AK049_199, AK051_600, AK051_237, AK052_515, AK057_393, AK058_142, AK058_400, AK059_451, AK059_473, AK060_421, AK086_125, AK100_557, AK101_005, AK102_061, AK107_004, AK066_012, AK054_075, AK055_155, AK055_242, AK063_034, AK052_306, AK058_443, AK090_427, AK091_323, AK093_432, AK095_101, AK109_041, AK115_178, AK071_061, AK071_231, AK072_178, AK072_216, AK072_217, AK072_220, AK072_231, AK072_263, AK072_272, AK072_271, AK072_294, AK072_331, AK072_357, AK072_377, AK072_393, AK072_394, AK072_456, AK073_460, AK072_507, AK072_511, AK072_531, AK072_532, AK072_548, AK072_554, AK072_558, AK072_560, AK072_579, AK073_461, AK073_173, AK073_459, AK073_387, AK073_503'"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"', '.join(mountains['akon_id'])"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 User Default",
"language": "python",
"name": "python_3_user_default"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
}
},
"nbformat": 4,
"nbformat_minor": 2
}