DART 고유번호

Python

ianman99 ㅣ 2024. 3. 7. 10:57

import requests

import io

import zipfile

import xmltodict

import pandas as pd

key = "API 인증키"

params = {

"crtfc_key": key

}

resp = requests.get(url, params=params)

f = io.BytesIO(resp.content)

zfile = zipfile.ZipFile(f)

zfile.namelist()

xml = zfile.read("CORPCODE.xml").decode("utf-8")

dict_data = xmltodict.parse(xml)

data = dict_data['result']['list']

df = pd.DataFrame(data)

df.head()

df = pd.DataFrame(data)

csv_file_path = 'data.csv'

df.to_csv(csv_file_path, index=False, encoding='utf-8-sig')

ianman99