- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies

- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who

# How does the series.cumsum() method work in Pandas?

The pandas Series.cumsum() method is used to find the cumulative sum of the elements in a series object.

The Series.cumsum() method returns a cumulative sum with the same length as the original series object. The first element of the cumulative sum is the same as the input object.

This method has three parameters which are “axis”, “skipna” and “args” keywords. The important parameter is “skipna” which is used to exclude Nan/null values by default, if we include the missing values then we need to set it to “False”.

## Example 1

# importing required packages import pandas as pd import numpy as np # create a pandas Series object series = pd.Series([9,3,8,np.nan,4]) print(series) print("Cumulative sum: ",series.cumsum())

## Explanation

In this example, we are finding the cumulative sum of the series object “series”, which is having some integer values and Nan. Here, we have applied the cumsum() method without changing the default parameter values.

## Output

0 9.0 1 3.0 2 8.0 3 NaN 4 4.0 dtype: float64 Cumulative sum: 0 9.0 1 12.0 2 20.0 3 NaN 4 24.0 dtype: float64

The first element of the cumulative sum has the same element as the original series object. The cumsam() method skips the Nan values by default so that the Nan value at index position 3 is ignored.

## Example 2

# importing required packages import pandas as pd import numpy as np # create a pandas Series object series = pd.Series([7,-3,18,np.nan,4,1]) print(series) print("Cumulative sum including NA: ",series.cumsum(skipna=False))

## Explanation

Same as the previous example, here also we calculated the cumulative sum, But the skipna parameter is changed to False from default True. Hence NULL values won’t be ignored.

## Output

0 7.0 1 -3.0 2 18.0 3 NaN 4 4.0 5 1.0 dtype: float64 Cumulative sum including NA: 0 7.0 1 4.0 2 22.0 3 NaN 4 NaN 5 NaN dtype: float64

Up to the Nan value, we got the cumulative sum elements. After that we got only Nan value, this is because the cumulative sum of NaN with anything that will be NaN only.

- Related Articles
- How does the pandas Series idxmax() method work?
- How does the pandas Series idxmin() method work?
- How does pandas series astype() method work?
- How does pandas series combine() method work?
- How does pandas series combine_first() method work?
- How does pandas series div() method work?
- How does pandas series argsort work?
- How does the pandas series.ffill() method work?
- How does the pandas series.expanding() method work?
- How does the pandas series.first_valid_index() method work?
- How does the series.copy() method work in Pandas?
- How does the series.corr() method work in pandas?
- How does the series.cummax() method work in Pandas?
- How does the series.cumprod() method work in Pandas?
- How does the pandas series.gt() method work if the series object contains string-type elements?