Pandasライブラリを使用してデータベースに接続し、データの散点図を描画して分析します.

#  
import os
import sys

#              
sys.path.append('../../mymac')
#              
os.environ["DJANGO_SETTINGS_MODULE"] = 'mymac.settings'
#  django  
import django
#  matplotlib
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
#  sqlalchemy
from sqlalchemy import create_engine
#      
django.setup()
from myapp.models import Student


if __name__ == "__main__":
    #       
    engine = create_engine('mysql+pymysql://root:mysql@localhost:3306/mymac')
    

    #  
    sql = 'select * from myapp_student'
    res = pd.read_sql_query(sql,engine)
    # print(res)
    weight = res['weight']
    # print(weight)
    height = res['height']
    # print(height)
    weight = list(weight)
    height = list(height)
    # print(height,weight)

    plt.scatter(weight,height)
    #       
    plt.title('THE STUDENT BODY')
    #    
    plt.legend()

    
    plt.show()