import requests
from bs4 import BeautifulSoup
import pandas as pd
# 유빈이 제공한 사건 링크
url = "https://www.tankauction.com/ca/caView.php?tid=2292041&chkNo=1&TotNo=1"
headers = {
'User-Agent': 'Mozilla/5.0'
}
response = requests.get(url, headers=headers)
soup = BeautifulSoup(response.text, 'html.parser')
# 데이터 추출 예시 (실제 태그 구조 확인 필요)
def get_text(selector):
element = soup.select_one(selector)
return element.text.strip() if element else ""
# 각 항목은 실제 구조에 따라 selector 바꿔야 해
data = {
"사건번호": get_text("div.caseNum > strong"),
"물건소재지": get_text("div.caseAddr"),
"감정가": get_text("table.tbl_view td:contains('감정가') + td"),
"최저입찰가": get_text("table.tbl_view td:contains('최저입찰가') + td"),
"입찰기일": get_text("table.tbl_view td:contains('입찰기일') + td"),
"유찰횟수": get_text("table.tbl_view td:contains('유찰횟수') + td"),
"URL": url
}
df = pd.DataFrame([data])
df.to_excel("tankauction_result.xlsx", index=False)
print("엑셀 저장 완료!")
