2020_SPRING_RUSH/week5/week5_5.1_best_sandwitches_rank_Chicago.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 🦉COSADAMA Introduction to Data Science Study\n",
    "\n",
    "- 일자: 2020-04-13\n",
    "- 작성자: 박하람 \n",
    "- 참고자료: 파이썬으로 데이터 주무르기(민형기), 점프 투 파이썬(박응용), 파이썬 입문과 크롤링 기초 부트캠프(잔재미코딩)\n",
    "- 교재: 139 - 158쪽 (깃헙 교안으로 공부하면서, 궁금한 부분은 교재를 참고하세요. 혹은 깃헙 교안을 다 보고 교재를 복습 겸 읽어봐도 됩니다!)\n",
    "\n",
    "## 5-1. 시카고 샌드위치 맛집 분석 \n",
    "\n",
    "이번 주차에는 지난 시간에 배운 **웹 크롤링**을 활용해 **시카고 샌드위치 맛집 분석**을 해보려 합니다. 더불어 네이버 영화 사이트에서 **네이버 영화 평점 순으로 시각화**하는 것까지 해보려고 해요. 당연히 지난 시간에 배웠던 HTML/CSS 지식, 정규 표현식, BeautifulSoup과 urllib 등도 함께 모두 사용해 볼겁니다. \n",
    "\n",
    "시카고 샌드위치 맛집 분석에서는 샌드위치 맛집의 이름, 샌드위치 이름, 가게의 주소 등의 정보를 얻고, 주소로 Google Maps를 이용해 위도와 경도를 찾아 Folium으로 시각화하는 방법까지 해볼 겁니다. 더불어 웹 크롤링을 하여 정보를 가져올 때에는 꽤 시간이 걸리기 때문에 걸리는 시간을 시각화 해 알려주는 tqdm 모듈도 사용해 볼겁니다. 정말 재미있는 부분💖이라 이번 주차도 신나게 공부할 수 있을 것 같습니다!🐶 그럼 이번 주도 공부 열심히 해봅시다🐨\n",
    "\n",
    "### 5.1 urllib과 BeautifulSoup으로 사이트에 접근하기 \n",
    "\n",
    "urllib과 BeautifulSoup으로 시카고 샌드위치 맛집 랭킹을 알려주는 사이트를 불러와 볼게요. 여기에서는 가게이름, 가게 메인 메뉴, 각 가게 소개 페이지를 가져와 볼거에요. 우선 필요한 모듈들을 모두 import 해봅시다.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from urllib.request import urlopen \n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- [시카고 샌드위치 맛집 사이트](https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-Chicago/)\n",
    "\n",
    "교재에서는 url을 두 부분으로 나누어 놓았어요. 후에 상대주소를 절대주소 바꾸기 위해서 이렇게 하는 것이 필요해요. (자세한 설명은 후에 상대주소/절대주소를 나눌 때 설명할게요.) 이렇게 하고 html을 읽어와 보기로 해요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_base = 'https://www.chicagomag.com'\n",
    "url_sub = '/Chicago-Magazine/November-2012/Best-Sandwiches-Chicago/'\n",
    "url = url_base + url_sub\n",
    "html = urlopen(url)\n",
    "\n",
    "soup = BeautifulSoup(html, 'html.parser')\n",
    "# soup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 불러와졌는지 확인해보는 것을 잊지 말구요. 그 다음 크롬의 개발자 도구를 확인해 우선 1위의 BLT와 다른 정보들이 담겨있는 태그와 클라스가 무엇인지 확인해봅니다. div 태그에 class는 sammy네요. find_all을 사용해 가져와볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "lists = soup.find_all('div', class_='sammy')\n",
    "# lists"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 불러와졌네요! 1) 샌드위치 이름 2) 샌드위치 가게 이름 3) 사이트 주소 4) 랭킹까지 모두 들어있죠? 그런데 너무 다양하게 많이 적혀져 있으니, 이름만 우선 get_text()로 모두 가져와 볼게요. for문으로 이를 출력해보겠습니다. len()을 사용해 정확히 50개가 맞는지도 살펴보구요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "1\n",
      "BLT\r\n",
      "Old Oak Tap\n",
      "Read more \n",
      "\n",
      "\n",
      "2\n",
      "Fried Bologna\r\n",
      "Au Cheval\n",
      "Read more \n",
      "\n",
      "\n",
      "3\n",
      "Woodland Mushroom\r\n",
      "Xoco\n",
      "Read more \n",
      "\n",
      "\n",
      "4\n",
      "Roast Beef\r\n",
      "Al’s Deli\n",
      "Read more \n",
      "\n",
      "\n",
      "5\n",
      "PB&L\r\n",
      "Publican Quality Meats\n",
      "Read more \n",
      "\n"
     ]
    }
   ],
   "source": [
    "for list in lists[:5]: \n",
    "    print(list.get_text())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(lists)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 뽑아낸 것 같습니다. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5.2 접근한 웹 페이지에서 원하는 데이터 추출, 정리하기\n",
    "\n",
    "데이터를 가져와 dataframe에 넣어보겠습니다. div의 sammy에서 각각의 정보들을 정확히 꺼내어보죠."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "bs4.element.Tag"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one = soup.find_all('div', 'sammy')[0]\n",
    "type(tmp_one)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<div class=\"sammy\" style=\"position: relative;\">\n",
       "<div class=\"sammyRank\">1</div>\n",
       "<div class=\"sammyListing\"><a href=\"/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/\"><b>BLT</b><br>\n",
       "Old Oak Tap<br>\n",
       "<em>Read more</em> </br></br></a></div>\n",
       "</div>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "첫번째만 가져와서 생각해보면, type이 tag이기 때문에 여기에도 바로 find를 사용할 수 있어요. 여기에 링크가 들어있는 class를 크롬 개발자 도구로 보니 'sammyRank'에요. 가져와서 제대로 뽑아 봤나 볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<div class=\"sammyRank\">1</div>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one.find(class_='sammyRank')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그럼 안에 있는 정보만 가져와볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1'"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one.find(class_='sammyRank').get_text() # .string도 가능"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그 다음으로는 메뉴 이름과 가게 이름을 얻어볼게요. 클라스 이름이 'sammyListing'이네요. (크롬 개발자 도구로 반드시 태그를 확인해보세요!) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BLT\\r\\nOld Oak Tap\\nRead more '"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one.find(class_='sammyListing').get_text()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "엇, 나오긴 나왔는데 우리가 의도한대로 나오지 않았네요. 아주 조금 있다가 보기로 하고, 지금은 그 다음 url 주소를 확인해봅시다. 아래를 보면, 이건 get_text로 얻을 수 있는게 아니라 a 태그의 href에 들어있어요. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<div class=\"sammy\" style=\"position: relative;\">\n",
       "<div class=\"sammyRank\">1</div>\n",
       "<div class=\"sammyListing\"><a href=\"/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/\"><b>BLT</b><br>\n",
       "Old Oak Tap<br>\n",
       "<em>Read more</em> </br></br></a></div>\n",
       "</div>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그래서 가져올 때는 이렇게 아래와 같이 가져와야 합니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/'"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one.find('a')['href']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "근데 주소가 끊겨져 있는 것 같죠? 앞에 https://www.chicagomag.com 가 있어야 바로 사이트가 연결이 되어요. 이렇게 적혀있는 부분들을 '상대주소'라고 해요. 모두 적혀져 있어 사이트로 바로 연결되는 주소를 '절대주소'라고 하구요. \n",
    "\n",
    "다시 돌아가, 제대로 샌드위치 이름과 가게 이름을 구해 봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BLT\\r\\nOld Oak Tap\\nRead more '"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_one.find(class_='sammyListing').get_text()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 정규 표현식 활용해 데이터 가공하기\n",
    "\n",
    "구조를 보면 맨 앞에가 샌드위치 이름, 중간이 샌드위치 가게 이름이네요. 이를 분리하기 위해서 우리는 지난 시간에 배운 '정규 표현식'을 활용해 볼 겁니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['BLT', 'Old Oak Tap', 'Read more ']"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re \n",
    "\n",
    "tmp_string = tmp_one.find(class_='sammyListing').get_text()\n",
    "\n",
    "re.split('\\r\\n|\\n', tmp_string)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "정규표현식이 기억나지 않는다면, 다시 돌아가 봐야겠죠? \\r\\n과 \\n 둘 중 하나라도 있으면 split 해줘라 라고 명령을 해줬습니다. 잘 분리를 해줬네요ㅎㅎ 리스트로 담겨져 있으니까 아래와 같이 샌드위치 이름과 가게 이름을 분리하면 됩니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BLT'"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 샌드위치 이름\n",
    "re.split('\\r\\n|\\n', tmp_string)[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Old Oak Tap'"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 샌드위치 가게 이름\n",
    "re.split('\\r\\n|\\n', tmp_string)[1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 절대경로와 상대경로 \n",
    "\n",
    "앞서 상대경로, 절대경로에 대한 설명을 잠깐 드렸는데요. 더 정확하게 이해를 하기 위해서 샌드위치 페이지에 있는 모든 url들을 가져와 볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Au-Cheval-Fried-Bologna/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Xoco-Woodland-Mushroom/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Als-Deli-Roast-Beef/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Publican-Quality-Meats-PB-L/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Hendrickx-Belgian-Bread-Crafter-Belgian-Chicken-Curry-Salad/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Acadia-Lobster-Roll/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Birchwood-Kitchen-Smoked-Salmon-Salad/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Cemitas-Puebla-Atomica-Cemitas/\n",
      "/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Nana-Grilled-Laughing-Bird-Shrimp-and-Fried-Oyster-Po-Boy/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Lula-Cafe-Ham-and-Raclette-Panino/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Ricobenes-Breaded-Steak/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Frog-n-Snail-The-Hawkeye/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Crosbys-Kitchen-Chicken-Dip/\n",
      "http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Longman-and-Eagle-Wild-Boar-Sloppy-Joe/\n"
     ]
    }
   ],
   "source": [
    "# 상대경로와 절대경로 - 그냥 검은색으로 되어 있는 부분은 상대경로, 링크로 되어 있는 것은 절대경로 \n",
    "address_all = soup.find_all('div', 'sammy')\n",
    "for item in address_all[:15]: \n",
    "    print(item.find('a')['href'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "15줄만 뽑아 보았는데, 여기서 상대경로로 된 부분들이 많죠? 이것 이용해 바로 사이트를 열려면, 앞에 https://www.chicagomag.com 을 붙여주어야 합니다. 이렇게 묶어주기 위해서 urllib에 있는 urljoin을 사용할 거에요. 이 함수는 절대 경로라면 냅두고, 상대경로에만 앞의 주소를 붙여서 절대 경로로 전환시켜줘요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'http://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Longman-and-Eagle-Wild-Boar-Sloppy-Joe/'"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from urllib.parse import urljoin\n",
    "\n",
    "urljoin('https://www.chicagomag.com', item.find('a')['href'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그러면 이제 모든 정보들을 가져와 보겠습니다. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "rank = []\n",
    "main_menu = []\n",
    "cafe_name = []\n",
    "url_add =[]\n",
    "\n",
    "list_soup = soup.find_all('div', 'sammy')\n",
    "\n",
    "for item in list_soup:\n",
    "    rank.append(item.find(class_='sammyRank').get_text())\n",
    "    \n",
    "    tmp_string = item.find(class_='sammyListing').get_text()\n",
    "    \n",
    "    main_menu.append(re.split(('\\n|\\r\\n'), tmp_string)[0])\n",
    "    cafe_name.append(re.split(('\\n|\\r\\n'), tmp_string)[1])\n",
    "    \n",
    "    url_add.append(urljoin(url_base, item.find('a')['href']))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "제대로 가져와졌는지 확인을 해보겠습니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1', '2', '3', '4', '5']"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rank[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['BLT', 'Fried Bologna', 'Woodland Mushroom', 'Roast Beef', 'PB&L']"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_menu[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Old Oak Tap', 'Au Cheval', 'Xoco', 'Al’s Deli', 'Publican Quality Meats']"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cafe_name[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/',\n",
       " 'https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Au-Cheval-Fried-Bologna/',\n",
       " 'https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Xoco-Woodland-Mushroom/',\n",
       " 'https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Als-Deli-Roast-Beef/',\n",
       " 'https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Publican-Quality-Meats-PB-L/']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_add[:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "개수도 50개가 맞는지 확인해볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(50, 50, 50, 50)"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(rank), len(main_menu), len(cafe_name), len(url_add)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### DataFrame에 정보 담기 \n",
    "\n",
    "이렇게 웹 크롤링을 통해 구한 정보들을 모두 데이터 프레임에 담아 둡시다. 이제는 pandas의 DataFrame이 친숙하죠?ㅎㅎ "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Menu</th>\n",
       "      <th>Cafe</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>BLT</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rank               Menu                    Cafe  \\\n",
       "0    1                BLT             Old Oak Tap   \n",
       "1    2      Fried Bologna               Au Cheval   \n",
       "2    3  Woodland Mushroom                    Xoco   \n",
       "3    4         Roast Beef               Al’s Deli   \n",
       "4    5               PB&L  Publican Quality Meats   \n",
       "\n",
       "                                                 URL  \n",
       "0  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "1  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "2  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "3  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "4  https://www.chicagomag.com/Chicago-Magazine/No...  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd \n",
    "\n",
    "data = {'Rank': rank, 'Menu':main_menu, 'Cafe':cafe_name, 'URL':url_add}\n",
    "df = pd.DataFrame(data)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "예히, 정보들이 잘 담겼네요. 우리가 원하는 칼럼 순으로 정보를 저장해주려면 아래와 같이 하면 됩니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Cafe</th>\n",
       "      <th>Menu</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>BLT</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rank                    Cafe               Menu  \\\n",
       "0    1             Old Oak Tap                BLT   \n",
       "1    2               Au Cheval      Fried Bologna   \n",
       "2    3                    Xoco  Woodland Mushroom   \n",
       "3    4               Al’s Deli         Roast Beef   \n",
       "4    5  Publican Quality Meats               PB&L   \n",
       "\n",
       "                                                 URL  \n",
       "0  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "1  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "2  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "3  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "4  https://www.chicagomag.com/Chicago-Magazine/No...  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df[['Rank','Cafe','Menu','URL']]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 되었으니, 이를 우리 csv에다 저장해 둡니다. 이렇게 중간 저장을 잘 해놓지 않으면, 정보가 날라가 버리는 것은 당연하고, 웹 크롤링하는데 시간이 너무 많이 걸리면 다시 하기가 또 곤란해져요. 그러니 중간 저장을 습관화 해두는 것이 좋습니다. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('03. best_sandwiches_list_chicago.csv', sep=',', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "이렇게 무사히 저장까지 해보았습니다. \n",
    "\n",
    "### 5.3 다수의 웹페이지에서 정보 가져오기 \n",
    "\n",
    "여기까지는 가게 이름, 가게의 샌드위치 이름, 정보들이 더 담겨있는 url 주소까지 모두 확인해보았습니다. \n",
    "\n",
    "- [Old Oak Tap BLT](https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/)\n",
    "\n",
    "이 페이지를 살펴보면, 아래에 '가격'과 '주소'가 적혀져 있습니다. 그러니 여기에서 각각 가격과 주소를 얻어보도록 하겠습니다. 또 개발자 도구를 사용해 이 정보가 들어있는 태그를 확인해봅시다. 보니 p 태그에 addy class네요.\n",
    "\n",
    "우선 그 전에 우리가 저장한 csv 파일을 불러와보겠습니다. 필요한 모듈들도 함께 뽑아와 보구요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Cafe</th>\n",
       "      <th>Menu</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>BLT</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Cafe               Menu  \\\n",
       "0     1             Old Oak Tap                BLT   \n",
       "1     2               Au Cheval      Fried Bologna   \n",
       "2     3                    Xoco  Woodland Mushroom   \n",
       "3     4               Al’s Deli         Roast Beef   \n",
       "4     5  Publican Quality Meats               PB&L   \n",
       "\n",
       "                                                 URL  \n",
       "0  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "1  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "2  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "3  https://www.chicagomag.com/Chicago-Magazine/No...  \n",
       "4  https://www.chicagomag.com/Chicago-Magazine/No...  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup \n",
    "from urllib.request import urlopen \n",
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('03. best_sandwiches_list_chicago.csv', encoding='utf-8', index_col=0)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "첫번째 사이트부터 들어가보면, 아까 들어있는 태그가 p 태그에 addy class죠? "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://www.chicagomag.com/Chicago-Magazine/November-2012/Best-Sandwiches-in-Chicago-Old-Oak-Tap-BLT/'"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['URL'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "html = urlopen(df['URL'][0])\n",
    "soup = BeautifulSoup(html, 'html.parser')\n",
    "\n",
    "# soup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "여기에서 가격과 주소가 들어있는 곳만 뽑아와 보면!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<p class=\"addy\">\n",
       "<em>$10. 2109 W. Chicago Ave., 773-772-0406, <a href=\"http://www.theoldoaktap.com/\">theoldoaktap.com</a></em></p>"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "soup.find('p', class_='addy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\n$10. 2109 W. Chicago Ave., 773-772-0406, theoldoaktap.com'"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_tmp = soup.find('p', class_='addy').get_text()\n",
    "price_tmp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "이 정보를 또 쪼개봐야지요. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['$10.', '2109', 'W.', 'Chicago', 'Ave.,', '773-772-0406,', 'theoldoaktap.com']"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_tmp.split()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'$10.'"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_tmp.split()[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "가격에 .이 붙어있으니까 점을 없애보죠."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'$10'"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_tmp.split()[0][:-1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그럼 이제는 주소를 한 번 봅시다. 이것을 보면, 항상 뒤에서 두개를 제외하고까지가 주소인 것을 알 수 있습니다. (다른 주소들도 확인해보세요.)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['$10.', '2109', 'W.', 'Chicago', 'Ave.,', '773-772-0406,', 'theoldoaktap.com']"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_tmp.split()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2109', 'W.', 'Chicago', 'Ave.,']"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 주소만 가져오기\n",
    "price_tmp.split()[1:-2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "주소만 가져와봤는데, 이것이 다 따로따로 떨여져 있죠? 이것을 하나로 합하려면 join 함수를 사용하면 됩니다. \n",
    "\n",
    "- [파이썬 join 함수](https://wikidocs.net/13#join)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2109 W. Chicago Ave.,'"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "' '.join(price_tmp.split()[1:-2])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그럼 이제 주소는 해결이 됐고, 가격과 주소가 잘 뽑아지는지 3개만 뽑아서 확인을 해보겠습니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "price = []\n",
    "address =[]\n",
    "\n",
    "for n in df.index[:3]:\n",
    "    html = urlopen(df['URL'][n])\n",
    "    soup_tmp = BeautifulSoup(html, 'html.parser')\n",
    "\n",
    "    gettings = soup_tmp.find('p', 'addy').get_text()\n",
    "    price.append(gettings.split()[0][:-1])\n",
    "    address.append(' '.join(gettings.split()[1:-2]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['$10', '$9', '$9.50']"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2109 W. Chicago Ave.,', '800 W. Randolph St.,', '445 N. Clark St.,']"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 나오네요! \n",
    "\n",
    "### 5.4 tqdm 모듈을 사용해 50 페이지에 접근하기\n",
    "\n",
    "tqdm은 웹 크롤링할 때 상태 진행이 어떻게 되는지 알려주는 바형태의 시각화입니다. 앞서 뽑아낼 정보들이 50페이지를 모두 확인해보면서 추출하는 것이기 때문에 이렇게 얼마나 진행되었는지 알려주는 것이 있으면, 더 편하게 정보를 얻을 수 있겠죠. \n",
    "\n",
    "- terminal에서 conda install -c conda-forge tqdm 해주기\n",
    "\n",
    "아래와 같이 tqdm을 import 해주고, 앞서 한 대로 50 페이지를 모두 들어가 가격과 주소를 가져와 보도록 하죠. (코드를 그냥 쓰기 전에 먼저 코드를 어떻게 쓸 지 생각해보고 보는 것이 좋습니다)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "5f0ab302be9243e095f9ab3846b1931f",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HBox(children=(IntProgress(value=0, max=50), HTML(value='')))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "from tqdm import tqdm_notebook\n",
    "\n",
    "price = []\n",
    "address = []\n",
    "\n",
    "for n in tqdm_notebook(df.index): \n",
    "    html = urlopen(df['URL'][n])\n",
    "    soup_tmp = BeautifulSoup(html, 'html.parser')\n",
    "\n",
    "    gettings = soup_tmp.find('p', 'addy').get_text()\n",
    "    price.append(gettings.split()[0][:-1])\n",
    "    address.append(' '.join(gettings.split()[1:-2]))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "정말 오래 걸리죠? 제대로 가져와봤는지 확인해봅시다. (제대로 안 됐으면 완전 짱나겠죠ㅎㅎ) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['$10', '$9', '$9.50', '$9.40', '$10', '$7.25', '$16', '$10', '$9', '$17']"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2109 W. Chicago Ave.,',\n",
       " '800 W. Randolph St.,',\n",
       " '445 N. Clark St.,',\n",
       " '914 Noyes St., Evanston,',\n",
       " '825 W. Fulton Mkt.,',\n",
       " '100 E. Walton',\n",
       " '1639 S. Wabash Ave.,',\n",
       " '2211 W. North Ave.,',\n",
       " '3619 W. North Ave.,',\n",
       " '3267 S. Halsted St.,',\n",
       " '2537 N. Kedzie Blvd.,',\n",
       " 'Multiple',\n",
       " '3124 N. Broadway,',\n",
       " '3455 N. Southport Ave.,',\n",
       " '2657 N. Kedzie Ave.,',\n",
       " '1120 W. Grand Ave.,',\n",
       " '1141 S. Jefferson St.,',\n",
       " '333 E. Benton Pl.,',\n",
       " '1411 N. Wells St.,',\n",
       " '1747 N. Damen Ave.,',\n",
       " '3209 W. Irving Park',\n",
       " 'Multiple',\n",
       " '5347 N. Clark St.,',\n",
       " '2954 W. Irving Park Rd.,',\n",
       " 'Multiple',\n",
       " '191 Skokie Valley Rd., Highland Park,',\n",
       " 'Multiple',\n",
       " '1818 W. Wilson Ave.,',\n",
       " '2517 W. Division St.,',\n",
       " '218 W. Kinzie']"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "address[:30]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "어, 그런데 여기 multiple이란게 있죠. 샌드위치 가게가 체인점이라 여러군데에 있나봐요. 일단 이것을 알아두시고 어떻게 처리할 지 고민을 해봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(50, 50)"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(price), len(address)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "와핫, 다 잘 가져온 것 같네요. (여러분들은 price와 address를 모두 확인해보세요~) 이 정보들을 데이터프레임에 새로운 컬럼에 넣어볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Cafe</th>\n",
       "      <th>Menu</th>\n",
       "      <th>URL</th>\n",
       "      <th>Price</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>BLT</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>2109 W. Chicago Ave.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9</td>\n",
       "      <td>800 W. Randolph St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.50</td>\n",
       "      <td>445 N. Clark St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.40</td>\n",
       "      <td>914 Noyes St., Evanston,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>825 W. Fulton Mkt.,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                    Cafe               Menu  \\\n",
       "0     1             Old Oak Tap                BLT   \n",
       "1     2               Au Cheval      Fried Bologna   \n",
       "2     3                    Xoco  Woodland Mushroom   \n",
       "3     4               Al’s Deli         Roast Beef   \n",
       "4     5  Publican Quality Meats               PB&L   \n",
       "\n",
       "                                                 URL  Price  \\\n",
       "0  https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "1  https://www.chicagomag.com/Chicago-Magazine/No...     $9   \n",
       "2  https://www.chicagomag.com/Chicago-Magazine/No...  $9.50   \n",
       "3  https://www.chicagomag.com/Chicago-Magazine/No...  $9.40   \n",
       "4  https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "\n",
       "                    Address  \n",
       "0     2109 W. Chicago Ave.,  \n",
       "1      800 W. Randolph St.,  \n",
       "2         445 N. Clark St.,  \n",
       "3  914 Noyes St., Evanston,  \n",
       "4       825 W. Fulton Mkt.,  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Price'] = price \n",
    "df['Address'] = address\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "유후, 잘 됐구요! 깔끔하게 Rank를 index로 넣어봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Cafe</th>\n",
       "      <th>Menu</th>\n",
       "      <th>URL</th>\n",
       "      <th>Price</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>BLT</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>2109 W. Chicago Ave.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9</td>\n",
       "      <td>800 W. Randolph St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.50</td>\n",
       "      <td>445 N. Clark St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.40</td>\n",
       "      <td>914 Noyes St., Evanston,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>825 W. Fulton Mkt.,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Cafe               Menu  \\\n",
       "Rank                                              \n",
       "1                Old Oak Tap                BLT   \n",
       "2                  Au Cheval      Fried Bologna   \n",
       "3                       Xoco  Woodland Mushroom   \n",
       "4                  Al’s Deli         Roast Beef   \n",
       "5     Publican Quality Meats               PB&L   \n",
       "\n",
       "                                                    URL  Price  \\\n",
       "Rank                                                             \n",
       "1     https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "2     https://www.chicagomag.com/Chicago-Magazine/No...     $9   \n",
       "3     https://www.chicagomag.com/Chicago-Magazine/No...  $9.50   \n",
       "4     https://www.chicagomag.com/Chicago-Magazine/No...  $9.40   \n",
       "5     https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "\n",
       "                       Address  \n",
       "Rank                            \n",
       "1        2109 W. Chicago Ave.,  \n",
       "2         800 W. Randolph St.,  \n",
       "3            445 N. Clark St.,  \n",
       "4     914 Noyes St., Evanston,  \n",
       "5          825 W. Fulton Mkt.,  "
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('Rank', inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "자, 또 우리의 정신 건강을 위해서! 중간 저장하는 것을 잊지 마세요!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('03. best_sandwitches_list_chicago2.csv', sep=',', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5.5 Google Maps와 Folium으로 맛집 지도 표기 \n",
    "\n",
    "필요한 모듈들을 다 import 하구요, 데이터도 다시 불러와봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import googlemaps \n",
    "import folium\n",
    "from tqdm import tqdm_notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Cafe</th>\n",
       "      <th>Menu</th>\n",
       "      <th>URL</th>\n",
       "      <th>Price</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Old Oak Tap</td>\n",
       "      <td>BLT</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>2109 W. Chicago Ave.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Au Cheval</td>\n",
       "      <td>Fried Bologna</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9</td>\n",
       "      <td>800 W. Randolph St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Xoco</td>\n",
       "      <td>Woodland Mushroom</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.50</td>\n",
       "      <td>445 N. Clark St.,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Al’s Deli</td>\n",
       "      <td>Roast Beef</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$9.40</td>\n",
       "      <td>914 Noyes St., Evanston,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Publican Quality Meats</td>\n",
       "      <td>PB&amp;L</td>\n",
       "      <td>https://www.chicagomag.com/Chicago-Magazine/No...</td>\n",
       "      <td>$10</td>\n",
       "      <td>825 W. Fulton Mkt.,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Cafe               Menu  \\\n",
       "Rank                                              \n",
       "1                Old Oak Tap                BLT   \n",
       "2                  Au Cheval      Fried Bologna   \n",
       "3                       Xoco  Woodland Mushroom   \n",
       "4                  Al’s Deli         Roast Beef   \n",
       "5     Publican Quality Meats               PB&L   \n",
       "\n",
       "                                                    URL  Price  \\\n",
       "Rank                                                             \n",
       "1     https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "2     https://www.chicagomag.com/Chicago-Magazine/No...     $9   \n",
       "3     https://www.chicagomag.com/Chicago-Magazine/No...  $9.50   \n",
       "4     https://www.chicagomag.com/Chicago-Magazine/No...  $9.40   \n",
       "5     https://www.chicagomag.com/Chicago-Magazine/No...    $10   \n",
       "\n",
       "                       Address  \n",
       "Rank                            \n",
       "1        2109 W. Chicago Ave.,  \n",
       "2         800 W. Randolph St.,  \n",
       "3            445 N. Clark St.,  \n",
       "4     914 Noyes St., Evanston,  \n",
       "5          825 W. Fulton Mkt.,  "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('03. best_sandwitches_list_chicago2.csv', index_col=0)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "구글 맵스를 활용해 경도와 위도 정보를 얻어야 지도에 시각화할 수 있겠죠. 지난 번에 얻었던 구글 키를 다시 활용하여 정보를 얻어봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "gmaps_key = 'AIzaSyCZxESH7tbF2nFO7gou4y_zUKOGZzTZ11A'\n",
    "gmaps = googlemaps.Client(key=gmaps_key)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "아래 주소는 df의 주소에 시카고라는 주소를 추가한 겁니다. 더 정확한 정보를 얻을 수 있겠죠."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'address_components': [{'long_name': '2109',\n",
       "    'short_name': '2109',\n",
       "    'types': ['street_number']},\n",
       "   {'long_name': 'West Chicago Avenue',\n",
       "    'short_name': 'W Chicago Ave',\n",
       "    'types': ['route']},\n",
       "   {'long_name': 'West Town',\n",
       "    'short_name': 'West Town',\n",
       "    'types': ['neighborhood', 'political']},\n",
       "   {'long_name': 'Chicago',\n",
       "    'short_name': 'Chicago',\n",
       "    'types': ['locality', 'political']},\n",
       "   {'long_name': 'Cook County',\n",
       "    'short_name': 'Cook County',\n",
       "    'types': ['administrative_area_level_2', 'political']},\n",
       "   {'long_name': 'Illinois',\n",
       "    'short_name': 'IL',\n",
       "    'types': ['administrative_area_level_1', 'political']},\n",
       "   {'long_name': 'United States',\n",
       "    'short_name': 'US',\n",
       "    'types': ['country', 'political']},\n",
       "   {'long_name': '60622', 'short_name': '60622', 'types': ['postal_code']},\n",
       "   {'long_name': '4821',\n",
       "    'short_name': '4821',\n",
       "    'types': ['postal_code_suffix']}],\n",
       "  'formatted_address': '2109 W Chicago Ave, Chicago, IL 60622, USA',\n",
       "  'geometry': {'location': {'lat': 41.8956049, 'lng': -87.67996149999999},\n",
       "   'location_type': 'ROOFTOP',\n",
       "   'viewport': {'northeast': {'lat': 41.8969538802915,\n",
       "     'lng': -87.67861251970848},\n",
       "    'southwest': {'lat': 41.8942559197085, 'lng': -87.6813104802915}}},\n",
       "  'place_id': 'ChIJw8Al2kotDogRnCJTS_Ydiws',\n",
       "  'plus_code': {'compound_code': 'V8WC+62 Chicago, Illinois, United States',\n",
       "   'global_code': '86HJV8WC+62'},\n",
       "  'types': ['street_address']}]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "target_name = df['Address'][1] + ', ' + 'Chicago'\n",
    "gmaps_output = gmaps.geocode(target_name)\n",
    "gmaps_output"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "여기서 경도와 위도는 geometry라는 키에 있습니다. 원하는 정보를 제대로 가져오기 위해서 한번 봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'address_components': [{'long_name': '2109',\n",
       "   'short_name': '2109',\n",
       "   'types': ['street_number']},\n",
       "  {'long_name': 'West Chicago Avenue',\n",
       "   'short_name': 'W Chicago Ave',\n",
       "   'types': ['route']},\n",
       "  {'long_name': 'West Town',\n",
       "   'short_name': 'West Town',\n",
       "   'types': ['neighborhood', 'political']},\n",
       "  {'long_name': 'Chicago',\n",
       "   'short_name': 'Chicago',\n",
       "   'types': ['locality', 'political']},\n",
       "  {'long_name': 'Cook County',\n",
       "   'short_name': 'Cook County',\n",
       "   'types': ['administrative_area_level_2', 'political']},\n",
       "  {'long_name': 'Illinois',\n",
       "   'short_name': 'IL',\n",
       "   'types': ['administrative_area_level_1', 'political']},\n",
       "  {'long_name': 'United States',\n",
       "   'short_name': 'US',\n",
       "   'types': ['country', 'political']},\n",
       "  {'long_name': '60622', 'short_name': '60622', 'types': ['postal_code']},\n",
       "  {'long_name': '4821',\n",
       "   'short_name': '4821',\n",
       "   'types': ['postal_code_suffix']}],\n",
       " 'formatted_address': '2109 W Chicago Ave, Chicago, IL 60622, USA',\n",
       " 'geometry': {'location': {'lat': 41.8956049, 'lng': -87.67996149999999},\n",
       "  'location_type': 'ROOFTOP',\n",
       "  'viewport': {'northeast': {'lat': 41.8969538802915,\n",
       "    'lng': -87.67861251970848},\n",
       "   'southwest': {'lat': 41.8942559197085, 'lng': -87.6813104802915}}},\n",
       " 'place_id': 'ChIJw8Al2kotDogRnCJTS_Ydiws',\n",
       " 'plus_code': {'compound_code': 'V8WC+62 Chicago, Illinois, United States',\n",
       "  'global_code': '86HJV8WC+62'},\n",
       " 'types': ['street_address']}"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmaps_output[0]  #리스트를 벗긴 딕셔너리 형태 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'location': {'lat': 41.8956049, 'lng': -87.67996149999999},\n",
       " 'location_type': 'ROOFTOP',\n",
       " 'viewport': {'northeast': {'lat': 41.8969538802915,\n",
       "   'lng': -87.67861251970848},\n",
       "  'southwest': {'lat': 41.8942559197085, 'lng': -87.6813104802915}}}"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmaps_output[0].get('geometry')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "리스트를 벗기면 딕셔너리 형태가 되니, get을 이용해 경도와 위도 정보가 들어있는 곳까지 왔네요. 그럼 경도와 위도 정보는 아래와 같이 찾으면 됩니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'lat': 41.8956049, 'lng': -87.67996149999999}"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmaps_output[0].get('geometry')['location']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "41.8956049"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmaps_output[0].get('geometry')['location']['lat']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-87.67996149999999"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gmaps_output[0].get('geometry')['location']['lng']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그러면 이제 모두를 가져와 봅시다. 이것도 tqdm 모듈을 활용해 진행상황을 알아볼 겁니다. 그 전에 중요한 것은 우리가 가져온 주소들 중에 Multiple이라 적혀있는 주소들을 어떻게 처리할지입니다. \n",
    "\n",
    "여기에서는 for문을 활용해 multiple이 아닌 위도와 경도 정보를 얻기로 하고, 정보가 없는 것은 넘파이를 활용해 NaN 표시를 해줄 겁니다. (혹은 우리가 배운 예외처리를 활용하여 처리할 수도 있겠죠^^)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "15ebc5e732a94ae98fc07d6ec7f8b852",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HBox(children=(IntProgress(value=0, max=50), HTML(value='')))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "lat = []\n",
    "lng = []\n",
    "\n",
    "for n in tqdm_notebook(df.index):\n",
    "    if df['Address'][n] != 'Multiple':\n",
    "        target_name = df['Address'][n] + ', ' + 'Chicago'\n",
    "        gmaps_output = gmaps.geocode(target_name)\n",
    "        location_output = gmaps_output[0].get('geometry')\n",
    "        lat.append(location_output['location']['lat'])\n",
    "        lng.append(location_output['location']['lng'])\n",
    "    else: \n",
    "        lat.append(np.nan)\n",
    "        lng.append(np.nan)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 뽑아졌는지 몇개만 볼게요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "([41.8956049,\n",
       "  41.8846582,\n",
       "  41.8905226,\n",
       "  42.0583217,\n",
       "  41.8865998,\n",
       "  41.9002501,\n",
       "  41.8590541,\n",
       "  41.9102031,\n",
       "  41.9097558,\n",
       "  41.8345302,\n",
       "  41.9276207,\n",
       "  nan,\n",
       "  41.9384419,\n",
       "  41.9451044,\n",
       "  41.9301107],\n",
       " [-87.67996149999999,\n",
       "  -87.6476668,\n",
       "  -87.6307834,\n",
       "  -87.6837479,\n",
       "  -87.6484514,\n",
       "  -87.6250781,\n",
       "  -87.6252007,\n",
       "  -87.68287529999999,\n",
       "  -87.7176727,\n",
       "  -87.6456492,\n",
       "  -87.706792,\n",
       "  nan,\n",
       "  -87.64464369999999,\n",
       "  -87.6636812,\n",
       "  -87.7072408])"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lat[:15], lng[:15]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "잘 얻어왔으니 데이터프레임에 칼럼으로 추가해봅시다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>41.895605</td>\n",
       "      <td>-87.679961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>41.884658</td>\n",
       "      <td>-87.647667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>41.890523</td>\n",
       "      <td>-87.630783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>42.058322</td>\n",
       "      <td>-87.683748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>41.886600</td>\n",
       "      <td>-87.648451</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            lat        lng\n",
       "Rank                      \n",
       "1     41.895605 -87.679961\n",
       "2     41.884658 -87.647667\n",
       "3     41.890523 -87.630783\n",
       "4     42.058322 -87.683748\n",
       "5     41.886600 -87.648451"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['lat'] = lat \n",
    "df['lng'] = lng\n",
    "df[['lat','lng']].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "그럼 이제 folium으로 지도에 시각화 해볼게요. 먼저는 샌드위치 집들의 위도와 경도의 평균으로 지도를 가져와보겠습니다. 그래야 우리가 원하는 샌드위치 맛집들이 한 면에 들어오겠죠."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><iframe src=\"about:blank\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" data-html=PCFET0NUWVBFIGh0bWw+CjxoZWFkPiAgICAKICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVVURi04IiAvPgogICAgCiAgICAgICAgPHNjcmlwdD4KICAgICAgICAgICAgTF9OT19UT1VDSCA9IGZhbHNlOwogICAgICAgICAgICBMX0RJU0FCTEVfM0QgPSBmYWxzZTsKICAgICAgICA8L3NjcmlwdD4KICAgIAogICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vY2RuLmpzZGVsaXZyLm5ldC9ucG0vbGVhZmxldEAxLjUuMS9kaXN0L2xlYWZsZXQuanMiPjwvc2NyaXB0PgogICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vY29kZS5qcXVlcnkuY29tL2pxdWVyeS0xLjEyLjQubWluLmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9qcy9ib290c3RyYXAubWluLmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9MZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy8yLjAuMi9sZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy5qcyI+PC9zY3JpcHQ+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vY2RuLmpzZGVsaXZyLm5ldC9ucG0vbGVhZmxldEAxLjUuMS9kaXN0L2xlYWZsZXQuY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMi4wL2Nzcy9ib290c3RyYXAubWluLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLXRoZW1lLm1pbi5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9mb250LWF3ZXNvbWUvNC42LjMvY3NzL2ZvbnQtYXdlc29tZS5taW4uY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL0xlYWZsZXQuYXdlc29tZS1tYXJrZXJzLzIuMC4yL2xlYWZsZXQuYXdlc29tZS1tYXJrZXJzLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL3Jhd2Nkbi5naXRoYWNrLmNvbS9weXRob24tdmlzdWFsaXphdGlvbi9mb2xpdW0vbWFzdGVyL2ZvbGl1bS90ZW1wbGF0ZXMvbGVhZmxldC5hd2Vzb21lLnJvdGF0ZS5jc3MiLz4KICAgIDxzdHlsZT5odG1sLCBib2R5IHt3aWR0aDogMTAwJTtoZWlnaHQ6IDEwMCU7bWFyZ2luOiAwO3BhZGRpbmc6IDA7fTwvc3R5bGU+CiAgICA8c3R5bGU+I21hcCB7cG9zaXRpb246YWJzb2x1dGU7dG9wOjA7Ym90dG9tOjA7cmlnaHQ6MDtsZWZ0OjA7fTwvc3R5bGU+CiAgICAKICAgICAgICAgICAgPG1ldGEgbmFtZT0idmlld3BvcnQiIGNvbnRlbnQ9IndpZHRoPWRldmljZS13aWR0aCwKICAgICAgICAgICAgICAgIGluaXRpYWwtc2NhbGU9MS4wLCBtYXhpbXVtLXNjYWxlPTEuMCwgdXNlci1zY2FsYWJsZT1ubyIgLz4KICAgICAgICAgICAgPHN0eWxlPgogICAgICAgICAgICAgICAgI21hcF83OGMwMzIyMDg4ODQ0NDM5OTYwNGIzNjc5MmFkYjZmMSB7CiAgICAgICAgICAgICAgICAgICAgcG9zaXRpb246IHJlbGF0aXZlOwogICAgICAgICAgICAgICAgICAgIHdpZHRoOiAxMDAuMCU7CiAgICAgICAgICAgICAgICAgICAgaGVpZ2h0OiAxMDAuMCU7CiAgICAgICAgICAgICAgICAgICAgbGVmdDogMC4wJTsKICAgICAgICAgICAgICAgICAgICB0b3A6IDAuMCU7CiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIDwvc3R5bGU+CiAgICAgICAgCjwvaGVhZD4KPGJvZHk+ICAgIAogICAgCiAgICAgICAgICAgIDxkaXYgY2xhc3M9ImZvbGl1bS1tYXAiIGlkPSJtYXBfNzhjMDMyMjA4ODg0NDQzOTk2MDRiMzY3OTJhZGI2ZjEiID48L2Rpdj4KICAgICAgICAKPC9ib2R5Pgo8c2NyaXB0PiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFwXzc4YzAzMjIwODg4NDQ0Mzk5NjA0YjM2NzkyYWRiNmYxID0gTC5tYXAoCiAgICAgICAgICAgICAgICAibWFwXzc4YzAzMjIwODg4NDQ0Mzk5NjA0YjM2NzkyYWRiNmYxIiwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBjZW50ZXI6IFs0MS45MjQyNDk3NDA5MDkwOCwgLTg3LjY4MDk3OTcwMjI3MjddLAogICAgICAgICAgICAgICAgICAgIGNyczogTC5DUlMuRVBTRzM4NTcsCiAgICAgICAgICAgICAgICAgICAgem9vbTogMTEsCiAgICAgICAgICAgICAgICAgICAgem9vbUNvbnRyb2w6IHRydWUsCiAgICAgICAgICAgICAgICAgICAgcHJlZmVyQ2FudmFzOiBmYWxzZSwKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKTsKCiAgICAgICAgICAgIAoKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgdGlsZV9sYXllcl9jNDRmYjYxYWRiOTA0ZTZjYjJiOGE0N2Y0ZDRkNjhjZiA9IEwudGlsZUxheWVyKAogICAgICAgICAgICAgICAgImh0dHBzOi8ve3N9LnRpbGUub3BlbnN0cmVldG1hcC5vcmcve3p9L3t4fS97eX0ucG5nIiwKICAgICAgICAgICAgICAgIHsiYXR0cmlidXRpb24iOiAiRGF0YSBieSBcdTAwMjZjb3B5OyBcdTAwM2NhIGhyZWY9XCJodHRwOi8vb3BlbnN0cmVldG1hcC5vcmdcIlx1MDAzZU9wZW5TdHJlZXRNYXBcdTAwM2MvYVx1MDAzZSwgdW5kZXIgXHUwMDNjYSBocmVmPVwiaHR0cDovL3d3dy5vcGVuc3RyZWV0bWFwLm9yZy9jb3B5cmlnaHRcIlx1MDAzZU9EYkxcdTAwM2MvYVx1MDAzZS4iLCAiZGV0ZWN0UmV0aW5hIjogZmFsc2UsICJtYXhOYXRpdmVab29tIjogMTgsICJtYXhab29tIjogMTgsICJtaW5ab29tIjogMCwgIm5vV3JhcCI6IGZhbHNlLCAib3BhY2l0eSI6IDEsICJzdWJkb21haW5zIjogImFiYyIsICJ0bXMiOiBmYWxzZX0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfNzhjMDMyMjA4ODg0NDQzOTk2MDRiMzY3OTJhZGI2ZjEpOwogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfZDg1MzRkZDgyNDA3NDBhMmI4ZGY3ZGZkNmQxNDM1ZDMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS45MjQyNDk3NDA5MDkwOCwgLTg3LjY4MDk3OTcwMjI3MjddLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfNzhjMDMyMjA4ODg0NDQzOTk2MDRiMzY3OTJhZGI2ZjEpOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwX2M4ZTg0Njk3NzMxOTQxNDBiN2JmZjljMjFkYTRkNDlkID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF9kZDkxNTc5ODY0Mzk0M2QzOWIyNTk0YWRiOTRhMDZkMCA9ICQoYDxkaXYgaWQ9Imh0bWxfZGQ5MTU3OTg2NDM5NDNkMzliMjU5NGFkYjk0YTA2ZDAiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPmNlbnRlcjwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9jOGU4NDY5NzczMTk0MTQwYjdiZmY5YzIxZGE0ZDQ5ZC5zZXRDb250ZW50KGh0bWxfZGQ5MTU3OTg2NDM5NDNkMzliMjU5NGFkYjk0YTA2ZDApOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfZDg1MzRkZDgyNDA3NDBhMmI4ZGY3ZGZkNmQxNDM1ZDMuYmluZFBvcHVwKHBvcHVwX2M4ZTg0Njk3NzMxOTQxNDBiN2JmZjljMjFkYTRkNDlkKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKPC9zY3JpcHQ+ onload=\"this.contentDocument.open();this.contentDocument.write(atob(this.getAttribute('data-html')));this.contentDocument.close();\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x115fe7ad0>"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapping = folium.Map(location=[df['lat'].mean(), df['lng'].mean()], \n",
    "                                      zoom_start=11)\n",
    "folium.Marker([df['lat'].mean(), df['lng'].mean()], \n",
    "                                      popup='center').add_to(mapping)\n",
    "mapping"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "marker를 사용해 center를 표시해주었습니다. popup은 marker 클릭 시 나오는 이름을 설정해주는 거에요.\n",
    "\n",
    "그럼 for문을 사용해 주소가 Multiple이 아닐 경우에만 지도에 표기하도록 하겠습니다. popup으로 샌드위치 맛집의 이름도 표기해주고요."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><iframe src=\"about:blank\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" data-html=PCFET0NUWVBFIGh0bWw+CjxoZWFkPiAgICAKICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVVURi04IiAvPgogICAgCiAgICAgICAgPHNjcmlwdD4KICAgICAgICAgICAgTF9OT19UT1VDSCA9IGZhbHNlOwogICAgICAgICAgICBMX0RJU0FCTEVfM0QgPSBmYWxzZTsKICAgICAgICA8L3NjcmlwdD4KICAgIAogICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vY2RuLmpzZGVsaXZyLm5ldC9ucG0vbGVhZmxldEAxLjUuMS9kaXN0L2xlYWZsZXQuanMiPjwvc2NyaXB0PgogICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vY29kZS5qcXVlcnkuY29tL2pxdWVyeS0xLjEyLjQubWluLmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9qcy9ib290c3RyYXAubWluLmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9MZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy8yLjAuMi9sZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy5qcyI+PC9zY3JpcHQ+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vY2RuLmpzZGVsaXZyLm5ldC9ucG0vbGVhZmxldEAxLjUuMS9kaXN0L2xlYWZsZXQuY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vYm9vdHN0cmFwLzMuMi4wL2Nzcy9ib290c3RyYXAubWluLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLXRoZW1lLm1pbi5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9mb250LWF3ZXNvbWUvNC42LjMvY3NzL2ZvbnQtYXdlc29tZS5taW4uY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL0xlYWZsZXQuYXdlc29tZS1tYXJrZXJzLzIuMC4yL2xlYWZsZXQuYXdlc29tZS1tYXJrZXJzLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL3Jhd2Nkbi5naXRoYWNrLmNvbS9weXRob24tdmlzdWFsaXphdGlvbi9mb2xpdW0vbWFzdGVyL2ZvbGl1bS90ZW1wbGF0ZXMvbGVhZmxldC5hd2Vzb21lLnJvdGF0ZS5jc3MiLz4KICAgIDxzdHlsZT5odG1sLCBib2R5IHt3aWR0aDogMTAwJTtoZWlnaHQ6IDEwMCU7bWFyZ2luOiAwO3BhZGRpbmc6IDA7fTwvc3R5bGU+CiAgICA8c3R5bGU+I21hcCB7cG9zaXRpb246YWJzb2x1dGU7dG9wOjA7Ym90dG9tOjA7cmlnaHQ6MDtsZWZ0OjA7fTwvc3R5bGU+CiAgICAKICAgICAgICAgICAgPG1ldGEgbmFtZT0idmlld3BvcnQiIGNvbnRlbnQ9IndpZHRoPWRldmljZS13aWR0aCwKICAgICAgICAgICAgICAgIGluaXRpYWwtc2NhbGU9MS4wLCBtYXhpbXVtLXNjYWxlPTEuMCwgdXNlci1zY2FsYWJsZT1ubyIgLz4KICAgICAgICAgICAgPHN0eWxlPgogICAgICAgICAgICAgICAgI21hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCB7CiAgICAgICAgICAgICAgICAgICAgcG9zaXRpb246IHJlbGF0aXZlOwogICAgICAgICAgICAgICAgICAgIHdpZHRoOiAxMDAuMCU7CiAgICAgICAgICAgICAgICAgICAgaGVpZ2h0OiAxMDAuMCU7CiAgICAgICAgICAgICAgICAgICAgbGVmdDogMC4wJTsKICAgICAgICAgICAgICAgICAgICB0b3A6IDAuMCU7CiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIDwvc3R5bGU+CiAgICAgICAgCjwvaGVhZD4KPGJvZHk+ICAgIAogICAgCiAgICAgICAgICAgIDxkaXYgY2xhc3M9ImZvbGl1bS1tYXAiIGlkPSJtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzAiID48L2Rpdj4KICAgICAgICAKPC9ib2R5Pgo8c2NyaXB0PiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwID0gTC5tYXAoCiAgICAgICAgICAgICAgICAibWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwIiwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBjZW50ZXI6IFs0MS45MjQyNDk3NDA5MDkwOCwgLTg3LjY4MDk3OTcwMjI3MjddLAogICAgICAgICAgICAgICAgICAgIGNyczogTC5DUlMuRVBTRzM4NTcsCiAgICAgICAgICAgICAgICAgICAgem9vbTogMTEsCiAgICAgICAgICAgICAgICAgICAgem9vbUNvbnRyb2w6IHRydWUsCiAgICAgICAgICAgICAgICAgICAgcHJlZmVyQ2FudmFzOiBmYWxzZSwKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKTsKCiAgICAgICAgICAgIAoKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgdGlsZV9sYXllcl8wNWFiZDMzMWVjYmM0NjIzYTcyOGJkZTRlYmNlZTZlYyA9IEwudGlsZUxheWVyKAogICAgICAgICAgICAgICAgImh0dHBzOi8ve3N9LnRpbGUub3BlbnN0cmVldG1hcC5vcmcve3p9L3t4fS97eX0ucG5nIiwKICAgICAgICAgICAgICAgIHsiYXR0cmlidXRpb24iOiAiRGF0YSBieSBcdTAwMjZjb3B5OyBcdTAwM2NhIGhyZWY9XCJodHRwOi8vb3BlbnN0cmVldG1hcC5vcmdcIlx1MDAzZU9wZW5TdHJlZXRNYXBcdTAwM2MvYVx1MDAzZSwgdW5kZXIgXHUwMDNjYSBocmVmPVwiaHR0cDovL3d3dy5vcGVuc3RyZWV0bWFwLm9yZy9jb3B5cmlnaHRcIlx1MDAzZU9EYkxcdTAwM2MvYVx1MDAzZS4iLCAiZGV0ZWN0UmV0aW5hIjogZmFsc2UsICJtYXhOYXRpdmVab29tIjogMTgsICJtYXhab29tIjogMTgsICJtaW5ab29tIjogMCwgIm5vV3JhcCI6IGZhbHNlLCAib3BhY2l0eSI6IDEsICJzdWJkb21haW5zIjogImFiYyIsICJ0bXMiOiBmYWxzZX0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfNThiODUxYzVhYzI4NDc3NGJkZDEwZThjMzJjMDBkMWUgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44OTU2MDQ5LCAtODcuNjc5OTYxNDk5OTk5OTldLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzU0ZThjNGQ5MjVjYzQxOGM4ZmUxNDZjNzdlZjdmNzQzID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8xNzdiNGZjNjBkZWY0Y2JiOThlZTY0OWQ3N2JkZmU2NSA9ICQoYDxkaXYgaWQ9Imh0bWxfMTc3YjRmYzYwZGVmNGNiYjk4ZWU2NDlkNzdiZGZlNjUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk9sZCBPYWsgVGFwPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzU0ZThjNGQ5MjVjYzQxOGM4ZmUxNDZjNzdlZjdmNzQzLnNldENvbnRlbnQoaHRtbF8xNzdiNGZjNjBkZWY0Y2JiOThlZTY0OWQ3N2JkZmU2NSk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl81OGI4NTFjNWFjMjg0Nzc0YmRkMTBlOGMzMmMwMGQxZS5iaW5kUG9wdXAocG9wdXBfNTRlOGM0ZDkyNWNjNDE4YzhmZTE0NmM3N2VmN2Y3NDMpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfMDBjMWRlMTc5ZTNhNGMwNTg4MGRkMzA2Y2U2ZDg4ZGEgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44ODQ2NTgyLCAtODcuNjQ3NjY2OF0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfMGZkOTM3ZWViNjNmNDFjYmExY2RiMzk3ZjMyZDk5NzYgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sX2E3MDEyYjMxZDIyODQyYTk5ZjE5YWUyMWI4OTJhMTBlID0gJChgPGRpdiBpZD0iaHRtbF9hNzAxMmIzMWQyMjg0MmE5OWYxOWFlMjFiODkyYTEwZSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QXUgQ2hldmFsPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzBmZDkzN2VlYjYzZjQxY2JhMWNkYjM5N2YzMmQ5OTc2LnNldENvbnRlbnQoaHRtbF9hNzAxMmIzMWQyMjg0MmE5OWYxOWFlMjFiODkyYTEwZSk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl8wMGMxZGUxNzllM2E0YzA1ODgwZGQzMDZjZTZkODhkYS5iaW5kUG9wdXAocG9wdXBfMGZkOTM3ZWViNjNmNDFjYmExY2RiMzk3ZjMyZDk5NzYpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfZmE5ODJhMzdlOWJlNDAwNGFlYTRiYTY2Y2Y5N2Y1ZGMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44OTA1MjI2LCAtODcuNjMwNzgzNF0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfMmRkYzE0NjIxNGU1NGFjNGIzYmRiOTllZDZlMmNlYzkgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sX2RiZTdhYzc5OTUzYTRmNTRiYmZiN2YwNWQ3ZTQ2MjcwID0gJChgPGRpdiBpZD0iaHRtbF9kYmU3YWM3OTk1M2E0ZjU0YmJmYjdmMDVkN2U0NjI3MCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+WG9jbzwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8yZGRjMTQ2MjE0ZTU0YWM0YjNiZGI5OWVkNmUyY2VjOS5zZXRDb250ZW50KGh0bWxfZGJlN2FjNzk5NTNhNGY1NGJiZmI3ZjA1ZDdlNDYyNzApOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfZmE5ODJhMzdlOWJlNDAwNGFlYTRiYTY2Y2Y5N2Y1ZGMuYmluZFBvcHVwKHBvcHVwXzJkZGMxNDYyMTRlNTRhYzRiM2JkYjk5ZWQ2ZTJjZWM5KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2Y4OTVlZWZjM2Y5ZjRmYzBhNmUxZGM5NGQ2MzM1ZGUwID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDIuMDU4MzIxNywgLTg3LjY4Mzc0NzldLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwX2JhOTU0YWVlZTI1YTQxZTFhMTVlZThmNjRlNTE1ZTRjID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF9kNzE4Y2IyMGJmOWI0YjIyYjgwNDljNzE1ZmZmNTg0ZCA9ICQoYDxkaXYgaWQ9Imh0bWxfZDcxOGNiMjBiZjliNGIyMmI4MDQ5YzcxNWZmZjU4NGQiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkFs4oCZcyBEZWxpPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwX2JhOTU0YWVlZTI1YTQxZTFhMTVlZThmNjRlNTE1ZTRjLnNldENvbnRlbnQoaHRtbF9kNzE4Y2IyMGJmOWI0YjIyYjgwNDljNzE1ZmZmNTg0ZCk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl9mODk1ZWVmYzNmOWY0ZmMwYTZlMWRjOTRkNjMzNWRlMC5iaW5kUG9wdXAocG9wdXBfYmE5NTRhZWVlMjVhNDFlMWExNWVlOGY2NGU1MTVlNGMpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfNDUyMDJjNThkYzQxNDA0YzlhM2U0YjRiZDdjZDcyMzYgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44ODY1OTk4LCAtODcuNjQ4NDUxNF0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfMzQwMzkyMzMzYmViNDRlNmFkMWI1MTMwNmUxMzE5ODMgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzI4ZDU1Mzg5NDdkOTQ5Njc5ZTVhMzk2NTMwNWUzNzNhID0gJChgPGRpdiBpZD0iaHRtbF8yOGQ1NTM4OTQ3ZDk0OTY3OWU1YTM5NjUzMDVlMzczYSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+UHVibGljYW4gUXVhbGl0eSBNZWF0czwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8zNDAzOTIzMzNiZWI0NGU2YWQxYjUxMzA2ZTEzMTk4My5zZXRDb250ZW50KGh0bWxfMjhkNTUzODk0N2Q5NDk2NzllNWEzOTY1MzA1ZTM3M2EpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfNDUyMDJjNThkYzQxNDA0YzlhM2U0YjRiZDdjZDcyMzYuYmluZFBvcHVwKHBvcHVwXzM0MDM5MjMzM2JlYjQ0ZTZhZDFiNTEzMDZlMTMxOTgzKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2RmZGFhMzliNTQ2YTQwNzg4YzgxMDdkNjJhYTU3ZGI0ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTAwMjUwMSwgLTg3LjYyNTA3ODFdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzE5NzE0YWM5NmJjNzRiNzI5MzIwODk3OTI2NGQ1NmQ4ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF80NzQ1Y2IzMTAxNDM0Zjc5ODJiOTFmMDI5NDE0ZTc0NSA9ICQoYDxkaXYgaWQ9Imh0bWxfNDc0NWNiMzEwMTQzNGY3OTgyYjkxZjAyOTQxNGU3NDUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkhlbmRyaWNreCBCZWxnaWFuIEJyZWFkIENyYWZ0ZXI8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfMTk3MTRhYzk2YmM3NGI3MjkzMjA4OTc5MjY0ZDU2ZDguc2V0Q29udGVudChodG1sXzQ3NDVjYjMxMDE0MzRmNzk4MmI5MWYwMjk0MTRlNzQ1KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2RmZGFhMzliNTQ2YTQwNzg4YzgxMDdkNjJhYTU3ZGI0LmJpbmRQb3B1cChwb3B1cF8xOTcxNGFjOTZiYzc0YjcyOTMyMDg5NzkyNjRkNTZkOCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl8zMzFlOWU0MjVlN2M0MGJiYTIxYmRhOTYyZmI0OTQxYyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg1OTA1NDEsIC04Ny42MjUyMDA3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF83MTVkNGE4NzJlYjM0MDU4YWVmYmUzNDA3OThlYTljZCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfYTM1N2ZiMGJmYmM3NGI1M2JhZWU3YzkzNjhjNzcxMTMgPSAkKGA8ZGl2IGlkPSJodG1sX2EzNTdmYjBiZmJjNzRiNTNiYWVlN2M5MzY4Yzc3MTEzIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5BY2FkaWE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNzE1ZDRhODcyZWIzNDA1OGFlZmJlMzQwNzk4ZWE5Y2Quc2V0Q29udGVudChodG1sX2EzNTdmYjBiZmJjNzRiNTNiYWVlN2M5MzY4Yzc3MTEzKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzMzMWU5ZTQyNWU3YzQwYmJhMjFiZGE5NjJmYjQ5NDFjLmJpbmRQb3B1cChwb3B1cF83MTVkNGE4NzJlYjM0MDU4YWVmYmUzNDA3OThlYTljZCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl9jZDNhY2MyMGI2OTE0YzU4YTJlOWMyNTI1NDFhM2I0OSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkxMDIwMzEsIC04Ny42ODI4NzUyOTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfY2JhYWU5MTkzMzgwNDNjNGJmNWNiYjg4ZjE1ZDMxYmQgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzYxYzVlMDMyNzYxMzQ0MjQ5YWI3N2E3MWI4OTg0YjczID0gJChgPGRpdiBpZD0iaHRtbF82MWM1ZTAzMjc2MTM0NDI0OWFiNzdhNzFiODk4NGI3MyIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QmlyY2h3b29kIEtpdGNoZW48L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfY2JhYWU5MTkzMzgwNDNjNGJmNWNiYjg4ZjE1ZDMxYmQuc2V0Q29udGVudChodG1sXzYxYzVlMDMyNzYxMzQ0MjQ5YWI3N2E3MWI4OTg0YjczKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2NkM2FjYzIwYjY5MTRjNThhMmU5YzI1MjU0MWEzYjQ5LmJpbmRQb3B1cChwb3B1cF9jYmFhZTkxOTMzODA0M2M0YmY1Y2JiODhmMTVkMzFiZCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl83NGQ5NDkwMzQ3YTA0YzZjOGYxOGU2MjRjY2U4ZDUxNCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkwOTc1NTgsIC04Ny43MTc2NzI3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF8zNDlkYTY3NDFkZGY0NzRjYWY4ZGJkY2Y5MjM2OWFjMSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfNTM4MTk3YmE0YjgyNGI4ODk2Y2U2YWEwYTdmM2ViMGYgPSAkKGA8ZGl2IGlkPSJodG1sXzUzODE5N2JhNGI4MjRiODg5NmNlNmFhMGE3ZjNlYjBmIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5DZW1pdGFzIFB1ZWJsYTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8zNDlkYTY3NDFkZGY0NzRjYWY4ZGJkY2Y5MjM2OWFjMS5zZXRDb250ZW50KGh0bWxfNTM4MTk3YmE0YjgyNGI4ODk2Y2U2YWEwYTdmM2ViMGYpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfNzRkOTQ5MDM0N2EwNGM2YzhmMThlNjI0Y2NlOGQ1MTQuYmluZFBvcHVwKHBvcHVwXzM0OWRhNjc0MWRkZjQ3NGNhZjhkYmRjZjkyMzY5YWMxKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzkzNmI5YzlhMzBiNjQ3NDhiNGRkMWM0Y2YzYWEzY2ZmID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuODM0NTMwMiwgLTg3LjY0NTY0OTJdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzJmYzI2MzI0NjgwOTRkYWM4YjFjNGQ5MmY3NTRlMTM1ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8xNmFlOWNlOGFjN2M0NTA5YjEzZjdhZjkzODNmZGNkZiA9ICQoYDxkaXYgaWQ9Imh0bWxfMTZhZTljZThhYzdjNDUwOWIxM2Y3YWY5MzgzZmRjZGYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk5hbmE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfMmZjMjYzMjQ2ODA5NGRhYzhiMWM0ZDkyZjc1NGUxMzUuc2V0Q29udGVudChodG1sXzE2YWU5Y2U4YWM3YzQ1MDliMTNmN2FmOTM4M2ZkY2RmKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzkzNmI5YzlhMzBiNjQ3NDhiNGRkMWM0Y2YzYWEzY2ZmLmJpbmRQb3B1cChwb3B1cF8yZmMyNjMyNDY4MDk0ZGFjOGIxYzRkOTJmNzU0ZTEzNSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl83OTc0OTE1YmQxOGM0YjUxYjQwZTY5N2M4YTQ3YTFmMyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkyNzYyMDcsIC04Ny43MDY3OTJdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzE3NWE4NzhhMmUxYjQ5OWI5YzI3NTA5ZTg2MjIwNzk3ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8yMWVkZGUyZTk1OTU0YTU1OWQyNWQ0ZTVmY2ZkOWQ4YiA9ICQoYDxkaXYgaWQ9Imh0bWxfMjFlZGRlMmU5NTk1NGE1NTlkMjVkNGU1ZmNmZDlkOGIiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkx1bGEgQ2FmZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8xNzVhODc4YTJlMWI0OTliOWMyNzUwOWU4NjIyMDc5Ny5zZXRDb250ZW50KGh0bWxfMjFlZGRlMmU5NTk1NGE1NTlkMjVkNGU1ZmNmZDlkOGIpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfNzk3NDkxNWJkMThjNGI1MWI0MGU2OTdjOGE0N2ExZjMuYmluZFBvcHVwKHBvcHVwXzE3NWE4NzhhMmUxYjQ5OWI5YzI3NTA5ZTg2MjIwNzk3KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzVhY2Q3NjllMWIzZDQxZjY5OTI5NjgyOGFjMjUyYTRiID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTM4NDQxOSwgLTg3LjY0NDY0MzY5OTk5OTk5XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF9mZGFhMjgxYTkzNWI0YTk5YTk2YWUyMTVkYTUwYjlkYSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfOWZiN2UxOWVlNmE0NGM0ODgwOTUwZWM2N2JkMGJiZWYgPSAkKGA8ZGl2IGlkPSJodG1sXzlmYjdlMTllZTZhNDRjNDg4MDk1MGVjNjdiZDBiYmVmIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Gcm9nIG4gU25haWw8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfZmRhYTI4MWE5MzViNGE5OWE5NmFlMjE1ZGE1MGI5ZGEuc2V0Q29udGVudChodG1sXzlmYjdlMTllZTZhNDRjNDg4MDk1MGVjNjdiZDBiYmVmKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzVhY2Q3NjllMWIzZDQxZjY5OTI5NjgyOGFjMjUyYTRiLmJpbmRQb3B1cChwb3B1cF9mZGFhMjgxYTkzNWI0YTk5YTk2YWUyMTVkYTUwYjlkYSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl82NDliY2IyYjQyZWM0MGZkOGQyZTU2YzA0MDBmZjdkYSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjk0NTEwNDQsIC04Ny42NjM2ODEyXSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF8wNjgyY2FkZmM3ODY0ZTdiYmI0YWEzYjljZTAyYzk0MCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfM2IxY2ZhOWNlOGE0NGNhNzgyYzgxMmE2MzY3NDM4MzkgPSAkKGA8ZGl2IGlkPSJodG1sXzNiMWNmYTljZThhNDRjYTc4MmM4MTJhNjM2NzQzODM5IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Dcm9zYnnigJlzIEtpdGNoZW48L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfMDY4MmNhZGZjNzg2NGU3YmJiNGFhM2I5Y2UwMmM5NDAuc2V0Q29udGVudChodG1sXzNiMWNmYTljZThhNDRjYTc4MmM4MTJhNjM2NzQzODM5KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzY0OWJjYjJiNDJlYzQwZmQ4ZDJlNTZjMDQwMGZmN2RhLmJpbmRQb3B1cChwb3B1cF8wNjgyY2FkZmM3ODY0ZTdiYmI0YWEzYjljZTAyYzk0MCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl8yZTA0YWQ0OThlOTk0NDlhYTFlOGU2ZDFiMWRiMTQyMCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkzMDExMDcsIC04Ny43MDcyNDA4XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF85N2M0NjYyNTAwNmE0NDc4YjZlYTM0Y2RkMjA1ODMwMSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfNjZiOTE3MjBjMzY4NGExYTg0NThjZjI5ZDIwMTFlMWIgPSAkKGA8ZGl2IGlkPSJodG1sXzY2YjkxNzIwYzM2ODRhMWE4NDU4Y2YyOWQyMDExZTFiIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Mb25nbWFuICYgRWFnbGU8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfOTdjNDY2MjUwMDZhNDQ3OGI2ZWEzNGNkZDIwNTgzMDEuc2V0Q29udGVudChodG1sXzY2YjkxNzIwYzM2ODRhMWE4NDU4Y2YyOWQyMDExZTFiKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzJlMDRhZDQ5OGU5OTQ0OWFhMWU4ZTZkMWIxZGIxNDIwLmJpbmRQb3B1cChwb3B1cF85N2M0NjYyNTAwNmE0NDc4YjZlYTM0Y2RkMjA1ODMwMSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl85N2M1MDcxNmUyZmI0Y2Q0YmUyZDZjZGMyMGZlOWY4OSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg5MTI5MDAwMDAwMDAxLCAtODcuNjU1NTU3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF85MzY3M2E3ZTA4N2Q0ZmMyOWE3NzVlNTNhMDljMjM1OCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfMjc3MzFlODUwMjI4NGFhNzhlN2I1MDM3NWE4ZDg1N2EgPSAkKGA8ZGl2IGlkPSJodG1sXzI3NzMxZTg1MDIyODRhYTc4ZTdiNTAzNzVhOGQ4NTdhIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CYXJpPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzkzNjczYTdlMDg3ZDRmYzI5YTc3NWU1M2EwOWMyMzU4LnNldENvbnRlbnQoaHRtbF8yNzczMWU4NTAyMjg0YWE3OGU3YjUwMzc1YThkODU3YSk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl85N2M1MDcxNmUyZmI0Y2Q0YmUyZDZjZGMyMGZlOWY4OS5iaW5kUG9wdXAocG9wdXBfOTM2NzNhN2UwODdkNGZjMjlhNzc1ZTUzYTA5YzIzNTgpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfMWRmMzY1NjY2Y2I4NDM1ZDkyYjkyZjA2MWI5ZGNmNWMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44Njc4NTI5LCAtODcuNjQxOTI4OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfYzMyMGJlYTJmMWIxNDMwOTlhZWZjOTFjNWYyNTlkYWYgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzBmNjc5ODBiMWIyNDRkZjc5MGZiN2JkZjhmN2EyOGQwID0gJChgPGRpdiBpZD0iaHRtbF8wZjY3OTgwYjFiMjQ0ZGY3OTBmYjdiZGY4ZjdhMjhkMCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+TWFubnnigJlzPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwX2MzMjBiZWEyZjFiMTQzMDk5YWVmYzkxYzVmMjU5ZGFmLnNldENvbnRlbnQoaHRtbF8wZjY3OTgwYjFiMjQ0ZGY3OTBmYjdiZGY4ZjdhMjhkMCk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl8xZGYzNjU2NjZjYjg0MzVkOTJiOTJmMDYxYjlkY2Y1Yy5iaW5kUG9wdXAocG9wdXBfYzMyMGJlYTJmMWIxNDMwOTlhZWZjOTFjNWYyNTlkYWYpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfZDU2NDEyMGMzZmY2NDA2OGE4MjFjNDg3ZWE1N2Y2YmIgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44ODUyNjkxLCAtODcuNjE4NDgzN10sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfYjM2YTFjNzZkNWQxNGVkN2I3M2I5ZWQwNjRlZThiMTAgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzM4YzhhMzcyNDQzODRhM2E5M2M4NzZkMGM2M2E2OWYxID0gJChgPGRpdiBpZD0iaHRtbF8zOGM4YTM3MjQ0Mzg0YTNhOTNjODc2ZDBjNjNhNjlmMSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+RWdneeKAmXM8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfYjM2YTFjNzZkNWQxNGVkN2I3M2I5ZWQwNjRlZThiMTAuc2V0Q29udGVudChodG1sXzM4YzhhMzcyNDQzODRhM2E5M2M4NzZkMGM2M2E2OWYxKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2Q1NjQxMjBjM2ZmNjQwNjhhODIxYzQ4N2VhNTdmNmJiLmJpbmRQb3B1cChwb3B1cF9iMzZhMWM3NmQ1ZDE0ZWQ3YjczYjllZDA2NGVlOGIxMCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl9kYWU2ZTRiMzRkYTE0ZmIzOGUwZDU5OGNlMzMwYmVkYyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkwODA1MzksIC04Ny42MzQzMTEzXSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF8zZDQ2NDBkOTAwY2Y0NjU0ODlmN2Y2NjQ5MjQwZWEzOCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfNGI5ODkwNmJlNTU5NDIyZThjYWY0MjJmMzFmMGQ3ZjggPSAkKGA8ZGl2IGlkPSJodG1sXzRiOTg5MDZiZTU1OTQyMmU4Y2FmNDIyZjMxZjBkN2Y4IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5PbGQgSmVydXNhbGVtPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzNkNDY0MGQ5MDBjZjQ2NTQ4OWY3ZjY2NDkyNDBlYTM4LnNldENvbnRlbnQoaHRtbF80Yjk4OTA2YmU1NTk0MjJlOGNhZjQyMmYzMWYwZDdmOCk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl9kYWU2ZTRiMzRkYTE0ZmIzOGUwZDU5OGNlMzMwYmVkYy5iaW5kUG9wdXAocG9wdXBfM2Q0NjQwZDkwMGNmNDY1NDg5ZjdmNjY0OTI0MGVhMzgpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfMzE0NTc4YmQxMmIxNGEwNTk1NWRkYWFiYzA0YmMwNGYgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS45MTM2OTUzOTk5OTk5OSwgLTg3LjY3NzEyNzNdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwX2Q1MTY0NDM3YTg4OTQ1ZDdhNmM1NjEyMWJhZjU2MDE3ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF83YzcwZjk5Y2YwZjQ0MmM4ODI3MWRkNDRkZjA2ZGU4NSA9ICQoYDxkaXYgaWQ9Imh0bWxfN2M3MGY5OWNmMGY0NDJjODgyNzFkZDQ0ZGYwNmRlODUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk1pbmR54oCZcyBIb3RDaG9jb2xhdGU8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfZDUxNjQ0MzdhODg5NDVkN2E2YzU2MTIxYmFmNTYwMTcuc2V0Q29udGVudChodG1sXzdjNzBmOTljZjBmNDQyYzg4MjcxZGQ0NGRmMDZkZTg1KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzMxNDU3OGJkMTJiMTRhMDU5NTVkZGFhYmMwNGJjMDRmLmJpbmRQb3B1cChwb3B1cF9kNTE2NDQzN2E4ODk0NWQ3YTZjNTYxMjFiYWY1NjAxNykKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl85OWI2M2JjYzJhNzI0MDdjOGRjNTk2OWEwYmVhYmI3YyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjk1MzcwNTQsIC04Ny43MDg0NTAyXSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF81NTJjYWI5YWQ4NmE0Y2ZjYTViMGI0MWI0OGQ4NDFiNCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfODdiY2ZjYjA0ZGRlNDkyYmE5MDIwMTI1NTYzMGM1ZTYgPSAkKGA8ZGl2IGlkPSJodG1sXzg3YmNmY2IwNGRkZTQ5MmJhOTAyMDEyNTU2MzBjNWU2IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5PbGdh4oCZcyBEZWxpY2F0ZXNzZW48L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNTUyY2FiOWFkODZhNGNmY2E1YjBiNDFiNDhkODQxYjQuc2V0Q29udGVudChodG1sXzg3YmNmY2IwNGRkZTQ5MmJhOTAyMDEyNTU2MzBjNWU2KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzk5YjYzYmNjMmE3MjQwN2M4ZGM1OTY5YTBiZWFiYjdjLmJpbmRQb3B1cChwb3B1cF81NTJjYWI5YWQ4NmE0Y2ZjYTViMGI0MWI0OGQ4NDFiNCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl80ZWRlZjhjYmE4MmM0Y2JhOTUyZmE1NzFkYjNjNzgzMyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjk3OTQ0OTYsIC04Ny42Njc5NTcxOTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfMTRmNzdjODBiZmJiNDViYmI0ZGU4MTQyZGRkNzEwY2MgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sX2YxNmJmMzBmNWNkZDRlNmFhMDc5MWZiMmJlZjYwMDQ0ID0gJChgPGRpdiBpZD0iaHRtbF9mMTZiZjMwZjVjZGQ0ZTZhYTA3OTFmYjJiZWY2MDA0NCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QmlnIEpvbmVzPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzE0Zjc3YzgwYmZiYjQ1YmJiNGRlODE0MmRkZDcxMGNjLnNldENvbnRlbnQoaHRtbF9mMTZiZjMwZjVjZGQ0ZTZhYTA3OTFmYjJiZWY2MDA0NCk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl80ZWRlZjhjYmE4MmM0Y2JhOTUyZmE1NzFkYjNjNzgzMy5iaW5kUG9wdXAocG9wdXBfMTRmNzdjODBiZmJiNDViYmI0ZGU4MTQyZGRkNzEwY2MpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfZDMwYjMyYzc4MGNhNDIyNDg4MGY5NDY1ODE3ZjVmMmUgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS45NTQxNjIsIC04Ny43MDI3MTA3OTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfZDZlOGQ3ZjEwNTg4NGI2NGFjNzNiZmVjMTY4MDQ5YzcgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sX2FmYjNmYTYwZTc0ODRkZTFhNDE2ZDc2MWQyMzc2OTExID0gJChgPGRpdiBpZD0iaHRtbF9hZmIzZmE2MGU3NDg0ZGUxYTQxNmQ3NjFkMjM3NjkxMSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+TGEgUGFuZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9kNmU4ZDdmMTA1ODg0YjY0YWM3M2JmZWMxNjgwNDljNy5zZXRDb250ZW50KGh0bWxfYWZiM2ZhNjBlNzQ4NGRlMWE0MTZkNzYxZDIzNzY5MTEpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfZDMwYjMyYzc4MGNhNDIyNDg4MGY5NDY1ODE3ZjVmMmUuYmluZFBvcHVwKHBvcHVwX2Q2ZThkN2YxMDU4ODRiNjRhYzczYmZlYzE2ODA0OWM3KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2Q3OTI0Yzk3Yjk2NDRhNzI5MjQ0MmU0NTgwMjRiZDM1ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDIuMTU2NjkxLCAtODcuODAzNjE4XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF80MzBlNjNiY2Q0Zjc0MDQxYWUyZGM5OGJjOTdiNWRhYyA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfMDkyMTAyMzIzYjc4NDNhMjk1YTE0ZWU2ZWM4MzI2ZDYgPSAkKGA8ZGl2IGlkPSJodG1sXzA5MjEwMjMyM2I3ODQzYTI5NWExNGVlNmVjODMyNmQ2IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5NYXjigJlzIERlbGk8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNDMwZTYzYmNkNGY3NDA0MWFlMmRjOThiYzk3YjVkYWMuc2V0Q29udGVudChodG1sXzA5MjEwMjMyM2I3ODQzYTI5NWExNGVlNmVjODMyNmQ2KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2Q3OTI0Yzk3Yjk2NDRhNzI5MjQ0MmU0NTgwMjRiZDM1LmJpbmRQb3B1cChwb3B1cF80MzBlNjNiY2Q0Zjc0MDQxYWUyZGM5OGJjOTdiNWRhYykKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl82ZWJjNzFjYzgyNzU0YTdiYjdlM2U0MTBmMDI3MDk0NCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjk2NTI5ODcsIC04Ny42NzU1Nzk1OTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfZDVjZGFmODQzNzg4NDgyMjliMTdjZmE1ODVkNWY0MDYgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzk3NzEwYThhOThlYjQwMDM4ZjNjY2VkN2Q1OGU2OWY2ID0gJChgPGRpdiBpZD0iaHRtbF85NzcxMGE4YTk4ZWI0MDAzOGYzY2NlZDdkNThlNjlmNiIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+Q2l0eSBQcm92aXNpb25zPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwX2Q1Y2RhZjg0Mzc4ODQ4MjI5YjE3Y2ZhNTg1ZDVmNDA2LnNldENvbnRlbnQoaHRtbF85NzcxMGE4YTk4ZWI0MDAzOGYzY2NlZDdkNThlNjlmNik7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl82ZWJjNzFjYzgyNzU0YTdiYjdlM2U0MTBmMDI3MDk0NC5iaW5kUG9wdXAocG9wdXBfZDVjZGFmODQzNzg4NDgyMjliMTdjZmE1ODVkNWY0MDYpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfNTgwNjM1NjQ4MzI0NDg5MWI4YzRmOTAzOWEwZjllZGEgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS45MDI3MjE3OTk5OTk5OSwgLTg3LjY5MDIxMzVdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzZmMDk2ZWYxNDU2NTQwMzg4NGY1MzJlZDA4MTdkZmY1ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF9iYjBlZDc1MTNhMDk0OThhYjI3YzcwZTAyYzQyMmE4MCA9ICQoYDxkaXYgaWQ9Imh0bWxfYmIwZWQ3NTEzYTA5NDk4YWIyN2M3MGUwMmM0MjJhODAiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlBhcGHigJlzIENhY2hlIFNhYnJvc288L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNmYwOTZlZjE0NTY1NDAzODg0ZjUzMmVkMDgxN2RmZjUuc2V0Q29udGVudChodG1sX2JiMGVkNzUxM2EwOTQ5OGFiMjdjNzBlMDJjNDIyYTgwKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzU4MDYzNTY0ODMyNDQ4OTFiOGM0ZjkwMzlhMGY5ZWRhLmJpbmRQb3B1cChwb3B1cF82ZjA5NmVmMTQ1NjU0MDM4ODRmNTMyZWQwODE3ZGZmNSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl85NTA3YTA3ZTgyMDg0MjA2YjkyNjAyNmY5MDRmNDRkZSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg4OTM2ODMsIC04Ny42MzQ5NDg3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF8wNzNmYTM1ZTIxMzc0YmVmOWJkMzBjZmIyZDBiNDM3MiA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfZTcyYjUyZTNkNTllNGQ5MTg2YjQ2OTMxODNkM2U1YmIgPSAkKGA8ZGl2IGlkPSJodG1sX2U3MmI1MmUzZDU5ZTRkOTE4NmI0NjkzMTgzZDNlNWJiIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CYXZldHRl4oCZcyBCYXIgJiBCb2V1ZjwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8wNzNmYTM1ZTIxMzc0YmVmOWJkMzBjZmIyZDBiNDM3Mi5zZXRDb250ZW50KGh0bWxfZTcyYjUyZTNkNTllNGQ5MTg2YjQ2OTMxODNkM2U1YmIpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfOTUwN2EwN2U4MjA4NDIwNmI5MjYwMjZmOTA0ZjQ0ZGUuYmluZFBvcHVwKHBvcHVwXzA3M2ZhMzVlMjEzNzRiZWY5YmQzMGNmYjJkMGI0MzcyKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2FkMDYzOWYzMjU5OTRmODRiZTE4MThiZDkzZmEwZTA4ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTEwNTI1OCwgLTg3LjYzNDM3NzVdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwX2IzMDEyODVhOGRjNjRmMWZhZGZjYTRiMGM2NjU4NTY3ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF85NGViYTViODgxYzA0NjQ1ODlhYjQ1ZDU2NDI3OGUwYiA9ICQoYDxkaXYgaWQ9Imh0bWxfOTRlYmE1Yjg4MWMwNDY0NTg5YWI0NWQ1NjQyNzhlMGIiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkxhIEZvdXJuZXR0ZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9iMzAxMjg1YThkYzY0ZjFmYWRmY2E0YjBjNjY1ODU2Ny5zZXRDb250ZW50KGh0bWxfOTRlYmE1Yjg4MWMwNDY0NTg5YWI0NWQ1NjQyNzhlMGIpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfYWQwNjM5ZjMyNTk5NGY4NGJlMTgxOGJkOTNmYTBlMDguYmluZFBvcHVwKHBvcHVwX2IzMDEyODVhOGRjNjRmMWZhZGZjYTRiMGM2NjU4NTY3KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzYyMDJjYzRjNGNiNDRhMjdhZDRlMDJlMGYwM2U0YmYyID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuODg5NjE4OCwgLTg3LjY0NDg0MjU5OTk5OTk5XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF9jZGE3M2FkYjViOTY0ZTFjOTJiMzMzZGI4ZWIyNTBmMiA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfYzk0OTM2ZWQzNDBkNDNmN2I3NDRiODQwYzUzODZhOGQgPSAkKGA8ZGl2IGlkPSJodG1sX2M5NDkzNmVkMzQwZDQzZjdiNzQ0Yjg0MGM1Mzg2YThkIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5QYXJhbW91bnQgUm9vbTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9jZGE3M2FkYjViOTY0ZTFjOTJiMzMzZGI4ZWIyNTBmMi5zZXRDb250ZW50KGh0bWxfYzk0OTM2ZWQzNDBkNDNmN2I3NDRiODQwYzUzODZhOGQpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfNjIwMmNjNGM0Y2I0NGEyN2FkNGUwMmUwZjAzZTRiZjIuYmluZFBvcHVwKHBvcHVwX2NkYTczYWRiNWI5NjRlMWM5MmIzMzNkYjhlYjI1MGYyKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzczYTQ1YzY1NWRmNjQ2OTU5MWM3OGQ3ODVlZDNmNDU2ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTE1MDQ5OTAwMDAwMDEsIC04Ny42Nzc4MDQ3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF9kOWZiYTQxZjk1YjY0NDc3YmM0ZDc0ZGQxMDRjOWU2OSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfZjZkMGQ3ZjNmY2I3NGRlY2JjZmExYzI1MGVhZTMxYzggPSAkKGA8ZGl2IGlkPSJodG1sX2Y2ZDBkN2YzZmNiNzRkZWNiY2ZhMWMyNTBlYWUzMWM4IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5NZWx0IFNhbmR3aWNoIFNob3BwZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9kOWZiYTQxZjk1YjY0NDc3YmM0ZDc0ZGQxMDRjOWU2OS5zZXRDb250ZW50KGh0bWxfZjZkMGQ3ZjNmY2I3NGRlY2JjZmExYzI1MGVhZTMxYzgpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfNzNhNDVjNjU1ZGY2NDY5NTkxYzc4ZDc4NWVkM2Y0NTYuYmluZFBvcHVwKHBvcHVwX2Q5ZmJhNDFmOTViNjQ0NzdiYzRkNzRkZDEwNGM5ZTY5KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzI5Mjk2MmViYzMzZjQ4ZTQ5M2Q1ZjAzMDBjZTQ2NzM4ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTIxODUyMSwgLTg3LjY1OTIxMjRdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzE5MjRiZGU2YmMyMzQ5NTNiMTg0NmNhYjk4ZjZlOWRhID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF81NTJiZjY2NjNiOTU0NjViODVmNTA4OTg0ODQxYzRlNiA9ICQoYDxkaXYgaWQ9Imh0bWxfNTUyYmY2NjYzYjk1NDY1Yjg1ZjUwODk4NDg0MWM0ZTYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkZsb3Jpb2xlIENhZmUgJiBCYWtlcnk8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfMTkyNGJkZTZiYzIzNDk1M2IxODQ2Y2FiOThmNmU5ZGEuc2V0Q29udGVudChodG1sXzU1MmJmNjY2M2I5NTQ2NWI4NWY1MDg5ODQ4NDFjNGU2KTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzI5Mjk2MmViYzMzZjQ4ZTQ5M2Q1ZjAzMDBjZTQ2NzM4LmJpbmRQb3B1cChwb3B1cF8xOTI0YmRlNmJjMjM0OTUzYjE4NDZjYWI5OGY2ZTlkYSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl9lMDgyMWMzODJkYmU0Y2M0YTNkYWU3ZTIzYTE3N2M2NyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjk3OTcwOTksIC04Ny42NjkzNDQwOTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfOGM0MDMxM2I4MzE1NGIyZDk0ODQ0NjQyZTg4ZTc1OWEgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzQ5NDk0ZDI0NGJmNDQyNjVhODc2ZGQ0ODcwMmZiNTI3ID0gJChgPGRpdiBpZD0iaHRtbF80OTQ5NGQyNDRiZjQ0MjY1YTg3NmRkNDg3MDJmYjUyNyIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+Rmlyc3QgU2xpY2UgUGllIENhZsOpPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzhjNDAzMTNiODMxNTRiMmQ5NDg0NDY0MmU4OGU3NTlhLnNldENvbnRlbnQoaHRtbF80OTQ5NGQyNDRiZjQ0MjY1YTg3NmRkNDg3MDJmYjUyNyk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl9lMDgyMWMzODJkYmU0Y2M0YTNkYWU3ZTIzYTE3N2M2Ny5iaW5kUG9wdXAocG9wdXBfOGM0MDMxM2I4MzE1NGIyZDk0ODQ0NjQyZTg4ZTc1OWEpCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfZGM5MGIyNzA2NjVjNDAyYzk3MmE2ZDJjNWU2ZGM0YzUgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS45NjE3MTIyLCAtODcuNjc1ODE2MjAwMDAwMDFdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzc5ZjRlODYzM2UxMTRiZmE4ZjVkNjk2ODI2ZGUzM2YwID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8xOWNkOGFiMjNkNWQ0ZjAwYjcyZjgxNzI3MWQ5YWQwYiA9ICQoYDxkaXYgaWQ9Imh0bWxfMTljZDhhYjIzZDVkNGYwMGI3MmY4MTcyNzFkOWFkMGIiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlRyb3F1ZXQ8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNzlmNGU4NjMzZTExNGJmYThmNWQ2OTY4MjZkZTMzZjAuc2V0Q29udGVudChodG1sXzE5Y2Q4YWIyM2Q1ZDRmMDBiNzJmODE3MjcxZDlhZDBiKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2RjOTBiMjcwNjY1YzQwMmM5NzJhNmQyYzVlNmRjNGM1LmJpbmRQb3B1cChwb3B1cF83OWY0ZTg2MzNlMTE0YmZhOGY1ZDY5NjgyNmRlMzNmMCkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl84MzVjYmFmOTE5M2U0NmVjOWU4MjdjN2NmYWYzNTgxYSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg5Mjk2MTE5OTk5OTk5LCAtODcuNjI3ODIxNF0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfYjBiMTQ5YTVlMGMwNDc2YjhlOTJhZjdjYTVkZjkzNjYgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzU1NWFjNzBkZGEzNTQwOTg5OTdhMDc5Zjg0YmE0NWJhID0gJChgPGRpdiBpZD0iaHRtbF81NTVhYzcwZGRhMzU0MDk4OTk3YTA3OWY4NGJhNDViYSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+R3JhaGFtd2ljaDwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9iMGIxNDlhNWUwYzA0NzZiOGU5MmFmN2NhNWRmOTM2Ni5zZXRDb250ZW50KGh0bWxfNTU1YWM3MGRkYTM1NDA5ODk5N2EwNzlmODRiYTQ1YmEpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfODM1Y2JhZjkxOTNlNDZlYzllODI3YzdjZmFmMzU4MWEuYmluZFBvcHVwKHBvcHVwX2IwYjE0OWE1ZTBjMDQ3NmI4ZTkyYWY3Y2E1ZGY5MzY2KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2U4ZWI0MDhhNGJlMDQ4MGFhNzQxMTAzOGZlMmJkMDAyID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTA0NzU1MSwgLTg3LjkzOTY0NTldLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzZkZjhlZmRlYzczODQ3ZGJiOWNjMGQwOWJiNDYzYjdlID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF9lZGFmN2Y3ZjExYzM0YzFiOTI1ZmRjMGE0NDg4NjEzMiA9ICQoYDxkaXYgaWQ9Imh0bWxfZWRhZjdmN2YxMWMzNGMxYjkyNWZkYzBhNDQ4ODYxMzIiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlJvc2FsaWHigJlzIERlbGk8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNmRmOGVmZGVjNzM4NDdkYmI5Y2MwZDA5YmI0NjNiN2Uuc2V0Q29udGVudChodG1sX2VkYWY3ZjdmMTFjMzRjMWI5MjVmZGMwYTQ0ODg2MTMyKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2U4ZWI0MDhhNGJlMDQ4MGFhNzQxMTAzOGZlMmJkMDAyLmJpbmRQb3B1cChwb3B1cF82ZGY4ZWZkZWM3Mzg0N2RiYjljYzBkMDliYjQ2M2I3ZSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl8wMWUzZmU0YzZjZDg0OTMxODQ5YjE0YTBiZmY1OTk3NyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjc5MTMxODUsIC04Ny41OTM4NDU2XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF8yN2YxYjE3MGU3M2M0NTM3YTM5NDg2Y2E1ZWY4OWU5ZSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfZDMwNjBhNGYyOTYxNDI0YWI4MjEzMzRiOTIwMzg2NWEgPSAkKGA8ZGl2IGlkPSJodG1sX2QzMDYwYTRmMjk2MTQyNGFiODIxMzM0YjkyMDM4NjVhIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5aJkggTWFya2V0Q2FmZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF8yN2YxYjE3MGU3M2M0NTM3YTM5NDg2Y2E1ZWY4OWU5ZS5zZXRDb250ZW50KGh0bWxfZDMwNjBhNGYyOTYxNDI0YWI4MjEzMzRiOTIwMzg2NWEpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfMDFlM2ZlNGM2Y2Q4NDkzMTg0OWIxNGEwYmZmNTk5NzcuYmluZFBvcHVwKHBvcHVwXzI3ZjFiMTcwZTczYzQ1MzdhMzk0ODZjYTVlZjg5ZTllKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzEzNGU2MWI4NmE2ZTQwNDA4Yzk1YTdiMDNmYTJlZWI3ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDIuMjUxNzg0MDk5OTk5OTksIC04Ny44NDEzNTM1XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF82OGZmZDhiYmYyNmM0NDYyYjc5ZWExMWVlMjliNGUzOCA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfNTUwZGZlZDg5NDI4NDYzNWJjZmE5MGY3OWEzMGFlOTkgPSAkKGA8ZGl2IGlkPSJodG1sXzU1MGRmZWQ4OTQyODQ2MzViY2ZhOTBmNzlhMzBhZTk5IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5NYXJrZXQgSG91c2Ugb24gdGhlIFNxdWFyZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF82OGZmZDhiYmYyNmM0NDYyYjc5ZWExMWVlMjliNGUzOC5zZXRDb250ZW50KGh0bWxfNTUwZGZlZDg5NDI4NDYzNWJjZmE5MGY3OWEzMGFlOTkpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfMTM0ZTYxYjg2YTZlNDA0MDhjOTVhN2IwM2ZhMmVlYjcuYmluZFBvcHVwKHBvcHVwXzY4ZmZkOGJiZjI2YzQ0NjJiNzllYTExZWUyOWI0ZTM4KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzEzNjZhYTk3MjE0OTQ3Nzk5YWFiY2Q0NTQzYmY4ODYzID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTE1Mjg3NSwgLTg3LjYzNDM4ODhdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzlkODA2NGEwYzIwMTQ3NjZiODJkNTlhYmU0YWM2ZGEzID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF81YWFkY2U0ZTExNjU0NGM5ODllOGY4ZmZkYjczYzdiZSA9ICQoYDxkaXYgaWQ9Imh0bWxfNWFhZGNlNGUxMTY1NDRjOTg5ZThmOGZmZGI3M2M3YmUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkVsYWluZeKAmXMgQ29mZmVlIENhbGw8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfOWQ4MDY0YTBjMjAxNDc2NmI4MmQ1OWFiZTRhYzZkYTMuc2V0Q29udGVudChodG1sXzVhYWRjZTRlMTE2NTQ0Yzk4OWU4ZjhmZmRiNzNjN2JlKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzEzNjZhYTk3MjE0OTQ3Nzk5YWFiY2Q0NTQzYmY4ODYzLmJpbmRQb3B1cChwb3B1cF85ZDgwNjRhMGMyMDE0NzY2YjgyZDU5YWJlNGFjNmRhMykKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl9mN2NhN2Q1NzUyZDA0MDU2OWQ5MDU2ZjRkNDA4YTRkOCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg4NjM2MjIsIC04Ny44MDIyMjk3XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF82NWUwODNhMmZhNzU0MTVjODM1MzkwNTRhMzdlMTRjNyA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfZThlMGEzNzc4ZjdlNGFhMmE5MjExMmZiMDNjZDAzY2MgPSAkKGA8ZGl2IGlkPSJodG1sX2U4ZTBhMzc3OGY3ZTRhYTJhOTIxMTJmYjAzY2QwM2NjIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5NYXJpb24gU3RyZWV0IENoZWVzZSBNYXJrZXQ8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfNjVlMDgzYTJmYTc1NDE1YzgzNTM5MDU0YTM3ZTE0Yzcuc2V0Q29udGVudChodG1sX2U4ZTBhMzc3OGY3ZTRhYTJhOTIxMTJmYjAzY2QwM2NjKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyX2Y3Y2E3ZDU3NTJkMDQwNTY5ZDkwNTZmNGQ0MDhhNGQ4LmJpbmRQb3B1cChwb3B1cF82NWUwODNhMmZhNzU0MTVjODM1MzkwNTRhMzdlMTRjNykKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl84OWRhNWE1NDY3YTE0ZDliYjBlYzY4NjJjZDBlMmU4OCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjg3NTgxMDIsIC04Ny42MjY0NDg5XSwKICAgICAgICAgICAgICAgIHt9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzNmNTExNTVkYWQxZTRkODZhZDY5ZWQzNWI3MzAwMjcwKTsKICAgICAgICAKICAgIAogICAgICAgIHZhciBwb3B1cF80NzI4Y2M4YjA1YjE0NDFhYWU1ODAwNTJmY2M1NDMzMSA9IEwucG9wdXAoeyJtYXhXaWR0aCI6ICIxMDAlIn0pOwoKICAgICAgICAKICAgICAgICAgICAgdmFyIGh0bWxfOGY3MDEwMzc2ZTc2NDA3MThlMWUzYWFjN2YxYzNhODcgPSAkKGA8ZGl2IGlkPSJodG1sXzhmNzAxMDM3NmU3NjQwNzE4ZTFlM2FhYzdmMWMzYTg3IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5DYWZlY2l0bzwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF80NzI4Y2M4YjA1YjE0NDFhYWU1ODAwNTJmY2M1NDMzMS5zZXRDb250ZW50KGh0bWxfOGY3MDEwMzc2ZTc2NDA3MThlMWUzYWFjN2YxYzNhODcpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfODlkYTVhNTQ2N2ExNGQ5YmIwZWM2ODYyY2QwZTJlODguYmluZFBvcHVwKHBvcHVwXzQ3MjhjYzhiMDViMTQ0MWFhZTU4MDA1MmZjYzU0MzMxKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzVkY2U4Y2NkYjY1MzQyMTI5OGJlMTFhYTRkMTYyNjk2ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuODk2MDczOCwgLTg3LjY3NzgxODVdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzhhNGRkMjhjZDgwNDRjY2M5NjJmNjYyY2Y0YmM1MTQwID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8wZjIyZTIyNjkzZDc0YzBhYjEzZTBiODcyMDFhMmFkZSA9ICQoYDxkaXYgaWQ9Imh0bWxfMGYyMmUyMjY5M2Q3NGMwYWIxM2UwYjg3MjAxYTJhZGUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkNoaWNrcGVhPC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzhhNGRkMjhjZDgwNDRjY2M5NjJmNjYyY2Y0YmM1MTQwLnNldENvbnRlbnQoaHRtbF8wZjIyZTIyNjkzZDc0YzBhYjEzZTBiODcyMDFhMmFkZSk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl81ZGNlOGNjZGI2NTM0MjEyOThiZTExYWE0ZDE2MjY5Ni5iaW5kUG9wdXAocG9wdXBfOGE0ZGQyOGNkODA0NGNjYzk2MmY2NjJjZjRiYzUxNDApCiAgICAgICAgOwoKICAgICAgICAKICAgIAogICAgCiAgICAgICAgICAgIHZhciBtYXJrZXJfOWM0ZjJkYTM3ODZhNDI5Mjg1YWViODM5YjJiZWEyN2MgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0MS44OTg5Nzg1MDAwMDAwMSwgLTg3LjYyNzM5MjZdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwX2I1NjA5MWRkN2QwMDRjN2E5NTZjOGZmMGIyOGU0NDJhID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF83Y2QzODE5YzZjYzA0Nzc2ODU5NGMxNzExOTcwNDkxZiA9ICQoYDxkaXYgaWQ9Imh0bWxfN2NkMzgxOWM2Y2MwNDc3Njg1OTRjMTcxMTk3MDQ5MWYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlRoZSBHb2RkZXNzIGFuZCBHcm9jZXI8L2Rpdj5gKVswXTsKICAgICAgICAgICAgcG9wdXBfYjU2MDkxZGQ3ZDAwNGM3YTk1NmM4ZmYwYjI4ZTQ0MmEuc2V0Q29udGVudChodG1sXzdjZDM4MTljNmNjMDQ3NzY4NTk0YzE3MTE5NzA0OTFmKTsKICAgICAgICAKCiAgICAgICAgbWFya2VyXzljNGYyZGEzNzg2YTQyOTI4NWFlYjgzOWIyYmVhMjdjLmJpbmRQb3B1cChwb3B1cF9iNTYwOTFkZDdkMDA0YzdhOTU2YzhmZjBiMjhlNDQyYSkKICAgICAgICA7CgogICAgICAgIAogICAgCiAgICAKICAgICAgICAgICAgdmFyIG1hcmtlcl8yNjNjYzE4ZjUxMjc0Nzc1YTcyMjhhM2U2YmQ2OTJjZSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQxLjkxMDU4MzIsIC04Ny45NDA0ODgzOTk5OTk5OV0sCiAgICAgICAgICAgICAgICB7fQogICAgICAgICAgICApLmFkZFRvKG1hcF8zZjUxMTU1ZGFkMWU0ZDg2YWQ2OWVkMzViNzMwMDI3MCk7CiAgICAgICAgCiAgICAKICAgICAgICB2YXIgcG9wdXBfYTEwMGU4ODM4ODkxNDAwYTk3OTM4NTU2YWIwZWFjYTAgPSBMLnBvcHVwKHsibWF4V2lkdGgiOiAiMTAwJSJ9KTsKCiAgICAgICAgCiAgICAgICAgICAgIHZhciBodG1sXzAyNTRhZDYyYjllMjQ5MDk4NDY1ZmVhYmMwZDdjMTAyID0gJChgPGRpdiBpZD0iaHRtbF8wMjU0YWQ2MmI5ZTI0OTA5ODQ2NWZlYWJjMGQ3YzEwMiIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+WmVud2ljaDwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF9hMTAwZTg4Mzg4OTE0MDBhOTc5Mzg1NTZhYjBlYWNhMC5zZXRDb250ZW50KGh0bWxfMDI1NGFkNjJiOWUyNDkwOTg0NjVmZWFiYzBkN2MxMDIpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfMjYzY2MxOGY1MTI3NDc3NWE3MjI4YTNlNmJkNjkyY2UuYmluZFBvcHVwKHBvcHVwX2ExMDBlODgzODg5MTQwMGE5NzkzODU1NmFiMGVhY2EwKQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyXzlmMjFjZjhjYWVkMzQ3ZGU5YTdiOGIyM2MxNmI4NDNlID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuODgzMTA2MSwgLTg3LjYyNTQzODFdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzQzMWU2NDk2NjY1ODQ0OTQ4ZGM1OGUxY2I5MjZkOTQ4ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF9jNDYyNzJlNzJjNGU0ZTE0Yjc0OTdlOWI2MTM0ODA5NiA9ICQoYDxkaXYgaWQ9Imh0bWxfYzQ2MjcyZTcyYzRlNGUxNGI3NDk3ZTliNjEzNDgwOTYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlRvbmkgUGF0aXNzZXJpZTwvZGl2PmApWzBdOwogICAgICAgICAgICBwb3B1cF80MzFlNjQ5NjY2NTg0NDk0OGRjNThlMWNiOTI2ZDk0OC5zZXRDb250ZW50KGh0bWxfYzQ2MjcyZTcyYzRlNGUxNGI3NDk3ZTliNjEzNDgwOTYpOwogICAgICAgIAoKICAgICAgICBtYXJrZXJfOWYyMWNmOGNhZWQzNDdkZTlhN2I4YjIzYzE2Yjg0M2UuYmluZFBvcHVwKHBvcHVwXzQzMWU2NDk2NjY1ODQ0OTQ4ZGM1OGUxY2I5MjZkOTQ4KQogICAgICAgIDsKCiAgICAgICAgCiAgICAKICAgIAogICAgICAgICAgICB2YXIgbWFya2VyX2I5ZmUxMTY1OTM0ODRiMmJhNGRlOWFjODAwYWQzNTcyID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDEuOTQzMTYzMiwgLTg3LjY0NDUwNzFdLAogICAgICAgICAgICAgICAge30KICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2Y1MTE1NWRhZDFlNGQ4NmFkNjllZDM1YjczMDAyNzApOwogICAgICAgIAogICAgCiAgICAgICAgdmFyIHBvcHVwXzczOGVjYTNiOTg4NjRkNTZhZjIyMTM1ZWQwODU1Mzg2ID0gTC5wb3B1cCh7Im1heFdpZHRoIjogIjEwMCUifSk7CgogICAgICAgIAogICAgICAgICAgICB2YXIgaHRtbF8wYmRmZjUxNGM4ZDM0ZDhjYjAzMDhkMGNkNjcwMjdjZCA9ICQoYDxkaXYgaWQ9Imh0bWxfMGJkZmY1MTRjOGQzNGQ4Y2IwMzA4ZDBjZDY3MDI3Y2QiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlBob2ViZeKAmXMgQmFrZXJ5PC9kaXY+YClbMF07CiAgICAgICAgICAgIHBvcHVwXzczOGVjYTNiOTg4NjRkNTZhZjIyMTM1ZWQwODU1Mzg2LnNldENvbnRlbnQoaHRtbF8wYmRmZjUxNGM4ZDM0ZDhjYjAzMDhkMGNkNjcwMjdjZCk7CiAgICAgICAgCgogICAgICAgIG1hcmtlcl9iOWZlMTE2NTkzNDg0YjJiYTRkZTlhYzgwMGFkMzU3Mi5iaW5kUG9wdXAocG9wdXBfNzM4ZWNhM2I5ODg2NGQ1NmFmMjIxMzVlZDA4NTUzODYpCiAgICAgICAgOwoKICAgICAgICAKICAgIAo8L3NjcmlwdD4= onload=\"this.contentDocument.open();this.contentDocument.write(atob(this.getAttribute('data-html')));this.contentDocument.close();\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x115a3ca50>"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapping = folium.Map(location=[df['lat'].mean(), df['lng'].mean()], \n",
    "                     zoom_start=11)\n",
    "\n",
    "for n in df.index:\n",
    "    if df['Address'][n] != 'Multiple':\n",
    "        folium.Marker([df['lat'][n], df['lng'][n]], \n",
    "                                      popup=df['Cafe'][n]).add_to(mapping)\n",
    "\n",
    "mapping"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 공부를 끝내며 \n",
    "\n",
    "호호호, 이번 주 공부도 무척 재미있었죠? 그러나! 아직 공부는 끝나지 않았습니다. 이번 주는 하나 더 프로젝트가 있습니다. 간단하지만 그래도 배울 것이 많은 **네이버 영화 평점 순 크롤링**을 해 볼 것입니다. 그럼 다음 교안에서 만나요! "
   ]
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}