Oct-01-2017, 02:16 PM
I want to concatenate specific columns and rows of multiple excel file(Like first.xlsx[B13:D13] and second.xlsx[B13:D13]). How can I improve my codes on below?
import os
import pandas as pd
path = os.getcwd()
files = os.listdir("C:\Files");
files_xls = [f for f in files if f[-3:] == 'xls' or 'xlsx']
print(files_xls)
df = pd.concat(map(pd.read_excel, glob.glob(os.path.join('',"C:\Files\*.xls"))),axis=1)
print(df)
