Pandas uses Panel.radd()
to add a series and series / dataframe element by element. This is equivalent to another + panel.
Syntax: Panel.radd (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’ , ’ for’ , ’real’ ], ’b’ : [ 11 , 1.025 , 333 , 114.48 , 1333 ]}) data = { ’item1’ : df1, ’ item2’ : df1} # create a panel p anel = pd.Panel.from_dict (data, orient = ’minor’ ) print ( "panel [’ b’] is - " , panel [ ’ b’ ], ’’ ) print ( "Adding panel [’ b’] with df1 [’b ’] using radd () method -" ) print ( "" , panel [ ’b’ ]. radd (df1 [ ’b’ ], 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 Adding panel [’b’] with df1 [’ b’] using radd () method - item1 item2 0 22.00 22.00 1 2.05 2.05 2 666.00 666.00 3 228.96 228.96 4 2666.00 2666.00
Code # 2:
# import pandas module import pandas as pd import numpy as np df1 = pd.DataFrame ({ ’ a’ : [< / code> ’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 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 ( "Adding panel [’ b’] with df2 using radd () method - " ) print (panel [ ’b’ ]. radd (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 datafram e with random values is - item1 item2 0 0.584980 0.504366 1 0.730408 0.259226 2 0.255814 0.825562 3 0.459585 0.052188 4 0.197732 0.551450 Adding panel [’b’] with df2 using radd () method - item1 item2 0 11.584980 11.504366 1 1.755408 1.2.855 114.939585 114.532188 4 1333.197732 1333.551450
Code # 3:
# pandas module import import pandas as pd import numpy as np df1 = pd.DataFrame ({ ’a’ : [ ’ Geeks’ , ’For’ , ’geeks’ , ’ real’ ], ’b’ : [ - 11 , + 1.025 , - 114.48 , 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 ( "Adding panel [’ b’] with df2 [’b’] using radd () method -" ) print ( "" , panel [ ’b’ ]. radd (df2 [ ’b’ ], axis = 0 )) |
Output:
panel [’b’] is - item1 item2 0 -11.000 100 1 1.025 100 2 -114.480 100 3 1333.000 100 Adding panel [’ b’] with df2 [’b ’] using rad d () method - item1 item2 0 89.000 200 1 101.025 200 2 -14.480 200 3 1433.000 200