/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

2 votes165 views2 answers
Python unresolved import local visual studio code 2019
Python
5 votes128 views6 answers
Python pycharm
Python
0 vote133 views1 answer
Pylatex bold
Python
24 votes141 views1 answer
How to replace na values in python
Python
0 vote126 views1 answer
Top gun: maverick
Python
0 vote147 views1 answer
Python how to d oa hello worl
Python
0 vote126 views1 answer
Python extract words from string with format
Python
0 vote136 views1 answer
Python find matching string regardless of case
Python
0 vote124 views1 answer
Return maximum of three values in python
Python
0 vote129 views1 answer
Capitalise words in a column pandas
Python