use py_us_pre_ele;
create  table if not exists tab(#表
state varchar(20),#州名
enddate varchar(10), #截止时间
grade varchar(5),#评分
clinton varchar(15),#希拉里所占的比例
trump varchar(15),#川普所占的比例
johnson varchar(15),#强生所占的比例
id varchar(10) primary key
);

load data infile 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\presidential_polls.csv' into table tab
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n';

C:\ProgramData\MySQL\MySQL Server 8.0\Uploads

import pymysql

#获得数据库的链接
def getdb():
    conn_db = pymysql.connect(host="127.0.0.1", port=3306, user="root", passwd="4399", db="py_us_pre_ele", charset="utf8")
    return conn_db

#得到数据库中的所有的城市
def get_all_city(db):
    set={""}#创建一个set集合，用来放置所有的城市
    str_sql="select state from tab"#查找到所有的城市语句
    cur=db.cursor()#得到cursor对象
    cur.execute(str_sql)#执行sql语句
    rows=cur.fetchall()#得到结果集
    for row in rows:#将城市加入到不重复的set集合中
        set.add(row)
    set.remove("")
    with open("all_cities.txt", "w") as f:
        for ele in set:
            f.write(str(ele)+"\n")

def main():
    get_all_city(getdb())

if __name__ == '__main__':
    main()
    print("程序完成")

import easygui as g
import pymysql
import matplotlib.pyplot as plt
from pylab import mpl
mpl.rcParams['font.sans-serif'] = ['SimHei']#插入中文不会出现空格
import random

#得到所有的州的名称
states = {"U.S."}
list=[]
def get_state():  # 将所有的州写入全局变量中
    for line in open("all_cities.txt", "r"):  # 设置文件对象并读取每一行文件
        line = line[:-1]  # 去除换行符
        states.add(line.split("'")[1])  # 将每一行文件加入到state中,只有州的名称

def main():
    # 启动界面
    g.msgbox("\n\n\t\t\t\t美国大选的数据处理", ok_button='打开', title="美国大选的数据处理")
    #得到所有的州的名称
    get_state()
    reply = g.choicebox("选择的州", choices=states)
    #如果有选择则确认选择的州
    if reply!=None :
        YN=g.boolbox(msg='\n\n\n\t\t\t\t确定你的选择：'+reply, title='确认选择', choices=('Yes', 'No'), image=None)
        if YN==True:#完成了最终的确认
            sql="select clinton,trump,johnson,grade,id from tab where state='"+reply+"'"#构造sql语句查找数据
            db = pymysql.connect(host="127.0.0.1", port=3306, user="root", passwd="4399", db="py_us_pre_ele",charset="utf8")#得到一个物理会话
            cur = db.cursor()#得到一个cursor对象
            cur.execute(sql)#执行sql语句
            for i in range(cur.rowcount - 1):#去除列名
                row = cur.fetchone()
                if 'a' not in row[0]:#防止列名
                    clinton = float(row[0].strip())
                    trump = float(row[1].strip())
                    johnson = float(row[2].strip())
                    tup = (clinton, trump, johnson)
                    list.append(tup)
                    paint(tup, reply, row[3], row[4])
                    con=g.buttonbox(reply + "州的第" + row[4] + "号" + "图片" + "评论机构评分;" + row[3], image=str(row[4]) + 'pie.png',
                                      choices=("下一张", "退出"))
                    if con=="退出":
                        exit("退出")
        else:
                g.msgbox("程序退出")

def paint(tup,state,grade,id):#画图
    label_list = ["川普", "希拉里", "强生", "弃权票"] # 各部分标签
    size = [tup[0], tup[1], tup[2], (100-tup[0]-tup[1]-tup[2])]  # 各部分大小
    color = ["red", "green", "blue", "yellow"]  # 各部分颜色
    explode = [0.05, 0, 0, 0]  # 各部分突出值
    patches, l_text, p_text = plt.pie(size, explode=explode, colors=color, labels=label_list, labeldistance=1.1,
                                      autopct="%1.1f%%", shadow=False, startangle=90, pctdistance=0.6)
    plt.axis("equal")  # 设置横轴和纵轴大小相等，这样饼才是圆的
    plt.legend()
    ran_num = random.sample(range(10000), 1)
    plt.savefig(str(id)+'pie.png')
    plt.show()

if __name__ == '__main__':
    main()