Demo python 读取excel数据输出图形

2019独角兽企业重金招聘Python工程师标准>>>

#-*- coding: UTF-8 -*
'''
Created on Mar 26, 2013

@author: roy
'''


import matplotlib.pyplot as plt
import numpy as np
import xlrd
import os
import datetime as dt
import time
import matplotlib.dates as md
#from StringIO import StringIO


fig = plt.figure(figsize=(20,10))
if __name__ == '__main__':
    data = xlrd.open_workbook('/home/roy/Downloads/C2000A_Ethernet_Script_Information(1).xls')


plt.xlabel(u'second')
plt.ylabel(u'memory')


x_index=1
m_index=1

data.sheet_names()
table = data.sheets()[0]
table = data.sheet_by_index(0)
table = data.sheet_by_name(u'3.13')
print("Good")
COLOR_INDEX=1
INDEX_NAME=''

## init data
x = []
y = []
dates = []
nrows = table.nrows
ncols = table.ncols
print("nr=%d nc=%d \n"%(nrows,ncols))


for rownum in range(table.nrows):
    value = table.cell_value(rownum,0)
    print "print value"
    print value
    if rownum == 0:
        print("")
    else:
        try:
            value_str = str(value)
            value_date1 = time.strptime(value_str, '%Y-%m-%d %H:%M:%S')
            x.append(x_index)
            print value_date1
            y.append(time.mktime(value_date1))
            dates = [dt.datetime.fromtimestamp(date) for date in y]

#print("index=%d" %x_index)
            x_index=x_index+1
        except:
            print("error11111111111111111")
print x_index
print y
print "print dates"
print dates

m = []
n = []

for rownum in range(table.nrows):
    value = table.cell(rownum,1).value
    if rownum == 0:
        print("")
    else:
        try:
            value_int = int(value)
            m.append(m_index)
            n.append(value_int)
#print("index=%d"%m_index)
            m_index=m_index+1

        except:
            print("error")
print m_index
print "print n"
print n
color = range(1,5)
plt.subplots_adjust(bottom=0.4)
plt.xticks( rotation=25 )
ax=plt.gca()
xfmt = md.DateFormatter('%Y-%m-%d %H:%M:%S')
ax.xaxis.set_major_formatter(xfmt)
plt.plot(dates,n,'cx--',label = "Memory")
'''
plt.plot(dates,n,label = 'Memory',color = 'blue',linestyle='dashdot',linewidth=4,#color设置线的颜色，linestyle设置线的形状（前面用的是简写）
         #linewidth是设置线的宽度
         marker='o',markerfacecolor='red',markeredgecolor='black',#marker设置线的标记，markerfacecolor设置正面颜色
         #markeredgecolor设置点周围的颜色
         markeredgewidth=1,markersize=1)#设置边缘的宽度，设置整个点的大小
'''
plt.legend(loc = "upper left")
plt.title("Preformance Test")
plt.xlabel("Times")
plt.ylabel("Memory")
plt.ylim(200,500)
#plt.xticks(range(len(dates)),dates)#通过不同的方法设置刻度
plt.show()
plt.grid(True)# show grid
fig.autofmt_xdate()

plt.savefig("/home/roy/Desktop/20130326.pdf")

转载于:https://my.oschina.net/xxjbs001/blog/118154