/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 vote303 views1 answer
For loop in django template css
Python Django
1 vote252 views1 answer
Django.db.models avg
Python Django
2 votes280 views1 answer
Django load model by name
Python Django
3 votes235 views2 answers
Copy a 2d array in python
Python
0 vote252 views1 answer
Python run async function without await
Python
1 vote326 views1 answer
Redirected but the response is missing a Location: header.
Python
0 vote246 views1 answer
What happens if you lose your virginity before getting your first period
Python
0 vote273 views1 answer
Python savefig full screen
Python
0 vote260 views1 answer
Python apply function to list
Python
0 vote239 views9 answers
Filter dataframe site:stackoverflow.com
Python