/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 vote118 views1 answer
Python how to close the turtle tab on click
Python
0 vote106 views1 answer
Python ssl module is not available
Python
2 votes114 views2 answers
AttributeError: module 'tensorflow._api.v2.train' has no attribute 'RMSPropOptimizer' site:stackoverflow.com
Python
0 vote123 views1 answer
Python cursor placement
Python
0 vote146 views1 answer
Expected a list of items but got type int . django
Python Django
0 vote119 views4 answers
Dataframe to dictionary without index
Python
0 vote126 views1 answer
Swapping upper case and lower case string python
Python
17 votes130 views5 answers
Append element to list py
Python
0 vote147 views1 answer
Web socket in python
Python
-1 vote121 views1 answer
Starry spheres
Python