从mysql中读取数据,然后生成均线

import pymysql.cursors import pymysql import pandas as pd from datetime import datetime import numpy as np

config = {    'host':'127.0.0.1',    'port':3306,    'user':'root',    'password':'123456',    'db':'stock',    'charset':'utf8',    'cursorclass':pymysql.cursors.DictCursor,    } con= pymysql.connect(**config) try:  with con.cursor() as cursor:   sql="select * from stock_price limit 10"   cursor.execute(sql)   results=cursor.fetchall()  finally:  con.close();

df=pd.DataFrame(results) df.head()

print(df) print('\n\n') df['ma3']=df['Close'].rolling(3,min_periods=1).mean() print(df)