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="", 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="", 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()