Running sum in pandas (without loop)

by

As @JonClements mentions, you can do this using the cumsum DataFrame method:

from pandas import DataFrame
df = DataFrame({0: {'10/10/2012': 50, '10/11/2012': -10, '10/12/2012': 100}, 1: {'10/10/2012': 0, '10/11/2012': 90, '10/12/2012': -5}})

In [3]: df
Out[3]: 
              0   1
10/10/2012   50   0
10/11/2012  -10  90
10/12/2012  100  -5

In [4]: df.cumsum()
Out[4]: 
              0   1
10/10/2012   50   0
10/11/2012   40  90
10/12/2012  140  85

More Related Contents:

  1. change column name in pandas, which will be used to change name for 1 column
  2. Pandas read in table without headers
  3. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  4. Can pandas automatically read dates from a CSV file?
  5. Pandas cannot open an Excel (.xlsx) file
  6. pandas dataframe str.contains() AND operation
  7. Python Pandas: Check if string in one column is contained in string of another column in the same row
  8. First non-null value per row from a list of Pandas columns
  9. Pandas: Filtering multiple conditions
  10. How to determine the length of lists in a pandas dataframe column
  11. Pandas fill missing values in dataframe from another dataframe
  12. Filter a pandas dataframe using values from a dict
  13. What is the difference between a pandas Series and a single-column DataFrame?
  14. Get data from pandas into a SQL server with PYODBC
  15. Find the unique values in a column and then sort them
  16. how do I calculate a rolling idxmax
  17. binning a dataframe in pandas in Python [duplicate]
  18. What is the difference between pandas agg and apply function?
  19. Pandas: Return Hour from Datetime Column Directly
  20. How to filter a pandas dataframe based on the length of a entry
  21. Selecting pandas column by location
  22. Plot multiple columns of pandas DataFrame using Seaborn
  23. Getting Google Spreadsheet CSV into A Pandas Dataframe
  24. Python Pandas merge only certain columns
  25. Pandas: Creating aggregated column in DataFrame
  26. How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
  27. pandas convert from datetime to integer timestamp
  28. geopandas point in polygon
  29. Rename columns in Pandas based on a dictionary
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment