1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
from matplotlib import mlab
from pylab import figure, show
import matplotlib.cbook as cbook
datafile = cbook.get_sample_data('msft.csv', asfileobj=False)
print 'loading', datafile
a = mlab.csv2rec(datafile)
a.sort()
print a.dtype
fig = figure()
ax = fig.add_subplot(111)
ax.plot(a.date, a.adj_close, '-')
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
show()
|
