/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 vote230 views1 answer
Python added dictionary together
Python
0 vote231 views1 answer
;dslaoeidksamclsoeld,cmskadi934lglllfgl;llgldklkkkkjkklllloooofklllflll;=\f]p[
Python
0 vote219 views1 answer
How stract avery .jpg string in a website python
Python
1 vote264 views1 answer
Solution TypeError: can’t multiply sequence by non-int of type ‘float’
Python
0 vote245 views1 answer
Python numpy how to empty array cycle
Python
7 votes260 views3 answers
List of list to numpy array
Python
0 vote271 views1 answer
How to add static files in django 3.2.9
Python Django
1 vote255 views3 answers
List of dict to df
Python
2 votes186 views2 answers
How to play audio in python
Python
0 vote248 views1 answer
Python turn seconds into zulu time
Python