# Cumulative percentage of a column in pandas python

Cumulative percentage of a column in pandas python is carried out using sum() and cumsum() function in roundabout way. cumulative percentage of the column is calculated in the roundabout way in two methods as shown below. Let’s see how to

• Get the cumulative percentage of a column in pandas dataframe in python With an example.

#### Desired result : Cumulative percentage of column:

First let’s create a dataframe

```
import pandas as pd
import numpy as np

#Create a DataFrame
df1 = {
'Name':['George','Andrea','micheal','maggie','Ravi','Xien','Jalpa'],
'Mathematics_score':[62,47,55,74,32,77,86]}

df1 = pd.DataFrame(df1,columns=['Name','Mathematics_score'])
print(df1)

```

df1 will be

#### Cumulative percentage of a column in a pandas dataframe python : Method 1

Cumulative percentage of a column in pandas dataframe is computed using cumsum() and sum() function and stored in a new column namely cumulative_percentage as shown below

```##### cumulative percentage of column
df1['cumulative_percentage'] = 100*df1.Mathematics_score.cumsum()/df1.Mathematics_score.sum()
df1

```

so resultant dataframe will be

#### Cumulative percentage of a column in a pandas  : Method 2

Cumulative percentage of a column in pandas dataframe is computed using cumsum() and sum() function and stored in a new column namely cumulative_percentage as shown below

```##### cumulative percentage of column : Method 2
df1['cumulative_percentage'] = (df1.Mathematics_score.cumsum() / df1.Mathematics_score.sum()) * 100
df1
```

so resultant dataframe will be,

#### Other Related Topics:

further details about cumsum() function is in documentation.

## Author

• With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.