/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 vote225 views1 answer
Insert single value in dataframe using index
Python
1 vote219 views2 answers
Why mentioning user agent in request library
Python
4 votes171 views1 answer
Pandas concat reset index
Python
0 vote212 views1 answer
How to make html files open in chrome using python
Python
0 vote217 views1 answer
No module named 'pygame' visual studio
Python
5 votes192 views1 answer
Python check file extension
Python
0 vote212 views1 answer
Python how to compress pytorch model
Python
0 vote207 views1 answer
Django file field from base64
Python
7 votes261 views2 answers
No module named 'PyQt5.QtWebEngineWidgets'
Python
0 vote201 views1 answer
Matplotlib show percentage y axis
Python