Python pandas cumsum with reset everytime there is a 0

by

You can use:

a = df != 0
df1 = a.cumsum()-a.cumsum().where(~a).ffill().fillna(0).astype(int)
print (df1)
   a  b
0  0  1
1  1  2
2  0  3
3  1  0
4  2  1
5  0  2

More Related Contents:

  1. How to groupby consecutive values in pandas DataFrame
  2. Cumsum as a new column in an existing Pandas data
  3. Cumsum reset at NaN
  4. How can I use cumsum within a group in Pandas?
  5. Pandas dataframe – running sum with reset
  6. Cumsum as a new column in an existing Pandas dataframe
  7. Python pandas cumsum() reset after hitting max
  8. Why does the following code cant get value of n_fold = 1?
  9. Pandas long to wide reshape, by two variables
  10. How to avoid Python/Pandas creating an index in a saved csv?
  11. Convert floats to ints in Pandas?
  12. datetime dtypes in pandas read_csv
  13. Calculate average of every x rows in a table and create new table
  14. get previous row’s value and calculate new column pandas python
  15. How to move pandas data from index to column after multiple groupby
  16. sorting by a custom list in pandas
  17. Get last “column” after .str.split() operation on column in pandas DataFrame
  18. removing time from date&time variable in pandas?
  19. How do you update the levels of a pandas MultiIndex after slicing its DataFrame?
  20. Prevent pandas read_csv treating first row as header of column names
  21. How to specify date format when using pandas.to_csv?
  22. Using Pandas Value_Counts and matplotlib
  23. How to plot two columns of a pandas data frame using points
  24. What is the fastest way to output large DataFrame into a CSV file?
  25. Format a number with commas to separate thousands
  26. Python: UserWarning: This pattern has match groups. To actually get the groups, use str.extract
  27. Sorting the order of bars in pandas/matplotlib bar plots
  28. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  29. Convert dates to pd.to_datetime where month could be either a number or month name
  30. Pandas: select all dates with specific month and day

Leave a Comment