/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 vote235 views1 answer
Customise the django rest api view
Python Django
0 vote212 views2 answers
Dataframe rolling window
Python
3 votes184 views2 answers
Python split by first match
Python
0 vote193 views4 answers
How to convert array of arrays into single array with unique values in numpy
Python
0 vote182 views1 answer
Https://stackoverflow.com/questions/7066121/how-to-set-a-single-main-title-above-all-the-subplots-with-pyplot
Python
8 votes211 views3 answers
Import turtle as t
Python
4 votes198 views1 answer
Server on python with address and port
Python
1 vote202 views2 answers
Histogram chart plotly
Python
5 votes185 views1 answer
What is seaborn in python
Python
1 vote209 views1 answer
Django model choice field from another model
Python