AI: '

import pandas as pd import matplotlib.pyplot as plt

读取数据

data = pd.read_excel('a.xlsx')

统计每个地区的酒店数量

hotel_counts = data['地区'].value_counts()

创建画布和子图

fig, ax = plt.subplots(figsize=(10, 5))

画柱状图

ax.bar(hotel_counts.index, hotel_counts.values, color='red')

设置横轴标签旋转90度

plt.xticks(rotation=90)

显示柱子上方的数值

for x, y in zip(hotel_counts.index, hotel_counts.values): ax.text(x, y, str(y), ha='center', va='bottom')

设置标题、横轴标签、纵轴标签

ax.set_title('Hotel Counts by Region') ax.set_xlabel('Region') ax.set_ylabel('Counts')

显示图像

plt.show()'