import pymysql import xlrd import pandas as pd host = '' user = '' password = '' db = '' chartset = 'utf8' conn = pymysql.connect(host= host, user=user,password=password,db=db,charset = chartset) price_data = [] try: curs = conn.cursor() sql = 'SELECT * from 삼성전자' curs.execute(sql) result = curs.fetchall() finally: conn.close() columns = ['date','open','high','low','close','volume'] result = pd.DataFrame(result,columns=columns) result.set_index('date',inplace=True)...
#
mysql
#
파이썬
원문 링크 : mysql 에서 주가데이터 import