import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from pandas import DataFrame,Series
#制定用编译器python就行
# df = pd.read_csv("home1.csv",engine='python')
#可以把格式正确的重新写入一个csv 也可以不用
# df.to_csv("homenew.csv")
df = pd.read_csv("homenew.csv")
plt.rcParams['font.sans-serif']=['SimHei']
#对单价一列的数据按照区域进行分组
s = df['danjia'].groupby(df["quyu"])
# 求每一个区域的单价平均值
s1 = s.mean()
s1.plot(kind="bar")
plt.title("南京各区域二手房平均单价")
plt.ylabel("单价(元/平米")
plt.savefig("3.png")
plt.show()