python add elements to dataframe row

Question

I'm iterating over a dataframe and I want to add new elements to each row, so that I can add the new row to a second dataframe.

for index, row in df1.iterrows():
    # I looking for somethis like this:
    new_row = row.append({'column_name_A':10})

    df2 = df2.append(new_row,ignore_index=True)

Before for loop: new_row =[] in For loop: new_row.append({'column_name_A':10}) — Rahul Agarwal
– Rahul Agarwal, Commented Sep 18, 2018 at 9:36
why not create a full column with df['column_name_A''] = 10 and not itterate over the rows? — Frayal
– Frayal, Commented Sep 18, 2018 at 10:04
This is just an example. In each iteration, I will add different values. But thanks. — Miguel
– Miguel, Commented Sep 18, 2018 at 10:06

Abhinav Upadhyay · Accepted Answer · 2018-09-18 10:18:45Z

1

If I understand correctly, you want to have a copy of your original dataframe with a new column added. You can create a copy of the original dataframe, add the new column to it and then iterate over the rows of the new dataframe to update the values of the new column as you would have done in your code posted in the question.

df2 = df1.copy()
df2['column_name_A'] = 0
for index, row in df2.iterrows():
    row['column_name_A'] = some_value

answered Sep 18, 2018 at 10:18

Abhinav Upadhyay

2,60522 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python add elements to dataframe row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related