/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 votes145 views1 answer
Python install command in linux
Python
0 vote146 views2 answers
Torch.cat
Python
6 votes172 views3 answers
Django models filter
Python
0 vote149 views1 answer
Docker remote
Python
0 vote175 views1 answer
Python read file to eof
Python
0 vote166 views1 answer
How to use the dot lower function
Python
1 vote145 views1 answer
Python install pandas for linux
Python
1 vote138 views1 answer
Cannot import name 'abc' from 'bson.py3compat'
Python
-1 vote118 views1 answer
What will be the output of the following python code? print("abc. def".capitalize())
Python
1 vote147 views1 answer
Exclude first value of an array python
Python