add a sequence of numbers to a column in pandas data frame in Python

Question

I have a data frame and I want to add a column with values 0, 0.005, 0.010, 0.015...up to the length of the df, how do I proceed? thanks

Pierre D · Accepted Answer · 2021-03-24 15:30:11Z

1

Only Pandas:

df = df.assign(newcol=pd.Series(range(df.shape[0])) * 0.005)

Using Numpy:

df = df.assign(newcol=np.arange(df.shape[0]) * 0.005)

answered Mar 24, 2021 at 15:30

Pierre D

26.6k8 gold badges71 silver badges108 bronze badges

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

Comments

s3dev · Accepted Answer · 2021-03-26 10:21:34Z

0

One way to get there would be with the numpy.arange function:

import numpy as np

df['new_column'] = np.arange(0, (df.shape[0]*0.005), 0.005)

s3dev

9,8713 gold badges34 silver badges49 bronze badges

answered Mar 24, 2021 at 15:05

acrobat

9175 silver badges8 bronze badges