柱状图呈现各省出租率 出租率是反映住宿场所经营状况的一项重要指标，它是已出租的 客房数与住宿场所可以提供租用的房间总数的百分比。住宿场所出租 率的情况可以在一定程度上反应出该住宿场所的整体运营的情况，

import pandas as pd
from sqlalchemy import create_engine
import matplotlib.pyplot as plt

engine = create_engine('mysql+mysqlconnector://root:123456@127.0.0.1:3306/radar_lines_copy')
sql = 'select * from  radar_lines_copy'
datas = pd.read_sql(sql, engine)

print('===***原数据条数为***===')
print(datas.shape[0])

for i in datas['accommodation_num']:
    try:
        i = float(i)
    except:
        datas = datas[datas['accommodation_num'] != i]
print('===***异常处理后据条数为***===')
print(datas.shape[0])

datas["lease_rate"] = datas["lease_rate"].astype(float)
datas['accommodation_num'] = datas['accommodation_num'].astype(float)
datas = datas.drop_duplicates()
print('===***删除重复值后据条数为***===&#