JSON_DataFram

import urllib.parse
import urllib.request
import json
import pandas as pd

# 네이버 개발자센터에서 발급받은 ID/SECRET
client_id = "AR1qEhVIYM6TRV0bdcBM"
client_secret = "2rdVEC1idb"

query = urllib.parse.quote("ChatGPT")
url = f"https://openapi.naver.com/v1/search/news.json?query={query}&display=5"

# request 생성
request = urllib.request.Request(url)
request.add_header("X-Naver-Client-Id", client_id)
request.add_header("X-Naver-Client-Secret", client_secret)

# API 호출
response = urllib.request.urlopen(request)
rescode = response.getcode()

if rescode == 200:
    news_json1 = response.read().decode('utf-8')
    print("원본 JSON:\n", news_json1)

    # JSON 파싱
    json_result = json.loads(news_json1)
    
    # Pandas DataFrame 변환
    if 'items' in json_result:
        df = pd.json_normalize(json_result['items'])
        print("\nDataFrame 결과:")
        print(df)
    else:
        print("JSON 응답에 'items' 키가 없습니다.")
else:
    print("Error Code:" + str(rescode))