ETF 종목가져오기

import requests
import json
from pandas.io.json import json_normalize
url = 'https://finance.naver.com/api/sise/etfItemList.nhn'
json_data = json.loads(requests.get(url).text)
df = json_normalize(json_data['result']['etfItemList'])

df.to_excel('etf_list.xlsx');