python中画折线图_python画折线图

importpymysqldefRead_database (sql):

user_name='root'password='root'address='localhost'port='3306'database_name='test'conn= pymysql.connect(host = address,user = user_name,passwd =password,\

db= database_name , port = int(port) ,charset = "utf8mb4")try:#df = pd.read_sql (sql,con = conn)

cursor =conn.cursor()

cursor.execute(sql)

df=cursor.fetchall()except:print ('\n Reading Error \n')finally:

conn.close()print ('\n Completion of data reading \n')return (df)