数据可视化——散点的颜色和直径随散点的值变化

from xlrd import open_workbook
from matplotlib import pyplot as plt

b = open_workbook('test.xls')
s = b.sheet_by_name('Sheet')
nrows = s.nrows
x = []
y = []
z = []
for i in range(1,nrows):
	x.append(s.cell_value(i,0))
	y.append(s.cell_value(i,1))
	z.append(s.cell_value(i,2))

plt.scatter(x,y,c=z,s=[i*1000 for i in z])
plt.colorbar()
plt.show()

运行结果：