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 overReturns: Panel
Code # 1:
|
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:
|
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:
|
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