/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

1 vote200 views2 answers
Django queryset exists
Python Django
0 vote224 views1 answer
Pyplot define plotsize
Python
1 vote161 views1 answer
Python towers of hanoi recursive
Python
0 vote155 views1 answer
Try: if '1' != 1: raise "someError" else: print("someError has not occurred") except "someError": print ("someError has occurred")
Python
0 vote149 views1 answer
Seaborn line chart set fig size
Python
0 vote147 views1 answer
Open tar file pandas
Python
10 votes138 views3 answers
Pandas show all dataframe method
Python
0 vote148 views2 answers
How to make SAPI.SpVoice say a variable in python
Python
0 vote142 views1 answer
Equivalent of case_when in r in pandas
Python
142 votes163 views6 answers
Write to file python
Python