Open In App

Python | Pandas Panel.sum()

Last Updated : 01 Jan, 2019
Comments
Improve
Suggest changes
Like Article
Like
Report
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: Python3 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: Python3 1==
# 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: Python3 1==
# 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:

Next Article

Similar Reads