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

Python | Pandas Panel.floordiv ()



Pandas Panel.floordiv() uses a function to get integer division of a row and data frame / Panel.

Syntax: Panel.floordiv (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 ( "Integer Dividing panel [` b`] with df2 [`b`] using floordiv () method -" ) 

print ( "" , panel [ `b` ]. floordiv (df2 [ `b` ], axis = 0 )) 

Output: 

 panel [`b`] is - item1 item2 0 111 100 1 123 100 2 425 100 3 1333 100 Integer Dividing panel [` b`] with df2 [`b`] using floordiv () method - item1 item2 0 1 1 1 1 1 2 4 1 3 13 1

Code # 2:

# pandas module import

import pandas as pd 

import numpy as np 

  

df1 = pd .DataFrame ({ `a` : [ ` Geeks` , `For` , `geeks` , ` for` , `real` ], 

 < / code> `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 ( " Integer Dividing panel [`b`] with df2 using floordiv () method -" ) 

print (panel [ `b` ]. floordiv (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.346012 0.135318 1 0.850487 0.589151 2 0.074627 0.742770 3 0.296359 0.417620 4 0.216676 0.682704 Integer Dividing panel [`b`] with floord method - item1 item2 0 31 81 1 1 1 2 4462 448 3 386 274 4 6152 1952

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 ( "Integer Dividing panel [` b`] [`item1`] with df2 [` b`] or panel [`b`] [` item2`] using floordiv () method - " ) 

print ( " " , panel [ `b` ] [ `item1` ]. floordiv (df2 [ ` b` ], axis = 0 )) 

Exit:

 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 Integer Dividing panel [`b`] [` item1`] with df2 [`b`] or panel [`b`] [` item2`] using floordiv () method - 0 1 1 0 2 33 3 1 4 12 dtype: float64