/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

3 votes217 views1 answer
Install re package python
Python
2 votes202 views1 answer
Python copy a 2D list
Python
0 vote218 views1 answer
Install ansible with pip
Python
4 votes233 views1 answer
Python zip file open as text
Python
1 vote217 views2 answers
Python flask api
Python
1 vote200 views1 answer
Python for/else
Python
0 vote208 views1 answer
Last 2 numbers of integer in python
Python
0 vote220 views1 answer
Python beacon
Python
0 vote221 views1 answer
Python slack webhook
Python
73 votes205 views6 answers
Remove duplicates python
Python