Problem while adding new column in Panda dataframe using Python

Question

I have tried various methods to add new column to a Panda dataframe but I get the same result. Methods tried:

call_duration is a list having same number of items as in the data frame.

df['Duration_sec'] = pd.Series(call_duration,index=np.arange(len(df)))

and

df['Duration_sec'] = pd.Series(call_duration,index=df.index)

and

# df['Duration_sec'] = np.array(call_duration)

All three gave the same result as under-

I don't understand why the new column is added to new line? And why is there a \ at the end of the first line?

Please take the time to read this post on how to provide a great pandas example and Please don't post images of code/data (or links to them) but as text so we can copy them — anky
– anky, Commented Nov 2, 2019 at 17:13

Vishnudev Krishnadas · Accepted Answer · 2019-11-02 17:35:36Z

2

"The new column is not added to a new line"

The DataFrame is wider than the screen and hence continued in next row. In python the \ is usually used to denote join

To add a column, Simply use df.assign

df.assign(Duration_sec=call_duration)

answered Nov 2, 2019 at 17:21

11k2 gold badges29 silver badges58 bronze badges

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

Comments

aprilangel · Accepted Answer · 2019-11-03 00:13:40Z

1

You can just do

df['Duration_sec'] = call_duration

"\" means the dataframe is wider than your screen and will continue.

answered Nov 3, 2019 at 0:13

aprilangel

3792 silver badges8 bronze badges