테크니션

import requests
import json

def search_address(api_key, keyword):
    url = "https://business.juso.go.kr/addrlink/addrLinkApiJsonp.do"
    params = {
        "currentPage": "1",
        "countPerPage": "1",
        "keyword": keyword,
        "confmKey": api_key,
        "resultType": "json",
        "hstryYn" :"N",
        "firstSort": "none",
        "addInfoYn": "Y"
    }

    # JSONP 요청을 보내기 위해 callback 파라미터를 지정합니다.
    params["callback"] = "callback"

    response = requests.get(url, params=params)

    # 응답을 JSONP 형식으로 받기 위해 callback 부분을 잘라냅니다.
    jsonp_data = response.text[response.text.find("(") + 1:response.text.rfind(")")]

    # JSON 형식으로 파싱합니다.
    result = json.loads(jsonp_data)

    if result.get("results"):
        address_info = result["results"]["juso"][0]
        return address_info
    else:
        return None


def main():
    api_key = ""
    keyword = "서귀포시 태평로 351"

    address_info = search_address(api_key, keyword)

    if address_info:
        print("주소:", address_info["roadAddr"])
        print("우편번호:", address_info["zipNo"])
        print("동사무소:", address_info["hemdNm"])
    else:
        print("주소 검색에 실패했습니다.")


if __name__ == "__main__":
    main()

import time
from selenium import webdriver
import pandas as pd
from selenium.webdriver.common.by import By
import openpyxl


file_path = r'C:\Users\Administrator\Downloads\all_personn.xlsx'
sheet_name = 'Sheet1'

df = pd.read_excel(file_path, sheet_name=sheet_name)

data_list_juso = df["지번주소"].tolist()
driver= webdriver.Chrome()
dongsamuso=[]
for i in range(0,len(data_list_juso)):
    url = "https://www.juso.go.kr/support/AddressMainSearch.do?searchKeyword=&dsgubuntext=&dscity1text=&dscounty1text=&dsemd1text=&dsri1text=&dssan1text=&dsrd_nm1text=&aotYn=N"
    driver.get(url)
    time.sleep(0.1)
    driver.maximize_window()
    time.sleep(0.22)
    ddd = ' '.join(data_list_juso[i].split()[:3])
    #ddd = data_list_juso[i]
    # input_xpath = r'/html/body/div[4]/main/div/section[1]/div[1]/form/fieldset/div/div[1]/input[1]'
    input_xpath = r'/html/body/div[2]/div/main/div[1]/form/fieldset/div[1]/div[1]/div/input[1]'
    input_element = driver.find_element(By.XPATH, input_xpath)
    input_element.send_keys(ddd)
    time.sleep(0.2)
    button_xpath = r'/html/body/div[2]/div/main/div[1]/form/fieldset/div[1]/button'
    button_element = driver.find_element(By.XPATH, button_xpath)
    button_element.click()

    time.sleep(2)

    nbutton_xpath = r'#list1 > div.addrWrap > div.addAddr > a'
    nbutton_element = driver.find_element(By.CSS_SELECTOR, nbutton_xpath)
    nbutton_element.click()
    paegi = r'#list1'
    meeee = driver.find_element(By.CSS_SELECTOR, paegi).text.split('\n')
    k = list(meeee[1])[-1]
    if k == '지':
        anbutton_xpath = r' # list2 > div.addrWrap > div.addAddr > a'
        anbutton_element = driver.find_element(By.CSS_SELECTOR, nbutton_xpath)
        anbutton_element.click()

        text_xpath = r'#engAddr_2 > ul > li:nth-child(3) > span:nth-child(2)'
        text_element = driver.find_element(By.CSS_SELECTOR, text_xpath)
        text_value = text_element.text
        words = text_value.split()
        second_last_word = str(words[:-1])

    else:
        text_xpath = r'#engAddr_1 > ul > li:nth-child(3) > span:nth-child(2)'
        text_element = driver.find_element(By.CSS_SELECTOR, text_xpath)
        text_value = text_element.text

    words = text_value.split()
    second_last_word = str(words[:-1])
    dongsamuso.append(second_last_word)
    workbook = openpyxl.load_workbook(file_path)
    sheet_name = 'Sheet1'
    sheet = workbook[sheet_name]
    sheee_name = 'H'+str(i+2)
    sheet[sheee_name] = second_last_word
    workbook.save(file_path)