/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 vote315 views1 answer
Use module Crypto.Cipher.PKCS1_OAEP instead
Python
7 votes309 views6 answers
Eval()
Python
1 vote342 views1 answer
Python get last item in a list
Python
2 votes314 views1 answer
Python for loop m to n
Python
2 votes353 views3 answers
Change python version of a conda environment
Python
0 vote303 views1 answer
Restrict ticks to integers matplotlib
Python
0 vote315 views1 answer
Python Root finding code
Python
0 vote300 views1 answer
Importando todo o pacote em python
Python
0 vote346 views1 answer
Numpy convolution stride tricks
Python
0 vote324 views2 answers
Mechanize python #6
Python