/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 vote197 views1 answer
Add widget in pyqt
Python
0 vote137 views1 answer
Histogram matplotliub
Python
0 vote133 views1 answer
Check if environment variable exists
Python
10 votes156 views3 answers
Discord.py custom status
Python
0 vote156 views1 answer
How to use tensorboard
Python
3 votes156 views1 answer
Change plot size matplotlib python
Python
0 vote193 views1 answer
Find width and height of imported video frame opencv2
Python
3 votes237 views1 answer
Django session expire time
Python Django
5 votes182 views3 answers
How to extract zip file using python
Python
2 votes171 views3 answers
Combine list of dicts
Python