matplotlib

#https://matplotlib.org/stable/gallery/index.html
import matplotlib.pyplot as plt
import numpy as np

# Fixing random state for reproducibility
np.random.seed(19680801)

plt.rcdefaults()
fig, ax = plt.subplots()

# Example data
people = ('Tom', 'Dick', 'Harry', 'Slim', 'Jim')
y_pos = np.arange(len(people))
performance = 3 + 10 * np.random.rand(len(people))
error = np.random.rand(len(people))

ax.barh(y_pos, performance, xerr=error, align='center')
ax.set_yticks(y_pos)
ax.set_yticklabels(people)
ax.invert_yaxis()  # labels read top-to-bottom
ax.set_xlabel('Performance')
ax.set_title('How fast do you want to go today?')

plt.show()

 

#散点图
area = df.loc[:,'县区']
langsong = df.loc[:,'朗诵']
#解决中文显示问题
plt.rcParams['font.sans-serif'] = ['KaiTi'] # 指定默认字体
plt.rcParams['axes.unicode_minus'] = False # 解决保存图像是负号'-'显示为方块的问题
# s原点面积 c颜色 alpha 透明度
plt.scatter(langsong,area,s=20,c='r',alpha=0.5)

langsong = df.loc[:,'朗诵']
#折线图
plt.plot(langsong)

 

#饼状图
total_value=[15,30,45,10]
#标签
labes=['A','B','C','D']
#突出
explode=[0,0.05,0.1,0]
plt.pie(x=total_value,labels = labes,explode=explode,shadow=False,autopct='% .0f%%')

 

#条形图
area = df.loc[:,'县区']
langsong = df.loc[:,'朗诵']
#解决中文显示问题
plt.rcParams['font.sans-serif'] = ['KaiTi'] # 指定默认字体
plt.rcParams['axes.unicode_minus'] = False # 解决保存图像是负号'-'显示为方块的问题
plt.bar(area,height=langsong)

==================================================================================================

import pandas as pd
# 把文件路径给记录下来
path = 'D:/tongyaoshequ.xlsx'
# 把读取到的数据保存下来
datas = pd.read_excel(path)

#datas.loc[datas.loc[:,'close'] <= 21]
qxres = datas.loc[:,'所在地址'] == 570
qiaoxi = datas.loc[qxres].loc[:,['家长姓名','手机号码']]
qx = pd.DataFrame(qiaoxi)

 

 

import pandas as pd
# 把文件路径给记录下来
path = 'D:\sjz.xlsx'
# 把读取到的数据保存下来
datas = pd.read_excel(path)
# 按信息查询
#datas.loc[:,['家长姓名','手机号码','所在地址']]
qxres = datas.loc[:,'所在地址'].str.contains("桥西区")
qiaoxi = datas.loc[qxres].loc[:,['家长姓名','手机号码']]
qx = pd.DataFrame(qiaoxi)
yhres = datas.loc[:,'所在地址'].str.contains("裕华区")
yuhua = datas.loc[yhres].loc[:,['家长姓名','手机号码']]
yh = pd.DataFrame(yuhua)
lcres = datas.loc[:,'所在地址'].str.contains("栾城县")
luancheng = datas.loc[lcres].loc[:,['家长姓名','手机号码']]
lc = pd.DataFrame(luancheng)
xhres = datas.loc[:,'所在地址'].str.contains("新华区")
xinhua = datas.loc[xhres].loc[:,['家长姓名','手机号码']]
xh = pd.DataFrame(xinhua)
lqres = datas.loc[:,'所在地址'].str.contains("鹿泉市")
luquan = datas.loc[lqres].loc[:,['家长姓名','手机号码']]
lq = pd.DataFrame(luquan)
cares = datas.loc[:,'所在地址'].str.contains("长安区")
changan = datas.loc[cares].loc[:,['家长姓名','手机号码']]
ca = pd.DataFrame(changan)
qdres = datas.loc[:,'所在地址'].str.contains("桥东区")
qiaodong = datas.loc[qdres].loc[:,['家长姓名','手机号码']]
qd = pd.DataFrame(qiaodong)

#print(qd.count())
#df.to_excel('D:\桥西.xlsx', index=False,encoding='utf-8',sheet_name='桥西区')
writer = pd.ExcelWriter('D:\石家庄.xlsx')
qx.to_excel(writer, index=False,encoding='utf-8',sheet_name='桥西区')
yh.to_excel(writer, index=False,encoding='utf-8',sheet_name='裕华区')
xh.to_excel(writer, index=False,encoding='utf-8',sheet_name='新华区')
lc.to_excel(writer, index=False,encoding='utf-8',sheet_name='栾城县')
lq.to_excel(writer, index=False,encoding='utf-8',sheet_name='鹿泉市')
ca.to_excel(writer, index=False,encoding='utf-8',sheet_name='长安区')
qd.to_excel(writer, index=False,encoding='utf-8',sheet_name='桥东区')

import matplotlib.pyplot as plt
plt.rcdefaults()
fig, ax = plt.subplots()
ax.set_xlabel('石家庄')
ax.set_title('抗疫作品活动区域报名情况')
#条形图
x = [0,1,2,3,4,5,6]
lables = ['桥西区','裕华区','新华区','栾城县','鹿泉市','长安区','桥东区']
shuzhi = [qx.shape[0],yh.shape[0],xh.shape[0],lc.shape[0],lq.shape[0],ca.shape[0],qd.shape[0]]
#解决中文显示问题
plt.rcParams['font.sans-serif'] = ['KaiTi'] # 指定默认字体
plt.rcParams['axes.unicode_minus'] = False # 解决保存图像是负号'-'显示为方块的问题
#plt.bar(lables,height=shuzhi)

plt.xticks(x,lables)
p1 = plt.bar(x, height=shuzhi, width=0.4,color='#123465', label="报名人数", tick_label=lables)

# 添加数据标签
for a, b in zip(x, shuzhi):
    plt.text(a, b + 0.05, '%.0f' % b, ha='center', va='bottom', fontsize=10)
# 添加图例
plt.legend()
# 展示图形
plt.show()