๋ฐ๋ณต ํฌ๋กค๋ง ์ get_text() ๊ฒฐ๊ณผ None์ธ ๊ฒฝ์ฐ๋ฅผ ๊ฑด๋๋ฐ๋ ๋ฐฉ๋ฒ?
์ ๋ ๊ฐ์ ์ง๋ฌธ์ ํ๋ ค๊ณ ๋ค์ด์๋ค๊ฐ ๊ฐ์ฌ๋ ๋ต๋ณ์ ๋ณด๊ณ ์๋์ ๊ฐ์ด ํด๊ฒฐํด๋ณด์์ต๋๋ค. ๋น์ทํ ๊ณ ๋ฏผ์ ํ์ ๋ถ๋ค๊ป ๋์์ด ๋๊ธธ ๋ฐ๋ผ๋ฉด์ ์ฝ๋ ์ฒจ๋ถํด๋ด
๋๋ค. import requests from bs4 import BeautifulSoup import openpyxl res = requests.get('http://corners.gmarket.co.kr/Bestsellers?viewType=G&groupCode=G01') soup = BeautifulSoup(res.content, 'html.parser') excel_file = openpyxl.Workbook() excel_sheet = excel_file.active excel_sheet.column_dimensions['B'].width = 100 excel_sheet.column_dimensions['C'].width = 20 excel_sheet.column_dimensions['D'].width = 20 excel_sheet.column_dimensions['E'].width = 20 excel_sheet.append(['๋ญํน', '์ํ๋ช
', 'ํ ์ธ ์ ๊ฐ๊ฒฉ', 'ํ ์ธ๋ฅ ', 'ํ ์ธ๋ ๊ฐ๊ฒฉ']) if res.status_code == 200 : best_list = soup.select('div.best-list') best_item = best_list[1] products = best_item.select('ul > li') for index, item in enumerate(products): name = item.select_one('a.itemname') origin_price = item.select_one('div.o-price') sale_price = item.select_one('div.s-price > strong') sale_percent = item.select_one('div.s-price em') discount_percent = 0 original_price = 0 if sale_percent == None : discount_percent = str('0%') original_price = sale_price.get_text() else : discount_percent = sale_percent.get_text() original_price = origin_price.get_text() print(str(index+1), name.get_text(), original_price, discount_percent, sale_price.get_text()) excel_sheet.append ( [str(index+1), name.get_text(), original_price, discount_percent, sale_price.get_text()]) else : print ("Error Code:", res.status_code) excel_file.save('G_market_item_list.xlsx') excel_file.close()