search
Search
Login
Unlock 100+ guides
menu
menu
web
search toc
close
Comments
Log in or sign up
Cancel
Post
account_circle
Profile
exit_to_app
Sign out
What does this mean?
Why is this true?
Give me some examples!
search
keyboard_voice
close
Searching Tips
Search for a recipe:
"Creating a table in MySQL"
Search for an API documentation: "@append"
Search for code: "!dataframe"
Apply a tag filter: "#python"
Useful Shortcuts
/ to open search panel
Esc to close search panel
to navigate between search results
d to clear all current filters
Enter to expand content preview
icon_star
Doc Search
icon_star
Code Search Beta
SORRY NOTHING FOUND!
mic
Start speaking...
Voice search is only supported in Safari and Chrome.
Navigate to

Pandas DataFrame | floordiv method

schedule Aug 10, 2023
Last updated
local_offer
PythonPandas
Tags
mode_heat
Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

Pandas DataFrame.floordiv(~) method divides the values in the source DataFrame by a scalar, sequence, Series or DataFrame via integer division, that is:

DataFrame // other
NOTE

Unless you use the parameters axis, level and fill_value, the floordiv(~) is equivalent to performing division using the // operator.

Parameters

1. otherlink | scalar or sequence or Series or DataFrame

The resulting DataFrame will be the source DataFrame divided by other via integer division.

2. axislink | int or string | optional

Whether to broadcast other for each column or row of the source DataFrame:

Axis

Description

"index" or 0

other is broadcasted for each column.

"columns" or 1

other is broadcasted for each row.

Note that this is only relevant if the shape of the source DataFrame and that of other does not match up. By default, axis=1.

3. level | int or string | optional

The name or the integer index of the level to consider. This is relevant only if your DataFrame is Multi-index.

4. fill_valuelink | float or None | optional

The value to replace NaN before the computation. Note that if both pair of entries are NaN, then the result would still be NaN. By default, fill_value=None.

Return Value

A new DataFrame resulting from integer division.

Examples

Basic usage

Consider the following DataFrame:

df = pd.DataFrame({"A":[5,6], "B":[7,8]})
df_other = pd.DataFrame({"A":[1,2], "B":[3,4]})
A B | A B
0 5 7 | 0 1 3
1 6 8 | 1 2 4

Performing integer division:

df.floordiv(df_other)
A B
0 5 2
1 3 2

Here, we're performing the following element-wise floor division:

5//1 7//3
6//2 8//4

Note that this is equivalent to:

df // df_other
A B
0 5 2
1 3 2

Broadcasting

Consider the following DataFrame:

df = pd.DataFrame({"A":[3,4], "B":[5,6]})
df
A B
0 3 5
1 4 6

Row-wise integer division

By default, axis=1, which means that other will be broadcasted for each row in df:

df.floordiv([1,2]) # axis=1
A B
0 3 2
1 4 3

Here, we're doing the following element-wise integer division:

3//1 5//2
4//1 6//2

Column-wise integer division

To broadcast other for each column in df, set axis=0 like so:

df.floordiv([1,2], axis=0)
A B
0 3 5
1 2 3

Here, we're doing the following element-wise division:

3//1 5//1
4//2 6//2

Specifying fill_value

Consider the following DataFrames:

df = pd.DataFrame({"A":[6,np.NaN], "B":[np.NaN,7]})
df_other = pd.DataFrame({"A":[2,3], "B":[np.NaN,np.NaN]})
A B | A B
0 6.0 NaN | 0 2 NaN
1 NaN 7.0 | 1 3 NaN

By default, when we perform integer division using floordiv(~), any operation with NaN results in NaN:

df.floordiv(df_other)
A B
0 3.0 NaN
1 NaN NaN

We can fill the NaN values before we perform integer division by using the fill_value parameter:

df.floordiv(df_other, fill_value=1)
A B
0 3.0 NaN
1 0.0 7.0

Notice how if the integer division is between two NaN, then the result would always be NaN regardless of fill_value.

robocat
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!