【python】读取Excel文件并绘制图表

最新推荐文章于 2023-07-29 20:12:18 发布

tastesweet

最新推荐文章于 2023-07-29 20:12:18 发布

阅读量2.8k

点赞数 1

分类专栏： Python/Ruby

本文链接：https://blog.csdn.net/u011202336/article/details/9172319

版权

Python/Ruby 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

依赖的包：

1.xlrd

2.matplot

3.numpy

读取excel文件并绘制图表

代码如下：

点击(此处)折叠或打开

import matplotlib.pyplot as plt
import numpy as np
import xlrd
import os
from StringIO import StringIO
if __name__ == '__main__':
data = xlrd.open_workbook('D:\\tt.xls')
plt.figure(figsize=(8,4))
plt.xlabel(u'second')
plt.ylabel(u'xxx')
x_index=1
data.sheet_names()
table = data.sheets()[0]
table = data.sheet_by_index(0)
table = data.sheet_by_name(u'Sheet1')
print("Good")
COLOR_INDEX=1
INDEX_NAME=''
## init data
nrows = table.nrows
ncols = table.ncols
print("nr=%d nc=%d \n"%(nrows,ncols))
'''
for rownum in range(table.nrows):
value = table.cell(rownum,2).value
if rownum == 0:
print("")
else:
try:
value_int = int(value)
x.append(x_index)
y.append(value_int)
# line = ax.plot(x_index,value_int,label="xx ",color="red",linewidth=2)
#plt.plot(x_index,value_int,label="xx ",color="red",linewidth=2)
print("index=%d"%x_index)
#plt.plot_date(x_index,value_int)
x_index=x_index+1
except:
print("error")
plt.plot(x,y,label="xx ",color="red",linewidth=2)
'''
for colnum in range(table.ncols):
x=[]
y=[]
for rownum in range(table.nrows):
value = table.cell(rownum,colnum).value
#print("nr=%d nc=%d value=%d \n"%(rownum,colnum,value ))
#print(value)
#print("rownum=%d colnum=%d "%(rownum,colnum))
if rownum == 0:
print("")
else:
try:
value_int = int(value)
x.append(x_index)
y.append(value_int)
#plt.plot(x_index,value_int,label=" ",color="red",linewidth=2)
#print("index=%d"%x_index)
#plt.plot_date(x_index,value_int)
x_index=x_index+1
except:
print("error")
if COLOR_INDEX == 1:
COLOR_INDEX = 0
plt.plot(x,y,color="red",linewidth=2)
else:
COLOR_INDEX =1
plt.plot(x,y,color="blue",linewidth=2)
print("==============================>")
plt.title("Test")
#plt.ylim(10,2000)
plt.legend()
plt.show()
pass

阅读(301) | 评论(0) | 转发(0) |

上一篇：读取excel文件并绘制图表[Python]

下一篇：【python】 xlrd的使用

【python】 读取Excel文件并绘制图表

“相关推荐”对你有帮助么？

【python】读取Excel文件并绘制图表