1. Python
  2. Python | Pandas Panel.rsub ()

Python | Pandas Panel.rsub ()

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