写一个python代码读取我mysql80数据库中data表中的总价转化为整型和小区名称的数据从中选取总价最高的10个二手房y轴展示小区名称x轴展示总价每条柱都染上不同颜色制成柱状图柱子从长到短展示出来

以下是一个Python代码示例，可供参考：

import mysql.connector
import matplotlib.pyplot as plt

# 连接数据库
conn = mysql.connector.connect(
  host="localhost",
  user="root",
  password="password",
  database="mydatabase"
)

# 查询数据
cursor = conn.cursor()
cursor.execute("SELECT name, CAST(price AS SIGNED) AS price FROM data ORDER BY price DESC LIMIT 10")
result = cursor.fetchall()

# 处理数据
names = [row[0] for row in result]
prices = [row[1] for row in result]
colors = ['#FF0000', '#00FF00', '#0000FF', '#FFFF00', '#00FFFF', '#FF00FF', '#800000', '#008000', '#000080', '#808000']

# 绘制图表
plt.barh(names, prices, color=colors)
plt.title('Top 10 Second-hand Houses by Total Price')
plt.xlabel('Total Price')
plt.ylabel('Community Name')
plt.show()

请注意，此代码需要安装mysql-connector-python和matplotlib模块。您还需要将localhost、root、password和mydatabase替换为您的实际数据库连接信息