/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 vote200 views1 answer
Customise the django rest api view
Python
0 vote213 views1 answer
Python pandas convert series to percent
Python
43 votes198 views6 answers
Pygame draw line
Python
0 vote214 views1 answer
Get height of image in pygame
Python
5 votes214 views2 answers
How to subtract 2 lists in python
Python
68 votes243 views5 answers
Python main method
Python
2 votes206 views1 answer
Python dictonary of dictonary
Python
0 vote203 views1 answer
Labelencoder update
Python
23 votes417 views4 answers
Django runserver
Python Django
12 votes204 views2 answers
How to execute a python file from another python file
Python