+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Concatenate Specific Cell Interval With Pandas (/thread-5388.html)
Concatenate Specific Cell Interval With Pandas - vidividi12 - Oct-01-2017
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)