/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 vote337 views1 answer
Python seaborn violin stack overflow
Python
0 vote360 views1 answer
Python Split list into chunks using itertools Method
Python
2 votes338 views1 answer
And condition with or in django
Python
1 vote374 views1 answer
A list inside a list python
Python
16 votes352 views3 answers
How to read the first line in a file python
Python
1 vote332 views1 answer
Read image python
Python
1 vote367 views1 answer
Unable to execute 'x86_64-linux-gnu-gcc': No such file or directoryunable to execute 'x86_64-linux-gnu-gcc': No such file or directory
Python
8 votes342 views3 answers
Python multiply list
Python
0 vote356 views1 answer
Python opening file modalities
Python
56 votes379 views6 answers
Activate python virtual environment
Python