Skip to content
Related Articles

Related Articles

Python | Pandas Panel.div()

View Discussion
Improve Article
Save Article
  • Last Updated : 28 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.

In Pandas Panel.div() function is used to get the division of series and dataframe/Panel.

Syntax: Panel.div(other, axis=0)

Parameters:
other : DataFrame or Panel
axis : Axis to broadcast over

Returns: Panel

Code #1:




# importing pandas module 
import pandas as pd 
import numpy as np 
  
df1 = pd.DataFrame({'a': ['Geeks', 'For', 'geeks', 'real'], 
                    'b': [111, 123, 425, 1333]}) 
  
df2 = pd.DataFrame({'a': ['I', 'am', 'dataframe', 'two'], 
                    'b': [100, 100, 100, 100]}) 
                      
data = {'item1':df1, 'item2':df2}
  
# creating Panel 
panel = pd.Panel.from_dict(data, orient ='minor'
print("panel['b'] is - \n\n", panel['b']) 
  
print("\nDividing panel['b'] with df2['b'] using div() method - \n"
print("\n", panel['b'].div(df2['b'], 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': [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'] is - \n\n", panel['b'], '\n'
  
# Create a 5 * 5 dataframe 
df2 = pd.DataFrame(np.random.rand(5, 2), columns =['item1', 'item2']) 
print("Newly create dataframe with random values is - \n\n", df2)
  
print("\nDividing panel['b'] with df2 using div() method - \n"
print(panel['b'].div(df2, axis = 0)) 

Output:

 

Code #3:




# 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]}) 
                      
df2 = pd.DataFrame({'a': ['I', 'am', 'DataFrame', 'number', 'two'], 
                    'b': [10, 10, 10, 110, 110]})                     
                      
data = {'item1':df1, 'item2':df2} 
  
# creating Panel 
panel = pd.Panel.from_dict(data, orient ='minor'
  
print("panel['b'] is - \n\n", panel['b'], '\n'
  
print("\nDividing panel['b']['item1'] with df2['b'] or panel['b']['item2'] using div() method - \n"
print("\n", panel['b']['item1'].div(df2['b'], axis = 0)) 

Output:

 


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!