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

Python | Pandas Panel.sub ()



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 )) 

Output: