/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

4 votes256 views1 answer
Iterating over 2d array python
Python
2 votes276 views2 answers
Python trim leading whitespace
Python
0 vote257 views1 answer
Isenable selenium python
Python
37 votes256 views6 answers
Turn list into string
Python
0 vote268 views1 answer
How to plot a linear equation in matplotlib
Python
0 vote251 views1 answer
Python requests cannot find existing url
Python
30 votes261 views6 answers
How to create a superuser in django
Python
0 vote275 views1 answer
Python format inverse
Python
2 votes265 views1 answer
Get distance between 2 multidimentional point in python
Python
-1 vote260 views1 answer
Python how to import a module given a stringg
Python