Python | Pandas Panel.add ()

Michael Zippo 18.07.2021

In pandas Panel.add() function is used for elementwise addition of rows and rows / dataframe.

Syntax: Panel.add (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

panel = pd.Panel.from_dict (data, orient = ’minor’ )

print ( "panel [’ b’] is - " , panel [ ’b’ ], ’ ’ )

print ( " Adding panel [’b’] with df1 [’ b’] using add () method - " )

print ( "" , panel [ ’b’ ]. add (df1 [ ’b’ ], axis = 0 ))

Output:

Code # 2:

       # import pandas module  
   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   (   "Adding panel [’ b’] with df2 using add () method - " )  
   print   (panel [  ’b’  ]. add (df2, axis   =   0  ) )

Output:

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 add () method -" )

print ( "" , panel [ ’b’ ]. add (df2 [ ’ b’ ], axis = 0 ))

Output:

Shop

Learn programming in R: courses

$FREE

Best Python online courses for 2022

$FREE

Best laptop for Fortnite

$399+

Best laptop for Excel

Best laptop for Solidworks

$399+

Best laptop for Roblox

$399+

Best computer for crypto mining

$499+

Best laptop for Sims 4

Python | Pandas Panel.add ()

Shop

News

Wiki