SANG HOON HAM
Reviews Written
-
Average Rating
-
Posts
Q&A
๋ค์ด๋ฒ ์ผํ API ์์ ๋ก ์ฎ๊ธธ ๋ ์ง๋ฌธ์์ด์!
excel_sheet.append([num, item['title'], item['link']]) ์ด๋ถ๋ถ์์ ๊ทธ๋๋ก ํ๋ฉด /b ์๊ฐ์ ํ ์คํธ๋ ๊ฐ์ด ๋์ค๋๋ฐ ์ด๋ป๊ฒ ํ๋ฉด ํ์ํ ์ ๋ชฉ๋ง ๋ฝ์ ์ ์์๊น์?
- 0
- 5
- 754
Q&A
๋ค์ด๋ฒ ์ผํ 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 = 'yXIHkID5kR' num = 0 for index in range(10): start_num = 1 + (index*100) naver_open_api = 'https://openapi.naver.com/v1/search/shop.json?query=android&display=100&start' + str(start_num) header_params = {'X-Naver-Client-Id': client_id ,'X-Naver-Client-Secret':client_secret} res = requests.get(naver_open_api, headers = header_params) if res.status_code == 200: data = res.json() for item in data['items']: num += 1 excel_sheet.append([num, item['title'], item['link']]) else: print('Error:', res.status_code) excel_file.save('0710์ฐ์ต.xlsx') excel_file.close()
- 0
- 5
- 754
Q&A
Open Api ์ ๊ดํด์
data = res.json() for item in data['items']: num += 1 print(num, item['title'], item['lprice'], item['link']) ์ด๋ฌํ ์ฝ๋์์ item['title'].get_text() ํ๋ฉด ์ค๋ฅ๊ฐ ๋์ค๋๋ผ๊ตฌ์..ใ Open api ๋ค์ด๋ฒ ์ผํ ๋ฆฌ์คํธ ๋ฝ์์ค๋ ๊ฐ์์ ๋๋ค.
- 0
- 2
- 306




