/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 vote199 views1 answer
Np.linalg.eigvals positive check python
Python
0 vote189 views1 answer
Tensorboard dev upload in background colab
Python
0 vote195 views2 answers
While scraping table data i am getting output as none
Python
1 vote179 views1 answer
Convert url to base64 image py
Python
-2 votes228 views1 answer
How to get data from django session
Python Django
1 vote190 views1 answer
Create spark dataframe in python
Python
0 vote214 views1 answer
Python svg viewing
Python
0 vote193 views1 answer
Dump ML Model
Python
2 votes253 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
7 votes199 views2 answers
Pandas read_csv ignore unnamed columns
Python