pandas: adding rows in a column

Question

i have a dataframe like this,

Count
1
0
1
1
1

I want to add N and N+1 in count column and store it in N, is it possible to do in pandas way?

result should like this, technically it is cumulative sum:

Counts
1
1
2
3
4

Could you be more clear in what you want to achieve?, how do you want your final dataframe to look like? — VMEscoli
– VMEscoli, Commented Jul 6, 2018 at 9:37

Spinor8 · Accepted Answer · 2018-07-06 09:45:35Z

2

You can use the cumulative sum function, cumsum().

df = pd.DataFrame([1, 0, 1, 1,1], columns=['Count'])

df['Counts'] = df['Count'].cumsum()
print(df)

giving you the desired output.

   Count  Counts
0      1       1
1      0       1
2      1       2
3      1       3
4      1       4

answered Jul 6, 2018 at 9:45

Spinor8

1,6174 gold badges24 silver badges54 bronze badges

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

1 Answer 1