/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

1 vote335 views1 answer
Circular array python
Python
-1 vote352 views1 answer
Matplotlib units of scatter size
Python
0 vote323 views1 answer
Without @tf.function OOM
Python
1 vote373 views1 answer
Stack overflow python ip check
Python
1 vote346 views3 answers
Insertion sort calculator
Python
5 votes337 views4 answers
Prime numbers from 1 to 100 in python
Python
0 vote321 views1 answer
Pandas automatic allignment of columns
Python
2 votes324 views1 answer
Python tkinter underline text
Python
-2 votes366 views2 answers
Count in python
Python
1 vote336 views2 answers
Panda count how many values are less than n in a column
Python