Answers for "how to append panda columns using loop"

Python

0

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)

Posted by: Guest on January-09-2022

Source

Code answers related to "how to append panda columns using loop"

Code answers related to "Python"

Python Answers by Framework

Django
Flask

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#