参考代码:
http://matplotlib.org/examples/pylab_examples/loadrec.html
依赖的包:
1.matplot
2.numpy
Python 读取csv文件(Excel转化的)并绘制图表。
代码如下:
from __future__ import print_function
from matplotlib import mlab
import matplotlib.pyplot as plt
import matplotlib.cbook as cbook
datafile = cbook.get_sample_data('d:\\FileTest\\Barometer.csv', asfileobj=False)
print('loading', datafile)
a = mlab.csv2rec(datafile)
#a.sort()
print(a.dtype)
fig = plt.figure()
ax = fig.add_subplot(111)
ax.plot(a.pressure, '-')
fig.autofmt_xdate()
# if you have xlwt installed, you can output excel
try:
import mpl_toolkits.exceltools as exceltools
exceltools.rec2excel(a, 'test.xls')
except ImportError:
pass
plt.title('Barometer')
plt.ylabel('Pa')
plt.show()
代码下载: