Skip to content
Related Articles

Related Articles

Python | Pandas Panel.sum()
  • Last Updated : 01 Jan, 2019

In Pandas, Panel is a very important container for three-dimensional data. The names for the 3 axes are intended to give some semantic meaning to describing operations involving panel data and, in particular, econometric analysis of panel data.

Panel.sum() function is used to return the sum of the values for the requested axis.

Syntax: Panel.sum(axis=None, skipna=None, level=None, numeric_only=None, min_count=0, **kwargs)

Parameters:
axis : {items (0), major_axis (1), minor_axis (2)}
skipna : Exclude NA/null values when computing the result.
level : If the axis is a MultiIndex, count along a particular level, collapsing into a DataFrame
numeric_only : Include only float, int, boolean columns. If None, will attempt to use everything, then use only numeric data.
min_count : The required number of valid values to perform the operation.

Returns: DataFrame or Panel



Code #1:




# importing pandas module 
import pandas as pd 
import numpy as np
  
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'for', 'real'], 
                    'b': [11, 1.025, 333, 114.48, 1333]})
                      
data = {'item1':df1, 'item2':df1}
  
# creating Panel 
panel = pd.Panel.from_dict(data, orient ='minor')
  
print(panel['b'], '\n')
  
print("\n", panel['b'].sum(axis = 0))

Output:

 

Code #2:




# importing pandas module 
import pandas as pd 
import numpy as np
  
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'for', 'real'], 
                    'b': [33.0, -152.140, 3.0133, 114.48, 13.033]})
                      
data = {'item1':df1, 'item2':df1}
  
# creating Panel 
panel = pd.Panel.from_dict(data, orient ='minor')
  
print(panel['b'], '\n')
  
print("\n", panel['b'].sum(axis = 1))

Output:

 

Code #3:




# importing pandas module 
import pandas as pd 
import numpy as np
  
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks'], 
                    'b': np.random.randn(3)})
                      
data = {'item1':df1, 'item2':df1}
  
# creating Panel 
panel = pd.Panel.from_dict(data, orient ='minor')
  
print(panel['b'], '\n')
  
  
print("\n", panel['b'].sum(axis = 1))

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. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course

My Personal Notes arrow_drop_up
Recommended Articles
Page :