/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 vote202 views1 answer
How to input sentence in python
Python
-3 votes188 views2 answers
How to separate date and time in python
Python
0 vote182 views1 answer
Elevando numero ao quadrado em python
Python
10 votes178 views3 answers
Matplotlib axis labels
Python
0 vote230 views1 answer
How to send file in django response
Python Django
0 vote237 views1 answer
Get last save id django model
Python Django
0 vote174 views1 answer
Python - dataframe columns is a list - drop
Python
5 votes187 views2 answers
Append string variable with integer python
Python
0 vote207 views1 answer
Python round 2.5
Python
3 votes176 views1 answer
Python plot cut off when saving figure
Python