교수진.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "import ssl\n",
    "import urllib.request\n",
    "import urllib.parse \n",
    "from bs4 import BeautifulSoup\n",
    "\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [],
   "source": [
    "import openpyxl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['http://faculty.korea.ac.kr/kufaculty/pro_busi.do', 'http://faculty.korea.ac.kr/kufaculty/pro_liberal_philo.do', 'http://faculty.korea.ac.kr/kufaculty/pro_lifeSiences_Bio.do', 'http://faculty.korea.ac.kr/kufaculty/pro_polisci_polisci.do', 'http://faculty.korea.ac.kr/kufaculty/pro_sci_math.do', 'http://faculty.korea.ac.kr/kufaculty/pro_eng_ingre.do', 'http://faculty.korea.ac.kr/kufaculty/pro_doc_family.do', 'http://faculty.korea.ac.kr/kufaculty/pro_edu_pedago.do', 'http://faculty.korea.ac.kr/kufaculty/pro_nursing.do', 'http://faculty.korea.ac.kr/kufaculty/pro_health_bsm.do', 'http://faculty.korea.ac.kr/kufaculty/pro_info_computer.do', 'http://faculty.korea.ac.kr/kufaculty/pro_design.do', 'http://faculty.korea.ac.kr/kufaculty/pro_media.do']\n"
     ]
    }
   ],
   "source": [
    "urllist=[]\n",
    "a=['busi.do','liberal_philo.do','lifeSiences_Bio.do','polisci_polisci.do','sci_math.do','eng_ingre.do','doc_family.do','edu_pedago.do','nursing.do','health_bsm.do','info_computer.do','design.do','media.do']\n",
    "url = 'http://faculty.korea.ac.kr/kufaculty/pro_'\n",
    "for i in range(len(a)):\n",
    "    urllist.append(url+a[i])\n",
    "print(urllist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<tbody>\n",
      "<tr>\n",
      "<th scope=\"row\">박광태</th>\n",
      "<td><a href=\"http://faculty.korea.ac.kr/ktpark\" target=\"_blank\">http://faculty.korea.ac.kr/ktpark</a></td>\n",
      "<th scope=\"row\">박찬수</th>\n",
      "<td><a href=\"http://faculty.korea.ac.kr/chansu\" target=\"_blank\">http://faculty.korea.ac.kr/chansu</a></td>\n",
      "</tr>\n",
      "<tr>\n",
      "<th scope=\"row\">유승원</th>\n",
      "<td><a href=\"http://faculty.korea.ac.kr/swyoo\" target=\"_blank\">http://faculty.korea.ac.kr/swyoo</a></td>\n",
      "<th scope=\"row\">김재욱</th>\n",
      "<td><a href=\"http://faculty.korea.ac.kr/jaewook\" target=\"_blank\">http://faculty.korea.ac.kr/jaewook</a></td>\n",
      "</tr>\n",
      "</tbody>]\n"
     ]
    }
   ],
   "source": [
    "url = 'http://faculty.korea.ac.kr/kufaculty/pro_busi.do'\n",
    "req=requests.get(url)\n",
    "html = req.text\n",
    "soup = BeautifulSoup(html, 'html.parser')\n",
    "pro_list = soup.find_all('tbody')\n",
    "print(pro_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['철학과', '한국사학과', '사학과', '심리학과', '사회학과', '한문학과', '영어영문학과', '독어독문학과', '불어물문학과', '중어중문학과', '노어노문학과', '일어일문학과', '서어서문학과', '언어학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_liberal_philo.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_korhist.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_history.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_psycho.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_soci.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_chin.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_eng.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_germ.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_french.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_chinese.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_rusian.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_japanese.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_spanish.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_linguistics.do']\n"
     ]
    }
   ],
   "source": [
    "subject = soup.select('div#container')\n",
    "\n",
    "subject_list=[]\n",
    "for i in subject:\n",
    "    subject_list=i.select('h4')\n",
    "    \n",
    "subject_list2=[]\n",
    "for i in subject_list:\n",
    "    subject_list2.append(i.select('a'))\n",
    "\n",
    "subject_name=[]\n",
    "for i in range(len(subject_list2)):\n",
    "    subject_name.append(subject_list2[i][0].text)\n",
    "print(subject_name)\n",
    "    \n",
    "subject_list3=[]\n",
    "for i in range(len(subject_list2)):\n",
    "    subject_list3.append(subject_list2[i][0]['href'])\n",
    "\n",
    "subject_url=[]\n",
    "for i in range(len(subject_list3)):\n",
    "    subject_url.append('http://faculty.korea.ac.kr/' + subject_list3[i])\n",
    "    \n",
    "\n",
    "print(subject_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['박광태', '박찬수', '유승원', '김재욱']\n",
      "['http://faculty.korea.ac.kr/ktpark', 'http://faculty.korea.ac.kr/chansu', 'http://faculty.korea.ac.kr/swyoo', 'http://faculty.korea.ac.kr/jaewook']\n",
      "[['박광태', 'http://faculty.korea.ac.kr/ktpark'], ['박찬수', 'http://faculty.korea.ac.kr/chansu'], ['유승원', 'http://faculty.korea.ac.kr/swyoo'], ['김재욱', 'http://faculty.korea.ac.kr/jaewook']]\n"
     ]
    }
   ],
   "source": [
    "for i in pro_list:\n",
    "    pro_list2=i.select('th')\n",
    "    \n",
    "pro_list3 =[] \n",
    "\n",
    "for i in pro_list2:\n",
    "    pro_list3.append(i.text)\n",
    "\n",
    "for i in range(len(pro_list3)):\n",
    "    if len(pro_list3[i])==0:\n",
    "        del pro_list3[i]\n",
    "print(pro_list3)\n",
    "\n",
    "for i in pro_list:\n",
    "    prolink_list=i.select('a')\n",
    "prolink_list2 =[]\n",
    "for i in range(len(prolink_list)):\n",
    "    prolink_list2.append(prolink_list[i]['href'])\n",
    "print(prolink_list2)\n",
    "\n",
    "final_pro=[]\n",
    "for i in range(len(pro_list3)):\n",
    "    final_pro.append([pro_list3[i]] +[prolink_list2[i]])\n",
    "print(final_pro)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['철학과', '박광태', 'http://faculty.korea.ac.kr/ktpark', 'ktpark@korea.ac.kr']]\n"
     ]
    }
   ],
   "source": [
    "final=[]\n",
    "final.append([subject_name[0]] + final_pro[0] + [mail_list2[0]])\n",
    "print(final)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ktpark@korea.ac.kr\n",
      "['ktpark@korea.ac.kr']\n"
     ]
    }
   ],
   "source": [
    "url2 = 'http://faculty.korea.ac.kr/kufaculty/ktpark/index.do'\n",
    "req2=requests.get(url2)\n",
    "html2 = req2.text\n",
    "soup = BeautifulSoup(html2, 'html.parser')\n",
    "\n",
    "mail_list=soup.select('p.info-mail')\n",
    "mail_list2 = []\n",
    "for i in mail_list:\n",
    "    mail = i.text\n",
    "    mail = re.sub('E-mail: ', '', mail)\n",
    "    mail = re.sub('\\n', '', mail)\n",
    "    mail_list2.append(mail)\n",
    "print(mail_list2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "#"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['경영학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_busi.do']\n",
      "['박광태', '박찬수', '유승원', '김재욱']\n",
      "['http://faculty.korea.ac.kr/ktpark', 'http://faculty.korea.ac.kr/chansu', 'http://faculty.korea.ac.kr/swyoo', 'http://faculty.korea.ac.kr/jaewook']\n",
      "['철학과', '한국사학과', '사학과', '심리학과', '사회학과', '한문학과', '영어영문학과', '독어독문학과', '불어물문학과', '중어중문학과', '노어노문학과', '일어일문학과', '서어서문학과', '언어학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_liberal_philo.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_korhist.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_history.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_psycho.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_soci.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_chin.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_eng.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_germ.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_french.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_chinese.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_rusian.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_japanese.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_spanish.do', 'http://faculty.korea.ac.kr//kufaculty/pro_liberal_linguistics.do']\n",
      "['성창원']\n",
      "['http://faculty.korea.ac.kr/sung']\n",
      "['박대재', '정태헌', '최광식']\n",
      "['http://faculty.korea.ac.kr/dj-park', 'http://faculty.korea.ac.kr/taehern', 'http://faculty.korea.ac.kr/kukh']\n",
      "['', '']\n",
      "[]\n",
      "pro 예외처리\n",
      "['최기홍']\n",
      "['http://faculty.korea.ac.kr/smile']\n",
      "['심재만', '조대엽']\n",
      "['http://faculty.korea.ac.kr/jayshim', 'http://faculty.korea.ac.kr/dycho']\n",
      "['송혁기', '임준철']\n",
      "['http://faculty.korea.ac.kr/keysong', 'http://faculty.korea.ac.kr/catcher1']\n",
      "['윤조원']\n",
      "['http://faculty.korea.ac.kr/joewon']\n",
      "['']\n",
      "[]\n",
      "pro 예외처리\n",
      "['지영래']\n",
      "['http://faculty.korea.ac.kr/jimage']\n",
      "['권혁준']\n",
      "['http://faculty.korea.ac.kr/hyokjun']\n",
      "['김진원']\n",
      "['http://faculty.korea.ac.kr/jinwon/']\n",
      "['조영남', '채성식']\n",
      "['http://faculty.korea.ac.kr/choyn', 'http://faculty.korea.ac.kr/csshhs']\n",
      "['']\n",
      "[]\n",
      "pro 예외처리\n",
      "['최재웅']\n",
      "['http://faculty.korea.ac.kr/jchoe']\n",
      "['생명과학부', '생명공학부', '식품공학과', '환경생태공학부', '\\n  식품자원경제학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_lifeSiences_Bio.do', 'http://faculty.korea.ac.kr//kufaculty/pro_lifeSiences_Biotech.do', 'http://faculty.korea.ac.kr//kufaculty/pro_lifeSiences_foodbio.do', 'http://faculty.korea.ac.kr//kufaculty/pro_lifeSiences_envi.do', 'http://faculty.korea.ac.kr//kufaculty/pro_lifeSiences_foodeco.do']\n",
      "['강성만', '고영규', '고제상', '구승회', '김옥매', '김윤기', '김익영', '김정국', '김재홍', '김준', '김태성', '김충호', '박세호', '백경희', '백자현', '신정섭', '안병윤', '안지훈', '오은규', '유상동', '윤봉준', '윤철원', '이상호', '이은진', '지성길', '최무현', '최상윤', '최의주', '홍정호', '송현규', '우재성', '최해웅']\n",
      "['http://faculty.korea.ac.kr/SKMG/', 'http://faculty.korea.ac.kr/ygko/', 'http://faculty.korea.ac.kr/ICCB', 'http://faculty.korea.ac.kr/metabolism/', 'http://faculty.korea.ac.kr/PDSL/', 'http://rna.korea.ac.kr/', 'http://faculty.korea.ac.kr/CMBio/', 'http://faculty.korea.ac.kr/jkkim/', 'http://faculty.korea.ac.kr/jhongkim/', 'http://faculty.korea.ac.kr/kimjoon/', 'http://faculty.korea.ac.kr/immunomicslab/', 'http://matrixbio.korea.ac.kr', 'http://faculty.korea.ac.kr/MILKU/', 'http://faculty.korea.ac.kr/khpaek/', 'http://faculty.korea.ac.kr/Molecular-Neurobiology/', 'http://faculty.korea.ac.kr/jsshin/', 'http://faculty.korea.ac.kr/viruslab/', 'http://faculty.korea.ac.kr/pbioa/', 'http://faculty.korea.ac.kr/plant/', 'http://faculty.korea.ac.kr/YooLab/', 'http://faculty.korea.ac.kr/neurosci', 'http://faculty.korea.ac.kr/cheolwony/', 'http://faculty.korea.ac.kr/sangho', 'http://faculty.korea.ac.kr/microbialgenetics/', 'http://faculty.korea.ac.kr/MCBL4278/', 'http://faculty.korea.ac.kr/choemh/', 'http://faculty.korea.ac.kr/sychoi/', 'http://faculty.korea.ac.kr/cdd', 'http://faculty.korea.ac.kr/jh_hong', 'http://song.korea.ac.kr', 'http://faculty.korea.ac.kr/mcsb', 'http://faculty.korea.ac.kr/ibp']\n",
      "['홍기창', '서용원', '고용', '김기덕', '정남현', '유승권', '김형기', '이호정', '김종훈', '김욱', '이철구', '황광연', '이동호', '이영식', '송문정', '전태훈', '한성옥', '송권화', '이병천', '김종윤', '김범석', '최인걸', '황광연', '정의환']\n",
      "['http://faculty.korea.ac.kr/AMB', 'http://faculty.korea.ac.kr/cropmolecularbreeding', 'http://faculty.korea.ac.kr/yongko', 'http://faculty.korea.ac.kr/biocontrol', 'http://faculty.korea.ac.kr/nchung', 'http://faculty.korea.ac.kr/CellFunctionRegulation', 'http://faculty.korea.ac.kr/CGRL', 'http://faculty.korea.ac.kr/APSB', 'http://faculty.korea.ac.kr/stemcell_lab', 'http://faculty.korea.ac.kr/kwook', 'http://ckaging.korea.ac.kr/doku.php', 'http://faculty.korea.ac.kr/KUMSB', 'http://faculty.korea.ac.kr/npm', 'http://faculty.korea.ac.kr/RRBL', 'http://faculty.korea.ac.kr/vhilab', 'http://faculty.korea.ac.kr/IML', 'http://faculty.korea.ac.kr/bioenergy', 'http://faculty.korea.ac.kr/MDE', 'http://faculty.korea.ac.kr/bcl', 'http://faculty.korea.ac.kr/jongkim', 'http://faculty.korea.ac.kr/KUPP', 'http://faculty.korea.ac.kr/choilab', 'http://faculty.korea.ac.kr/nrn3492', 'http://faculty.korea.ac.kr/PIPL']\n",
      "['김세헌', '류지훈', '이광원', '이민석', '이성준', '한재준']\n",
      "['http://faculty.korea.ac.kr/foodmicrobiology', 'http://faculty.korea.ac.kr/escheri', 'http://faculty.korea.ac.kr/TOX', 'http://faculty.korea.ac.kr/rheems', 'http://faculty.korea.ac.kr/fbs', 'http://faculty.korea.ac.kr/hanlab']\n",
      "['손요환', '이우균', '조기종', '박우준', '김규혁', '전성우', '정진호', '']\n",
      "['http://faculty.korea.ac.kr/ecology', 'http://faculty.korea.ac.kr/eGIS', 'http://faculty.korea.ac.kr/ecotoxicology', 'http://faculty.korea.ac.kr/aem320', 'http://faculty.korea.ac.kr/wood', 'http://faculty.korea.ac.kr/eepps', 'http://faculty.korea.ac.kr/jjung', '']\n",
      "['한두봉', '조용성', '서병선', '임송수', '박호정', '임재영', '안병일', 'GayanehKyureghian', 'KarHoLim', 'VincenzinaCaputo']\n",
      "['http://faculty.korea.ac.kr/han', 'http://faculty.korea.ac.kr/yscho', 'http://faculty.korea.ac.kr/seo', 'http://faculty.korea.ac.kr/songsoo', 'http://faculty.korea.ac.kr/hjeongpark', 'http://faculty.korea.ac.kr/jylimecon', 'http://faculty.korea.ac.kr/simhae08', 'http://faculty.korea.ac.kr/gkyuregh', 'http://faculty.korea.ac.kr/karholim', 'http://faculty.korea.ac.kr/vin']\n",
      "['정치외교학과', '행정학과', '경제학과', '통계학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_polisci_polisci.do', 'http://faculty.korea.ac.kr/http://faculty.korea.ac.kr/kufaculty/pro_polisci_admini.do', 'http://faculty.korea.ac.kr/http://faculty.korea.ac.kr/kufaculty/pro_polisci_economics.do', 'http://faculty.korea.ac.kr//kufaculty/pro_polisci_stat.do']\n",
      "['권혁용', '김동훈', '신재혁', '이용욱']\n",
      "['http://faculty.korea.ac.kr/kwon/', 'http://faculty.korea.ac.kr/dhkim71/', 'http://faculty.korea.ac.kr/shinj/', 'http://faculty.korea.ac.kr/yongir/']\n",
      "['권혁용', '김동훈', '신재혁', '이용욱']\n",
      "['http://faculty.korea.ac.kr/kwon/', 'http://faculty.korea.ac.kr/dhkim71/', 'http://faculty.korea.ac.kr/shinj/', 'http://faculty.korea.ac.kr/yongir/']\n",
      "['권혁용', '김동훈', '신재혁', '이용욱']\n",
      "['http://faculty.korea.ac.kr/kwon/', 'http://faculty.korea.ac.kr/dhkim71/', 'http://faculty.korea.ac.kr/shinj/', 'http://faculty.korea.ac.kr/yongir/']\n",
      "['구자용', '박민규', '박유성', '송성주', '송주원', '신승준', '이재원', '전명식', '정윤서', '정환', '조형준', '최상범', '최태련', '허명회']\n",
      "['http://faculty.korea.ac.kr/jykoo', 'http://faculty.korea.ac.kr/mpark2', 'http://faculty.korea.ac.kr/yspark', 'http://faculty.korea.ac.kr/sjsong', 'http://faculty.korea.ac.kr/jsong', 'http://faculty.korea.ac.kr/sjshin', 'http://faculty.korea.ac.kr/biostat', 'http://faculty.korea.ac.kr/jhun', 'http://faculty.korea.ac.kr/yoonsuh', 'http://faculty.korea.ac.kr/hwanch', 'http://faculty.korea.ac.kr/hj4cho', 'http://faculty.korea.ac.kr/choisang', 'http://faculty.korea.ac.kr/trchoi', 'http://faculty.korea.ac.kr/stat420']\n",
      "['수학과', '물리학과', '화학과', '지구환경과학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_sci_math.do', 'http://faculty.korea.ac.kr//kufaculty/pro_sci_physics.do', 'http://faculty.korea.ac.kr//kufaculty/pro_sci_chem.do', 'http://faculty.korea.ac.kr//kufaculty/pro_sci_earth.do']\n",
      "['김일두']\n",
      "['http://faculty.korea.ac.kr/waldoo']\n",
      "['이동헌', '최원식', '홍병식', '']\n",
      "['https://www.qdl.korea.ac.kr', 'http://faculty.korea.ac.kr/bioimaging', 'http://faculty.korea.ac.kr/bhong']\n",
      "pro 예외처리\n",
      "['이석중', '정광섭']\n",
      "['http://faculty.korea.ac.kr/sjlee/', 'http://faculty.korea.ac.kr/jeong_lab_chem/']\n",
      "['윤성택', '이미혜', '이영재', '이진한', '조석주']\n",
      "['http://faculty.korea.ac.kr/geochem', 'http://faculty.korea.ac.kr/ATMOS', 'http://faculty.korea.ac.kr/yjlee_EMSG', 'http://faculty.korea.ac.kr/fault', 'http://faculty.korea.ac.kr/sedrock']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['신소재공학부', '화공생명공학과', '건축사회환경공학과', '건축학과', '기계공학부', '전기전자공학부']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_eng_ingre.do', 'http://faculty.korea.ac.kr//kufaculty/pro_eng_chem.do', 'http://faculty.korea.ac.kr//kufaculty/pro_eng_infra.do', 'http://faculty.korea.ac.kr//kufaculty/pro_eng_archi.do', 'http://faculty.korea.ac.kr//kufaculty/pro_eng_mecha.do', 'http://faculty.korea.ac.kr//kufaculty/pro_engi_electro.do']\n",
      "['김영근', '김웅', '성태연', '이준호', '이해근', '장호']\n",
      "['http://faculty.korea.ac.kr/youngkeunkim', 'http://faculty.korea.ac.kr/nanotech', 'http://faculty.korea.ac.kr/oemd', 'http://faculty.korea.ac.kr/ironnsteel', 'http://faculty.korea.ac.kr/lsma', 'http://faculty.korea.ac.kr/fmr']\n",
      "['오민규', '정현욱', '이지원', '김중배']\n",
      "['http://faculty.korea.ac.kr/sysbio', 'http://faculty.korea.ac.kr/HyunWookJUNG', 'http://faculty.korea.ac.kr/leejw', 'http://faculty.korea.ac.kr/nanobiocat']\n",
      "['김지형', '박희등', '유철상', '윤영수', '이우진', '이종구', '이한선', '지광습', '홍승관', '주영규', '강영종', '허연숙']\n",
      "['http://faculty.korea.ac.kr/hyeong', 'http://faculty.korea.ac.kr/heedeung', 'http://faculty.korea.ac.kr/hydrology', 'http://faculty.korea.ac.kr/concrete', 'http://faculty.korea.ac.kr/woojin', 'http://faculty.korea.ac.kr/KUCML', 'http://faculty.korea.ac.kr/kuscl', 'http://faculty.korea.ac.kr/structure', 'http://faculty.korea.ac.kr/WEPE', 'http://faculty.korea.ac.kr/histructure', 'http://faculty.korea.ac.kr/steel', 'http://faculty.korea.ac.kr/urbane-squared']\n",
      "['류성룡']\n",
      "['http://faculty.korea.ac.kr/archi_cnh']\n",
      "['문영준', '박신석', '최원준']\n",
      "['http://faculty.korea.ac.kr/CFDAL', 'http://faculty.korea.ac.kr/drsspark', 'http://faculty.korea.ac.kr/CRG']\n",
      "['고영채', '박정호', '박종선', '']\n",
      "['http://faculty.korea.ac.kr/koyc', 'http://faculty.korea.ac.kr/mins', 'http://faculty.korea.ac.kr/jongsun']\n",
      "pro 예외처리\n",
      "['가정의학과', '내과', '법의학', '비뇨의학', '산부인과', '생화학분자생물학', '성형외과', '소아청소년과', '안과', '예방의학', '외과', '의학교육학', '이비인후과', '정신건강의학과', '정형외과', '진단검사의학과', '치과', '해부학', '흉부외과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_doc_family.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_internal.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_forensic.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_urology.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_gynecology.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_bioche.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_child.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_child.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_ophthalmology.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_prevent.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_general.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_edu.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_otor.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_neuropsychiatry.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_ort.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_diagnostic.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_dental.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_anatomy.do', 'http://faculty.korea.ac.kr//kufaculty/pro_doc_thoracic.do']\n",
      "['최윤선']\n",
      "['http://faculty.korea.ac.kr/younseonchoi']\n",
      "['나진오', '오상철', '이승룡', '이홍식', '임도선', '전훈재', '진윤태', '최원석', '최종일']\n",
      "['http://faculty.korea.ac.kr/koolup', 'http://faculty.korea.ac.kr/sachoh', 'http://faculty.korea.ac.kr/syl0801', 'http://faculty.korea.ac.kr/hslee60', 'http://faculty.korea.ac.kr/dslmd', 'http://faculty.korea.ac.kr/drchunhj', 'http://faculty.korea.ac.kr/JeenYT', 'http://faculty.korea.ac.kr/wschoi', 'http://faculty.korea.ac.kr/cvri']\n",
      "['손기훈']\n",
      "['http://faculty.korea.ac.kr/NeuroClock']\n",
      "['문두건', '박재영', '배재현', '최훈']\n",
      "['http://faculty.korea.ac.kr/dgmoon', 'http://faculty.korea.ac.kr/jaeyoungpark', 'http://faculty.korea.ac.kr/urobae', 'http://faculty.korea.ac.kr/doc71377']\n",
      "['안기훈']\n",
      "['http://faculty.korea.ac.kr/ahnkihoon']\n",
      "['손정원']\n",
      "['http://faculty.korea.ac.kr/biojs']\n",
      "['이기형', '정지태']\n",
      "['http://faculty.korea.ac.kr/doclee', 'http://faculty.korea.ac.kr/jt42525']\n",
      "['이기형', '정지태']\n",
      "['http://faculty.korea.ac.kr/doclee', 'http://faculty.korea.ac.kr/jt42525']\n",
      "['백세현', '엄영섭']\n",
      "['http://faculty.korea.ac.kr/shbaek6534', 'http://faculty.korea.ac.kr/eomy']\n",
      "['이원진', '윤석준']\n",
      "['http://faculty.korea.ac.kr/LWJ', 'http://faculty.korea.ac.kr/yoonsjlab']\n",
      "['김훈엽', '이선일', '홍광대']\n",
      "['http://faculty.korea.ac.kr/hoonyubkim', 'http://faculty.korea.ac.kr/cancer', 'http://faculty.korea.ac.kr/drhkd']\n",
      "['이영미']\n",
      "['http://faculty.korea.ac.kr/ymleehj']\n",
      "['박일호', '백승국', '최준']\n",
      "['http://faculty.korea.ac.kr/parkil5', 'http://faculty.korea.ac.kr/ENT-BK', 'http://faculty.korea.ac.kr/mednlaw', '']\n",
      "['고영훈', '이헌정', '한규만', '함병주']\n",
      "['http://faculty.korea.ac.kr/korean', 'http://faculty.korea.ac.kr/moodcircadian', 'http://faculty.korea.ac.kr/drkmhan', 'http://faculty.korea.ac.kr/hamlab']\n",
      "['박정호', '박종웅']\n",
      "['http://faculty.korea.ac.kr/canall', 'http://faculty.korea.ac.kr/HANDSURGERY']\n",
      "['윤수영']\n",
      "['http://faculty.korea.ac.kr/labmd']\n",
      "['장현석']\n",
      "['http://faculty.korea.ac.kr/omfs1109']\n",
      "['박선화', '선웅']\n",
      "['http://faculty.korea.ac.kr/sunhwa42', 'http://faculty.korea.ac.kr/woongsun']\n",
      "['김현구']\n",
      "['http://faculty.korea.ac.kr/kimhyunkoo']\n",
      "['교육학과', '체육교육과', '가정교육과', '수학교육과', '국어교육과', '영어교육과', '지리교육과', '역사교육과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_edu_pedago.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_sports.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_fami.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_math.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_kor.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_eng.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_geo.do', 'http://faculty.korea.ac.kr//kufaculty/pro_edu_his.do']\n",
      "['권대봉', '변기용', '신창호', '이보라', '한용진']\n",
      "['http://faculty.korea.ac.kr/hrd', 'http://faculty.korea.ac.kr/byunkiyong', 'http://faculty.korea.ac.kr/EHP-Classic', 'http://faculty.korea.ac.kr/boralee', 'http://faculty.korea.ac.kr/mankong']\n",
      "[]\n",
      "['http://faculty.korea.ac.kr/kufaculty/pedagogy/index.do']\n",
      "['이연숙', '이윤정', '임정하', '김유경', '이예영', '배다영', '유난숙']\n",
      "['https://faculty.korea.ac.kr/yonsuk/', 'https://faculty.korea.ac.kr/yleehe/', 'https://faculty.korea.ac.kr/jhlimkuhome/', 'https://faculty.korea.ac.kr/ykkim/', 'https://faculty.korea.ac.kr/young509/', 'http://faculty.korea.ac.kr/dbae', 'https://faculty.korea.ac.kr/starwell/']\n",
      "['김동중', '김용철']\n",
      "['http://faculty.korea.ac.kr/DJ_Kim', 'http://faculty.korea.ac.kr/ychkim']\n",
      "['고형진', '전경욱', '이관규', '이남호', '이순영']\n",
      "['https://faculty.korea.ac.kr/hjko/', 'https://faculty.korea.ac.kr/kwjeon/', 'https://faculty.korea.ac.kr/kklee/', 'https://faculty.korea.ac.kr/namoo/', 'https://faculty.korea.ac.kr/literacy/', '']\n",
      "['']\n",
      "[]\n",
      "pro 예외처리\n",
      "['서태열', '홍금수']\n",
      "['http://faculty.korea.ac.kr/geopia', 'http://faculty.korea.ac.kr/kshong85']\n",
      "[]\n",
      "['http://faculty.korea.ac.kr/blyi/', 'http://faculty.korea.ac.kr/E-history/', 'http://faculty.korea.ac.kr/nhyun/', 'http://faculty.korea.ac.kr/chokra/', 'http://faculty.korea.ac.kr/taijired/', 'http://faculty.korea.ac.kr/hadrianus/']\n",
      "['간호대학']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_nursing.do']\n",
      "['이숙자', '박은숙', '박영주', '유호신', '장성옥', '한금선', '서문경애', '송준아', '설근희', '신나미', '추진아', '박수경', '신현정', '오원옥', '김성렬', '김경해']\n",
      "['http://faculty.korea.ac.kr/scslee', 'http://faculty.korea.ac.kr/espark', 'http://faculty.korea.ac.kr/pyj1851', 'http://faculty.korea.ac.kr/hosihn', 'http://faculty.korea.ac.kr/sungok', 'http://faculty.korea.ac.kr/kuemsunhan', 'http://faculty.korea.ac.kr/seomun', 'http://faculty.korea.ac.kr/jasong', 'http://faculty.korea.ac.kr/ghseol', 'http://faculty.korea.ac.kr/nshin', 'http://faculty.korea.ac.kr/jinachoo', 'http://faculty.korea.ac.kr/sookyungpark', 'http://faculty.korea.ac.kr/hyunjeongshin', 'http://faculty.korea.ac.kr/wooh', 'http://faculty.korea.ac.kr/srkim74', 'http://faculty.korea.ac.kr/kyounghaekim']\n",
      "['바이오시스템의과학부', '보건환경융합과학부', '보건정책관리학부']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_health_bsm.do', 'http://faculty.korea.ac.kr//kufaculty/pro_health_hes.do', 'http://faculty.korea.ac.kr//kufaculty/pro_health_hpm.do']\n",
      "['김인환', '박재용', '서형주', '신민정', '임영희', '김희남']\n",
      "['http://faculty.korea.ac.kr/oleochemistry', 'http://faculty.korea.ac.kr/interactomics', 'http://faculty.korea.ac.kr/food2764', 'http://faculty.korea.ac.kr/CMNlab', 'http://faculty.korea.ac.kr/LIMYH', 'http://faculty.korea.ac.kr/hstanleykim1']\n",
      "['김성욱', '김정민', '김형동', '변상훈', '윤범철', '이승관', '이원호', '최달웅']\n",
      "['http://faculty.korea.ac.kr/swkim', 'http://faculty.korea.ac.kr/RHSL', 'http://faculty.korea.ac.kr/biomechanics1', 'http://faculty.korea.ac.kr/shbyeon', 'http://faculty.korea.ac.kr/andlab', 'http://faculty.korea.ac.kr/LEA', 'http://faculty.korea.ac.kr/wonhol', 'http://faculty.korea.ac.kr/yerihamm']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['김승섭', '김지환', '김혜영', '이종태', '정혜주', '김웅철']\n",
      "['http://faculty.korea.ac.kr/epik', 'http://faculty.korea.ac.kr/kjh2804', 'http://faculty.korea.ac.kr/HealthMetrics', 'http://faculty.korea.ac.kr/jtlee', 'http://faculty.korea.ac.kr/hpolicy', 'http://faculty.korea.ac.kr/kuc2842']\n",
      "['컴퓨터학과']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_info_computer.do']\n",
      "['유혁', '정연돈', '허준범']\n",
      "['http://faculty.korea.ac.kr/chuckyoo', 'http://faculty.korea.ac.kr/ydchung', 'http://faculty.korea.ac.kr/jbhur']\n",
      "['디자인조형학부']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_design.do']\n",
      "['']\n",
      "[]\n",
      "pro 예외처리\n",
      "['미디어학부']\n",
      "['http://faculty.korea.ac.kr//kufaculty/pro_media.do']\n",
      "['심재철', '박희선', '정세훈', '']\n",
      "['http://faculty.korea.ac.kr/shim', 'http://faculty.korea.ac.kr/heesunpark', 'http://faculty.korea.ac.kr/sjeong']\n",
      "pro 예외처리\n",
      "[['경영학과', '박광태', 'http://faculty.korea.ac.kr/ktpark'], ['경영학과', '박찬수', 'http://faculty.korea.ac.kr/chansu'], ['경영학과', '유승원', 'http://faculty.korea.ac.kr/swyoo'], ['경영학과', '김재욱', 'http://faculty.korea.ac.kr/jaewook'], ['철학과', '성창원', 'http://faculty.korea.ac.kr/sung'], ['한국사학과', '박대재', 'http://faculty.korea.ac.kr/dj-park'], ['한국사학과', '정태헌', 'http://faculty.korea.ac.kr/taehern'], ['한국사학과', '최광식', 'http://faculty.korea.ac.kr/kukh'], ['심리학과', '최기홍', 'http://faculty.korea.ac.kr/smile'], ['사회학과', '심재만', 'http://faculty.korea.ac.kr/jayshim'], ['사회학과', '조대엽', 'http://faculty.korea.ac.kr/dycho'], ['한문학과', '송혁기', 'http://faculty.korea.ac.kr/keysong'], ['한문학과', '임준철', 'http://faculty.korea.ac.kr/catcher1'], ['영어영문학과', '윤조원', 'http://faculty.korea.ac.kr/joewon'], ['불어물문학과', '지영래', 'http://faculty.korea.ac.kr/jimage'], ['중어중문학과', '권혁준', 'http://faculty.korea.ac.kr/hyokjun'], ['노어노문학과', '김진원', 'http://faculty.korea.ac.kr/jinwon/'], ['일어일문학과', '조영남', 'http://faculty.korea.ac.kr/choyn'], ['일어일문학과', '채성식', 'http://faculty.korea.ac.kr/csshhs'], ['언어학과', '최재웅', 'http://faculty.korea.ac.kr/jchoe'], ['생명과학부', '강성만', 'http://faculty.korea.ac.kr/SKMG/'], ['생명과학부', '고영규', 'http://faculty.korea.ac.kr/ygko/'], ['생명과학부', '고제상', 'http://faculty.korea.ac.kr/ICCB'], ['생명과학부', '구승회', 'http://faculty.korea.ac.kr/metabolism/'], ['생명과학부', '김옥매', 'http://faculty.korea.ac.kr/PDSL/'], ['생명과학부', '김윤기', 'http://rna.korea.ac.kr/'], ['생명과학부', '김익영', 'http://faculty.korea.ac.kr/CMBio/'], ['생명과학부', '김정국', 'http://faculty.korea.ac.kr/jkkim/'], ['생명과학부', '김재홍', 'http://faculty.korea.ac.kr/jhongkim/'], ['생명과학부', '김준', 'http://faculty.korea.ac.kr/kimjoon/'], ['생명과학부', '김태성', 'http://faculty.korea.ac.kr/immunomicslab/'], ['생명과학부', '김충호', 'http://matrixbio.korea.ac.kr'], ['생명과학부', '박세호', 'http://faculty.korea.ac.kr/MILKU/'], ['생명과학부', '백경희', 'http://faculty.korea.ac.kr/khpaek/'], ['생명과학부', '백자현', 'http://faculty.korea.ac.kr/Molecular-Neurobiology/'], ['생명과학부', '신정섭', 'http://faculty.korea.ac.kr/jsshin/'], ['생명과학부', '안병윤', 'http://faculty.korea.ac.kr/viruslab/'], ['생명과학부', '안지훈', 'http://faculty.korea.ac.kr/pbioa/'], ['생명과학부', '오은규', 'http://faculty.korea.ac.kr/plant/'], ['생명과학부', '유상동', 'http://faculty.korea.ac.kr/YooLab/'], ['생명과학부', '윤봉준', 'http://faculty.korea.ac.kr/neurosci'], ['생명과학부', '윤철원', 'http://faculty.korea.ac.kr/cheolwony/'], ['생명과학부', '이상호', 'http://faculty.korea.ac.kr/sangho'], ['생명과학부', '이은진', 'http://faculty.korea.ac.kr/microbialgenetics/'], ['생명과학부', '지성길', 'http://faculty.korea.ac.kr/MCBL4278/'], ['생명과학부', '최무현', 'http://faculty.korea.ac.kr/choemh/'], ['생명과학부', '최상윤', 'http://faculty.korea.ac.kr/sychoi/'], ['생명과학부', '최의주', 'http://faculty.korea.ac.kr/cdd'], ['생명과학부', '홍정호', 'http://faculty.korea.ac.kr/jh_hong'], ['생명과학부', '송현규', 'http://song.korea.ac.kr'], ['생명과학부', '우재성', 'http://faculty.korea.ac.kr/mcsb'], ['생명과학부', '최해웅', 'http://faculty.korea.ac.kr/ibp'], ['생명공학부', '홍기창', 'http://faculty.korea.ac.kr/AMB'], ['생명공학부', '서용원', 'http://faculty.korea.ac.kr/cropmolecularbreeding'], ['생명공학부', '고용', 'http://faculty.korea.ac.kr/yongko'], ['생명공학부', '김기덕', 'http://faculty.korea.ac.kr/biocontrol'], ['생명공학부', '정남현', 'http://faculty.korea.ac.kr/nchung'], ['생명공학부', '유승권', 'http://faculty.korea.ac.kr/CellFunctionRegulation'], ['생명공학부', '김형기', 'http://faculty.korea.ac.kr/CGRL'], ['생명공학부', '이호정', 'http://faculty.korea.ac.kr/APSB'], ['생명공학부', '김종훈', 'http://faculty.korea.ac.kr/stemcell_lab'], ['생명공학부', '김욱', 'http://faculty.korea.ac.kr/kwook'], ['생명공학부', '이철구', 'http://ckaging.korea.ac.kr/doku.php'], ['생명공학부', '황광연', 'http://faculty.korea.ac.kr/KUMSB'], ['생명공학부', '이동호', 'http://faculty.korea.ac.kr/npm'], ['생명공학부', '이영식', 'http://faculty.korea.ac.kr/RRBL'], ['생명공학부', '송문정', 'http://faculty.korea.ac.kr/vhilab'], ['생명공학부', '전태훈', 'http://faculty.korea.ac.kr/IML'], ['생명공학부', '한성옥', 'http://faculty.korea.ac.kr/bioenergy'], ['생명공학부', '송권화', 'http://faculty.korea.ac.kr/MDE'], ['생명공학부', '이병천', 'http://faculty.korea.ac.kr/bcl'], ['생명공학부', '김종윤', 'http://faculty.korea.ac.kr/jongkim'], ['생명공학부', '김범석', 'http://faculty.korea.ac.kr/KUPP'], ['생명공학부', '최인걸', 'http://faculty.korea.ac.kr/choilab'], ['생명공학부', '황광연', 'http://faculty.korea.ac.kr/nrn3492'], ['생명공학부', '정의환', 'http://faculty.korea.ac.kr/PIPL'], ['식품공학과', '김세헌', 'http://faculty.korea.ac.kr/foodmicrobiology'], ['식품공학과', '류지훈', 'http://faculty.korea.ac.kr/escheri'], ['식품공학과', '이광원', 'http://faculty.korea.ac.kr/TOX'], ['식품공학과', '이민석', 'http://faculty.korea.ac.kr/rheems'], ['식품공학과', '이성준', 'http://faculty.korea.ac.kr/fbs'], ['식품공학과', '한재준', 'http://faculty.korea.ac.kr/hanlab'], ['환경생태공학부', '손요환', 'http://faculty.korea.ac.kr/ecology'], ['환경생태공학부', '이우균', 'http://faculty.korea.ac.kr/eGIS'], ['환경생태공학부', '조기종', 'http://faculty.korea.ac.kr/ecotoxicology'], ['환경생태공학부', '박우준', 'http://faculty.korea.ac.kr/aem320'], ['환경생태공학부', '김규혁', 'http://faculty.korea.ac.kr/wood'], ['환경생태공학부', '전성우', 'http://faculty.korea.ac.kr/eepps'], ['환경생태공학부', '정진호', 'http://faculty.korea.ac.kr/jjung'], ['환경생태공학부', '', ''], ['\\n  식품자원경제학과', '한두봉', 'http://faculty.korea.ac.kr/han'], ['\\n  식품자원경제학과', '조용성', 'http://faculty.korea.ac.kr/yscho'], ['\\n  식품자원경제학과', '서병선', 'http://faculty.korea.ac.kr/seo'], ['\\n  식품자원경제학과', '임송수', 'http://faculty.korea.ac.kr/songsoo'], ['\\n  식품자원경제학과', '박호정', 'http://faculty.korea.ac.kr/hjeongpark'], ['\\n  식품자원경제학과', '임재영', 'http://faculty.korea.ac.kr/jylimecon'], ['\\n  식품자원경제학과', '안병일', 'http://faculty.korea.ac.kr/simhae08'], ['\\n  식품자원경제학과', 'GayanehKyureghian', 'http://faculty.korea.ac.kr/gkyuregh'], ['\\n  식품자원경제학과', 'KarHoLim', 'http://faculty.korea.ac.kr/karholim'], ['\\n  식품자원경제학과', 'VincenzinaCaputo', 'http://faculty.korea.ac.kr/vin'], ['정치외교학과', '권혁용', 'http://faculty.korea.ac.kr/kwon/'], ['정치외교학과', '김동훈', 'http://faculty.korea.ac.kr/dhkim71/'], ['정치외교학과', '신재혁', 'http://faculty.korea.ac.kr/shinj/'], ['정치외교학과', '이용욱', 'http://faculty.korea.ac.kr/yongir/'], ['행정학과', '권혁용', 'http://faculty.korea.ac.kr/kwon/'], ['행정학과', '김동훈', 'http://faculty.korea.ac.kr/dhkim71/'], ['행정학과', '신재혁', 'http://faculty.korea.ac.kr/shinj/'], ['행정학과', '이용욱', 'http://faculty.korea.ac.kr/yongir/'], ['경제학과', '권혁용', 'http://faculty.korea.ac.kr/kwon/'], ['경제학과', '김동훈', 'http://faculty.korea.ac.kr/dhkim71/'], ['경제학과', '신재혁', 'http://faculty.korea.ac.kr/shinj/'], ['경제학과', '이용욱', 'http://faculty.korea.ac.kr/yongir/'], ['통계학과', '구자용', 'http://faculty.korea.ac.kr/jykoo'], ['통계학과', '박민규', 'http://faculty.korea.ac.kr/mpark2'], ['통계학과', '박유성', 'http://faculty.korea.ac.kr/yspark'], ['통계학과', '송성주', 'http://faculty.korea.ac.kr/sjsong'], ['통계학과', '송주원', 'http://faculty.korea.ac.kr/jsong'], ['통계학과', '신승준', 'http://faculty.korea.ac.kr/sjshin'], ['통계학과', '이재원', 'http://faculty.korea.ac.kr/biostat'], ['통계학과', '전명식', 'http://faculty.korea.ac.kr/jhun'], ['통계학과', '정윤서', 'http://faculty.korea.ac.kr/yoonsuh'], ['통계학과', '정환', 'http://faculty.korea.ac.kr/hwanch'], ['통계학과', '조형준', 'http://faculty.korea.ac.kr/hj4cho'], ['통계학과', '최상범', 'http://faculty.korea.ac.kr/choisang'], ['통계학과', '최태련', 'http://faculty.korea.ac.kr/trchoi'], ['통계학과', '허명회', 'http://faculty.korea.ac.kr/stat420'], ['수학과', '김일두', 'http://faculty.korea.ac.kr/waldoo'], ['물리학과', '이동헌', 'https://www.qdl.korea.ac.kr'], ['물리학과', '최원식', 'http://faculty.korea.ac.kr/bioimaging'], ['물리학과', '홍병식', 'http://faculty.korea.ac.kr/bhong'], ['화학과', '이석중', 'http://faculty.korea.ac.kr/sjlee/'], ['화학과', '정광섭', 'http://faculty.korea.ac.kr/jeong_lab_chem/'], ['지구환경과학과', '윤성택', 'http://faculty.korea.ac.kr/geochem'], ['지구환경과학과', '이미혜', 'http://faculty.korea.ac.kr/ATMOS'], ['지구환경과학과', '이영재', 'http://faculty.korea.ac.kr/yjlee_EMSG'], ['지구환경과학과', '이진한', 'http://faculty.korea.ac.kr/fault'], ['지구환경과학과', '조석주', 'http://faculty.korea.ac.kr/sedrock'], ['신소재공학부', '김영근', 'http://faculty.korea.ac.kr/youngkeunkim'], ['신소재공학부', '김웅', 'http://faculty.korea.ac.kr/nanotech'], ['신소재공학부', '성태연', 'http://faculty.korea.ac.kr/oemd'], ['신소재공학부', '이준호', 'http://faculty.korea.ac.kr/ironnsteel'], ['신소재공학부', '이해근', 'http://faculty.korea.ac.kr/lsma'], ['신소재공학부', '장호', 'http://faculty.korea.ac.kr/fmr'], ['화공생명공학과', '오민규', 'http://faculty.korea.ac.kr/sysbio'], ['화공생명공학과', '정현욱', 'http://faculty.korea.ac.kr/HyunWookJUNG'], ['화공생명공학과', '이지원', 'http://faculty.korea.ac.kr/leejw'], ['화공생명공학과', '김중배', 'http://faculty.korea.ac.kr/nanobiocat'], ['건축사회환경공학과', '김지형', 'http://faculty.korea.ac.kr/hyeong'], ['건축사회환경공학과', '박희등', 'http://faculty.korea.ac.kr/heedeung'], ['건축사회환경공학과', '유철상', 'http://faculty.korea.ac.kr/hydrology'], ['건축사회환경공학과', '윤영수', 'http://faculty.korea.ac.kr/concrete'], ['건축사회환경공학과', '이우진', 'http://faculty.korea.ac.kr/woojin'], ['건축사회환경공학과', '이종구', 'http://faculty.korea.ac.kr/KUCML'], ['건축사회환경공학과', '이한선', 'http://faculty.korea.ac.kr/kuscl'], ['건축사회환경공학과', '지광습', 'http://faculty.korea.ac.kr/structure'], ['건축사회환경공학과', '홍승관', 'http://faculty.korea.ac.kr/WEPE'], ['건축사회환경공학과', '주영규', 'http://faculty.korea.ac.kr/histructure'], ['건축사회환경공학과', '강영종', 'http://faculty.korea.ac.kr/steel'], ['건축사회환경공학과', '허연숙', 'http://faculty.korea.ac.kr/urbane-squared'], ['건축학과', '류성룡', 'http://faculty.korea.ac.kr/archi_cnh'], ['기계공학부', '문영준', 'http://faculty.korea.ac.kr/CFDAL'], ['기계공학부', '박신석', 'http://faculty.korea.ac.kr/drsspark'], ['기계공학부', '최원준', 'http://faculty.korea.ac.kr/CRG'], ['전기전자공학부', '고영채', 'http://faculty.korea.ac.kr/koyc'], ['전기전자공학부', '박정호', 'http://faculty.korea.ac.kr/mins'], ['전기전자공학부', '박종선', 'http://faculty.korea.ac.kr/jongsun'], ['가정의학과', '최윤선', 'http://faculty.korea.ac.kr/younseonchoi'], ['내과', '나진오', 'http://faculty.korea.ac.kr/koolup'], ['내과', '오상철', 'http://faculty.korea.ac.kr/sachoh'], ['내과', '이승룡', 'http://faculty.korea.ac.kr/syl0801'], ['내과', '이홍식', 'http://faculty.korea.ac.kr/hslee60'], ['내과', '임도선', 'http://faculty.korea.ac.kr/dslmd'], ['내과', '전훈재', 'http://faculty.korea.ac.kr/drchunhj'], ['내과', '진윤태', 'http://faculty.korea.ac.kr/JeenYT'], ['내과', '최원석', 'http://faculty.korea.ac.kr/wschoi'], ['내과', '최종일', 'http://faculty.korea.ac.kr/cvri'], ['법의학', '손기훈', 'http://faculty.korea.ac.kr/NeuroClock'], ['비뇨의학', '문두건', 'http://faculty.korea.ac.kr/dgmoon'], ['비뇨의학', '박재영', 'http://faculty.korea.ac.kr/jaeyoungpark'], ['비뇨의학', '배재현', 'http://faculty.korea.ac.kr/urobae'], ['비뇨의학', '최훈', 'http://faculty.korea.ac.kr/doc71377'], ['산부인과', '안기훈', 'http://faculty.korea.ac.kr/ahnkihoon'], ['생화학분자생물학', '손정원', 'http://faculty.korea.ac.kr/biojs'], ['성형외과', '이기형', 'http://faculty.korea.ac.kr/doclee'], ['성형외과', '정지태', 'http://faculty.korea.ac.kr/jt42525'], ['소아청소년과', '이기형', 'http://faculty.korea.ac.kr/doclee'], ['소아청소년과', '정지태', 'http://faculty.korea.ac.kr/jt42525'], ['안과', '백세현', 'http://faculty.korea.ac.kr/shbaek6534'], ['안과', '엄영섭', 'http://faculty.korea.ac.kr/eomy'], ['예방의학', '이원진', 'http://faculty.korea.ac.kr/LWJ'], ['예방의학', '윤석준', 'http://faculty.korea.ac.kr/yoonsjlab'], ['외과', '김훈엽', 'http://faculty.korea.ac.kr/hoonyubkim'], ['외과', '이선일', 'http://faculty.korea.ac.kr/cancer'], ['외과', '홍광대', 'http://faculty.korea.ac.kr/drhkd'], ['의학교육학', '이영미', 'http://faculty.korea.ac.kr/ymleehj'], ['이비인후과', '박일호', 'http://faculty.korea.ac.kr/parkil5'], ['이비인후과', '백승국', 'http://faculty.korea.ac.kr/ENT-BK'], ['이비인후과', '최준', 'http://faculty.korea.ac.kr/mednlaw'], ['정신건강의학과', '고영훈', 'http://faculty.korea.ac.kr/korean'], ['정신건강의학과', '이헌정', 'http://faculty.korea.ac.kr/moodcircadian'], ['정신건강의학과', '한규만', 'http://faculty.korea.ac.kr/drkmhan'], ['정신건강의학과', '함병주', 'http://faculty.korea.ac.kr/hamlab'], ['정형외과', '박정호', 'http://faculty.korea.ac.kr/canall'], ['정형외과', '박종웅', 'http://faculty.korea.ac.kr/HANDSURGERY'], ['진단검사의학과', '윤수영', 'http://faculty.korea.ac.kr/labmd'], ['치과', '장현석', 'http://faculty.korea.ac.kr/omfs1109'], ['해부학', '박선화', 'http://faculty.korea.ac.kr/sunhwa42'], ['해부학', '선웅', 'http://faculty.korea.ac.kr/woongsun'], ['흉부외과', '김현구', 'http://faculty.korea.ac.kr/kimhyunkoo'], ['교육학과', '권대봉', 'http://faculty.korea.ac.kr/hrd'], ['교육학과', '변기용', 'http://faculty.korea.ac.kr/byunkiyong'], ['교육학과', '신창호', 'http://faculty.korea.ac.kr/EHP-Classic'], ['교육학과', '이보라', 'http://faculty.korea.ac.kr/boralee'], ['교육학과', '한용진', 'http://faculty.korea.ac.kr/mankong'], ['가정교육과', '이연숙', 'https://faculty.korea.ac.kr/yonsuk/'], ['가정교육과', '이윤정', 'https://faculty.korea.ac.kr/yleehe/'], ['가정교육과', '임정하', 'https://faculty.korea.ac.kr/jhlimkuhome/'], ['가정교육과', '김유경', 'https://faculty.korea.ac.kr/ykkim/'], ['가정교육과', '이예영', 'https://faculty.korea.ac.kr/young509/'], ['가정교육과', '배다영', 'http://faculty.korea.ac.kr/dbae'], ['가정교육과', '유난숙', 'https://faculty.korea.ac.kr/starwell/'], ['수학교육과', '김동중', 'http://faculty.korea.ac.kr/DJ_Kim'], ['수학교육과', '김용철', 'http://faculty.korea.ac.kr/ychkim'], ['국어교육과', '고형진', 'https://faculty.korea.ac.kr/hjko/'], ['국어교육과', '전경욱', 'https://faculty.korea.ac.kr/kwjeon/'], ['국어교육과', '이관규', 'https://faculty.korea.ac.kr/kklee/'], ['국어교육과', '이남호', 'https://faculty.korea.ac.kr/namoo/'], ['국어교육과', '이순영', 'https://faculty.korea.ac.kr/literacy/'], ['지리교육과', '서태열', 'http://faculty.korea.ac.kr/geopia'], ['지리교육과', '홍금수', 'http://faculty.korea.ac.kr/kshong85'], ['간호대학', '이숙자', 'http://faculty.korea.ac.kr/scslee'], ['간호대학', '박은숙', 'http://faculty.korea.ac.kr/espark'], ['간호대학', '박영주', 'http://faculty.korea.ac.kr/pyj1851'], ['간호대학', '유호신', 'http://faculty.korea.ac.kr/hosihn'], ['간호대학', '장성옥', 'http://faculty.korea.ac.kr/sungok'], ['간호대학', '한금선', 'http://faculty.korea.ac.kr/kuemsunhan'], ['간호대학', '서문경애', 'http://faculty.korea.ac.kr/seomun'], ['간호대학', '송준아', 'http://faculty.korea.ac.kr/jasong'], ['간호대학', '설근희', 'http://faculty.korea.ac.kr/ghseol'], ['간호대학', '신나미', 'http://faculty.korea.ac.kr/nshin'], ['간호대학', '추진아', 'http://faculty.korea.ac.kr/jinachoo'], ['간호대학', '박수경', 'http://faculty.korea.ac.kr/sookyungpark'], ['간호대학', '신현정', 'http://faculty.korea.ac.kr/hyunjeongshin'], ['간호대학', '오원옥', 'http://faculty.korea.ac.kr/wooh'], ['간호대학', '김성렬', 'http://faculty.korea.ac.kr/srkim74'], ['간호대학', '김경해', 'http://faculty.korea.ac.kr/kyounghaekim'], ['바이오시스템의과학부', '김인환', 'http://faculty.korea.ac.kr/oleochemistry'], ['바이오시스템의과학부', '박재용', 'http://faculty.korea.ac.kr/interactomics'], ['바이오시스템의과학부', '서형주', 'http://faculty.korea.ac.kr/food2764'], ['바이오시스템의과학부', '신민정', 'http://faculty.korea.ac.kr/CMNlab'], ['바이오시스템의과학부', '임영희', 'http://faculty.korea.ac.kr/LIMYH'], ['바이오시스템의과학부', '김희남', 'http://faculty.korea.ac.kr/hstanleykim1'], ['보건환경융합과학부', '김성욱', 'http://faculty.korea.ac.kr/swkim'], ['보건환경융합과학부', '김정민', 'http://faculty.korea.ac.kr/RHSL'], ['보건환경융합과학부', '김형동', 'http://faculty.korea.ac.kr/biomechanics1'], ['보건환경융합과학부', '변상훈', 'http://faculty.korea.ac.kr/shbyeon'], ['보건환경융합과학부', '윤범철', 'http://faculty.korea.ac.kr/andlab'], ['보건환경융합과학부', '이승관', 'http://faculty.korea.ac.kr/LEA'], ['보건환경융합과학부', '이원호', 'http://faculty.korea.ac.kr/wonhol'], ['보건환경융합과학부', '최달웅', 'http://faculty.korea.ac.kr/yerihamm'], ['보건정책관리학부', '김승섭', 'http://faculty.korea.ac.kr/epik'], ['보건정책관리학부', '김지환', 'http://faculty.korea.ac.kr/kjh2804'], ['보건정책관리학부', '김혜영', 'http://faculty.korea.ac.kr/HealthMetrics'], ['보건정책관리학부', '이종태', 'http://faculty.korea.ac.kr/jtlee'], ['보건정책관리학부', '정혜주', 'http://faculty.korea.ac.kr/hpolicy'], ['보건정책관리학부', '김웅철', 'http://faculty.korea.ac.kr/kuc2842'], ['컴퓨터학과', '유혁', 'http://faculty.korea.ac.kr/chuckyoo'], ['컴퓨터학과', '정연돈', 'http://faculty.korea.ac.kr/ydchung'], ['컴퓨터학과', '허준범', 'http://faculty.korea.ac.kr/jbhur'], ['미디어학부', '심재철', 'http://faculty.korea.ac.kr/shim'], ['미디어학부', '박희선', 'http://faculty.korea.ac.kr/heesunpark'], ['미디어학부', '정세훈', 'http://faculty.korea.ac.kr/sjeong']]\n"
     ]
    }
   ],
   "source": [
    "#wb = openpyxl.Workbook()\n",
    "#sheet =wb.active\n",
    "#sheet.title='교수정보'\n",
    "#sheet.append(['단과대','학부','교수명','홈페이지','이메일'])\n",
    "\n",
    "final=[]\n",
    "mail_list2 = []\n",
    "\n",
    "cnt=0\n",
    "for url in urllist:\n",
    "    req=requests.get(url)\n",
    "    html = req.text\n",
    "    soup = BeautifulSoup(html, 'html.parser')\n",
    "    pro_list = soup.find_all('tbody')\n",
    "    \n",
    "    #학과 리스트 선택\n",
    "    subject = soup.select('div#container')\n",
    "\n",
    "    subject_list=[]\n",
    "    for i in subject:\n",
    "        subject_list=i.select('h4')\n",
    "    \n",
    "    subject_list2=[]\n",
    "    for i in subject_list:\n",
    "        subject_list2.append(i.select('a'))\n",
    "\n",
    "    subject_name=[]\n",
    "    for i in range(len(subject_list2)):\n",
    "        subject_name.append(subject_list2[i][0].text)\n",
    "    print(subject_name)\n",
    "    \n",
    "    subject_list3=[]\n",
    "    for i in range(len(subject_list2)):\n",
    "        subject_list3.append(subject_list2[i][0]['href'])\n",
    "\n",
    "    subject_url=[]\n",
    "    for i in range(len(subject_list3)):\n",
    "        subject_url.append('http://faculty.korea.ac.kr/' + subject_list3[i])\n",
    "    print(subject_url)\n",
    "    \n",
    "    #학과별 교수명 따기\n",
    "    for j in range(len(subject_url)):\n",
    "        url2=subject_url[j]\n",
    "        req2=requests.get(url2)\n",
    "        html2 = req2.text\n",
    "        soup2 = BeautifulSoup(html2, 'html.parser')\n",
    "        pro_list = soup2.find_all('tbody')\n",
    "        for i in pro_list:\n",
    "            pro_list2=i.select('th')\n",
    "            \n",
    "        pro_list3 =[] \n",
    "        pro_list3_1=[]\n",
    "        for i in pro_list2:\n",
    "            pro_list3_1.append(i.text)\n",
    "\n",
    "        for i in range(len(pro_list3_1)):\n",
    "            if len(pro_list3_1[i])==0:\n",
    "                del pro_list3_1[i]\n",
    "                \n",
    "        for i in pro_list3_1:\n",
    "            i= re.sub(' ', '', i)\n",
    "            i= re.sub('\\n', '', i)\n",
    "            i= re.sub('\\t', '', i)\n",
    "            pro_list3.append(i)\n",
    "        print(pro_list3)\n",
    "    \n",
    "        for i in pro_list:\n",
    "            prolink_list=i.select('a')\n",
    "        prolink_list2 =[]\n",
    "        for i in range(len(prolink_list)):\n",
    "            prolink_list2.append(prolink_list[i]['href'])\n",
    "        print(prolink_list2)\n",
    "        \n",
    "        '''\n",
    "        mail_list2 = []\n",
    "        for url3 in prolink_list2:\n",
    "            url3\n",
    "            req3=requests.get(url3)\n",
    "            html3 = req3.text\n",
    "            soup3 = BeautifulSoup(html3, 'html.parser')\n",
    "\n",
    "            mail_list=soup3.select('p.info-mail')\n",
    "            \n",
    "            for i in mail_list:\n",
    "                mail = i.text\n",
    "                mail = re.sub('E-mail: ', '', mail)\n",
    "                mail = re.sub('\\n', '', mail)\n",
    "                mail_list2.append(mail)\n",
    "            \n",
    "        print(mail_list2)\n",
    "        \n",
    "        '''\n",
    "        final_pro=[]\n",
    "        try:\n",
    "            \n",
    "            for i in range(len(pro_list3)):\n",
    "                final_pro.append([pro_list3[i]] +[prolink_list2[i]])\n",
    "        except:\n",
    "            print('pro 예외처리')\n",
    "        try:\n",
    "            \n",
    "            for i in range(len(final_pro)):\n",
    "                final.append([subject_name[j]] + final_pro[i])\n",
    "        except:\n",
    "            print('index 예외처리')\n",
    "        for content in final:\n",
    "            try:\n",
    "                a = content[0]\n",
    "                b = content[1]\n",
    "                c = content[2]\n",
    "            \n",
    "                sheet.append([a,b,c])\n",
    "            except:\n",
    "                print('예외처리')\n",
    "                \n",
    "        \n",
    "#wb.save('교수정보.xlsx')\n",
    "print(final)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {},
   "outputs": [],
   "source": [
    "wb = openpyxl.Workbook()\n",
    "sheet =wb.active\n",
    "sheet.title='교수정보'\n",
    "sheet.append(['학부','교수명','홈페이지'])\n",
    "\n",
    "for i in final:\n",
    "    try:\n",
    "        a = i[0]\n",
    "        b = i[1]\n",
    "        c = i[2]\n",
    "        sheet.append([a,b,c])\n",
    "    except:\n",
    "        print('예외처리')\n",
    "wb.save('교수정보.xlsx')"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}