Breaking News: Grepper is joining You.com. Read the official announcement!

how to append panda columns using loop

Niransha answered on January 9, 2022 Popularity 9/10 Helpfulness 4/10

answer how to append panda columns using loop

related Appending pandas dataframes generated in a for loop

how to append panda columns using loop

Comment

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)

Popularity 9/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: append python using

Link to this answer
Share Copy Link

Contributed on Jan 09 2022

Niransha

0 Answers Avg Quality 2/10

Closely Related Answers

Appending pandas dataframes generated in a for loop

Comment

appended_data = []
for infile in glob.glob("*.xlsx"):
    data = pandas.read_excel(infile)
    # store DataFrame in list
    appended_data.append(data)
# see pd.concat documentation for more info
appended_data = pd.concat(appended_data)
# write DataFrame to an excel sheet 
appended_data.to_excel('appended.xlsx')

Popularity 9/10 Helpfulness 10/10 Language python

Source: stackoverflow.com

Tags: for-loop for-loo

Link to this answer
Share Copy Link