Concat not working as expected

Question

I have 2 files

• 1st Containing Data (No Column Header)
• 2nd Containing Column Header

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.

My Code Till now

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)

Now, With concat i want the result set as

HeaderDataFrame
DataDataFrame

Whereas i am getting result as

HeaderDataFrame|DataDataFrame

Answer 1

you need to change the axis from axis=1 to axis=0 in your code, so

CompleteDataFrame = pd.concat([HeaderDataFrame,DataDataFrame], ignore_index=True,axis=0)