/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 vote280 views1 answer
Python convert to hmac sha256
Python
0 vote295 views1 answer
Get the values of your aws tags from ec2 instance
Python
1 vote295 views1 answer
Removing odd index character of a given string in python
Python
0 vote268 views1 answer
Pandas read csv file header column not equal data columns
Python
1 vote293 views1 answer
[Solved] TypeError: can’t multiply sequence by non-int of type str
Python
0 vote273 views1 answer
Scrapy selenium screnshot
Python
0 vote258 views1 answer
Select numbers from a list with a limit python
Python
1 vote273 views1 answer
Python discord discord.py disable remove help command
Python
20 votes294 views4 answers
Button tkinter
Python
1 vote279 views1 answer
Add time delta pytohn
Python