/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 vote289 views1 answer
Python setattr function
Python
72 votes280 views6 answers
Python compilers
Python
0 vote294 views1 answer
Display full length jupyter
Python
0 vote293 views1 answer
Python scatter plot legend
Python
2 votes258 views1 answer
How to clear an array python
Python
1 vote299 views1 answer
Test cuda pytorch
Python
0 vote290 views1 answer
Django get current user in form
Python
0 vote263 views3 answers
A program that asks for the user's input of a list of numbers and sort it in reverse in python
Python
5 votes282 views2 answers
Isnotin python
Python
1 vote271 views2 answers
Get the number of today week python
Python