Python Pandas Series floordiv() Function

Pandas Series floordiv() Function:

The floordiv() method of the Pandas module returns element-by-element integer division of series and other. It’s the same as series / /other, except with the ability to provide a fill_value as one of the parameters to replace missing data.

Syntax:

Series.floordiv(other, level=None, fill_value=None)

Parameters

other: This is required. It indicates a Series or a scalar value.

level: This is optional. To broadcast over a level, specify an int or a name that matches the Index values on the passed MultiIndex level. The type of this may be int or name. None is the default value.

fill_value: This is optional. It indicates a value to fill in any current missing (NaN) values, as well as any new elements required for successful Series alignment. The result will be missing if data is missing in both corresponding Series locations. The type of this may be float or None. None is the default value.

Return Value:

The result of the arithmetic operation is returned.

Pandas Series floordiv() Function in Python

Example1

Approach:

  • Import pandas module using the import keyword.
  • Pass some random list as an argument to the Series() function of the pandas module to create a series.
  • Store it in a variable.
  • Print the above-given series
  • Apply floordiv() function on all the elements of the given series by passing some random number to it and print the result.
  • Here it floor divides all the elements of the given series by 5.
  • The Exit of the Program.

Below is the implementation:

# Import pandas module using the import keyword.
import pandas as pd
# Pass some random list as an argument to the Series() function
# of the pandas module to create a series.
# Store it in a variable.
gvn_series = pd.Series([12, 25, 34, 45, 82])
# Print the above given series
print("The given series is:")
print(gvn_series)
print()
# Apply floordiv() function on all the elements of the given series
# by pasing some random number to it and print the result.
# Here it floor divides all the elements of the given series by 5
print("Floor dividing all the elements of the given series by 5:")
print(gvn_series.floordiv(5))

Output:

The given series is:
0    12
1    25
2    34
3    45
4    82
dtype: int64

Floor dividing all the elements of the given series by 5:
0     2
1     5
2     6
3     9
4    16
dtype: int64

Example2

Here, we floor divide one series with the other series.

Approach:

  • Import pandas module using the import keyword.
  • Import numpy module using the import keyword.
  • Pass some random list, index values as the arguments to the Series() function of the pandas module to create a series.
  • Store it in a variable.
  • Similarly, Pass some random list, index values as the arguments to the Series() function of the pandas module to create another series.
  • Store it in another variable.
  • Print the above first given series
  • Print the above second given series
  • Pass the given second series and fill_value as some random number as the arguments to the floordiv() function and apply it to the first series.
  • Here, each element of the first series will get floor divided by the corresponding element of the second series by filling NaN values with the given fill_value.
  • The Exit of the Program.

Below is the implementation:

# Import pandas module using the import keyword.
import pandas as pd
# Import numpy module using the import keyword.
import numpy as np
# Pass some random list, index values as the arguments to the 
# Series() function of the pandas module to create a series.
# Store it in a variable.
gvn_series1 = pd.Series([24, 23, 32, np.NaN], 
              index=['P', 'Q', 'R', 'S'])
# Similarly, Pass some random list, index values as the arguments to the 
# Series() function of the pandas module to create another series.
# Store it in another variable.
gvn_series2 = pd.Series([5, 6, np.NaN, 2], 
              index=['P', 'Q', 'R', 'S'])
# Print the above first given series
print("The given first series is:")
print(gvn_series1)
print()
# Print the above second given series
print("The given second series is:")
print(gvn_series2)
print()
# Pass the given second series and fill_value as some random number as the 
# arguments to the floordiv() function and apply it to the first series.
# Here, each element of first series will get floor divided by the corresponding element
# of the second series by filling NaN values with the given fill_value
print("Floor Dividing first series by corresponding elements of second with filling NaN values:")
print(gvn_series1.floordiv(gvn_series2, fill_value=10))

Output:

The given first series is:
P    24.0
Q    23.0
R    32.0
S     NaN
dtype: float64

The given second series is:
P    5.0
Q    6.0
R    NaN
S    2.0
dtype: float64

Floor Dividing first series by corresponding elements of second with filling NaN values:
P    4.0
Q    3.0
R    3.0
S    5.0
dtype: float64

Example3

Approach:

  • Import pandas module using the import keyword.
  • Pass some random key-value pair(dictionary) as arguments to the DataFrame() function of the pandas module to create a dataframe.
  • Store it in a variable.
  • Print the given dataframe
  • Floor Divide the column gvn_list1 by gvn_list2 using the floordiv() function and store it as a new column in the dataframe.
  • Print the dataframe after adding a new column(gvn_list1//gvn_list2).
  • The Exit of the Program.

Below is the implementation:

# Import pandas module using the import keyword.
import pandas as pd
# Pass some random key-value pair(dictionary) as arguments to the 
# DataFrame() function of the pandas module to create a dataframe
# Store it in a variable.
data_frme  = pd.DataFrame({
  "gvn_list1": [45, 24, 54, 90],
  "gvn_list2": [5, 7, 6, 4]
})
# Print the given dataframe
print("The given Dataframe:")
print(data_frme)
print()

# Floor Divide the column gvn_list1 by gvn_list2 using the floordiv() 
# function and store it as a new column in the dataframe.
data_frme ['gvn_list1//gvn_list2'] = data_frme ['gvn_list1'].floordiv(data_frme ['gvn_list2'])
# Print the dataframe after adding a new column(gvn_list1//gvn_list2)
print("The dataframe after adding a new column(gvn_list1//gvn_list2):")
print(data_frme )

Output:

The given Dataframe:
   gvn_list1  gvn_list2
0         45          5
1         24          7
2         54          6
3         90          4

The dataframe after adding a new column(gvn_list1//gvn_list2):
   gvn_list1  gvn_list2  gvn_list1//gvn_list2
0         45          5                     9
1         24          7                     3
2         54          6                     9
3         90          4                    22