画图2

import pandas as pd
import matplotlib as mpl
import matplotlib.pyplot as plt

mpl.rcParams['font.sans-serif']=[u'simHei']
#plt.rcParams['font.family'] = 'sans_serif'
mpl.rcParams['axes.unicode_minus']=False

df = pd.read_excel('散点图例子.xlsx',sheet_name=1)

###df.shape[0]==len(df) 行数

plt.scatter(df['avg_active_days'],df[u'uv占比']) ##简单散点图

 

#前面对字符的设置未生效，依然乱码，改用下面的

from matplotlib.font_manager import FontProperties
font = FontProperties(fname='/System/Library/Fonts/STHeiti Light.ttc')

 

plt.figure(figsize=(12,8))
plt.xlim(15,29)
plt.ylim(0,0.12)

#设置纵坐标轴数值格式
#fmt = '%.2f%%'
#yticks = mtick.FormatStrFormatter(fmt)
#plt.yticks(mtick.FixedFormatter(fmt))
plt.yticks((0,0.02,0.04,0.06,0.08,0.10,0.12),('0.00%','2.00%','4.00%','6.00%','8.00%','10.00%','12.00%'))

for i in range(len(df)) :
    plt.plot(df.loc[i][4],df.loc[i][5],c='#2678b2',marker='o')
    plt.text(df.loc[i][4],df.loc[i][5],'%s' %(df.loc[i][1]),fontproperties=font)
plt.title(u'OPPO端人群兴趣分布',fontproperties=font,size='14')
#plt.axes((0,0.03,0,0),fc='w')
ax = plt.axes()
ax.arrow(15,0.03,13.7,0,width=0.0003,head_width=0.003,head_length=0.3,fc='#2678b2')
ax.arrow(24,0,0,0.115,head_width=0.2,head_length=0.005,fc='#2678b2')
#plt.axes(0,0.03,0,0,head_width=0.05,head_length=0.15,facecolor='b')
plt.grid(True)
plt.show()