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

Python | Pandas Panel.add ()



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: