/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

4 votes231 views1 answer
Python comma separated string to list
Python
0 vote283 views1 answer
Shutil.make_archive
Python
10 votes257 views3 answers
Matplotlib axis labels
Python
0 vote225 views1 answer
Python concatenate dictionaries
Python
0 vote255 views1 answer
Pil normalize image
Python
10 votes254 views3 answers
Text to image python
Python
52 votes295 views2 answers
Python find index by value
Python
3 votes274 views1 answer
Draw a single pixel using pygame
Python
0 vote276 views1 answer
Ping with python
Python
0 vote262 views1 answer
Python drop in tuple
Python