pax_global_header 0000666 0000000 0000000 00000000064 13502401465 0014512 g ustar 00root root 0000000 0000000 52 comment=b732b0092a00f00335593ba6a77916e479a9e075
akon-experiments-b732b0092a00f00335593ba6a77916e479a9e075/ 0000775 0000000 0000000 00000000000 13502401465 0021416 5 ustar 00root root 0000000 0000000 akon-experiments-b732b0092a00f00335593ba6a77916e479a9e075/AKON Data Overview.ipynb 0000664 0000000 0000000 00000170376 13502401465 0025650 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": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/kst/tmp/dingsdi/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
}
],
"source": [
"df = pd.read_csv('https://labs.onb.ac.at/gitlab/labs-team/raw-metadata/raw/master/akon_postcards_public_domain.csv.bz2', compression='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": [
"34846"
]
},
"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",
" geoname_id | \n",
" latitude | \n",
" longitude | \n",
" name | \n",
" country_id | \n",
" admin_name_1 | \n",
" admin_code_1 | \n",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" AK111_021 | \n",
" 74682 | \n",
" NaN | \n",
" NaN | \n",
" Kiel, Blücherplatz | \n",
" False | \n",
" 1921 gel | \n",
" NaN | \n",
" NaN | \n",
" ... | \n",
" 2891122.0 | \n",
" 54.32133 | \n",
" 10.13489 | \n",
" Kiel | \n",
" DE | \n",
" NaN | \n",
" NaN | \n",
" 54.32133, 10.13489 | \n",
" https://iiif.onb.ac.at/images/AKON/AK111_021/0... | \n",
" https://iiif.onb.ac.at/images/AKON/AK111_021/0... | \n",
"
\n",
" \n",
"
\n",
"
1 rows × 32 columns
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city color \\\n",
"0 0 AK111_021 74682 NaN NaN Kiel, Blücherplatz False \n",
"\n",
" comment mountain other ... geoname_id latitude longitude name \\\n",
"0 1921 gel NaN NaN ... 2891122.0 54.32133 10.13489 Kiel \n",
"\n",
" country_id admin_name_1 admin_code_1 geo \\\n",
"0 DE NaN NaN 54.32133, 10.13489 \n",
"\n",
" download_link \\\n",
"0 https://iiif.onb.ac.at/images/AKON/AK111_021/0... \n",
"\n",
" download_link_256x256 \n",
"0 https://iiif.onb.ac.at/images/AKON/AK111_021/0... \n",
"\n",
"[1 rows x 32 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",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0 | \n",
" AK111_021 | \n",
" 74682 | \n",
" NaN | \n",
" NaN | \n",
" Kiel, Blücherplatz | \n",
" False | \n",
" 1921 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Geogr. Topogr. Bilder-Samml. 1943, 7735 | \n",
" 2014-09-05 10:13:06.342 | \n",
" gelaufen 1921 | \n",
" P | \n",
" PPLA | \n",
" 2891122.0 | \n",
" 54.32133 | \n",
" 10.13489 | \n",
" Kiel | \n",
" DE | \n",
" NaN | \n",
" NaN | \n",
" 54.32133, 10.13489 | \n",
" https://iiif.onb.ac.at/images/AKON/AK111_021/0... | \n",
" https://iiif.onb.ac.at/images/AKON/AK111_021/0... | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city color \\\n",
"0 0 AK111_021 74682 NaN NaN Kiel, Blücherplatz False \n",
"\n",
" comment mountain other photographer publisher publisher_place region \\\n",
"0 1921 gel NaN NaN NaN NaN NaN NaN \n",
"\n",
" water_body year inventory_number signature \\\n",
"0 NaN NaN NaN Geogr. Topogr. Bilder-Samml. 1943, 7735 \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"0 2014-09-05 10:13:06.342 gelaufen 1921 P PPLA \n",
"\n",
" geoname_id latitude longitude name country_id admin_name_1 admin_code_1 \\\n",
"0 2891122.0 54.32133 10.13489 Kiel DE NaN NaN \n",
"\n",
" geo download_link \\\n",
"0 54.32133, 10.13489 https://iiif.onb.ac.at/images/AKON/AK111_021/0... \n",
"\n",
" download_link_256x256 \n",
"0 https://iiif.onb.ac.at/images/AKON/AK111_021/0... "
]
},
"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', 'geo', 'download_link',\n",
" 'download_link_256x256'],\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": 8,
"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",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 28908 | \n",
" 28908 | \n",
" AK066_086 | \n",
" 40120 | \n",
" NaN | \n",
" NaN | \n",
" Innsbruck, Maria Theresienstrasse | \n",
" False | \n",
" 1907 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Gratl | \n",
" Innsbruck | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.424 | \n",
" vor 1907 | \n",
" P | \n",
" PPLA | \n",
" 2775220.0 | \n",
" 47.26266 | \n",
" 11.39454 | \n",
" Innsbruck | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.26266, 11.39454 | \n",
" https://iiif.onb.ac.at/images/AKON/AK066_086/0... | \n",
" https://iiif.onb.ac.at/images/AKON/AK066_086/0... | \n",
"
\n",
" \n",
" 21317 | \n",
" 21317 | \n",
" AK034_386 | \n",
" 20303 | \n",
" 251.0 | \n",
" NaN | \n",
" Gars-Thunau am Kamp | \n",
" True | \n",
" NaN | \n",
" NaN | \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.272 | \n",
" 1909 | \n",
" P | \n",
" PPL | \n",
" 2763660.0 | \n",
" 48.58333 | \n",
" 15.65000 | \n",
" Thunau am Kamp | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 48.58333, 15.65 | \n",
" https://iiif.onb.ac.at/images/AKON/AK034_386/3... | \n",
" https://iiif.onb.ac.at/images/AKON/AK034_386/3... | \n",
"
\n",
" \n",
" 23201 | \n",
" 23201 | \n",
" AK041_572 | \n",
" 24699 | \n",
" 251.0 | \n",
" NaN | \n",
" Gars-Thunau am Kamp | \n",
" False | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1908.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.328 | \n",
" 1908 | \n",
" P | \n",
" PPL | \n",
" 2763660.0 | \n",
" 48.58333 | \n",
" 15.65000 | \n",
" Thunau am Kamp | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 48.58333, 15.65 | \n",
" https://iiif.onb.ac.at/images/AKON/AK041_572/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK041_572/5... | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building \\\n",
"28908 28908 AK066_086 40120 NaN NaN \n",
"21317 21317 AK034_386 20303 251.0 NaN \n",
"23201 23201 AK041_572 24699 251.0 NaN \n",
"\n",
" city color comment mountain other \\\n",
"28908 Innsbruck, Maria Theresienstrasse False 1907 gel NaN NaN \n",
"21317 Gars-Thunau am Kamp True NaN NaN NaN \n",
"23201 Gars-Thunau am Kamp False NaN NaN NaN \n",
"\n",
" photographer publisher publisher_place region water_body year \\\n",
"28908 NaN Gratl Innsbruck NaN NaN NaN \n",
"21317 NaN Ledermann Wien NaN NaN 1909.0 \n",
"23201 NaN Ledermann Wien NaN NaN 1908.0 \n",
"\n",
" inventory_number signature revision_date date \\\n",
"28908 NaN NaN 2014-08-04 07:59:10.424 vor 1907 \n",
"21317 NaN NaN 2014-08-04 07:59:10.272 1909 \n",
"23201 NaN NaN 2014-08-04 07:59:10.328 1908 \n",
"\n",
" feature_class feature_code geoname_id latitude longitude \\\n",
"28908 P PPLA 2775220.0 47.26266 11.39454 \n",
"21317 P PPL 2763660.0 48.58333 15.65000 \n",
"23201 P PPL 2763660.0 48.58333 15.65000 \n",
"\n",
" name country_id admin_name_1 admin_code_1 \\\n",
"28908 Innsbruck AT NaN NaN \n",
"21317 Thunau am Kamp AT NaN NaN \n",
"23201 Thunau am Kamp AT NaN NaN \n",
"\n",
" geo download_link \\\n",
"28908 47.26266, 11.39454 https://iiif.onb.ac.at/images/AKON/AK066_086/0... \n",
"21317 48.58333, 15.65 https://iiif.onb.ac.at/images/AKON/AK034_386/3... \n",
"23201 48.58333, 15.65 https://iiif.onb.ac.at/images/AKON/AK041_572/5... \n",
"\n",
" download_link_256x256 \n",
"28908 https://iiif.onb.ac.at/images/AKON/AK066_086/0... \n",
"21317 https://iiif.onb.ac.at/images/AKON/AK034_386/3... \n",
"23201 https://iiif.onb.ac.at/images/AKON/AK041_572/5... "
]
},
"execution_count": 8,
"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": 9,
"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",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 18810 | \n",
" 18810 | \n",
" AK025_111 | \n",
" 14618 | \n",
" NaN | \n",
" NaN | \n",
" Bruck an der Mur | \n",
" True | \n",
" NaN | \n",
" Mugel | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1916.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-10-15 12:03:01.028 | \n",
" 1916 | \n",
" P | \n",
" PPLA3 | \n",
" 2781371.0 | \n",
" 47.41667 | \n",
" 15.28333 | \n",
" Bruck an der Mur | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.41667, 15.28333 | \n",
" https://iiif.onb.ac.at/images/AKON/AK025_111/1... | \n",
" https://iiif.onb.ac.at/images/AKON/AK025_111/1... | \n",
"
\n",
" \n",
" 28146 | \n",
" 28146 | \n",
" AK061_165 | \n",
" 36541 | \n",
" NaN | \n",
" NaN | \n",
" Orosháza | \n",
" True | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Vágner | \n",
" Orosháza | \n",
" NaN | \n",
" NaN | \n",
" 1917.0 | \n",
" NaN | \n",
" Kartensammlung 79/66 G | \n",
" 2015-08-25 15:28:56.547 | \n",
" 1917 | \n",
" P | \n",
" PPL | \n",
" 716736.0 | \n",
" 46.56667 | \n",
" 20.66667 | \n",
" Oroshaza | \n",
" HU | \n",
" Bekes County | \n",
" 03 | \n",
" 46.56667, 20.66667 | \n",
" https://iiif.onb.ac.at/images/AKON/AK061_165/1... | \n",
" https://iiif.onb.ac.at/images/AKON/AK061_165/1... | \n",
"
\n",
" \n",
" 8335 | \n",
" 8335 | \n",
" AK088_563 | \n",
" 56103 | \n",
" NaN | \n",
" NaN | \n",
" Bad Reichenhall | \n",
" False | \n",
" 1907 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Geogrphisch-topographische Bildersammlung 1076/43 | \n",
" 2014-08-28 16:20:02.029 | \n",
" vor 1907 | \n",
" P | \n",
" PPLA3 | \n",
" 2953371.0 | \n",
" 47.72947 | \n",
" 12.87819 | \n",
" Bad Reichenhall | \n",
" DE | \n",
" NaN | \n",
" NaN | \n",
" 47.72947, 12.87819 | \n",
" https://iiif.onb.ac.at/images/AKON/AK088_563/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK088_563/5... | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building city \\\n",
"18810 18810 AK025_111 14618 NaN NaN Bruck an der Mur \n",
"28146 28146 AK061_165 36541 NaN NaN Orosháza \n",
"8335 8335 AK088_563 56103 NaN NaN Bad Reichenhall \n",
"\n",
" color comment mountain other photographer publisher publisher_place \\\n",
"18810 True NaN Mugel NaN NaN Ledermann Wien \n",
"28146 True NaN NaN NaN NaN Vágner Orosháza \n",
"8335 False 1907 gel NaN NaN NaN NaN NaN \n",
"\n",
" region water_body year inventory_number \\\n",
"18810 NaN NaN 1916.0 NaN \n",
"28146 NaN NaN 1917.0 NaN \n",
"8335 NaN NaN NaN NaN \n",
"\n",
" signature \\\n",
"18810 NaN \n",
"28146 Kartensammlung 79/66 G \n",
"8335 Geogrphisch-topographische Bildersammlung 1076/43 \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"18810 2014-10-15 12:03:01.028 1916 P PPLA3 \n",
"28146 2015-08-25 15:28:56.547 1917 P PPL \n",
"8335 2014-08-28 16:20:02.029 vor 1907 P PPLA3 \n",
"\n",
" geoname_id latitude longitude name country_id \\\n",
"18810 2781371.0 47.41667 15.28333 Bruck an der Mur AT \n",
"28146 716736.0 46.56667 20.66667 Oroshaza HU \n",
"8335 2953371.0 47.72947 12.87819 Bad Reichenhall DE \n",
"\n",
" admin_name_1 admin_code_1 geo \\\n",
"18810 NaN NaN 47.41667, 15.28333 \n",
"28146 Bekes County 03 46.56667, 20.66667 \n",
"8335 NaN NaN 47.72947, 12.87819 \n",
"\n",
" download_link \\\n",
"18810 https://iiif.onb.ac.at/images/AKON/AK025_111/1... \n",
"28146 https://iiif.onb.ac.at/images/AKON/AK061_165/1... \n",
"8335 https://iiif.onb.ac.at/images/AKON/AK088_563/5... \n",
"\n",
" download_link_256x256 \n",
"18810 https://iiif.onb.ac.at/images/AKON/AK025_111/1... \n",
"28146 https://iiif.onb.ac.at/images/AKON/AK061_165/1... \n",
"8335 https://iiif.onb.ac.at/images/AKON/AK088_563/5... "
]
},
"execution_count": 9,
"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": 10,
"metadata": {},
"outputs": [],
"source": [
"df_in_italy = df[df['country_id'] == 'IT']"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"3221"
]
},
"execution_count": 11,
"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": 12,
"metadata": {},
"outputs": [],
"source": [
"df_in_color = df[df['color'] == True]"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"7667"
]
},
"execution_count": 13,
"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": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"7667"
]
},
"execution_count": 14,
"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": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"1545"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df['publisher_place'].unique())"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Show me some!"
]
},
{
"cell_type": "code",
"execution_count": 16,
"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[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": 17,
"metadata": {},
"outputs": [],
"source": [
"publisher_places = df['publisher_place'].unique()"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([nan, 'Wien', 'Kierling', ..., 'Königstein i. T.', 'Detmold',\n",
" 'Furth i. W.'], dtype=object)"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"publisher_places"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"pp = pd.DataFrame(publisher_places)"
]
},
{
"cell_type": "code",
"execution_count": 20,
"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",
" Wien | \n",
"
\n",
" \n",
" 2 | \n",
" Kierling | \n",
"
\n",
" \n",
" 3 | \n",
" Kindberg | \n",
"
\n",
" \n",
" 4 | \n",
" Kirchau | \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",
" Innsbruck | \n",
"
\n",
" \n",
" 9 | \n",
" Klagenfurt | \n",
"
\n",
" \n",
" 10 | \n",
" Grein a/D. | \n",
"
\n",
" \n",
" 11 | \n",
" Bozen | \n",
"
\n",
" \n",
" 12 | \n",
" Znaim | \n",
"
\n",
" \n",
" 13 | \n",
" Graz | \n",
"
\n",
" \n",
" 14 | \n",
" Heidelberg | \n",
"
\n",
" \n",
" 15 | \n",
" Komotau | \n",
"
\n",
" \n",
" 16 | \n",
" Gr. Siegharts | \n",
"
\n",
" \n",
" 17 | \n",
" Köln | \n",
"
\n",
" \n",
" 18 | \n",
" Bodenbach a. d. Elbe | \n",
"
\n",
" \n",
" 19 | \n",
" Meissen | \n",
"
\n",
" \n",
" 20 | \n",
" Leipzig | \n",
"
\n",
" \n",
" 21 | \n",
" Konstanz | \n",
"
\n",
" \n",
" 22 | \n",
" Korneuburg | \n",
"
\n",
" \n",
" 23 | \n",
" Brașov | \n",
"
\n",
" \n",
" 24 | \n",
" Mürzzuschlag | \n",
"
\n",
" \n",
" 25 | \n",
" Salzburg | \n",
"
\n",
" \n",
" 26 | \n",
" Frankfurt a. M. | \n",
"
\n",
" \n",
" 27 | \n",
" Arosa | \n",
"
\n",
" \n",
" 28 | \n",
" Kilchberg | \n",
"
\n",
" \n",
" 29 | \n",
" Arys | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 1515 | \n",
" Friedau | \n",
"
\n",
" \n",
" 1516 | \n",
" Wildalpe | \n",
"
\n",
" \n",
" 1517 | \n",
" Gießhübl | \n",
"
\n",
" \n",
" 1518 | \n",
" Schlossberg | \n",
"
\n",
" \n",
" 1519 | \n",
" Frakfurt a. Oder | \n",
"
\n",
" \n",
" 1520 | \n",
" Casale Monferrato | \n",
"
\n",
" \n",
" 1521 | \n",
" gr | \n",
"
\n",
" \n",
" 1522 | \n",
" Steinhaus a. Semmering | \n",
"
\n",
" \n",
" 1523 | \n",
" Sternberg | \n",
"
\n",
" \n",
" 1524 | \n",
" Stronsdorf | \n",
"
\n",
" \n",
" 1525 | \n",
" Thörl | \n",
"
\n",
" \n",
" 1526 | \n",
" Coburg | \n",
"
\n",
" \n",
" 1527 | \n",
" Traismauer | \n",
"
\n",
" \n",
" 1528 | \n",
" Trebnitz | \n",
"
\n",
" \n",
" 1529 | \n",
" Unterlamm | \n",
"
\n",
" \n",
" 1530 | \n",
" Daun | \n",
"
\n",
" \n",
" 1531 | \n",
" Kilchberg-Züich | \n",
"
\n",
" \n",
" 1532 | \n",
" Mühlhausen | \n",
"
\n",
" \n",
" 1533 | \n",
" Eschwege | \n",
"
\n",
" \n",
" 1534 | \n",
" Tabarz | \n",
"
\n",
" \n",
" 1535 | \n",
" Suhl | \n",
"
\n",
" \n",
" 1536 | \n",
" Weimar | \n",
"
\n",
" \n",
" 1537 | \n",
" Friedrichsroda i. Th. | \n",
"
\n",
" \n",
" 1538 | \n",
" Leipa i. B. | \n",
"
\n",
" \n",
" 1539 | \n",
" Schumburg a. D. | \n",
"
\n",
" \n",
" 1540 | \n",
" Pisa | \n",
"
\n",
" \n",
" 1541 | \n",
" Straßburg i./E. | \n",
"
\n",
" \n",
" 1542 | \n",
" Königstein i. T. | \n",
"
\n",
" \n",
" 1543 | \n",
" Detmold | \n",
"
\n",
" \n",
" 1544 | \n",
" Furth i. W. | \n",
"
\n",
" \n",
"
\n",
"
1545 rows × 1 columns
\n",
"
"
],
"text/plain": [
" 0\n",
"0 NaN\n",
"1 Wien\n",
"2 Kierling\n",
"3 Kindberg\n",
"4 Kirchau\n",
"5 Kirchhain\n",
"6 München\n",
"7 Kitzbühel\n",
"8 Innsbruck\n",
"9 Klagenfurt\n",
"10 Grein a/D.\n",
"11 Bozen\n",
"12 Znaim\n",
"13 Graz\n",
"14 Heidelberg\n",
"15 Komotau\n",
"16 Gr. Siegharts\n",
"17 Köln\n",
"18 Bodenbach a. d. Elbe\n",
"19 Meissen\n",
"20 Leipzig\n",
"21 Konstanz\n",
"22 Korneuburg\n",
"23 Brașov\n",
"24 Mürzzuschlag\n",
"25 Salzburg\n",
"26 Frankfurt a. M.\n",
"27 Arosa\n",
"28 Kilchberg\n",
"29 Arys\n",
"... ...\n",
"1515 Friedau\n",
"1516 Wildalpe\n",
"1517 Gießhübl\n",
"1518 Schlossberg\n",
"1519 Frakfurt a. Oder\n",
"1520 Casale Monferrato\n",
"1521 gr\n",
"1522 Steinhaus a. Semmering\n",
"1523 Sternberg\n",
"1524 Stronsdorf\n",
"1525 Thörl\n",
"1526 Coburg\n",
"1527 Traismauer\n",
"1528 Trebnitz\n",
"1529 Unterlamm\n",
"1530 Daun\n",
"1531 Kilchberg-Züich\n",
"1532 Mühlhausen\n",
"1533 Eschwege\n",
"1534 Tabarz\n",
"1535 Suhl\n",
"1536 Weimar\n",
"1537 Friedrichsroda i. Th.\n",
"1538 Leipa i. B.\n",
"1539 Schumburg a. D.\n",
"1540 Pisa\n",
"1541 Straßburg i./E.\n",
"1542 Königstein i. T.\n",
"1543 Detmold\n",
"1544 Furth i. W.\n",
"\n",
"[1545 rows x 1 columns]"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Better. Now show me some randomly:"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 1007 | \n",
" Wörschach | \n",
"
\n",
" \n",
" 1494 | \n",
" Raibl | \n",
"
\n",
" \n",
" 339 | \n",
" Imst | \n",
"
\n",
" \n",
" 879 | \n",
" Zbiroh | \n",
"
\n",
" \n",
" 457 | \n",
" Bad Sachsa | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" 0\n",
"1007 Wörschach\n",
"1494 Raibl\n",
"339 Imst\n",
"879 Zbiroh\n",
"457 Bad Sachsa"
]
},
"execution_count": 21,
"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": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 599 | \n",
" Aue | \n",
"
\n",
" \n",
" 938 | \n",
" Chocěn | \n",
"
\n",
" \n",
" 314 | \n",
" Ernstbrunn | \n",
"
\n",
" \n",
" 739 | \n",
" Hall Tirol | \n",
"
\n",
" \n",
" 788 | \n",
" Hardegg | \n",
"
\n",
" \n",
" 3 | \n",
" Kindberg | \n",
"
\n",
" \n",
" 19 | \n",
" Meissen | \n",
"
\n",
" \n",
" 725 | \n",
" Neuchatel | \n",
"
\n",
" \n",
" 1211 | \n",
" Sommerein | \n",
"
\n",
" \n",
" 1302 | \n",
" Vorkloster bei Bregenz | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" 0\n",
"599 Aue\n",
"938 Chocěn\n",
"314 Ernstbrunn\n",
"739 Hall Tirol\n",
"788 Hardegg\n",
"3 Kindberg\n",
"19 Meissen\n",
"725 Neuchatel\n",
"1211 Sommerein\n",
"1302 Vorkloster bei Bregenz"
]
},
"execution_count": 22,
"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": 23,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 0 | \n",
"
\n",
" \n",
" \n",
" \n",
" 1248 | \n",
" Békéscsaba | \n",
"
\n",
" \n",
" 1303 | \n",
" Łuck | \n",
"
\n",
" \n",
" 389 | \n",
" # | \n",
"
\n",
" \n",
" 1489 | \n",
" A B. | \n",
"
\n",
" \n",
" 1239 | \n",
" A. | \n",
"
\n",
" \n",
" 1397 | \n",
" Aachen | \n",
"
\n",
" \n",
" 487 | \n",
" Abbazia | \n",
"
\n",
" \n",
" 1280 | \n",
" Abbazia-Lovrana | \n",
"
\n",
" \n",
" 313 | \n",
" Absam b. Innsbruck | \n",
"
\n",
" \n",
" 1181 | \n",
" Abtenau | \n",
"
\n",
" \n",
" 722 | \n",
" Achensee | \n",
"
\n",
" \n",
" 1479 | \n",
" Adelsberg | \n",
"
\n",
" \n",
" 340 | \n",
" Admont | \n",
"
\n",
" \n",
" 354 | \n",
" Aeuckens | \n",
"
\n",
" \n",
" 308 | \n",
" Aflenz | \n",
"
\n",
" \n",
" 934 | \n",
" Afritz | \n",
"
\n",
" \n",
" 982 | \n",
" Aggsbach | \n",
"
\n",
" \n",
" 819 | \n",
" Aigen | \n",
"
\n",
" \n",
" 462 | \n",
" Albendorf | \n",
"
\n",
" \n",
" 57 | \n",
" Alexandria | \n",
"
\n",
" \n",
" 1111 | \n",
" Alland | \n",
"
\n",
" \n",
" 786 | \n",
" Alland II | \n",
"
\n",
" \n",
" 947 | \n",
" Allensteig | \n",
"
\n",
" \n",
" 933 | \n",
" Allentsteig | \n",
"
\n",
" \n",
" 765 | \n",
" Allerheiligen | \n",
"
\n",
" \n",
" 396 | \n",
" Alsfeld | \n",
"
\n",
" \n",
" 730 | \n",
" Alt Aussee | \n",
"
\n",
" \n",
" 736 | \n",
" Alt Lengbach | \n",
"
\n",
" \n",
" 1348 | \n",
" Altaussee | \n",
"
\n",
" \n",
" 955 | \n",
" Altenberg | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 1177 | \n",
" Würflach | \n",
"
\n",
" \n",
" 829 | \n",
" Würnitz | \n",
"
\n",
" \n",
" 650 | \n",
" Würzburg | \n",
"
\n",
" \n",
" 674 | \n",
" Ybbs | \n",
"
\n",
" \n",
" 651 | \n",
" Ypres | \n",
"
\n",
" \n",
" 802 | \n",
" Ypser | \n",
"
\n",
" \n",
" 1487 | \n",
" Ysper | \n",
"
\n",
" \n",
" 1144 | \n",
" Zakopane | \n",
"
\n",
" \n",
" 1249 | \n",
" Zantan | \n",
"
\n",
" \n",
" 652 | \n",
" Zara | \n",
"
\n",
" \n",
" 879 | \n",
" Zbiroh | \n",
"
\n",
" \n",
" 1028 | \n",
" Zell a. See | \n",
"
\n",
" \n",
" 45 | \n",
" Zell am See | \n",
"
\n",
" \n",
" 1074 | \n",
" Zistersdorf | \n",
"
\n",
" \n",
" 37 | \n",
" Zittau | \n",
"
\n",
" \n",
" 1368 | \n",
" Zlabing | \n",
"
\n",
" \n",
" 12 | \n",
" Znaim | \n",
"
\n",
" \n",
" 1369 | \n",
" Zuckmantel | \n",
"
\n",
" \n",
" 560 | \n",
" Zurigo | \n",
"
\n",
" \n",
" 654 | \n",
" Zurzach | \n",
"
\n",
" \n",
" 431 | \n",
" Zwettl | \n",
"
\n",
" \n",
" 401 | \n",
" Zwiesel | \n",
"
\n",
" \n",
" 33 | \n",
" Zürich | \n",
"
\n",
" \n",
" 1521 | \n",
" gr | \n",
"
\n",
" \n",
" 769 | \n",
" spitz | \n",
"
\n",
" \n",
" 861 | \n",
" w | \n",
"
\n",
" \n",
" 417 | \n",
" Č. Krumlov | \n",
"
\n",
" \n",
" 1304 | \n",
" Łuck | \n",
"
\n",
" \n",
" 893 | \n",
" Šibenik | \n",
"
\n",
" \n",
" 0 | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
1545 rows × 1 columns
\n",
"
"
],
"text/plain": [
" 0\n",
"1248 Békéscsaba \n",
"1303 Łuck\n",
"389 #\n",
"1489 A B.\n",
"1239 A.\n",
"1397 Aachen\n",
"487 Abbazia\n",
"1280 Abbazia-Lovrana\n",
"313 Absam b. Innsbruck\n",
"1181 Abtenau\n",
"722 Achensee\n",
"1479 Adelsberg\n",
"340 Admont\n",
"354 Aeuckens\n",
"308 Aflenz\n",
"934 Afritz\n",
"982 Aggsbach\n",
"819 Aigen\n",
"462 Albendorf\n",
"57 Alexandria\n",
"1111 Alland\n",
"786 Alland II\n",
"947 Allensteig\n",
"933 Allentsteig\n",
"765 Allerheiligen\n",
"396 Alsfeld\n",
"730 Alt Aussee\n",
"736 Alt Lengbach\n",
"1348 Altaussee\n",
"955 Altenberg\n",
"... ...\n",
"1177 Würflach\n",
"829 Würnitz\n",
"650 Würzburg\n",
"674 Ybbs\n",
"651 Ypres\n",
"802 Ypser\n",
"1487 Ysper\n",
"1144 Zakopane\n",
"1249 Zantan\n",
"652 Zara\n",
"879 Zbiroh\n",
"1028 Zell a. See\n",
"45 Zell am See\n",
"1074 Zistersdorf\n",
"37 Zittau\n",
"1368 Zlabing\n",
"12 Znaim\n",
"1369 Zuckmantel\n",
"560 Zurigo\n",
"654 Zurzach\n",
"431 Zwettl\n",
"401 Zwiesel\n",
"33 Zürich\n",
"1521 gr\n",
"769 spitz\n",
"861 w\n",
"417 Č. Krumlov\n",
"1304 Łuck\n",
"893 Šibenik\n",
"0 NaN\n",
"\n",
"[1545 rows x 1 columns]"
]
},
"execution_count": 23,
"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": 24,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 Békéscsaba \n",
"Name: 1248, dtype: object"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.iloc[1248]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"More specifically the column '0':"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"' Békéscsaba '"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pp.iloc[1248][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",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
akon-experiments-b732b0092a00f00335593ba6a77916e479a9e075/All the Mountains.ipynb 0000664 0000000 0000000 00000310237 13502401465 0025676 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": 1,
"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": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/kst/tmp/dingsdi/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
}
],
"source": [
"df = pd.read_csv('https://labs.onb.ac.at/gitlab/labs-team/raw-metadata/raw/master/akon_postcards_public_domain.csv.bz2', compression='bz2')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## View Data"
]
},
{
"cell_type": "code",
"execution_count": 3,
"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",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 7125 | \n",
" 7125 | \n",
" AK103_180 | \n",
" 67901 | \n",
" NaN | \n",
" Laurenskerk | \n",
" Alkmaar | \n",
" False | \n",
" gel. 1911 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 79/59 K | \n",
" NaN | \n",
" 2014-09-03 12:10:00.735 | \n",
" gelaufen 1911 | \n",
" P | \n",
" PPL | \n",
" 2759899.0 | \n",
" 52.63167 | \n",
" 4.74861 | \n",
" Alkmaar | \n",
" NL | \n",
" Nord-Holland | \n",
" 07 | \n",
" 52.63167, 4.74861 | \n",
" https://iiif.onb.ac.at/images/AKON/AK103_180/1... | \n",
" https://iiif.onb.ac.at/images/AKON/AK103_180/1... | \n",
"
\n",
" \n",
" 6850 | \n",
" 6850 | \n",
" AK080_116 | \n",
" 49953 | \n",
" NaN | \n",
" NaN | \n",
" Stuttgart | \n",
" False | \n",
" 1913 gel | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Schaller | \n",
" Stuttgart | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-25 14:42:50.107 | \n",
" gelaufen 1913 | \n",
" P | \n",
" PPLA | \n",
" 2825297.0 | \n",
" 48.78232 | \n",
" 9.17702 | \n",
" Stuttgart | \n",
" DE | \n",
" Baden-Württemberg | \n",
" 01 | \n",
" 48.78232, 9.17702 | \n",
" https://iiif.onb.ac.at/images/AKON/AK080_116/1... | \n",
" https://iiif.onb.ac.at/images/AKON/AK080_116/1... | \n",
"
\n",
" \n",
" 9180 | \n",
" 9180 | \n",
" AK092_417 | \n",
" 58634 | \n",
" NaN | \n",
" NaN | \n",
" Frankfurt a. M., Goetheplatz | \n",
" False | \n",
" v 1905 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Kiement | \n",
" Frankfurt a. M. | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Geogr. Topogr. Bilder-Samml. 1943, 13602 | \n",
" 2014-09-01 10:38:38.387 | \n",
" vor 1905 | \n",
" P | \n",
" PPLA3 | \n",
" 2925533.0 | \n",
" 50.11552 | \n",
" 8.68417 | \n",
" Frankfurt am Main | \n",
" DE | \n",
" NaN | \n",
" NaN | \n",
" 50.11552, 8.68417 | \n",
" https://iiif.onb.ac.at/images/AKON/AK092_417/4... | \n",
" https://iiif.onb.ac.at/images/AKON/AK092_417/4... | \n",
"
\n",
" \n",
" 14579 | \n",
" 14579 | \n",
" AK009_594 | \n",
" 5432 | \n",
" NaN | \n",
" NaN | \n",
" Mariazell | \n",
" False | \n",
" NaN | \n",
" Oetscher | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1922.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:09.936 | \n",
" 1922 | \n",
" P | \n",
" PPLA3 | \n",
" 2771893.0 | \n",
" 47.77306 | \n",
" 15.31639 | \n",
" Mariazell | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.77306, 15.31639 | \n",
" https://iiif.onb.ac.at/images/AKON/AK009_594/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK009_594/5... | \n",
"
\n",
" \n",
" 15018 | \n",
" 15018 | \n",
" AK011_064 | \n",
" 6115 | \n",
" NaN | \n",
" NaN | \n",
" Waidhofen an der Ybbs | \n",
" True | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Herzig | \n",
" Waidhofen a. d. Ybbs | \n",
" NaN | \n",
" NaN | \n",
" 1913.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:09.959 | \n",
" 1913 | \n",
" P | \n",
" PPLA3 | \n",
" 2762077.0 | \n",
" 47.96004 | \n",
" 14.77361 | \n",
" Waidhofen an der Ybbs | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.96004, 14.77361 | \n",
" https://iiif.onb.ac.at/images/AKON/AK011_064/0... | \n",
" https://iiif.onb.ac.at/images/AKON/AK011_064/0... | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building \\\n",
"7125 7125 AK103_180 67901 NaN Laurenskerk \n",
"6850 6850 AK080_116 49953 NaN NaN \n",
"9180 9180 AK092_417 58634 NaN NaN \n",
"14579 14579 AK009_594 5432 NaN NaN \n",
"15018 15018 AK011_064 6115 NaN NaN \n",
"\n",
" city color comment mountain other \\\n",
"7125 Alkmaar False gel. 1911 NaN NaN \n",
"6850 Stuttgart False 1913 gel NaN NaN \n",
"9180 Frankfurt a. M., Goetheplatz False v 1905 NaN NaN \n",
"14579 Mariazell False NaN Oetscher NaN \n",
"15018 Waidhofen an der Ybbs True NaN NaN NaN \n",
"\n",
" photographer publisher publisher_place region water_body year \\\n",
"7125 NaN NaN NaN NaN NaN NaN \n",
"6850 NaN Schaller Stuttgart NaN NaN NaN \n",
"9180 NaN Kiement Frankfurt a. M. NaN NaN NaN \n",
"14579 NaN Ledermann Wien NaN NaN 1922.0 \n",
"15018 NaN Herzig Waidhofen a. d. Ybbs NaN NaN 1913.0 \n",
"\n",
" inventory_number signature \\\n",
"7125 79/59 K NaN \n",
"6850 NaN NaN \n",
"9180 NaN Geogr. Topogr. Bilder-Samml. 1943, 13602 \n",
"14579 NaN NaN \n",
"15018 NaN NaN \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"7125 2014-09-03 12:10:00.735 gelaufen 1911 P PPL \n",
"6850 2014-08-25 14:42:50.107 gelaufen 1913 P PPLA \n",
"9180 2014-09-01 10:38:38.387 vor 1905 P PPLA3 \n",
"14579 2014-08-04 07:59:09.936 1922 P PPLA3 \n",
"15018 2014-08-04 07:59:09.959 1913 P PPLA3 \n",
"\n",
" geoname_id latitude longitude name country_id \\\n",
"7125 2759899.0 52.63167 4.74861 Alkmaar NL \n",
"6850 2825297.0 48.78232 9.17702 Stuttgart DE \n",
"9180 2925533.0 50.11552 8.68417 Frankfurt am Main DE \n",
"14579 2771893.0 47.77306 15.31639 Mariazell AT \n",
"15018 2762077.0 47.96004 14.77361 Waidhofen an der Ybbs AT \n",
"\n",
" admin_name_1 admin_code_1 geo \\\n",
"7125 Nord-Holland 07 52.63167, 4.74861 \n",
"6850 Baden-Württemberg 01 48.78232, 9.17702 \n",
"9180 NaN NaN 50.11552, 8.68417 \n",
"14579 NaN NaN 47.77306, 15.31639 \n",
"15018 NaN NaN 47.96004, 14.77361 \n",
"\n",
" download_link \\\n",
"7125 https://iiif.onb.ac.at/images/AKON/AK103_180/1... \n",
"6850 https://iiif.onb.ac.at/images/AKON/AK080_116/1... \n",
"9180 https://iiif.onb.ac.at/images/AKON/AK092_417/4... \n",
"14579 https://iiif.onb.ac.at/images/AKON/AK009_594/5... \n",
"15018 https://iiif.onb.ac.at/images/AKON/AK011_064/0... \n",
"\n",
" download_link_256x256 \n",
"7125 https://iiif.onb.ac.at/images/AKON/AK103_180/1... \n",
"6850 https://iiif.onb.ac.at/images/AKON/AK080_116/1... \n",
"9180 https://iiif.onb.ac.at/images/AKON/AK092_417/4... \n",
"14579 https://iiif.onb.ac.at/images/AKON/AK009_594/5... \n",
"15018 https://iiif.onb.ac.at/images/AKON/AK011_064/0... "
]
},
"execution_count": 3,
"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": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"34846"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"29271"
]
},
"execution_count": 5,
"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": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"5575"
]
},
"execution_count": 6,
"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": 7,
"metadata": {},
"outputs": [],
"source": [
"mountains = df[ ~ (df['mountain'].isnull()) ]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Take a look at the data"
]
},
{
"cell_type": "code",
"execution_count": 8,
"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",
" geo | \n",
" download_link | \n",
" download_link_256x256 | \n",
"
\n",
" \n",
" \n",
" \n",
" 7485 | \n",
" 7485 | \n",
" AK084_275 | \n",
" 52992 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" v 1905 | \n",
" Drei Zinnen | \n",
" NaN | \n",
" NaN | \n",
" Photoglob Co. | \n",
" Zürich | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-27 10:53:09.020 | \n",
" vor 1905 | \n",
" T | \n",
" PKS | \n",
" 3165272.0 | \n",
" 46.61900 | \n",
" 12.30185 | \n",
" Drei Zinnen | \n",
" IT | \n",
" NaN | \n",
" NaN | \n",
" 46.619, 12.30185 | \n",
" https://iiif.onb.ac.at/images/AKON/AK084_275/2... | \n",
" https://iiif.onb.ac.at/images/AKON/AK084_275/2... | \n",
"
\n",
" \n",
" 13042 | \n",
" 13042 | \n",
" AK006_027 | \n",
" 3076 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" False | \n",
" NaN | \n",
" Schareck | \n",
" NaN | \n",
" NaN | \n",
" Gutenberghaus | \n",
" Klagenfurt | \n",
" NaN | \n",
" Bärenfall | \n",
" 1911.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:09.851 | \n",
" 1911 | \n",
" T | \n",
" PASS | \n",
" 2766151.0 | \n",
" 47.04180 | \n",
" 13.01590 | \n",
" Schareck | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.0418, 13.0159 | \n",
" https://iiif.onb.ac.at/images/AKON/AK006_027/0... | \n",
" https://iiif.onb.ac.at/images/AKON/AK006_027/0... | \n",
"
\n",
" \n",
" 31375 | \n",
" 31375 | \n",
" AK100_503 | \n",
" 64754 | \n",
" NaN | \n",
" Rifugio Bolognini | \n",
" NaN | \n",
" False | \n",
" 1899 | \n",
" Bedole | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 79/66 G | \n",
" NaN | \n",
" 2014-09-03 07:13:16.993 | \n",
" gelaufen 1899 | \n",
" T | \n",
" PK | \n",
" 6696180.0 | \n",
" 46.18410 | \n",
" 11.80228 | \n",
" Bedole | \n",
" IT | \n",
" NaN | \n",
" NaN | \n",
" 46.1841, 11.80228 | \n",
" https://iiif.onb.ac.at/images/AKON/AK100_503/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK100_503/5... | \n",
"
\n",
" \n",
" 2166 | \n",
" 2166 | \n",
" AK114_236 | \n",
" 76661 | \n",
" NaN | \n",
" Stutenhaus, Berghotel Adlersberg | \n",
" Vesser | \n",
" False | \n",
" NaN | \n",
" Adlersberg | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 1907.0 | \n",
" 13/41 G. KA. | \n",
" Geographisch-topographische Bildersammlung 293... | \n",
" 2014-09-09 09:01:30.828 | \n",
" 1907 | \n",
" P | \n",
" PPL | \n",
" 2817527.0 | \n",
" 50.59519 | \n",
" 10.78953 | \n",
" Vesser | \n",
" DE | \n",
" NaN | \n",
" NaN | \n",
" 50.59519, 10.78953 | \n",
" https://iiif.onb.ac.at/images/AKON/AK114_236/2... | \n",
" https://iiif.onb.ac.at/images/AKON/AK114_236/2... | \n",
"
\n",
" \n",
" 4432 | \n",
" 4432 | \n",
" AK048_462 | \n",
" 28904 | \n",
" NaN | \n",
" Habsburghaus | \n",
" NaN | \n",
" True | \n",
" NaN | \n",
" Rax | \n",
" Alpengarten | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1908.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-16 11:05:32.590 | \n",
" 1908 | \n",
" S | \n",
" HTL | \n",
" 2777118.0 | \n",
" 47.73333 | \n",
" 15.70000 | \n",
" Habsburghaus | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.73333, 15.7 | \n",
" https://iiif.onb.ac.at/images/AKON/AK048_462/4... | \n",
" https://iiif.onb.ac.at/images/AKON/AK048_462/4... | \n",
"
\n",
" \n",
" 31396 | \n",
" 31396 | \n",
" AK101_239 | \n",
" 65894 | \n",
" NaN | \n",
" NaN | \n",
" Wallis | \n",
" False | \n",
" v. 1907 | \n",
" Urner Alpen | \n",
" Rhonegletscher | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 79/66 G | \n",
" NaN | \n",
" 2014-09-03 08:27:15.774 | \n",
" vor 1907 | \n",
" H | \n",
" GLCR | \n",
" 2659056.0 | \n",
" 46.60454 | \n",
" 8.38605 | \n",
" Rhonegletscher | \n",
" CH | \n",
" NaN | \n",
" NaN | \n",
" 46.60454, 8.38605 | \n",
" https://iiif.onb.ac.at/images/AKON/AK101_239/2... | \n",
" https://iiif.onb.ac.at/images/AKON/AK101_239/2... | \n",
"
\n",
" \n",
" 23714 | \n",
" 23714 | \n",
" AK043_519 | \n",
" 25852 | \n",
" 959.0 | \n",
" Jubiläumswarte | \n",
" NaN | \n",
" True | \n",
" NaN | \n",
" Jauerling | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1912.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-08-04 07:59:10.342 | \n",
" 1912 | \n",
" T | \n",
" MT | \n",
" 2775112.0 | \n",
" 48.34098 | \n",
" 15.34050 | \n",
" Jauerling Gipfelkreuz | \n",
" AT | \n",
" Niederösterreich | \n",
" 03 | \n",
" 48.34098, 15.3405 | \n",
" https://iiif.onb.ac.at/images/AKON/AK043_519/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK043_519/5... | \n",
"
\n",
" \n",
" 33482 | \n",
" 33482 | \n",
" AK097_371 | \n",
" 62297 | \n",
" NaN | \n",
" NaN | \n",
" Brenta | \n",
" False | \n",
" 1905 gel | \n",
" Kaiser Franz-Josef-Spitze | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-02 11:19:10.995 | \n",
" vor 1905 | \n",
" T | \n",
" PASS | \n",
" 3180988.0 | \n",
" 46.23970 | \n",
" 10.84110 | \n",
" Campo Carlo Magno | \n",
" IT | \n",
" NaN | \n",
" NaN | \n",
" 46.2397, 10.8411 | \n",
" https://iiif.onb.ac.at/images/AKON/AK097_371/3... | \n",
" https://iiif.onb.ac.at/images/AKON/AK097_371/3... | \n",
"
\n",
" \n",
" 25652 | \n",
" 25652 | \n",
" AK034_222 | \n",
" 20139 | \n",
" 442.0 | \n",
" NaN | \n",
" Gloggnitz | \n",
" False | \n",
" NaN | \n",
" Rax, Feuchter | \n",
" NaN | \n",
" NaN | \n",
" Ledermann | \n",
" Wien | \n",
" NaN | \n",
" NaN | \n",
" 1918.0 | \n",
" NaN | \n",
" NaN | \n",
" 2014-09-16 11:11:53.011 | \n",
" 1918 | \n",
" P | \n",
" PPLA3 | \n",
" 2778455.0 | \n",
" 47.67487 | \n",
" 15.93893 | \n",
" Gloggnitz | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.67487, 15.93893 | \n",
" https://iiif.onb.ac.at/images/AKON/AK034_222/2... | \n",
" https://iiif.onb.ac.at/images/AKON/AK034_222/2... | \n",
"
\n",
" \n",
" 28730 | \n",
" 28730 | \n",
" AK064_513 | \n",
" 39161 | \n",
" NaN | \n",
" NaN | \n",
" Hallein | \n",
" False | \n",
" NaN | \n",
" Tennengebirge | \n",
" NaN | \n",
" NaN | \n",
" Huttegger | \n",
" Salzburg | \n",
" NaN | \n",
" NaN | \n",
" 1916.0 | \n",
" NaN | \n",
" Geographisch-topographische Bildersammlung I. ... | \n",
" 2015-04-15 10:58:33.373 | \n",
" 1916 | \n",
" T | \n",
" MTS | \n",
" 2763805.0 | \n",
" 47.50000 | \n",
" 13.25000 | \n",
" Tennengebirge | \n",
" AT | \n",
" NaN | \n",
" NaN | \n",
" 47.5, 13.25 | \n",
" https://iiif.onb.ac.at/images/AKON/AK064_513/5... | \n",
" https://iiif.onb.ac.at/images/AKON/AK064_513/5... | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude \\\n",
"7485 7485 AK084_275 52992 NaN \n",
"13042 13042 AK006_027 3076 NaN \n",
"31375 31375 AK100_503 64754 NaN \n",
"2166 2166 AK114_236 76661 NaN \n",
"4432 4432 AK048_462 28904 NaN \n",
"31396 31396 AK101_239 65894 NaN \n",
"23714 23714 AK043_519 25852 959.0 \n",
"33482 33482 AK097_371 62297 NaN \n",
"25652 25652 AK034_222 20139 442.0 \n",
"28730 28730 AK064_513 39161 NaN \n",
"\n",
" building city color comment \\\n",
"7485 NaN NaN False v 1905 \n",
"13042 NaN NaN False NaN \n",
"31375 Rifugio Bolognini NaN False 1899 \n",
"2166 Stutenhaus, Berghotel Adlersberg Vesser False NaN \n",
"4432 Habsburghaus NaN True NaN \n",
"31396 NaN Wallis False v. 1907 \n",
"23714 Jubiläumswarte NaN True NaN \n",
"33482 NaN Brenta False 1905 gel \n",
"25652 NaN Gloggnitz False NaN \n",
"28730 NaN Hallein False NaN \n",
"\n",
" mountain other photographer publisher \\\n",
"7485 Drei Zinnen NaN NaN Photoglob Co. \n",
"13042 Schareck NaN NaN Gutenberghaus \n",
"31375 Bedole NaN NaN NaN \n",
"2166 Adlersberg NaN NaN NaN \n",
"4432 Rax Alpengarten NaN Ledermann \n",
"31396 Urner Alpen Rhonegletscher NaN NaN \n",
"23714 Jauerling NaN NaN Ledermann \n",
"33482 Kaiser Franz-Josef-Spitze NaN NaN NaN \n",
"25652 Rax, Feuchter NaN NaN Ledermann \n",
"28730 Tennengebirge NaN NaN Huttegger \n",
"\n",
" publisher_place region water_body year inventory_number \\\n",
"7485 Zürich NaN NaN NaN NaN \n",
"13042 Klagenfurt NaN Bärenfall 1911.0 NaN \n",
"31375 NaN NaN NaN NaN 79/66 G \n",
"2166 NaN NaN NaN 1907.0 13/41 G. KA. \n",
"4432 Wien NaN NaN 1908.0 NaN \n",
"31396 NaN NaN NaN NaN 79/66 G \n",
"23714 Wien NaN NaN 1912.0 NaN \n",
"33482 NaN NaN NaN NaN NaN \n",
"25652 Wien NaN NaN 1918.0 NaN \n",
"28730 Salzburg NaN NaN 1916.0 NaN \n",
"\n",
" signature \\\n",
"7485 NaN \n",
"13042 NaN \n",
"31375 NaN \n",
"2166 Geographisch-topographische Bildersammlung 293... \n",
"4432 NaN \n",
"31396 NaN \n",
"23714 NaN \n",
"33482 NaN \n",
"25652 NaN \n",
"28730 Geographisch-topographische Bildersammlung I. ... \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"7485 2014-08-27 10:53:09.020 vor 1905 T PKS \n",
"13042 2014-08-04 07:59:09.851 1911 T PASS \n",
"31375 2014-09-03 07:13:16.993 gelaufen 1899 T PK \n",
"2166 2014-09-09 09:01:30.828 1907 P PPL \n",
"4432 2014-09-16 11:05:32.590 1908 S HTL \n",
"31396 2014-09-03 08:27:15.774 vor 1907 H GLCR \n",
"23714 2014-08-04 07:59:10.342 1912 T MT \n",
"33482 2014-09-02 11:19:10.995 vor 1905 T PASS \n",
"25652 2014-09-16 11:11:53.011 1918 P PPLA3 \n",
"28730 2015-04-15 10:58:33.373 1916 T MTS \n",
"\n",
" geoname_id latitude longitude name country_id \\\n",
"7485 3165272.0 46.61900 12.30185 Drei Zinnen IT \n",
"13042 2766151.0 47.04180 13.01590 Schareck AT \n",
"31375 6696180.0 46.18410 11.80228 Bedole IT \n",
"2166 2817527.0 50.59519 10.78953 Vesser DE \n",
"4432 2777118.0 47.73333 15.70000 Habsburghaus AT \n",
"31396 2659056.0 46.60454 8.38605 Rhonegletscher CH \n",
"23714 2775112.0 48.34098 15.34050 Jauerling Gipfelkreuz AT \n",
"33482 3180988.0 46.23970 10.84110 Campo Carlo Magno IT \n",
"25652 2778455.0 47.67487 15.93893 Gloggnitz AT \n",
"28730 2763805.0 47.50000 13.25000 Tennengebirge AT \n",
"\n",
" admin_name_1 admin_code_1 geo \\\n",
"7485 NaN NaN 46.619, 12.30185 \n",
"13042 NaN NaN 47.0418, 13.0159 \n",
"31375 NaN NaN 46.1841, 11.80228 \n",
"2166 NaN NaN 50.59519, 10.78953 \n",
"4432 NaN NaN 47.73333, 15.7 \n",
"31396 NaN NaN 46.60454, 8.38605 \n",
"23714 Niederösterreich 03 48.34098, 15.3405 \n",
"33482 NaN NaN 46.2397, 10.8411 \n",
"25652 NaN NaN 47.67487, 15.93893 \n",
"28730 NaN NaN 47.5, 13.25 \n",
"\n",
" download_link \\\n",
"7485 https://iiif.onb.ac.at/images/AKON/AK084_275/2... \n",
"13042 https://iiif.onb.ac.at/images/AKON/AK006_027/0... \n",
"31375 https://iiif.onb.ac.at/images/AKON/AK100_503/5... \n",
"2166 https://iiif.onb.ac.at/images/AKON/AK114_236/2... \n",
"4432 https://iiif.onb.ac.at/images/AKON/AK048_462/4... \n",
"31396 https://iiif.onb.ac.at/images/AKON/AK101_239/2... \n",
"23714 https://iiif.onb.ac.at/images/AKON/AK043_519/5... \n",
"33482 https://iiif.onb.ac.at/images/AKON/AK097_371/3... \n",
"25652 https://iiif.onb.ac.at/images/AKON/AK034_222/2... \n",
"28730 https://iiif.onb.ac.at/images/AKON/AK064_513/5... \n",
"\n",
" download_link_256x256 \n",
"7485 https://iiif.onb.ac.at/images/AKON/AK084_275/2... \n",
"13042 https://iiif.onb.ac.at/images/AKON/AK006_027/0... \n",
"31375 https://iiif.onb.ac.at/images/AKON/AK100_503/5... \n",
"2166 https://iiif.onb.ac.at/images/AKON/AK114_236/2... \n",
"4432 https://iiif.onb.ac.at/images/AKON/AK048_462/4... \n",
"31396 https://iiif.onb.ac.at/images/AKON/AK101_239/2... \n",
"23714 https://iiif.onb.ac.at/images/AKON/AK043_519/5... \n",
"33482 https://iiif.onb.ac.at/images/AKON/AK097_371/3... \n",
"25652 https://iiif.onb.ac.at/images/AKON/AK034_222/2... \n",
"28730 https://iiif.onb.ac.at/images/AKON/AK064_513/5... "
]
},
"execution_count": 8,
"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": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'AK111_048, AK111_080, AK111_096, AK111_117, AK111_131, AK111_139, AK111_193, AK111_149, AK111_169, AK111_241, AK111_242, AK111_287, AK111_332, AK111_333, AK047_273, AK111_470, AK111_476, AK111_514, AK111_551, AK111_549, AK111_559, AK111_560, AK111_562, AK111_565, AK116_227, AK111_581, AK111_582, AK111_598, AK112_015, AK112_038, 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, AK033_541, AK114_261, AK114_302, AK114_303, AK114_391, AK114_447, AK114_449, AK059_222, AK114_453, AK114_454, AK114_458, AK061_243, AK114_509, AK114_544, AK114_554, AK114_562, AK114_566, AK115_064, 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_171, AK115_172, AK115_174, AK115_175, AK115_176, AK115_180, AK115_182, AK115_183, AK115_188, AK115_192, AK115_199, AK115_200, AK115_205, AK115_207, AK115_208, AK115_209, AK115_240, AK115_251, AK115_262, AK115_278, AK115_285, AK067_206, AK115_372, AK115_375, 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_508, AK115_509, AK115_510, AK115_511, AK115_513, AK115_514, AK115_515, AK115_516, AK115_517, AK115_518, AK115_519, AK115_520, AK115_521, AK115_522, AK115_524, AK115_526, AK115_527, AK115_528, AK115_529, 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_155, 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_293, AK116_298, AK116_303, AK116_306, AK116_307, AK116_317, AK116_318, AK116_328, AK116_355, AK116_362, AK082_325, AK116_412, AK116_421, AK116_428, AK116_430, AK116_448, AK116_482, AK116_518, AK116_507, AK116_515, AK116_584, AK116_597, AK117_017, 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_331, AK117_336, AK117_345, AK117_355, AK117_357, AK117_361, AK117_365, AK117_374, AK117_377, 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_547, AK117_580, AK117_596, AK117_598, AK118_010, AK118_012, AK118_014, AK118_016, AK118_017, AK118_018, AK118_023, AK118_026, AK118_030, AK118_046, 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_135, AK118_139, AK118_141, AK118_148, AK118_150, AK118_151, AK118_152, AK118_159, AK118_176, AK118_178, AK118_187, AK118_239, AK118_258, AK118_261, AK118_262, AK118_263, AK118_264, AK118_265, AK118_267, AK118_269, AK118_286, AK118_343, AK118_359, AK118_392, AK118_426, AK118_427, AK118_462, AK118_474, AK118_485, AK118_504, AK118_509, AK118_533, AK118_536, AK118_544, AK118_552, AK118_555, AK118_574, AK118_575, AK118_588, AK064_015, AK064_018, AK064_019, AK064_020, AK119_021, AK119_040, AK119_055, AK119_064, AK119_087, AK119_110, AK119_111, AK119_123, AK119_224, AK114_236, AK119_341, AK119_374, AK119_382, AK119_418, AK119_439, AK119_444, AK119_554, AK119_561, AK119_562, AK119_563, AK119_564, AK119_589, AK119_590, AK120_005, AK120_012, AK120_020, AK064_026, AK012_473, AK012_471, AK120_077, AK120_088, AK120_090, AK120_094, AK120_106, AK120_110, AK120_127, AK120_239, AK120_226, AK120_229, AK120_240, AK120_242, AK120_252, AK117_597, AK120_314, AK120_315, AK120_328, AK120_346, AK120_347, AK120_352, AK120_356, AK120_357, AK120_358, AK120_360, AK120_361, AK120_362, AK120_363, AK120_364, AK120_365, AK120_370, AK120_464, 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_456, AK120_463, AK120_465, AK120_467, AK120_468, AK120_469, AK120_471, AK120_472, AK120_473, AK120_474, AK120_475, AK120_477, AK120_478, AK120_479, AK120_480, AK120_481, AK120_494, AK121_248, 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_237, AK121_246, AK121_247, AK121_249, AK121_235, AK121_233, AK121_251, AK121_253, AK121_254, AK121_255, 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, AK122_055, AK122_177, AK122_179, AK122_180, AK122_185, AK122_186, AK122_187, AK122_188, AK122_228, AK122_232, AK122_233, AK122_244, AK122_247, AK122_265, AK122_286, AK122_287, AK122_288, AK122_312, AK122_319, AK122_349, AK122_352, AK122_356, AK122_355, AK122_354, AK122_351, AK122_359, AK122_362, AK122_376, AK122_464, AK122_528, AK122_541, AK074_345, AK122_578, AK067_458, AK123_037, AK123_039, AK012_455, AK123_049, AK104_531, AK123_364, AK074_428, AK123_409, AK123_481, AK123_553, AK123_555, AK123_556, AK123_560, AK027_234, AK122_544, AK124_010, AK074_435, 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, AK119_432, AK124_574, AK125_040, AK125_035, AK125_051, AK125_052, AK125_054, AK125_077, AK125_083, 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_416, AK125_417, AK125_425, AK125_435, AK125_438, AK125_440, AK125_441, AK125_444, AK125_446, AK125_447, AK125_421, AK125_454, AK125_455, AK125_460, AK125_462, AK125_472, AK125_483, AK104_567, AK070_588, AK071_214, 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, AK120_589, AK123_041, AK123_044, AK074_452, AK125_476, AK125_499, AK125_502, AK058_194, AK045_459, AK058_234, AK058_257, AK058_273, AK049_122, AK003_566, AK018_142, AK118_076, AK045_062, AK045_460, AK045_461, AK046_204, AK046_576, AK046_579, AK046_578, AK046_580, AK065_156, AK065_157, AK066_390, AK052_437, AK012_406, AK014_335, AK014_338, AK017_080, AK017_083, AK017_084, AK017_363, AK017_386, AK017_387, AK022_087, AK022_096, AK022_097, AK022_098, AK022_099, AK022_101, AK022_102, AK022_105, AK022_109, AK022_258, AK022_261, AK022_266, AK022_267, AK052_438, AK063_424, AK028_320, AK030_040, AK030_042, AK030_054, AK030_362, AK033_091, AK033_094, AK033_093, AK033_117, AK033_116, AK033_113, AK033_114, AK033_118, AK033_222, AK033_262, AK033_264, AK033_265, AK033_279, AK033_406, AK033_427, AK033_519, AK035_002, AK035_412, AK044_100, AK044_110, AK044_115, AK044_190, AK044_449, AK044_467, AK044_545, AK044_546, AK044_543, AK044_544, AK044_542, AK045_162, AK045_319, AK045_320, AK045_474, AK046_210, AK046_216, AK046_215, AK046_219, AK046_264, AK046_595, AK047_464, 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_395, AK048_407, AK048_399, AK048_404, AK048_408, AK048_423, AK048_426, AK048_427, AK048_428, AK048_432, AK048_433, AK048_435, AK048_441, AK048_442, AK048_443, AK048_449, AK048_451, AK048_452, AK048_457, AK048_411, AK048_412, AK048_417, AK048_418, AK048_461, AK048_462, AK048_464, AK048_465, AK048_466, AK048_467, AK048_468, AK048_470, 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_252, AK048_434, AK048_438, AK048_439, AK048_440, AK048_469, AK048_481, AK048_405, AK048_414, AK037_242, AK027_052, AK032_498, AK001_525, AK014_152, AK064_197, AK024_316, AK028_119, AK108_041, AK025_119, AK091_167, AK114_190, AK065_462, AK065_478, AK065_486, AK068_302, AK068_325, AK068_331, AK113_566, AK113_569, AK113_570, AK081_026, AK010_418, AK099_400, AK105_350, AK050_154, AK065_461, AK059_234, AK025_472, AK031_209, AK118_028, AK045_018, AK045_020, AK045_021, AK069_175, AK091_518, AK021_318, AK096_449, AK096_453, AK096_455, AK096_457, AK096_458, AK065_182, AK065_183, AK065_184, AK065_188, AK065_191, AK096_452, AK068_477, AK068_478, AK068_479, AK068_480, AK068_481, AK069_568, AK058_312, AK063_231, AK044_125, AK044_130, AK044_131, AK070_584, AK081_375, AK081_427, AK023_144, AK027_311, AK096_495, AK068_073, AK063_018, AK070_352, AK070_353, AK050_514, AK017_197, AK107_400, AK125_493, AK036_444, AK036_445, AK060_112, AK060_107, AK060_101, AK021_404, AK021_408, AK021_407, AK021_412, AK021_415, AK021_420, AK021_422, AK021_428, AK021_433, AK021_481, AK085_106, AK044_445, AK021_483, AK021_487, AK021_488, AK021_491, AK021_492, AK058_397, AK058_386, AK021_493, AK054_583, AK054_584, AK054_585, AK054_586, AK054_588, AK054_589, AK060_385, AK060_377, AK060_386, AK026_410, AK026_413, AK026_418, AK026_426, AK026_432, AK026_435, AK026_040, AK026_050, AK026_051, AK074_347, AK067_308, AK019_414, AK060_245, AK066_377, AK064_509, AK064_518, AK067_207, AK067_256, AK086_488, AK086_489, AK086_490, AK108_047, AK100_513, AK121_236, AK102_486, AK125_075, AK001_521, AK125_374, AK067_510, AK115_050, AK075_444, AK115_148, AK117_559, AK121_397, AK121_476, AK053_429, AK009_039, AK104_581, AK118_050, AK050_515, 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_513, AK075_539, AK075_540, AK075_566, AK076_023, AK076_024, AK076_056, AK076_097, AK076_113, AK076_103, AK076_186, AK076_187, AK105_294, AK105_295, AK076_439, AK105_379, AK076_447, AK076_454, AK078_396, AK076_512, AK076_524, AK076_525, AK076_549, AK105_388, AK105_397, AK105_391, AK048_430, AK003_216, AK055_240, AK048_456, AK003_367, AK003_370, AK003_371, AK003_467, AK003_468, AK003_469, AK077_243, AK077_380, 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_325, AK063_331, AK106_038, AK006_055, AK006_271, AK078_436, AK078_451, AK108_044, AK086_179, AK106_065, AK078_549, AK078_574, AK078_577, AK078_578, AK079_021, AK079_038, AK120_539, AK120_540, AK079_056, AK079_077, AK079_078, AK079_079, AK008_546, AK019_488, AK063_367, AK019_554, AK063_380, AK063_339, AK063_352, AK063_337, AK063_396, AK063_398, AK063_407, AK063_409, AK063_410, AK063_414, AK009_177, AK009_179, AK009_180, AK079_195, AK079_222, 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_491, AK079_496, AK079_502, AK114_323, AK079_557, AK106_248, AK080_202, AK012_271, AK080_366, AK080_418, AK080_420, AK022_223, AK080_431, AK080_438, AK080_441, AK080_442, AK080_544, AK080_545, AK080_568, AK080_575, AK082_011, AK082_015, 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, AK082_254, AK013_599, AK050_520, AK082_348, AK082_352, AK082_469, AK082_475, AK011_310, AK106_347, AK083_020, AK083_038, AK083_074, AK083_230, AK116_277, AK097_185, AK106_392, AK083_221, AK083_220, AK083_270, AK083_282, AK083_296, AK106_445, AK106_446, AK106_447, AK106_448, AK083_363, AK015_262, AK083_450, AK083_406, AK083_451, AK083_474, AK015_447, AK015_448, AK015_451, AK015_454, AK101_133, AK083_548, AK083_549, AK015_509, AK084_016, AK084_098, AK084_082, AK084_195, AK084_234, AK084_239, AK084_243, AK016_495, AK084_260, AK084_275, AK084_289, AK084_291, AK084_297, AK084_298, AK084_299, AK084_303, AK084_453, AK084_463, AK084_583, AK084_585, AK084_590, AK084_595, AK085_144, AK019_299, AK085_325, AK019_298, AK085_330, AK085_384, AK085_388, AK085_389, AK085_393, AK085_449, AK106_569, AK086_066, AK086_064, AK086_068, AK086_071, AK086_104, AK086_110, AK086_112, AK086_115, AK086_118, AK086_120, AK086_121, AK086_124, AK086_175, 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_230, AK086_232, AK086_245, AK086_274, AK086_283, AK086_286, AK086_287, AK086_331, AK086_320, AK086_321, AK086_323, AK086_324, AK022_339, 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_227, AK087_231, AK087_349, AK087_496, AK087_554, AK087_551, AK095_232, AK087_562, AK087_574, AK088_282, AK088_308, AK061_192, AK107_043, AK088_496, AK088_497, AK026_374, AK026_373, AK026_372, AK026_282, AK088_526, AK088_549, AK089_097, AK089_095, AK089_096, AK069_159, AK089_116, AK107_054, AK089_234, AK089_235, AK089_237, AK089_262, AK089_321, AK089_291, AK089_346, AK089_319, AK089_365, 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_510, AK091_525, AK092_026, AK092_068, AK002_420, AK002_419, AK092_209, AK092_213, AK092_219, AK092_220, AK092_221, 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_472, AK041_534, AK041_554, AK041_604, AK041_587, AK041_588, AK041_274, AK041_279, AK074_041, AK107_268, AK107_272, AK092_386, AK092_387, AK092_554, AK092_555, AK092_574, AK092_576, AK093_063, AK093_083, AK093_096, AK093_273, AK093_325, AK093_337, 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, AK107_407, AK094_240, AK094_261, AK094_264, AK094_294, AK094_296, 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_151, AK095_230, AK095_231, AK095_233, AK034_491, AK107_502, AK107_501, AK095_410, AK095_411, AK081_122, AK001_085, AK095_449, AK107_518, AK107_519, AK107_524, AK001_011, AK107_533, AK001_019, AK001_036, AK096_297, AK096_298, AK096_301, AK096_305, AK096_304, AK096_309, AK069_411, AK001_079, AK069_462, AK069_468, AK001_080, AK001_083, 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, AK001_220, AK099_002, AK001_198, AK001_201, AK001_210, AK099_042, AK099_060, AK099_062, AK099_090, AK099_106, AK099_105, AK108_117, AK108_129, AK108_132, AK108_141, AK099_208, AK099_262, AK099_287, AK099_296, AK099_356, AK099_376, AK099_385, 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_157, 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_327, AK001_328, AK001_331, AK100_445, AK100_479, AK100_488, AK108_186, AK108_188, AK108_190, AK100_516, AK100_517, AK100_572, AK100_571, AK101_007, AK101_010, 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_056, AK002_103, AK002_107, AK002_123, AK002_137, AK002_138, AK002_139, AK002_150, AK002_157, AK101_468, AK101_474, AK002_198, AK002_197, AK002_211, AK101_485, AK002_250, AK002_248, AK002_249, AK002_253, AK002_255, AK002_257, AK101_492, AK002_267, AK002_277, AK002_281, AK002_295, AK002_302, AK002_317, AK002_331, AK002_330, AK002_355, AK002_356, AK002_357, AK002_369, AK002_390, AK002_395, AK002_391, AK002_393, AK002_394, AK002_401, AK002_402, AK002_398, AK102_040, AK102_045, AK002_435, AK002_438, AK002_439, AK002_441, AK002_451, AK102_051, AK102_059, AK002_465, AK002_469, AK002_475, AK102_084, AK102_085, AK002_483, AK002_477, AK002_542, AK002_536, AK002_554, AK003_002, AK108_316, AK108_318, AK102_166, AK102_194, AK102_244, AK102_245, AK102_250, AK102_257, AK102_255, AK003_191, AK003_195, AK003_196, AK003_202, AK003_203, AK102_264, AK102_274, AK102_284, AK003_227, AK003_228, AK003_206, AK003_210, AK003_218, AK003_226, AK003_229, AK003_230, AK003_233, AK102_289, AK102_295, AK102_297, AK102_299, AK102_301, AK003_238, AK003_239, AK003_242, AK003_241, AK003_243, AK003_244, AK003_245, AK003_247, AK003_257, AK003_258, AK003_252, AK003_253, AK003_240, AK003_287, AK003_286, AK003_280, AK003_282, AK003_284, AK003_285, AK003_292, AK003_290, AK003_369, AK003_395, AK003_380, AK003_384, AK003_396, AK003_397, AK003_394, AK003_391, AK003_398, AK003_402, AK003_406, AK003_407, AK003_408, AK102_354, AK003_399, AK102_356, AK003_419, AK003_429, AK003_434, AK003_440, AK003_486, AK003_487, AK003_462, AK003_542, AK108_344, AK003_557, AK040_304, AK102_443, AK003_567, AK102_444, AK102_445, AK003_568, AK003_582, AK102_458, AK102_460, AK102_461, AK102_469, AK004_022, AK004_023, AK004_040, AK004_032, AK102_487, AK102_488, AK102_526, 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, AK004_478, AK103_093, AK004_471, AK004_491, AK004_494, AK004_501, AK108_371, AK004_518, AK004_519, AK004_534, AK108_372, AK004_530, AK004_531, AK004_540, AK108_373, AK103_136, AK004_555, AK004_574, AK004_566, AK004_580, AK004_581, AK004_582, AK004_583, AK103_152, AK004_589, AK108_376, AK004_590, AK004_591, AK108_374, AK108_375, AK108_377, AK108_381, AK108_383, AK005_062, AK005_063, AK005_065, AK005_069, AK005_067, AK005_070, AK005_072, AK108_385, AK005_080, AK005_079, AK005_083, AK005_082, AK005_086, AK005_087, AK005_088, AK005_089, AK005_090, AK005_091, AK005_081, AK005_126, 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, AK005_374, AK103_383, AK103_436, 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, AK103_552, AK103_554, AK006_063, AK006_075, AK006_093, AK006_081, AK006_097, AK006_085, AK006_100, AK006_117, AK006_134, AK006_130, AK006_127, AK006_119, AK006_126, AK006_129, AK006_135, AK006_157, AK006_159, AK006_160, AK006_177, 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_333, AK108_404, AK006_341, AK006_344, AK006_345, AK006_348, AK006_354, AK104_185, AK006_444, AK006_454, AK006_470, AK006_466, AK006_481, AK006_474, AK006_476, AK006_500, AK006_511, AK006_515, AK006_516, AK006_518, AK006_519, AK006_523, AK006_561, AK006_547, AK006_562, AK104_301, AK045_288, AK007_074, AK007_076, AK007_078, AK007_088, AK104_370, AK104_380, AK104_384, AK104_385, AK007_150, AK007_152, AK007_153, AK007_155, AK007_156, AK007_162, AK007_188, AK007_189, AK007_221, AK007_231, AK007_232, AK007_224, AK007_219, AK007_223, AK108_425, AK007_227, AK007_230, AK007_233, AK007_234, AK007_235, AK108_428, AK007_240, AK007_253, AK007_254, AK007_255, AK007_257, AK108_445, AK108_446, AK007_319, AK108_454, AK007_301, AK007_306, AK007_329, AK007_320, AK007_326, AK007_325, AK007_327, AK108_461, AK108_474, AK007_339, AK007_344, AK007_343, AK007_341, AK007_342, AK007_345, AK007_346, AK007_353, AK007_362, AK007_363, AK007_356, AK007_360, AK007_364, AK007_365, AK007_366, AK007_367, AK007_373, AK007_374, AK007_396, AK007_383, AK007_397, AK007_399, AK007_402, AK007_461, AK007_462, AK007_479, AK108_516, AK108_517, AK108_520, AK108_529, AK001_556, AK007_500, AK108_533, AK007_533, AK007_550, AK007_557, AK008_004, AK108_582, AK108_574, AK108_581, AK008_019, AK008_014, AK008_015, AK008_012, AK008_013, AK008_020, AK008_018, AK008_021, AK008_023, AK108_592, AK025_382, AK109_006, AK109_007, AK109_014, AK008_088, AK008_089, AK008_090, AK008_095, AK008_124, AK008_137, AK008_144, AK008_142, AK008_145, AK008_146, AK008_149, AK109_035, AK109_037, AK109_056, AK109_059, AK109_061, AK109_062, AK109_063, AK008_185, AK008_186, AK008_191, AK008_190, AK008_194, AK008_198, AK008_200, AK008_201, AK109_075, AK109_081, AK109_102, AK109_106, AK109_107, AK109_117, AK109_134, AK109_135, AK109_136, AK008_417, AK008_440, AK001_566, AK109_166, AK109_167, AK109_170, AK109_180, AK109_183, AK109_184, AK008_461, AK008_463, AK008_466, AK109_188, AK008_559, AK109_226, AK009_013, AK009_010, AK009_001, AK009_007, AK009_028, AK009_030, AK009_036, AK009_054, AK009_069, AK109_258, AK009_117, AK009_118, AK009_122, AK009_126, AK009_127, AK009_138, AK009_139, AK009_168, AK009_176, AK009_154, AK009_160, AK009_178, AK009_181, AK009_183, AK009_185, AK009_186, AK009_187, AK009_188, AK009_189, AK009_202, AK009_205, AK009_206, AK009_209, AK009_226, AK009_232, AK009_190, AK009_249, AK009_251, AK109_320, AK109_322, AK009_242, AK109_327, AK009_247, AK009_248, AK009_250, AK009_252, AK009_257, AK009_274, AK109_341, AK109_343, 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_464, AK009_467, AK009_470, AK009_472, AK009_468, AK009_474, AK009_489, AK009_480, AK009_500, AK009_466, AK009_505, AK009_516, AK009_512, AK009_524, AK009_535, AK009_543, AK009_553, AK109_498, AK009_583, AK009_584, AK109_511, AK109_523, AK109_525, AK109_526, AK009_594, AK009_604, AK109_528, AK109_530, AK109_531, AK109_532, AK109_535, AK109_536, AK109_540, AK109_541, AK010_032, AK010_101, AK010_098, AK010_099, AK010_094, AK010_095, AK010_097, AK010_109, AK010_130, AK010_132, AK010_134, AK110_017, AK110_021, AK110_031, AK010_141, AK010_142, AK010_145, AK010_154, AK010_158, AK010_177, AK010_180, AK010_179, AK110_057, AK110_062, AK010_218, AK110_076, AK110_080, AK110_085, AK010_258, AK010_261, AK010_263, AK001_199, AK001_205, AK001_073, AK002_303, AK110_144, AK110_141, AK001_277, AK005_298, AK001_283, AK010_324, AK007_228, AK110_226, AK110_249, AK110_250, AK010_366, AK003_565, AK002_436, AK001_088, AK010_421, AK010_451, AK010_567, AK010_561, AK010_562, AK010_568, AK010_581, AK011_001, AK011_010, AK011_018, AK011_049, AK011_051, AK011_056, AK011_059, AK011_061, AK011_045, AK011_077, AK011_087, AK011_070, AK011_084, AK011_096, AK011_132, AK011_133, AK110_384, AK011_181, AK011_182, AK011_183, AK011_209, AK011_250, AK011_260, AK011_272, AK011_406, AK011_407, AK011_430, AK011_465, AK011_563, AK011_561, AK054_472, AK054_491, AK110_526, AK110_527, AK011_579, AK001_065, AK011_598, AK059_072, AK059_185, AK011_360, AK011_361, AK011_355, AK011_356, AK011_359, AK011_362, AK011_393, AK011_307, AK011_308, AK012_001, AK063_553, AK012_055, AK012_070, AK012_075, AK012_076, AK012_082, AK012_085, AK012_086, AK012_090, AK012_094, AK012_098, AK012_099, AK012_102, AK002_254, AK005_074, AK012_129, AK012_139, AK012_140, AK012_152, AK020_551, AK012_149, AK012_153, AK012_146, AK012_147, AK012_156, AK012_157, AK012_159, AK012_158, AK012_160, AK012_161, AK012_173, AK012_175, AK012_367, AK012_371, AK012_405, AK012_372, AK012_374, AK012_375, AK012_395, AK012_398, AK012_401, AK012_402, AK012_425, AK012_474, AK012_528, AK012_521, AK012_522, AK012_524, AK012_529, AK012_544, AK012_533, AK012_556, AK013_034, AK012_598, AK012_585, AK013_012, AK013_019, AK013_020, AK013_022, AK013_023, AK013_024, AK013_028, AK013_036, AK013_039, AK013_057, AK013_058, AK013_071, AK013_075, AK013_132, AK013_164, AK013_182, AK013_183, AK013_186, AK013_235, AK013_258, AK013_259, AK013_260, AK013_333, AK013_334, AK013_343, AK013_344, AK013_389, AK013_413, AK014_056, AK014_062, AK014_073, AK014_111, AK014_112, AK014_120, AK014_123, AK014_126, AK014_130, AK014_150, AK014_221, AK014_210, AK014_230, AK014_320, AK014_302, AK014_303, AK014_301, AK014_304, AK014_332, AK014_331, AK014_333, AK014_352, AK014_358, AK014_368, AK014_373, AK014_397, AK014_398, AK014_399, AK014_404, AK014_429, AK014_431, AK014_432, AK014_433, AK014_435, AK014_447, AK014_448, AK014_475, AK014_480, AK014_481, AK014_482, AK014_483, AK015_015, AK015_017, AK015_031, AK015_028, AK015_057, AK015_071, AK015_127, AK015_135, AK015_140, AK015_178, AK015_169, AK015_180, AK015_182, AK015_219, AK015_283, AK015_269, AK015_244, AK015_287, AK015_288, AK015_301, AK015_302, AK015_303, AK015_295, AK015_333, AK015_334, AK015_356, AK015_363, AK015_367, AK015_432, AK015_434, AK015_435, AK015_425, AK015_418, AK015_446, AK015_458, 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_139, AK016_164, AK016_176, AK016_201, AK016_178, AK016_179, AK016_180, AK016_182, AK016_211, AK016_253, AK016_254, 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_397, AK016_403, AK016_401, AK016_404, AK016_405, AK016_414, AK016_436, AK016_459, AK016_492, AK016_497, AK016_527, AK016_530, AK016_531, AK016_532, AK016_533, AK016_536, AK016_562, AK016_563, AK016_569, AK016_578, AK017_002, AK017_003, AK017_005, 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_078, AK017_079, AK017_087, AK017_090, AK017_091, AK017_110, AK017_100, AK017_113, AK017_114, AK017_115, AK017_118, AK017_128, AK017_139, AK017_168, AK017_229, AK017_230, AK017_231, AK017_232, AK017_252, AK017_235, AK017_236, AK017_237, AK017_238, AK017_239, AK017_240, AK017_242, AK017_243, AK017_244, AK017_245, AK017_248, AK017_262, AK017_268, AK017_273, AK017_276, AK017_277, AK017_264, AK017_265, AK017_322, AK017_323, AK017_320, AK017_321, AK017_355, AK017_356, AK017_368, AK017_347, AK017_369, AK017_393, AK017_388, AK017_420, AK018_020, AK018_014, AK018_015, AK018_010, AK018_088, AK018_097, AK018_155, AK018_178, AK018_179, AK018_162, AK018_167, AK018_175, AK018_176, AK018_177, AK018_180, AK018_186, AK018_187, AK018_188, AK018_193, AK018_192, AK018_194, AK018_214, 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_488, AK018_489, AK018_494, AK018_517, AK018_518, AK018_519, AK018_520, AK018_521, AK018_544, AK018_545, AK018_546, AK018_547, AK018_549, AK018_550, AK018_552, AK018_553, AK018_554, AK018_551, AK018_561, AK019_010, AK019_031, AK018_592, AK019_026, AK019_038, AK019_041, AK019_042, AK019_043, AK019_044, AK019_046, AK019_071, AK019_107, AK019_109, AK019_110, AK019_112, AK019_113, AK019_114, AK019_179, AK019_180, AK019_181, AK019_182, AK019_183, AK019_221, AK019_222, AK019_223, AK019_256, AK019_257, AK019_258, AK019_259, AK019_244, 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_336, AK019_346, AK019_362, AK019_397, AK019_398, AK019_399, AK019_401, AK019_406, AK019_396, AK019_418, AK019_436, AK019_441, AK019_455, AK019_457, AK019_461, AK019_469, AK019_471, AK019_474, AK019_477, AK019_478, AK019_480, AK019_481, AK019_483, AK019_485, AK019_487, AK019_492, AK019_496, AK019_546, AK019_535, 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_566, AK020_567, AK020_543, AK020_546, AK020_549, AK020_554, AK020_563, AK020_564, AK020_572, AK020_573, AK020_576, AK020_581, AK020_588, AK020_598, AK021_002, AK021_033, AK021_060, AK021_061, AK021_096, AK021_097, AK021_083, AK021_129, AK021_183, AK021_192, AK021_193, AK021_198, AK021_199, AK021_187, AK021_248, AK021_273, AK021_276, AK047_477, AK021_372, AK021_390, AK021_393, AK021_397, AK021_398, AK021_403, AK048_029, AK021_490, AK021_450, AK021_474, AK021_476, AK021_495, AK021_520, AK021_538, AK021_536, AK021_579, AK021_582, AK022_071, AK022_079, AK022_081, AK022_070, 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_212, AK022_213, AK022_216, AK022_217, AK022_221, AK022_222, AK022_224, AK022_227, AK022_232, AK022_252, AK022_264, AK022_289, AK022_293, AK022_314, AK022_342, AK022_372, AK022_391, AK022_392, AK022_396, AK022_397, AK022_452, AK022_473, AK022_476, AK022_477, AK022_481, AK022_547, AK022_569, AK023_005, AK023_105, AK023_114, AK023_115, AK023_111, AK023_131, AK023_136, AK023_145, AK023_188, AK023_191, 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_401, AK023_415, AK023_416, AK023_420, AK023_421, AK023_422, AK023_429, AK023_441, AK023_453, AK023_454, AK023_446, AK023_488, AK023_498, AK023_504, AK023_522, AK023_511, AK023_519, AK023_512, AK023_532, AK052_436, AK063_425, AK063_426, AK052_052, AK052_122, AK053_076, AK063_472, AK053_164, AK063_496, AK063_497, AK024_037, AK024_054, AK024_058, AK063_522, AK024_065, AK053_433, AK081_061, AK054_132, AK024_248, AK024_250, AK024_256, AK024_285, AK024_306, AK024_311, AK024_312, AK024_313, AK024_332, AK024_337, AK024_366, AK024_379, AK024_387, AK063_566, AK054_355, AK024_392, AK024_411, AK024_381, AK055_085, AK024_429, AK024_433, AK055_096, AK024_460, AK024_443, AK024_444, 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_463, AK024_465, AK025_009, AK055_367, AK055_432, AK025_041, AK025_046, AK025_048, AK055_549, 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_144, AK025_148, AK025_138, AK025_149, AK025_153, AK025_155, AK025_156, AK025_165, AK025_178, AK025_198, AK025_207, AK025_205, AK025_206, AK025_213, AK025_230, AK025_231, AK025_236, AK025_237, AK025_240, AK025_241, AK025_242, AK025_251, AK025_266, AK025_267, AK056_371, AK056_421, AK025_316, 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_437, AK025_439, AK025_483, AK025_484, AK025_466, AK025_474, AK025_533, AK025_501, AK025_593, AK026_001, AK025_561, AK025_583, AK025_587, AK025_588, AK026_005, AK026_042, AK026_053, AK026_113, AK026_098, AK026_085, AK026_086, AK026_097, AK026_112, AK026_116, AK026_119, AK026_123, AK026_155, AK026_156, AK026_158, AK026_154, AK026_161, AK026_259, AK026_291, AK026_308, AK026_354, AK026_332, AK026_381, AK026_416, AK026_455, AK026_417, AK026_484, AK059_329, AK059_346, AK026_492, AK026_493, AK026_494, AK026_496, AK026_497, AK059_420, AK059_434, AK059_441, AK059_442, AK059_468, AK026_535, AK026_550, AK026_572, AK026_573, AK027_005, AK027_013, AK027_014, AK027_043, AK027_071, AK027_118, AK027_130, AK027_173, AK027_184, AK027_188, AK027_208, AK027_217, AK064_010, AK064_009, AK027_301, AK060_403, AK027_300, AK027_314, AK064_168, AK064_072, AK027_335, AK027_341, AK027_346, AK027_350, AK027_352, AK027_361, AK027_380, AK027_389, AK027_394, AK027_415, AK027_437, AK027_438, AK064_222, AK027_458, AK027_459, AK027_460, AK027_476, AK027_469, AK027_471, AK027_472, AK027_473, AK028_029, AK028_040, AK028_041, AK028_043, AK028_044, AK028_045, AK028_061, AK028_062, AK028_063, AK028_093, AK028_077, AK028_078, AK028_080, AK028_100, AK028_104, AK028_117, AK028_126, AK028_156, 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_316, AK028_317, AK028_295, AK028_321, AK028_294, AK028_319, AK028_322, AK028_330, 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_442, AK028_443, AK028_444, AK028_449, AK028_450, AK028_451, AK028_455, AK028_464, AK028_478, AK028_479, AK028_481, AK028_482, AK028_483, 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_056, 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_154, 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_004, AK030_011, 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_327, AK030_340, AK030_342, AK030_352, AK030_357, AK030_360, AK030_361, AK030_354, 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_569, AK030_575, AK030_581, AK030_586, AK030_587, AK068_547, AK031_147, AK006_156, AK016_181, AK031_168, AK031_185, AK031_216, AK031_217, AK031_234, AK031_235, AK031_240, AK031_325, AK031_321, AK031_323, AK031_324, AK031_361, AK031_366, AK031_372, AK031_360, AK031_365, AK031_402, AK031_404, AK031_582, 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_391, AK032_584, AK032_585, AK032_586, AK032_461, AK032_462, AK032_500, AK050_560, AK033_019, AK033_020, AK033_090, AK033_068, AK033_069, AK033_092, AK033_105, AK077_384, AK033_223, AK033_227, AK033_229, AK033_228, AK033_235, AK033_251, AK033_250, AK033_253, AK033_258, AK033_263, AK033_278, AK033_385, AK033_403, AK033_404, AK033_429, AK033_430, AK033_432, AK033_433, AK033_516, AK033_485, AK033_523, AK033_525, AK033_574, AK033_575, AK033_587, AK033_591, AK034_007, AK034_066, AK034_080, AK034_135, AK034_136, AK034_142, AK034_148, AK034_159, AK034_160, AK034_163, AK034_174, AK034_181, AK034_184, AK034_193, AK034_218, AK034_239, AK034_255, AK034_282, AK034_271, AK034_273, AK034_274, AK034_275, AK034_276, AK034_277, AK034_278, AK034_279, AK034_280, AK034_281, AK034_283, AK034_284, AK034_285, AK034_287, AK034_288, AK034_289, AK034_292, AK034_293, AK034_295, AK034_286, AK034_290, AK034_291, AK034_296, AK034_298, AK034_299, AK034_300, AK034_301, AK034_302, AK034_338, AK034_340, AK034_341, AK034_337, AK034_352, AK034_345, AK034_347, AK034_349, AK034_348, AK034_350, AK034_373, AK034_369, AK034_372, AK034_371, AK034_413, AK034_414, AK034_439, AK034_452, AK034_475, AK034_468, AK034_476, AK035_010, AK034_580, AK035_017, AK035_039, AK035_044, AK035_053, AK035_082, AK035_089, AK035_097, AK035_086, AK035_111, AK035_109, AK035_123, AK035_132, AK035_151, AK035_134, AK035_142, AK035_150, AK035_159, AK035_147, AK035_149, AK035_158, AK035_169, AK035_170, AK035_171, AK035_179, AK035_180, AK035_181, AK035_329, AK035_330, AK035_377, AK035_380, AK035_372, AK035_393, AK035_413, AK035_398, AK035_411, AK035_422, AK035_423, AK035_424, AK035_434, AK035_445, AK035_449, AK035_450, 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_088, AK036_095, AK036_098, AK036_103, AK036_104, AK036_129, AK036_131, AK036_120, AK036_121, AK036_132, AK036_153, AK036_272, AK036_276, AK036_274, AK036_273, AK036_277, AK036_303, AK036_308, AK036_305, AK051_148, 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_272, AK037_278, AK037_306, AK037_305, AK037_309, AK037_313, AK037_336, AK037_340, AK037_342, AK037_347, AK037_351, AK037_359, AK051_149, AK037_371, AK037_375, AK037_378, AK037_376, AK037_385, AK037_399, AK037_392, AK037_396, 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_040, AK038_088, AK038_101, AK038_102, AK038_103, AK038_106, AK038_108, AK038_137, AK038_269, AK038_325, AK038_416, AK038_420, AK038_421, AK038_427, AK038_428, AK038_431, AK038_436, AK038_456, AK038_464, AK038_474, AK038_483, AK038_562, AK038_575, AK039_004, AK039_020, AK039_044, AK039_045, AK039_058, AK039_061, AK039_035, AK039_018, AK039_074, AK039_087, AK039_089, AK039_094, AK039_106, AK039_114, AK039_115, AK039_125, AK039_131, AK039_133, AK039_135, AK039_152, AK039_134, AK039_162, AK039_161, AK039_167, AK039_204, AK039_213, AK039_211, AK039_205, AK039_244, AK039_241, AK039_242, AK039_251, AK001_204, AK001_203, AK035_100, AK033_405, AK036_437, AK039_306, AK039_390, AK039_381, AK039_383, AK039_384, AK039_385, AK039_414, AK039_423, AK059_512, AK039_478, AK039_477, AK039_483, AK039_526, AK040_037, AK040_049, AK040_074, AK040_083, AK040_085, AK040_087, AK040_134, AK040_145, AK040_147, AK040_174, AK040_214, AK040_225, AK040_227, AK040_222, AK040_232, AK040_230, AK040_245, AK040_238, AK040_244, AK040_264, AK040_255, AK040_271, AK040_288, AK040_286, AK040_287, AK040_290, AK040_303, AK040_391, AK040_399, AK040_528, AK040_476, AK040_489, AK040_499, AK040_508, AK040_509, AK040_494, AK040_511, AK040_505, AK040_502, AK040_538, AK040_543, AK040_542, AK040_575, AK040_591, AK041_033, AK041_032, AK041_036, AK041_136, AK041_138, AK041_139, AK041_140, AK041_149, AK105_161, AK041_212, AK041_213, AK041_382, AK041_390, AK041_396, AK041_416, AK041_423, AK041_427, AK041_428, AK041_442, AK041_447, AK041_448, AK041_450, AK041_492, AK041_507, AK041_521, AK041_560, AK041_563, AK041_555, AK041_556, AK041_557, AK041_558, AK041_564, AK041_581, AK041_598, AK042_008, AK041_592, AK041_595, AK042_036, AK042_047, AK042_069, AK042_105, AK042_085, AK042_130, AK042_154, AK042_147, AK042_255, AK042_268, AK042_262, 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_529, AK042_531, AK042_535, AK043_055, AK043_057, AK043_091, AK043_092, AK043_099, AK043_120, AK051_150, AK043_160, AK043_212, 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_501, AK043_502, AK043_505, AK043_506, AK043_519, AK043_540, AK043_553, AK043_562, AK043_557, AK043_568, AK043_569, AK043_570, AK044_003, AK044_004, AK044_052, AK044_046, AK044_080, AK044_500, AK044_126, AK044_151, AK044_154, AK044_173, AK044_196, AK044_188, AK044_208, AK044_211, AK044_212, AK044_213, AK044_229, AK044_230, AK044_231, AK044_232, AK044_260, AK044_275, AK044_276, AK044_290, AK044_293, AK044_294, AK044_301, AK044_327, AK044_341, AK044_337, AK044_359, AK044_360, AK044_377, AK044_386, AK044_391, AK044_397, AK044_420, AK044_432, AK044_441, AK044_443, AK044_444, AK044_450, AK044_457, AK044_464, AK044_481, AK044_465, AK044_506, AK044_516, AK044_485, AK044_513, AK044_497, AK044_510, AK044_494, AK044_502, AK044_511, AK044_535, AK045_025, AK045_028, AK045_024, AK045_001, AK045_036, AK045_039, AK045_055, 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_396, AK045_398, AK045_401, AK045_404, AK045_407, AK045_430, AK045_436, AK045_424, AK116_573, AK045_431, AK045_434, AK045_437, AK045_449, AK045_450, AK117_084, AK045_480, AK045_481, AK045_515, AK045_516, AK045_517, AK045_519, AK045_539, AK045_540, AK045_542, AK045_541, AK045_544, AK045_559, AK045_561, AK045_562, AK045_563, AK045_565, AK045_566, AK045_601, AK046_059, AK046_165, AK046_175, AK118_257, AK046_208, AK046_209, AK046_220, AK046_203, AK046_202, AK046_222, AK046_225, AK046_233, AK046_234, AK046_236, AK046_237, AK046_239, AK046_252, AK046_253, AK046_256, AK046_259, AK046_260, AK046_261, AK046_268, AK046_276, AK046_310, AK046_308, AK046_309, AK046_577, AK046_574, AK046_575, AK047_010, AK047_040, AK047_058, AK047_060, AK047_149, AK047_150, AK047_158, AK047_163, AK047_177, AK047_229, AK047_242, AK047_292, AK047_318, AK047_316, AK047_368, AK047_369, AK047_371, AK047_376, AK047_434, AK047_451, AK047_460, AK047_476, AK047_510, AK047_531, AK047_521, AK047_509, AK047_552, AK047_544, AK047_558, AK047_559, AK047_562, AK047_571, AK047_556, AK048_510, AK048_507, AK048_506, AK048_547, AK048_034, AK048_028, AK048_030, AK048_045, AK048_046, AK048_038, AK048_066, AK048_075, AK048_121, AK048_122, AK048_147, AK048_156, AK048_150, AK048_138, AK048_146, AK048_148, AK048_151, AK048_153, AK048_155, AK048_157, AK048_167, AK048_168, AK048_172, AK048_173, AK048_171, AK048_182, AK048_174, AK048_176, AK048_175, AK048_178, AK048_179, AK048_183, AK125_457, AK048_177, AK063_397, AK048_221, AK048_248, AK048_287, AK048_305, AK048_397, AK048_479, AK048_482, AK048_480, AK048_463, AK049_117, AK049_118, AK049_135, AK049_130, AK049_138, AK003_324, AK005_484, AK006_149, AK007_471, AK009_008, AK012_439, AK012_587, AK049_146, AK049_148, AK049_159, AK049_157, AK049_200, AK049_154, AK049_155, AK049_187, AK049_158, AK016_277, AK016_284, AK018_195, AK019_011, AK020_043, AK021_453, AK024_052, AK024_408, AK027_007, AK027_289, AK027_312, AK027_354, AK027_358, AK030_580, AK032_342, AK033_476, AK035_376, AK036_070, AK036_097, 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, AK055_208, AK067_472, AK004_281, AK006_061, AK006_279, AK008_010, AK012_397, AK012_399, AK014_071, AK049_373, AK049_374, AK049_375, AK049_372, AK049_371, AK049_369, AK049_370, AK049_376, AK049_377, AK049_379, AK049_478, AK049_479, AK049_514, AK049_512, AK014_418, AK016_200, AK017_165, AK017_166, AK017_169, AK017_170, AK018_427, AK018_444, AK018_448, AK019_007, AK019_005, AK019_040, AK019_008, AK019_037, AK019_039, AK019_367, AK020_432, AK022_086, AK021_448, AK024_491, AK024_501, AK025_434, AK026_107, AK026_108, AK027_062, AK027_369, AK027_375, AK027_385, AK028_115, AK028_398, AK028_401, AK028_404, AK004_400, AK009_110, AK010_112, AK030_309, AK031_166, AK031_287, AK031_311, AK034_342, AK034_147, AK034_346, AK034_344, AK034_343, AK035_203, AK038_121, AK039_053, AK039_173, AK039_398, AK033_480, AK042_046, AK042_056, AK044_503, AK045_472, AK034_222, AK047_392, 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_227, AK050_254, AK052_501, AK050_270, AK050_271, AK052_572, AK052_573, AK050_276, AK050_293, AK050_320, AK050_297, AK050_296, AK050_299, AK050_300, AK050_301, AK050_303, AK050_319, AK050_323, AK050_325, AK050_329, AK050_336, AK050_338, AK052_413, AK044_101, AK044_104, AK044_105, AK044_107, AK044_108, AK044_117, AK044_099, AK044_118, AK052_416, AK052_418, AK044_085, AK052_440, AK044_120, AK044_140, AK052_494, AK052_490, AK052_495, AK044_127, AK044_128, AK044_150, AK044_144, AK064_336, AK062_137, AK064_399, AK064_401, AK064_524, AK064_531, AK064_560, AK055_530, AK057_096, AK058_332, AK058_333, AK065_119, AK065_122, AK059_075, AK069_502, AK069_500, AK060_243, AK062_177, AK063_097, AK050_416, AK050_436, AK050_437, AK050_424, AK050_428, AK050_440, AK099_375, AK050_445, AK050_443, AK050_455, AK050_459, AK110_103, AK001_067, AK002_136, AK050_488, AK050_489, AK050_490, AK050_491, AK050_494, AK050_496, AK050_472, AK050_471, AK050_574, AK050_575, AK051_023, AK051_022, AK051_024, AK051_042, AK051_043, AK051_044, AK051_045, AK051_054, AK051_056, AK051_057, AK051_085, AK051_087, AK051_506, AK051_542, AK051_110, AK051_102, AK051_108, AK051_109, AK051_136, AK051_139, AK051_141, AK051_180, AK051_191, AK051_215, AK051_219, AK051_220, AK051_226, AK051_227, AK051_236, AK051_286, AK051_273, AK051_288, AK051_270, AK051_300, AK051_305, AK051_348, AK051_376, AK051_413, AK051_417, AK051_419, AK051_430, AK051_459, AK052_514, AK052_506, AK052_007, AK052_563, AK052_045, AK052_039, AK068_470, AK052_144, AK052_111, AK052_132, AK052_123, AK052_125, AK052_126, AK052_143, AK052_147, AK052_148, AK052_150, AK052_153, AK052_230, AK052_228, AK052_233, AK052_259, AK052_260, AK052_308, AK052_296, AK052_309, AK052_315, AK052_338, AK052_342, AK052_343, AK052_376, AK052_357, AK052_358, AK052_414, AK052_396, AK052_397, AK052_379, AK052_422, AK052_423, AK052_424, AK052_443, AK052_439, AK052_489, AK052_601, AK053_171, AK053_173, AK053_190, AK053_193, AK053_196, AK053_236, AK053_280, AK053_281, AK053_305, AK053_307, AK053_318, AK053_341, AK053_354, AK053_355, AK053_356, AK053_363, 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_488, AK054_489, AK054_558, AK054_559, AK054_560, AK054_561, AK054_553, AK054_576, AK054_551, AK054_566, AK054_569, 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_100, AK055_101, AK055_108, AK055_111, AK055_114, AK055_115, AK055_116, AK055_117, AK055_094, AK055_184, AK055_243, AK055_348, AK055_354, AK055_336, AK055_359, AK055_375, AK055_376, AK055_377, AK055_378, AK055_357, AK055_360, AK055_403, AK055_414, AK055_476, AK055_478, AK055_519, AK055_531, AK055_532, AK056_113, AK056_121, AK056_131, AK056_130, AK056_195, AK056_203, AK056_204, AK056_206, AK099_056, AK056_320, AK056_327, AK056_345, AK056_397, AK056_360, AK056_534, AK056_535, AK056_541, AK056_567, AK057_094, AK057_214, AK057_290, AK057_291, AK057_292, AK057_309, AK057_310, AK057_379, AK057_342, AK057_347, AK057_348, AK057_350, AK057_351, AK057_355, AK057_390, AK057_416, AK057_417, AK057_419, AK057_412, AK057_427, AK057_435, AK057_439, AK057_445, AK057_452, AK057_457, AK057_467, AK057_476, AK057_484, AK057_485, AK057_489, AK057_497, AK057_560, AK057_579, AK057_540, AK057_576, AK057_591, AK058_094, AK058_099, AK058_114, AK058_116, AK058_145, AK058_146, AK058_156, AK058_167, AK058_161, AK058_160, AK058_309, AK058_317, AK058_320, AK058_321, AK058_408, AK058_414, AK058_419, AK058_422, AK058_423, AK058_439, AK058_455, AK058_457, AK058_483, AK058_489, AK058_490, AK058_537, AK058_541, AK058_546, AK058_549, AK059_005, AK059_021, AK059_023, AK059_027, AK059_062, AK059_067, AK059_091, AK059_070, AK059_115, AK059_141, AK059_175, AK059_187, AK059_189, AK059_207, AK059_208, AK059_209, AK059_221, AK059_228, AK059_231, AK059_232, AK059_238, AK059_247, AK059_210, AK059_257, AK059_259, AK059_269, AK059_270, AK059_278, AK059_279, AK059_282, AK059_286, AK059_287, AK059_298, AK059_306, AK059_308, AK059_309, AK059_318, AK059_323, AK059_330, AK059_357, AK059_363, 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_429, AK059_432, AK059_433, AK059_479, AK059_435, AK059_437, AK059_440, AK059_444, AK059_445, AK059_446, AK059_450, AK059_464, AK059_474, AK059_475, AK059_476, AK059_477, AK059_478, AK059_480, AK059_481, AK059_482, AK059_484, AK059_485, AK059_503, AK059_504, AK059_514, AK059_519, AK059_522, AK059_523, AK059_526, AK059_528, AK059_520, AK059_543, AK059_544, AK059_574, AK059_565, AK059_534, AK059_564, AK060_005, AK060_039, AK060_040, AK060_044, AK060_051, AK060_108, AK060_056, AK060_100, AK060_125, AK060_144, AK103_385, AK060_137, AK060_138, AK060_190, 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_122, AK061_115, AK061_107, AK061_116, AK061_117, AK061_123, 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_241, AK061_253, AK061_280, AK061_297, AK061_252, AK061_323, AK061_305, AK061_363, AK061_404, AK061_414, AK061_437, AK061_459, AK061_483, AK061_492, AK061_493, AK061_494, AK061_495, AK062_037, AK062_038, AK062_043, AK062_044, AK062_120, AK062_147, AK062_148, AK062_131, AK062_188, AK062_204, AK062_220, AK062_223, AK062_226, AK062_224, AK062_252, AK062_267, AK062_278, AK062_297, AK062_302, AK062_322, AK062_326, AK062_327, AK062_386, AK062_466, AK062_467, AK062_431, AK062_541, AK062_570, AK106_416, AK063_012, AK063_036, AK063_029, AK063_087, AK063_127, 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_205, AK063_341, AK063_342, AK063_358, AK063_357, AK063_335, AK063_359, AK063_378, AK063_379, AK063_383, AK063_388, 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_398, 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_189, AK065_192, AK065_193, AK065_190, 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_065, AK066_069, AK066_084, AK066_089, AK066_091, AK066_098, AK066_100, AK066_104, AK066_140, AK066_149, AK066_193, AK066_226, AK066_236, AK066_289, AK066_388, AK066_395, AK066_445, AK066_450, AK066_459, AK066_534, AK066_520, AK066_563, AK066_572, AK067_022, AK066_577, AK066_589, AK066_556, AK067_025, AK067_062, AK067_302, AK067_257, 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_311, AK068_323, AK068_313, AK068_393, AK068_352, AK068_356, AK068_453, AK068_403, AK068_486, 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_274, AK069_342, AK069_343, AK069_354, AK069_356, AK069_359, AK069_380, AK069_388, AK069_404, AK069_405, AK069_407, AK069_447, AK116_478, AK069_558, AK070_002, AK070_003, AK070_004, AK070_018, AK070_020, AK070_035, AK070_037, AK070_054, AK070_055, AK070_144, AK070_133, AK070_211, AK070_244, AK070_235, AK070_237, AK070_250, 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, AK114_259, AK070_564, AK070_586, AK087_072, AK071_074, AK071_075, AK071_077, AK071_140, AK071_147, AK071_167, AK071_229, AK071_285, AK071_295, AK071_298, AK071_324, AK071_328, AK071_329, AK071_327, AK071_333, AK071_334, AK071_332, AK071_357, AK071_361, AK071_414, AK071_406, AK071_467, AK071_477, AK071_479, AK071_492, AK071_474, AK071_513, AK071_544, AK071_565, AK071_569, AK071_599, AK072_027, AK072_008, AK072_051, AK072_053, 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_347, AK075_348, AK075_350, AK075_401, AK075_456, AK075_458, AK076_461, AK077_475, AK077_477, AK077_476, AK077_489, AK078_100, AK078_106, AK078_111, AK078_113, AK078_471, AK078_409, AK079_262, AK079_265, AK079_362, AK079_370, AK079_485, AK079_546, AK081_045, AK081_067, AK081_077, AK081_088, AK081_171, AK081_079, AK081_234, AK081_289, AK081_316, AK081_386, AK081_596, AK082_005, AK082_008, AK082_119, AK083_089, AK083_301, AK083_320, AK083_326, AK083_448, AK083_517, AK083_578, AK084_196, AK084_202, AK084_272, AK085_028, AK085_046, AK085_349, AK085_385, AK085_447, AK085_450, AK086_200, AK086_193, AK086_199, AK086_356, AK086_599, AK087_009, AK087_147, AK087_130, AK087_151, AK087_524, AK087_525, AK088_031, AK088_272, AK088_269, AK088_257, AK088_265, AK088_266, AK088_581, AK089_236, AK089_314, AK089_320, AK089_322, AK089_500, AK100_510, AK090_245, AK090_496, AK090_495, AK090_564, AK090_565, AK090_569, AK091_003, AK115_155, AK091_067, AK091_091, AK091_094, AK091_168, AK091_117, AK091_336, AK091_337, AK091_338, AK091_339, AK091_408, AK091_409, 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, AK094_571, AK095_122, AK095_292, AK095_293, AK095_295, AK095_444, AK095_454, AK096_484, AK096_504, AK096_505, AK096_511, AK096_494, 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_366, AK097_367, AK097_370, AK097_373, AK097_375, AK097_437, AK098_024, AK098_029, AK098_159, AK098_398, 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, AK102_014, AK101_602, AK102_060, AK102_450, AK103_012, AK103_386, AK106_247, AK106_192, AK106_369, AK106_414, AK106_421, AK107_006, AK107_102, AK107_559, AK108_054, AK108_249, 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, AK120_042, AK121_124, AK122_142, AK122_346, AK123_045, AK123_046, AK064_601, AK065_024, AK065_018, AK069_426, AK066_023, AK066_092, AK066_166, AK066_218, AK066_219, AK066_224, AK066_228, AK066_229, AK066_272, AK066_276, AK066_285, AK066_292, AK084_248, AK066_294, AK066_349, AK097_358, AK066_393, AK066_296, AK066_306, AK109_533, AK097_136, AK066_446, AK066_571, AK067_002, AK066_539, AK066_540, AK067_063, AK067_086, AK067_107, AK067_108, AK067_109, AK067_077, AK067_174, AK067_175, AK067_179, AK067_183, AK067_186, AK079_483, AK070_254, AK086_285, AK090_033, AK093_361, AK110_147, AK067_396, AK067_422, AK067_417, AK067_445, AK067_539, AK068_059, AK068_069, AK068_083, AK068_091, AK068_129, AK068_132, AK068_149, AK068_248, AK098_396, AK063_412, AK041_269, AK063_523, AK064_027, AK038_574, AK038_596, AK039_170, AK039_175, AK041_263, 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, AK068_542, AK067_078, AK067_255, AK067_305, AK067_526, AK067_545, AK068_087, AK068_422, AK068_429, AK068_476, AK068_557, AK068_558, AK068_572, AK068_591, AK068_592, AK068_593, AK069_033, AK069_144, AK069_145, AK069_146, AK069_147, AK069_148, AK069_153, AK069_156, AK069_172, AK069_173, AK069_174, AK069_190, AK069_261, AK069_396, AK069_536, AK069_569, AK100_048, AK070_253, AK070_345, AK070_361, AK063_076, AK063_059, 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, AK072_016, AK072_152, AK001_587, AK010_575, AK010_577, AK011_511, AK024_380, AK059_469, AK028_271, AK028_272, AK049_124, AK049_199, AK050_298, AK051_600, AK051_237, AK052_512, AK052_515, AK052_142, AK053_172, AK053_220, AK057_393, AK058_142, AK058_400, AK059_451, AK059_452, AK059_473, AK060_369, AK060_421, AK076_055, AK086_125, AK100_557, AK101_005, AK102_061, AK107_004, AK066_012, AK066_271, 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_219, AK072_220, AK072_231, AK072_263, AK072_348, AK072_272, AK072_271, AK072_274, AK072_294, AK072_295, AK072_331, AK072_349, AK072_351, AK072_357, AK072_377, AK072_387, AK072_393, AK072_394, AK072_399, AK072_409, AK072_456, AK072_507, AK072_511, AK072_531, AK072_532, AK072_544, AK072_548, AK072_554, AK072_558, AK072_560, AK072_564, AK072_579, AK073_173, AK073_459, AK073_460, AK073_461, AK073_387, AK073_401, AK073_503, AK074_178'"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"', '.join(mountains['akon_id'])"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
akon-experiments-b732b0092a00f00335593ba6a77916e479a9e075/LICENSE 0000664 0000000 0000000 00000002104 13502401465 0022420 0 ustar 00root root 0000000 0000000 MIT License
Copyright (c) 2018 Österreichische Nationalbibliothek
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.