통계청 지역 정보

loc_to_csv.py

# http://kssc.kostat.go.kr/ksscNew_web/kssc/common/CommonBoardList.do?gubun=1&strCategoryNameCode=019&strBbsId=kascrr&categoryMenu=014

import pandas as pd

input = pd.ExcelFile("한국행정구역분류_2018.7.1.기준_최종.xls")
sheet = input.parse(4, 1)
sheet.to_csv("loc.csv")

sheet["label"] = sheet["시도"] + "_" + sheet["시군구"]
sheet["text"] = sheet["시도"] + " " + sheet["시군구"] + " " + sheet["행정구역명"] + " " + sheet["행정동"] + " " + sheet["법정동"]

data = sheet.loc[~(sheet["시도"] == sheet["시군구"])][["label", "text"]]
data.to_csv("loc.tsv", sep='\t', header=False, index=False, encoding="utf-8")