Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Pandas DataFrame floordiv() Method

❮ DataFrame Reference


Example

Divide each value in the DataFrame with 10, and return the integer (with no decimals):

import pandas as pd

data = {
  "points": [100, 120, 114],
  "total": [350, 340, 402]
}

df = pd.DataFrame(data)

print(df.floordiv(10))
Try it Yourself »

Definition and Usage

The floordiv() method divides each value in the DataFrame with a specified value, and returns the integer (removes any decimals).

The specified value must be an object that can be divided with the values of the DataFrame. It can be a constant number like the one in the example, or it can be a list-like object like a list [10, 20] or a tuple {"points": 10, "total": 20}, or a  Pandas Series or another DataFrame, that fits with the original DataFrame.


Syntax

dataframe.floordiv(other, axis, level, fill_value)

Parameters

Parameter Description
other Required. A number, list of numbers, or another object with a data structure that fits with the original DataFrame.
axis Optional, A definition that decides whether to compare by index or columns.
0 or 'index' means compare by index.
1 or 'columns' means compare by columns
level Optional. A number or label that indicates where to compare.
fill_value Optional. A number, or None. Specifies what to do with NaN values before dividing.

Return Value

A DataFrame with all integers.


❮ DataFrame Reference