Answers for "python loop add to dataframe"

2

creating data frame in python with for loop

df = pd.DataFrame(columns=["A", "B"])

for i in range(2):
    this_column = df.columns[i]
    df[this_column] = [i, i+1]

print(df)

#OUTPUT
#  A B
#0 0 1
#1 1 2
Posted by: Guest on August-21-2020
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

Python Answers by Framework

Browse Popular Code Answers by Language