Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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:DesktopMapping.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)
- HeaderDataFrame
- DataDataFrame
- HeaderDataFrame|DataDataFrame
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement