/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 vote186 views1 answer
Calculate quartil python
Python
-2 votes184 views9 answers
Django
Python Django
1 vote143 views1 answer
Jupyter notebook how to set max display row columns matrix numpy
Python
10 votes158 views3 answers
Create a virtualenv python3
Python
0 vote138 views1 answer
Python how to compress pytorch model
Python
0 vote147 views1 answer
Error: Not found: 'dart:ui' import 'dart:ui' show lerpDouble; ^
Python
0 vote161 views1 answer
Find different between list
Python
0 vote156 views1 answer
How to get session value in django template
Python Django
0 vote138 views2 answers
_xsrf argument missing from POST
Python
8 votes144 views1 answer
Pandas series to list
Python