/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 vote98 views1 answer
Remove column by index
Python
0 vote104 views2 answers
Append two 1d arrays python
Python
3 votes110 views1 answer
Clean punctuation from string python
Python
-2 votes89 views1 answer
Nodejs print
Python
0 vote98 views1 answer
Mechanize python XE #29
Python
0 vote105 views1 answer
How to append substring to string in specific position in python
Python
1 vote123 views2 answers
Django client ip
Python Django
0 vote99 views1 answer
Pydub create empty track
Python
0 vote87 views1 answer
Python tkinter importieren
Python
0 vote85 views1 answer
Python font
Python