pykrx 에서 주가데이터를 받아서 mysql로 데이터저장

import pandas as pd from sqlalchemy import create_engine import pymysql from pykrx import stock pymysql.install_as_MySQLdb() import string start = '20100101' end = '20210514' all_code_list = stock.get_market_ticker_list(market='ALL') engine = create_engine("mysql+mysqldb://이름:비밀번호@호스트/데이터베이스", encoding='utf-8') for code in all_code_list: stock_name = stock.get_market_ticker_name(code) if '스팩' in stock_name: continue df = stock.get_market_ohlcv_by_date(start,end,code) try: conn = engine.connect()...