/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 vote166 views1 answer
Python remove dtype from array
Python
0 vote146 views1 answer
Display full length jupyter
Python
0 vote190 views1 answer
Requests.Session() proxies
Python
0 vote144 views1 answer
Python round and map function
Python
-2 votes158 views1 answer
Python for-while
Python
0 vote145 views1 answer
Python3 paramiko read stdout
Python
0 vote152 views1 answer
Tensor.numpy() pytorch gpu
Python
1 vote147 views1 answer
How to download a page in python
Python
0 vote110 views1 answer
Df get columnvalues
Python
0 vote175 views1 answer
RuntimeError: Expected object of type torch.FloatTensor but found type torch.cuda.FloatTensor for argument
Python