MySQL数据库中的相关数据集包含了城市、省份、评分、评论数等多项基础信息字段。请使用Flask框架，结合Echarts完成下列题目。
数据库账号：root 密码：123456 库名：hotel
自行创建代码工程路径为：C:\s_hotel
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:55055ccc-0f8a-47a3-a9aa-3f6b5956b2db
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:305693f7-286d-4a8e-91db-f84458ecf436
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:a84e6bcc-6708-4181-9ab9-39b136029ef1
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:5459a040-a640-4c00-9d95-ff9c60f6a2a3
详细描述：
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:b868269d-0b66-44a9-a080-bb5b6f9f8069
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:fc2058a1-82ed-4a82-89a3-1a8b2ca01a76
具体任务要求：
1）提取表格相关字段，分别统计各省的订单数量，在控制台按照”订单数量”降序排列，打印输出各省份的订单数量；
打印语句格式如下：
==省份：* =订单数量：个==
……
2）使用Flask框架，结合Echarts绘制”订单数量”的条形图，标题为”各省订单数量”（字体颜色：红色，加粗），纵坐标为省份名称，横坐标为订单数量，并将可视化结果复制粘贴至对应报告中。
1.路径：orderNum.py
import pandas as pd
import numpy as np
from sqlalchemy import create_engine
from pandas.core.frame import DataFrame
mysql = create_engine(‘mysql+mysqlconnector://root:123456@127.0.0.1:3306/hotel’)
sql = ‘select * from platform’
df = pd.read_sql(sql, mysql)
df[‘order_num’] = df[‘order_num’].astype(float)
df = df.groupby(df[‘Province’])
df_province = df[‘Province’]
province = []
for i in df_province:
province.append(i[0])
print(province)
num_order = []
for i in df[‘order_num’].sum():
num_order.append(i)
print(num_order)
data = [province, num_order]
df_data = DataFrame({“Province”: province, “num_order”: num_order})
print(df_data)
df_data = df_data.sort_values(by=’num_order’, ascending=False)
df_data = df_data.reset_index(drop=True)
print(df_data)
for i in range(len(df_data)):
print(‘==省份：’ + df_data[‘Province’][i] + ‘ =订单数量：’ + str(df_data[‘num_order’][i]) + ‘个==’)
filepath = “E:\Python\keshihua\enterpriseCustomize\task1\csv\df_data.csv”
df_data.to_csv(filepath, index=False, header=False)
2.
(1) Echarts_01.html
Title
fucking window
(2)app.py
from flask import Flask, render_templateimport pandas as pdimport os# 获取数据Names_last_csv = os.listdir(r"E:\Python作业\keshihua\enterpriseCustomize\task1\csv")# print(Name_last_csv)Name_last_csv_01 = '\\' + Names_last_csv[-1]Name_last_csv_02 = r'E:\Python作业\keshihua\enterpriseCustomize\task1\csv' + Name_last_csv_01print(Name_last_csv_02)data = pd.read_csv(Name_last_csv_02)# 获取数据的列columns = data.columns# 提取数据province = data['province'].tolist()order_num = data['order_num'].tolist()# 创建flask实例app = Flask(__name__)# 创建视图@app.route("/")def echarts_01(): # 数据传输到前端 return render_template("Echarts_01.html", province=province, order_num=order_num)## 运行程序if __name__ == '__main__': app.run(debug=True)(3)目录
Original: https://www.cnblogs.com/unknownshangke/p/16397935.html
Author: Unknown尚可
Title: 数据可视化练习(1)
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/562567/
转载文章受原作者版权保护。转载请注明原作者出处！