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

Python | Pandas Panel.rsub ()

NumPy | Python Methods and Functions

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




Books for developers

Practices of the Python Pro

Professional-quality code does more than just run without bugs. It’s clean, readable, and easy to maintain. To step up from a capable Python coder to a professional developer, you need to learn indu...

23/09/2020

Intro to Python for Computer Science and Data Science

For many decades, some powerful trends have been in place. Computer hardware has rap- idly been getting faster, cheaper and smaller. Internet bandwidth (that is, its information carrying capacity) has...

23/09/2020

Computer Age Statistical Inference

Computer Age Statistical Inference: Algorithms, Evidence, and Data Science (Institute of Mathematical Statistics Monographs, Series Number 6). The twenty-first century has seen a breathtaking expan...

28/08/2021

Internet of Things and Big Data Technologies for Next Generation Healthcare

The series “Studies in Big Data” (SBD) publishes new developments and advances in the various areas of Big Data-quickly and with a high quality. The intent is to cover the theory, research, develo...

10/07/2020
Get Solution for free from DataCamp guru