Change language

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 

Shop

Gifts for programmers

Learn programming in R: courses

$FREE
Gifts for programmers

Best Python online courses for 2022

$FREE
Gifts for programmers

Best laptop for Fortnite

$399+
Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best computer for crypto mining

$499+
Gifts for programmers

Best laptop for Sims 4

$

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

1947 answers

PythonStackOverflow

Check if one list is a subset of another in Python

1173 answers

PythonStackOverflow

How to specify multiple return types using type-hints

1002 answers

PythonStackOverflow

Printing words vertically in Python

909 answers

PythonStackOverflow

Python Extract words from a given string

798 answers

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

606 answers

PythonStackOverflow

Python os.path.join () method

384 answers

PythonStackOverflow

Flake8: Ignore specific warning for entire file

360 answers

News


Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically