title: How to merge .csv files given some conditions?
body: <p>I have several <code>.csv</code> files in one directory. 
  I would like to iterate over those files an merge/combine them into a single .csv file  given some condition.</p>
  
  <p>Each file uses the same naming convention:</p>
  
  <pre><code>Date       Name   City   Supervisor
  
  2015-01-01_Steve__Boston_Steven.csv
  2015-10-03_Michael_Dallas_Thomas.csv
  2015-02-10_John_NewYork_Michael.csv
  </code></pre>
  
  <p>Each file contains only one column with varying length:</p>
  
  <pre><code>2015-01-01_Steve__Boston_Steven.csv
  
  Sales
  100
  20
  3
  100
  200
  </code></pre>
  
  <p>or</p>
  
  <pre><code>2015-10-03_Michael_Dallas_Thomas.csv
  
  Sales
  1
  2
  
  2015-02-10_John_NewYork_Michael.csv
  </code></pre>
  
  <p>or</p>
  
  <pre><code>Sales
  1
  2
  3
  </code></pre>
  
  <p>Because the header "Sales" in each file might be named differently I would like to skip the first row and beginn always with the second row.</p>
  
  <p>I would like to get a final table containing the following information:</p>
  
  <pre><code>Sales Name     City    Supervisor
  100   Steve    Boston  Steven
  20    Steve    Boston  Steven
  30    Steve    Boston  Steven
  3     Steve    Boston  Steven
  100   Steve    Boston  Steven
  200   Steve    Boston  Steven
  1     Michael  Dallas  Thomas
  2     Michael  Dallas  Thomas
  1     John     NewYork Michael
  2     John     NewYork Michael
  3     John     NewYork Michael
  </code></pre>
  
  <p>Im new to python so apologize for the inconvenience. </p>
  
  <p>What I have tried:</p>
  
  <pre><code>import pandas as pd
  from os import listdir
  
  source_path, dst_path = '/oldpath', '/newpath'
  
  files = [f for f in listdir(source_path) if f.endswith('.csv')]
  
  def combining_data(files):
      df_list = []
      for filename in files:
          df_list.append(pd.read_csv(filename))
  
  combining_data(files)
  </code></pre>
  
  <p>But that unfortunately is doesnt produces the required output</p>