/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 vote108 views1 answer
Get duplicate and remove but keep last in python df
Python
39 votes96 views6 answers
Python check if int
Python
0 vote101 views1 answer
Array search with regex python
Python
0 vote111 views1 answer
Sending image over ros
Python
1 vote101 views1 answer
Remainder identifying python
Python
0 vote108 views1 answer
Python get the name of the song that is playing
Python
6 votes107 views4 answers
Extract numbers from string python
Python
0 vote103 views1 answer
How to check type inside a list in python
Python
0 vote233 views2 answers
Resample ohlc pandas
Python
0 vote124 views1 answer
Calculate quartil python
Python