/Python/How to append panda columns using loop

How to append panda columns using loop

import pandas as pd
import glob

f_list = glob.glob("C:\\Users\\*.xlsx")  
#list comprehension 
all_data = [pd.read_excel(f) for f in f_list]  

#same like loops solution
all_data = []            
for f in f_list:                       
    df = pd.read_excel(f)             
    all_data.append(df)
    
df = pd.concat(all_data, axis=1)

Source: stackoverflow.com

Similar codes

1 vote166 views2 answers
Pandas rename column values dictionary
Python
8 votes121 views4 answers
Reverse dictionary python
Python
12 votes171 views1 answer
Create an environment in conda
Python
3 votes172 views3 answers
Python check internet connection
Python
2 votes194 views1 answer
Pandas dataframe set datetime index
Python
0 vote161 views1 answer
IQR to remove outlier
Python
0 vote152 views1 answer
Return positon of ele in list python
Python
-2 votes159 views1 answer
Center buttons tkinter
Python
9 votes154 views1 answer
Cv2 grayscale
Python
0 vote173 views1 answer
Randomforestregressor in sklearn
Python