/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 vote314 views1 answer
Import mean squared log error
Python
8 votes328 views2 answers
Pandas inner join on two columns
Python
0 vote300 views1 answer
How to import the whall library in python
Python
0 vote337 views1 answer
How to pre populate field flask wtforms
Python
0 vote323 views1 answer
Limit for loop python
Python
0 vote309 views1 answer
The Bytearray Type
Python
2 votes342 views3 answers
Geopandas set crs
Python
0 vote340 views1 answer
Onetoone vs foreign key django
Python Django
6 votes321 views2 answers
Python code for where to save the figures
Python
0 vote276 views6 answers
New listnode(-1)
Python