[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:5042245b-f765-4bd8-9ef9-c100a5d2d46a
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:cc55181e-57d1-45b7-ab30-374b6bc76b14
详细描述：
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:cf32dfa8-f85a-4f2e-bc48-6e309a82a6c5
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:8bb16d5b-467e-4935-bafb-3d9df3e40e3d
具体任务要求：
1） 提取表格相关字段，在控制台按照”各省住宿场所出租率”降序排列，打印输出各省名称及包含的住宿场所数量以及出租率；
打印语句格式如下：
==1.省=住宿场所数为个=出租率为：***===
==2.省=住宿场所数为个=出租率为：***===
2） 使用Flask框架，结合Echarts绘制柱状图。柱状图主标题为”各省住宿场所出租率”（字体要求：红色、加粗、斜体），副标题为出租率前十的省份；纵坐标为出租率，横坐标为省份名称（按照出租率降序排列）；将可视化结果截图并保存。
(1)ralateLease.py
import datetimeimport pandas as pdimport numpy as npfrom sqlalchemy import create_enginemysql = create_engine('mysql+mysqlconnector://root:123456@127.0.0.1:3306/hotel')sql = "select Province,order_num,midnight_num,real_num,realmidnight_num from platform;"df_leaseRate = pd.read_sql(sql, mysql)print(df_leaseRate)df_leaseRate['order_num'] = df_leaseRate['order_num'].astype('float')df_leaseRate['midnight_num'] = df_leaseRate['midnight_num'].astype('float')df_leaseRate['real_num'] = df_leaseRate['real_num'].astype('float')df_leaseRate['realmidnight_num'] = df_leaseRate['realmidnight_num'].astype('float')df_leaseRate = df_leaseRate.groupby(df_leaseRate['Province'])province_lst = []accommodation_lst = []leaseRate_lst = []for i in df_leaseRate: # print(i[1]) province_lst.append(i[0]) accommodation_lst.append(i[1].sum()['real_num'] + i[1].sum()['realmidnight_num']) leaseRate_lst.append((i[1].sum()['real_num'] + i[1].sum()['realmidnight_num']) / (i[1].sum()['order_num'] + i[1].sum()['midnight_num'])) print("==" + i[0] + "省(市/自治区)=住宿场所数为" + str(i[1].sum()['real_num'] + i[1].sum()['realmidnight_num']) + "个=出租率为：" + str((i[1].sum()['real_num'] + i[1].sum()['realmidnight_num']) / (i[1].sum()['order_num'] + i[1].sum()['midnight_num'])) + "===")# print(province_lst)# print(leaseRate_lst)df_output = pd.DataFrame({'Province': province_lst, 'accommodation_lst': accommodation_lst, 'leaseRate': leaseRate_lst})df_output = df_output.sort_values('leaseRate', ascending=False).reset_index(drop=True)# print(df_output)Now_time = datetime.datetime.now();filepath = "csv//" + str(Now_time.date()) + "_" + str(Now_time.timestamp()) + "df_leaseRate.csv"df_output.to_csv(filepath, index=False, header=['province', 'accommodation_lst', 'leaseRate'])
Original: https://www.cnblogs.com/unknownshangke/p/16422205.html
Author: Unknown尚可
Title: 数据可视化练习(3)
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/562563/
转载文章受原作者版权保护。转载请注明原作者出处！