/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

81 votes340 views6 answers
Python convert string to date
Python
0 vote331 views1 answer
Find maximum value by if else python
Python
0 vote326 views1 answer
Cbv uk django
Python
4 votes298 views1 answer
Matplotlib plot dashed
Python
1 vote315 views1 answer
Numpy subarray python
Python
0 vote328 views1 answer
Protected vs private python
Python
2 votes323 views1 answer
How to create a window in pygame
Python
19 votes314 views5 answers
Conda tensorflow
Python
2 votes329 views1 answer
Pass in queryset as filter django
Python
3 votes332 views1 answer
Python strlen
Python