Python | Pandas Panel.rsub ()

Michael Zippo 18.07.2021

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

Syntax : Panel.rsub (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 rsub () method -"  ) 
   print   (  ""  , panel [  ’b’  ]. rsub (df2 [ ’ b’  ], axis   =   0  ))

Exit:

 panel [’ b’] is - item1 item2 0 111 100 1 123 100 2 425 100 3 1333 100 Subtracting panel [’b’] with df2 [’ b’] using rsub () method - item1 item2 0 -11 0 1 -23 0 2 -325 0 3 -1233 0

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’] with df2 using rsub () method - "  ) 
   print   (panel [  ’b’  ]. rsub (df2, axis   =   0  ))

Exit:

 panel [’b’] is - item1 item2 0 11.000 11.000 1 1.025 1.025 2 333.000 333.000 3 114.480 114.480 4 1333.000 1333.000 Newly create dataframe with random values is - item1 item2 0 0.159943 0.383040 1 0.769608 0.776670 2 0.038762 0.889516 3 0.672955 0.094725 4 0.127130 0.729699 Subtracting panel [’b’] with df2 using rsub () method - item1 item2 0 -10.840057 -10.616960 1 -0.25531238 -0.23.9 332.110484 3 -113.807045 -114.385275 4 -1332.872870 -1332.270301

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 rsub () method - " ) 
   print   (  ""  , panel [  ’b’  ] [ ’ item1’  ]. rsub (df2 [  ’b’  ], axis   =   0  ))

Output:

 panel [’b’] is - item1 item2 0 11.000 10 1 1.025 10 2 333.000 10 3 114.480 110 4 1333.000 110 Subtracting panel [’ b’] [’item1’] with df2 [’ b ’] or panel [’ b’] [’item2’] using rsub () method - 0 -1.000 1 8.975 2 -323.000 3 -4.480 4 -1223.000 dtype: float64