How to Append a Row to Another Dataframe

Name: How to Append a Row to Another Dataframe
Uploaded: 2026-09-30T01:49:32+00:00
Duration: 14 min 31 s
Description: I Have Dataframes Df1 and Df2 Both with Columns ["Ticker", "Adj. Factor", "Date"]. I Want to Add to Df2 the Complete Row from Df1 If the Value of "Adj. Factor"...

Question

I have dataframes df1 and df2 both with columns ["Ticker", "Adj.Factor", "Date"]. I want to add to df2 the complete row from df1 if the value of "Adj.Factor" in that row in df1 equals to 0.

I have the following code.

for x in range(tot_len):
    if df1.iloc[x]['Adj.Factor'] == 0:
        df2.append(df1.iloc[x])  --> not working.

`

I have tried printing the values and it shows the correct output. But the values are not appended to df2.

Accepted Answer

It seems you missed an assignment. Here is a simpler solution

df2 = df2.append(df1[df1['Adj.Factor'] == 0])

Answer 2

Try:

df2 = df2.append(df1.iloc[x])

DataFrame.append(self, other, ignore_index=False, verify_integrity=False, sort=False) → 'DataFrame

Append rows of other to the end of caller, returning a new object.

REF

How to Append a Row to Another Dataframe

2 Answers

Must Read

Your Answer

James H. Sterling

How to Append a Row to Another Dataframe

2 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

James H. Sterling