title: Plotting 2 columns from multiple csv files from NASDAQ in a directory
body: <p>I am trying to make a program where I read multiple csv files in a directory. The files has been downloaded from <a href="http://www.nasdaqomxnordic.com/aktier/historiskakurser" rel="nofollow noreferrer">http://www.nasdaqomxnordic.com/aktier/historiskakurser</a></p>
  
  <p>The first row is <code>sep=</code> and it is skipped. The separator is <code>';'</code></p>
  
  <p>The problem is that even though I get the data printed from all csv files, I get only blank plots.</p>
  
  <p>The idea is to show a plot of data in column 6 with date as x-axis (column 0) for one csv file at a time and so on until the given directory is empty.</p>
  
  <p>I would prefer the name of the csv file (paper) only as title. Now I get the directory/csv name.</p>
  
  <p>It seems as matplotlib do not understand the csv file correct even though the data is printed.</p>
  
  <p>My code looks as this:</p>
  
  <pre><code>import pandas as pd
  #import csv
  import glob
  import matplotlib.pyplot as plt
  #from matplotlib.dates import date2num
  import pylab
  #import numpy as np
  #from matplotlib import style
  
  
  ferms = glob.glob("OMX-C20_ScrapeData_Long_Name/*.csv")
  
  for ferm in ferms:
      print(ferm)
  
  # define the dataframe
  
      data = pd.read_csv(ferm, skiprows=[0], encoding='utf-8', sep=';',  header=0)
  
      print(data)
      data.head()
  
      pylab.rcParams['figure.figsize'] = (25, 20)
      plt.rcParams['figure.dpi'] = 80
      plt.rcParams['legend.fontsize'] = 'medium'
      plt.rcParams['figure.titlesize'] = 'large'
      plt.rcParams['figure.autolayout'] = 'true'
      plt.rcParams['xtick.minor.visible'] = 'true'
  
      plt.xlabel('Date')
      plt.ylabel('Closing price')
      plt.title(ferm)
      plt.show()
  </code></pre>
  
  <p>I have tried some other ways to open the csv files but the result is the same. No curves.
  Hope one of you experienced guys can give a hint.</p>