第二次用Python和Plotly成功绘制图形

import pymysql
import plotly
import plotly.graph_objs

plotly.tools.set_credentials_file(username='JaneGinkgo', api_key='IDOV3Q7jOtABYvw7mhin')

try:  
    #连接数据库t  
    conn = pymysql.connect(host="localhost", user="root", passwd="root", db="t", charset="utf8")  
    print ("Conection success!\n")
    cur = conn.cursor()  
  
    cur.execute('SELECT gender, grade, ratio FROM score')  
    rows = cur.fetchall()  
    x_data = []  
    y_data = []  
    gender = []  
    colors = []  
    for row in rows:  
        gender.append(row[0])   #性别  
        x_data.append(row[1])   #成绩  
        y_data.append(row[2])   #出席率  
        if(row[0] == 'boy'):    #根据性别设置scatter的颜色  
            colors.append('rgb(93, 164, 214)')  
        else:  
            colors.append('rgb(255, 65, 54)')  
    data =