/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 vote199 views1 answer
Search for file in a whole system
Python
0 vote190 views10 answers
Python generator cheat sheet download
Python
15 votes208 views4 answers
Python time code
Python
3 votes199 views1 answer
Axis = 1 python
Python
0 vote184 views2 answers
Connect to mysql database jupyter
Python
5 votes216 views4 answers
Pandas categorical to numeric
Python
2 votes180 views1 answer
Convert time zone pandas
Python
1 vote310 views1 answer
Flask render error template
Python Flask
0 vote189 views1 answer
Access google transalte pandas
Python
0 vote217 views1 answer
Python binary remove 0b
Python