2015년부터 연간 재무데이터 생성

from sqlalchemy import create_engine import pymysql import pandas as pd import OpenDartReader from pykrx import stock import string df = pd.read_excel('우선주.xlsx') upper_code = df['Symbol'] upper_all_code = [] for code in upper_code: upper_all_code.append(code[1:]) pymysql.install_as_MySQLdb() engine = create_engine("mysql+mysqldb://root:[email protected]/재무데이터", encoding='utf-8') date = 2020 date2 = date - 3 date3 = date2 - 3 all_code_name = stock.get_market_ticker_list(market='ALL') code_list = se...