Related Articles

Related Articles

Cumulative percentage of a column in Pandas – Python
  • Last Updated : 26 Jul, 2020

Cumulative Percentage is calculated by the mathematical formula of dividing the cumulative sum of the column by the mathematical sum of all the values and then multiplying the result by 100. This is also applicable in Pandas Data frames.
Here, the pre-defined cumsum() and sum() functions are used to compute the cumulative sum and sum of all the values of a column.
Syntax: 

df[cum_percent] = 100 * (df[‘column_name’].cumcum()/df[‘column_name’].sum())

Example 1:

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

import pandas as pd
import numpy as np
   
# Create a DataFrame
df1 = {
     'Name':['abc','bcd','cde','def','efg','fgh','ghi'],
   'Math_score':[52,87,49,74,28,59,48]}
   
df1 = pd.DataFrame(df1, columns=['Name','Math_score'])
  
# Computing Cumulative Percentage
df1['cum_percent'] = 100*(df1.Math_score.cumsum() / df1.Math_score.sum())
  
df1

chevron_right


Output: 



 

Example 2: 

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

import pandas as pd
import numpy as np
   
# Create a DataFrame
df1 = {
     'Name':['abc','bcd','cde','def','efg','fgh','ghi'],
   'Math_score':[52,87,49,74,28,59,48],
  'Eng_score':[34,67,25,89,92,45,86]
}
   
df1 = pd.DataFrame(df1,columns=['Name','Math_score','Eng_score'])
  
# Computing cumulative Percentage
df1['Eng_cum_percent'] = (df1.Eng_score.cumsum() / df1.Eng_score.sum()) * 100
  
df1

chevron_right


Output: 


Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.




My Personal Notes arrow_drop_up
Recommended Articles
Page :