title: Extracting only a particular set of data from a URL with an Excel File
body: <p>I am looking to gather all the data from the penultimate worksheet in <a href="http://www.bankofengland.co.uk/statistics/Documents/yieldcurve/uknom05_mdaily.xls" rel="nofollow">this</a> Excel file along with all the data in the last Worksheet from "Maturity Years" of 5.5 onward. My code is below. I am currently just combining all the data from both sheets. I don't know how to extract only data associated with "Maturity Years" of 5.5 onward in the Last Worksheet. </p>
  
  <pre><code>import urllib2
  import pandas as pd
  import os
  import xlrd 
  
  url = 'http://www.bankofengland.co.uk/statistics/Documents/yieldcurve/uknom05_mdaily.xls'
  socket = urllib2.urlopen(url)
  
  xd = pd.ExcelFile(socket)
  df1 = xd.parse(xd.sheet_names[-1], header=None)
  df2 = xd.parse(xd.sheet_names[-2], header=None)
  
  bigdata = df1.append(df2,ignore_index = True)
  print bigdata
  </code></pre>