/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

2 votes341 views1 answer
How to make convert numpy array to string in python
Python
2 votes404 views1 answer
How to redirect in flask to the same page
Python Flask
108 votes684 views6 answers
Pandas sort dataframe by column
Python
0 vote336 views2 answers
Line to curve dynamo revit
Python
0 vote332 views1 answer
Least square fit straight line python
Python
1 vote376 views1 answer
Wtf forms required
Python
3 votes340 views2 answers
Randomly shuffle array python
Python
0 vote376 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python Django
0 vote347 views1 answer
Recursive python program to print numbers from n to 1
Python
0 vote364 views1 answer
Reading json without using relative path in django
Python Django