/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 vote141 views1 answer
How to make bot commands case insensitive in discord.py
Python
12 votes137 views6 answers
Curl in python
Python
8 votes202 views1 answer
How to do collision detection in pygame
Python
0 vote166 views1 answer
Django BruteBuster error failed attempts
Python Django
0 vote135 views1 answer
Numpy rolling 2d
Python
0 vote131 views1 answer
Python utf upper()
Python
0 vote138 views1 answer
Python open file same folder
Python
1 vote145 views1 answer
Python try/except loop
Python
1 vote130 views2 answers
Get pytorch version
Python
0 vote177 views1 answer
Statistique in python
Python