/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

0 vote331 views6 answers
Python django
Python
1 vote371 views1 answer
Unresolved reference 'django'
Python Django
1 vote321 views1 answer
Color name to hex python
Python
0 vote324 views1 answer
Piecewise linear regression python
Python
0 vote318 views1 answer
Pandas isolate data lower than a certain percentage
Python
2 votes327 views1 answer
Pyspark session
Python
0 vote311 views2 answers
How to skip error python
Python
0 vote297 views1 answer
Split dataset into train, test and validation sets
Python
17 votes317 views1 answer
Ypeerror: 'int' object is not subscriptable
Python
0 vote357 views1 answer
Dataframe groupby rank by multiple column value
Python