SUMIF on all columns with groupby()
This function is used to display sum of all columns with respect to grouped column
Syntax: dataframe.groupby(‘group_column’).sum()
where
- dataframe is the input dataframe
- group_column is the column in dataframe to be grouped
- sum() function is to perform the sum operation
Create the student dataframe with 4 columns
Python3
# import pandas module import pandas as pd # create dataframe with 4 columns data = pd.DataFrame({ "name" : [ 'sravan' , 'jyothika' , 'harsha' , 'ramya' , 'sravan' , 'jyothika' , 'harsha' , 'ramya' , 'sravan' , 'jyothika' , 'harsha' , 'ramya' ], "subjects" : [ 'java' , 'java' , 'java' , 'python' , 'python' , 'python' , 'html/php' , 'html/php' , 'html/php' , 'php/js' , 'php/js' , 'php/js' ], "internal marks" : [ 98 , 79 , 89 , 97 , 82 , 98 , 90 , 87 , 78 , 89 , 93 , 94 ], "external marks" : [ 88 , 71 , 89 , 97 , 82 , 98 , 80 , 87 , 71 , 89 , 92 , 64 ], }) # display dataframe print (data) |
Output:
Perform sum of all columns by grouping particular column
Python3
# import pandas module import pandas as pd # create dataframe with 4 columns data = pd.DataFrame({ "name" : [ 'sravan' , 'jyothika' , 'harsha' , 'ramya' , 'sravan' , 'jyothika' , 'harsha' , 'ramya' , 'sravan' , 'jyothika' , 'harsha' , 'ramya' ], "subjects" : [ 'java' , 'java' , 'java' , 'python' , 'python' , 'python' , 'html/php' , 'html/php' , 'html/php' , 'php/js' , 'php/js' , 'php/js' ], "internal marks" : [ 98 , 79 , 89 , 97 , 82 , 98 , 90 , 87 , 78 , 89 , 93 , 94 ], "external marks" : [ 88 , 71 , 89 , 97 , 82 , 98 , 80 , 87 , 71 , 89 , 92 , 64 ], }) # find sum of all columns group by name print (data.groupby( 'name' ). sum ()) # find sum of all columns group by subjects print (data.groupby( 'subjects' ). sum ()) |
Output:
How to Perform a SUMIF Function in Pandas?
sumif() function is used to perform sum operation by a group of items in the dataframe, It can be applied on single and multiple columns and we can also use this function with groupby function.