/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 vote181 views1 answer
Light fm cold start problem
Python
0 vote183 views1 answer
How to go to previous directory in os python
Python
0 vote135 views1 answer
Pandas read all csv in folder
Python
1 vote168 views1 answer
The name tf.summary.merge_all is deprecated. Please use tf.compat.v1.summary.merge_all
Python
0 vote229 views1 answer
How to remove quasi constant column in pandas dataframe
Python
0 vote167 views1 answer
Python if type dict
Python
16 votes173 views6 answers
Python list last element
Python
0 vote170 views1 answer
Returns a DataFrame representing the result of the given query
Python
0 vote171 views1 answer
Base conversion python
Python
7 votes170 views2 answers
Save a text file from web python
Python