python3.4读取excel数据绘图

#!/usr/bin/env python
# -*- coding:utf-8 -*-
# __author__ = "blzhu"
"""
python study
Date：2017
"""
# coding=utf-8
#######################################################
# filename:xlrd_draw.py
# author:
# date:xxxx-xx-xx
# function：读excel文件中的数据
#######################################################
import numpy as np
import matplotlib.pyplot as plt
import xlrd

# 打开一个workbook
workbook = xlrd.open_workbook(r'E:pythonpycharmwork	estmatplotlibzblBarometer.xlsx')

# 抓取所有sheet页的名称
worksheets = workbook.sheet_names()
print('worksheets is %s' % worksheets)

# 定位到mySheet
mySheet = workbook.sheet_by_name(u'Pressure')

# get datas
pressure = mySheet.col_values(0)
print(pressure)
time = mySheet.col(1)
print('time1',time)
time = [x.value for x in time]
print('time2',time)


# drop the 1st line of the data, which is the name of the data.
pressure.pop(0)
time.pop(0)

# declare a figure object to plot
fig = plt.figure(1)

# plot pressure
plt.plot(time,pressure)

plt.title('Barometer')
plt.ylabel('Pa')
plt.xticks(range(len(time)),time)
plt.show()

参考：http://blog.csdn.net/huhuang/article/details/53809891

学习python好去处：http://i.youku.com/pythontutorial