title: plotting/graphing excel file data using python
body: <p>I'm new to Python and there is a piece of Python coding that I am having trouble getting to graph.
  Specifically how to parse data from an Excel spreadsheet in order to generate and plot some basic value comparison graphs.</p>
  
  <p>I'm using the Spyder IDE with Python 3.6.3.</p>
  
  <p>The file 'foc' location is: 
  <code>C:\Users\Murphy\Desktop\WinPython-64bit-3.6.3.0Qt5\PYWorkFiles\foc.csv</code>
  I have more than one version of the excel spreadsheet foc file as I have attempted to graph it in more than one format. The two formats it is stored in at present are <code>csv</code> and <code>xlsx</code></p>
  
  <p>The code scraps I have put together at present are:</p>
  
  <pre><code>import xlrd
  
  workbook = xlrd.open_workbook('foc.xlsx')
  
  from csv import reader
  import matplotlib.pyplot as plt
  
  with open('foc.csv', 'r') as f:
  data = list(reader(f))
  
  taste = [i[6] for i in data]
  
  plt.plot(range(len(taste)), taste)
  plt.show()
  plt.plot()
  </code></pre>
  
  <p>All these pieces of code generate is two useless graphs (I've attached them below) with only the first one even showing any of the foc spreadsheet data.</p>
  
  <p>Can I get any help with this? I have very little knowledge of how to use Python. </p>
  
  <p><a href="https://i.stack.imgur.com/Zgm66.png" rel="nofollow noreferrer">graph1</a></p>
  
  <p><a href="https://i.stack.imgur.com/yHB4D.png" rel="nofollow noreferrer">graph2</a></p>