/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 vote112 views1 answer
Prettify json in pycharm
Python
2 votes123 views2 answers
Seaborn boxplot multiple columns
Python
0 vote109 views1 answer
Numpy is not nan
Python
0 vote147 views1 answer
Migrate using other database django
Python Django
20 votes114 views2 answers
Python list of paths
Python
2 votes106 views1 answer
Pandas get value not equal to
Python
0 vote116 views1 answer
Speak by a discord bot in python
Python
1 vote145 views1 answer
Flask form errors
Python Flask
3 votes111 views1 answer
Hwo much does mano house cost in python
Python
1 vote126 views1 answer
Flask blueprints
Python