Python3.4 reading excel Data drawing, python3.4excel

Python3.4 reading excel Data drawing, python3.4excel

1 #! /Usr/bin/env python 2 #-*-coding: UTF-8-*-3 # _ author _ = "blzhu" 4 "5 python study 6 Date: 2017 7 "8 # coding = UTF-8 9 ############################# ######################### 10 # filename: xlrd_draw.py11 # author: 12 # date: xxxx-xx-xx13 # function: reading data in an excel file 14 ################################## #################### 15 import numpy as np16 import matplotlib. pyplot as plt17 import xlrd18 19 # open a workbook20 workbook = xlrd. open_workbook (r 'e: \ python \ pycharmwork \ test \ matplotlibzbl \ Barometer.xlsx ') 21 22 # capture the name of all sheet pages 23 worksheets = workbook. sheet_names () 24 print ('worksheets is % s' % worksheets) 25 26 # locate mySheet27 mySheet = workbook. sheet_by_name (u 'Pressure ') 28 29 # get datas30 Pressure = mySheet. col_values (0) 31 print (pressure) 32 time = mySheet. col (1) 33 print ('time1', time) 34 time = [x. value for x in time] 35 print ('time2', time) 36 37 38 # drop the 1st line of the data, which is the name of the data.39 pressure. pop (0) 40 time. pop (0) 41 42 # declare a figure object to plot43 fig = plt. figure (1) 44 45 # plot pressure46 plt. plot (time, pressure) 47 48 plt. title ('barometer ') 49 plt. ylabel ('pa') 50 plt. xticks (range (len (time), time) 51 plt. show ()

Reference: http://blog.csdn.net/huhuang/article/details/53809891

Learning python good place: http:// I .youku.com/pythontutorial