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');