Python | Pandas Panel.sub ()

Michael Zippo 18.07.2021

In Pandas the Panel.sub() function is used to get the subtraction of a series and a data frame / Panel.

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

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

Returns: Panel

Code # 1:

# pandas module import

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}

# create a panel

panel = pd.Panel.from_dict (data, orient = ’minor’ )

print ( "panel [’ b’] is - " , panel [ ’ b’ ])

print ( " Subtracting panel [’b’] with df2 [’ b’] using sub () method - " )

print ( " " , panel [ ’b’ ]. sub (df2 [ ’ b’ ], axis = 0 ))

Output:

Code # 2:

       # pandas module import  
   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} 
    
  # create a panel  
   panel   =   pd.Panel.from_dict (data, orient   =   ’minor’  ) 
   print   ( " panel [’b’] is -"  , panel [  ’b’  ],  ’ ’ )  
   
  # Create a 5 * 5 data frame  
   df2   =   pd.DataFrame (np.random.rand (  5  ,   2  ), columns   =   [  ’item1’  ,  ’ item2’  ]) 
   print   ( " Newly create dataframe with random values is - "  , df2) 
   
   print   (  "Subtracting panel [’ b’] wi th df2 using sub () method - " ) 
   print   (panel [  ’b’  ]. sub (df2, axis   =   0  ))

Output:

Code # 3:

# pandas module import

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}

# create a panel

   panel   =   pd.Panel.from_dict (data, orient   =   ’minor’  ) 
   
   print   (  "panel [’ b’] is - " , panel [  ’b’  ],  ’ ’ ) 
   
   print   (  "Subtracting panel [’ b’] [’item1’] with df2 [’ b’] or panel [’b’] [’item2’] using sub () method -"  ) 
   print   (  ""  , panel [   ’b’  ] [ ’ item1’  ]. sub (df2 [  ’b’  ], axis   =   0  ))