pykrx로 전종목 코드 뽑고 종목명 저장

from pykrx import stock import pandas as pd stock_list = stock.get_market_ticker_list(market='ALL') code_name = [] for code in stock_list: stock_name = stock.get_market_ticker_name(code) data = [code,stock_name] code_name.append(data) print(stock_name,code) df = pd.DataFrame(code_name,columns=['종목코드','종목명']) df = df.sort_values(by='종목코드',ascending=True) df.set_index(df['종목코드']) df.to_excel('종목코드.xlsx') # df = pd.read_excel('종목코드.xlsx',index_col=0) # # # print(df.index) # data = [] # for code in ...