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.
2 Answers
It seems you missed an assignment. Here is a simpler solution
df2 = df2.append(df1[df1['Adj.Factor'] == 0])
Try:
df2 = df2.append(df1.iloc[x])
DataFrame.append(self, other, ignore_index=False, verify_integrity=False, sort=False) → 'DataFrameAppend rows of other to the end of caller, returning a new object.
