SANG HOON HAM

<span style="caret-color: #333333; color: #333333; font-family: 'Noto Sans KR', -apple-system, system-ui, BlinkMacSystemFont, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; excel_sheet.append([num, item['title'], item['link']])
<span style="caret-color: #333333; color: #333333; font-family: 'Noto Sans KR', -apple-system, system-ui, BlinkMacSystemFont, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">
<span style="caret-color: #333333; color: #333333; font-family: 'Noto Sans KR', -apple-system, system-ui, BlinkMacSystemFont, 'Apple SD Gothic Neo', 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif, Oxygen, Ubuntu, Cantarell, 'Fira Sans', 'Droid Sans', Helvetica; font-size: 16px; background-color: #ffffff;">이부분에서 그대로 하면 /b 와같은 텍스트도 같이 나오는데 어떻게 하면 필요한 제목만 뽑을 수 있을까요?

네이버 쇼핑 API 엑셀로 옮길 떄 질문있어요!

import requests, pprint
import openpyxl

excel_file = openpyxl.Workbook()
excel_sheet = excel_file.active
excel_sheet.column_dimensions['B'].width = 100
excel_sheet.column_dimensions['C'].width = 100
excel_sheet.append(['번호','제목','링크'])
client_id = 'gK2JvAAN997VlvpHrZbV'
client_secret &nbsp;= 'yXIHkID5kR'

num = 0
for index in range(10):
&nbsp; &nbsp; start_num = 1 + (index*100)
&nbsp; &nbsp; naver_open_api = 'https://openapi.naver.com/v1/search/shop.json?query=android&display=100&start' + str(start_num)
&nbsp; &nbsp; header_params = {'X-Naver-Client-Id': client_id ,'X-Naver-Client-Secret':client_secret}
&nbsp; &nbsp; res = requests.get(naver_open_api, headers = header_params)
&nbsp; &nbsp; if res.status_code == 200:
&nbsp; &nbsp; &nbsp; &nbsp; data = res.json()
&nbsp; &nbsp; &nbsp; &nbsp; for item in data['items']:
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num += 1
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; excel_sheet.append([num, item['title'], item['link']])
&nbsp; &nbsp; else:
&nbsp; &nbsp; &nbsp; &nbsp; print('Error:', res.status_code)

excel_file.save('0710연습.xlsx')
excel_file.close()

data = res.json()
&nbsp; &nbsp; &nbsp; &nbsp; for item in data['items']:
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num += 1
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; print(num, item['title'], item['lprice'], item['link'])

이러한 코드에서 item['title'].get_text() 하면 오류가 나오더라구요..ㅜ Open api 네이버 쇼핑 리스트 뽑아오는 강의입니다.

SANG HOON HAM

Bài viết