/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 vote127 views2 answers
Download pdf from url python
Python
0 vote124 views1 answer
Deepface facebook python
Python
57 votes108 views3 answers
How to add an item to a dictionary in python
Python
3 votes176 views2 answers
Python check if list
Python
0 vote122 views1 answer
Count proportion pandas
Python
35 votes124 views6 answers
For in range loop python
Python
0 vote119 views1 answer
Converting (YYYY-MM-DD-HH:MM:SS) date time
Python
3 votes117 views1 answer
How to export a string as txt file in python
Python
8 votes115 views1 answer
Positive lookahead regex python
Python
0 vote120 views1 answer
Matplotlib add text to axes
Python