title: Newbie Matplotlib and Pandas Plotting from CSV file
body: <p>I haven't had much training with Matplotlib at all, and this really seems like a basic plotting application, but I'm getting nothing but errors.</p>
  
  <p>Using Python 3, I'm simply trying to plot historical stock price data from a CSV file, using the date as the x axis and prices as the y. The data CSV looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/to1wu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/to1wu.png" alt="data"></a></p>
  
  <p>(only just now noticing to big gap in times, but whatever)</p>
  
  <pre><code>import glob
  import pandas as pd
  import matplotlib.pyplot as plt
  
  def plot_test():
      files = glob.glob('./data/test/*.csv')
  
      for file in files:
          df = pd.read_csv(file, header=1, delimiter=',', index_col=1)
          df['close'].plot()
          plt.show()
  
  plot_test()
  </code></pre>
  
  <p>I'm using glob for now just to identify any CSV file in that folder, but I've also tried just designating one specific CSV filename and get the same error:</p>
  
  <pre><code>KeyError: 'close'
  </code></pre>
  
  <p>I've also tried just designating a specific column number to only plot one particular column instead, but I don't know what's going on.</p>
  
  <p>Ideally, I would like to plot it just like real stock data, where everything is on the same graph, volume at the bottom on it's own axis, open high low close on the y axis, and date on the x axis for every row in the file. I've tried a few different solutions but can't seem to figure it out. I know this has probably been asked before but I've tried lots of different solutions from SO and others but mine seems to be hanging up on me. Thanks so much for the newbie help!</p>