title: Concat not working as expected
body: <p>I have 2 files</p>
  
  <ul>
  <li>1st Containing Data (No Column Header)</li>
  <li>2nd Containing Column Header</li>
  </ul>
  
  <p>I want to combine this 2 into 1 file. My approach push the data into dataframe and used concat on them get the file result set.</p>
  
  <p>My Code Till now</p>
  
  <pre><code>import pandas as pd
  from xlrd import open_workbook
  
  #contains mapping, Column present
  #DataFileName   FolderLocation  ColumnFileName
  #Data1           F:\Desktop      ColFile1
  #Data2           F:\Desktop      ColFile2
  
  filelocation = 'F:\Desktop\Mapping.xlsx'
  wb = open_workbook(filelocation)
  Separator = ','
  items = []
  for sheet in wb.sheets():
      number_of_rows = sheet.nrows
      number_of_columns = sheet.ncols
      for row in range(1, number_of_rows):
          for col in range(number_of_columns):
              ColumnFileName = sheet.cell(row,0).value
              Path = sheet.cell(row,1).value
              DataFileName = sheet.cell(row,2).value
  
              DataFileCompName = Path + "\\" + DataFileName +FileExtension
              ColumnFileCompName = Path + "\\" + ColumnFileName+ FileExtension
              HeaderDataFrame = pd.read_csv(ColumnFileCompName,sep=Separator)#,index_col=0)#,header=0)
              DataDataFrame = pd.read_csv(DataFileCompName,sep=Separator)#,header=None)
  
              CompleteDataFrame = pd.concat([HeaderDataFrame,DataDataFrame], ignore_index=True,axis=1)
  </code></pre>
  
  <p>Now, With concat i want the result set as</p>
  
  <pre><code>HeaderDataFrame
  DataDataFrame
  </code></pre>
  
  <p>Whereas i am getting result as </p>
  
  <pre><code>HeaderDataFrame|DataDataFrame
  </code></pre>