How to rounds a given number up to the nearest specified multiple using Pandas?

Question

May I know if there exist build-in Pandas module to rounds a given number up to the nearest specified multiple.

In excel this can be achieved using Ceiling function.

Say given a df of -0.4, 0.5,1.5, then round this to a multiple of 1 will result in 0,1,and 2.

While I have comb the net about this topic, but I dont see any reference about it. Please let me know if this is a duplicate.

Other might suggest something like here but its not a built in Pandas

`np.ceil(df)` or `np.ceil(serie)` – ansev Oct 14 '20 at 08:02 — ansev, Oct 14 '20 at 08:02

nocibambi · Accepted Answer · 2020-10-14T08:15:39.350

1

Maybe this?

> import math as m
> [m.ceil(n) for n in [-0.4, 0.5, 1.5]]
[0, 1, 2]

With dataframe

> import pandas as pd
> df = pd.DataFrame([-0.4, 0.5, 1.5], columns=['numbers'])
> df.apply(m.ceil, axis=1)
0    0
1    1
2    2
dtype: int64

Then without apply

> import numpy as np
> np.ceil(df['numbers'])
0   -0.0
1    1.0
2    2.0
Name: numbers, dtype: float64

Actually, you can also get a similar result only with operations.

> df // 1 + 1
    numbers
0   0.0
1   1.0
2   2.0

edited Oct 14 '20 at 08:15

answered Oct 14 '20 at 07:59

nocibambi

Thanks for the suggestion, but the OP present the data in term of dataframe. – mpx Oct 14 '20 at 08:01
2

https://stackoverflow.com/questions/54432583/when-should-i-ever-want-to-use-pandas-apply-in-my-code – ansev Oct 14 '20 at 08:03
It seems external module is still require then. – mpx Oct 14 '20 at 08:08
1

@balandongiv, maybe not, I added one without external modules. – nocibambi Oct 14 '20 at 08:15
plus one for that, maybe that answered why there is no built in function for this. – mpx Oct 14 '20 at 08:18

score 1 · Answer 2 · answered Oct 14 '20 at 08:05

1

I think this was answere here, not specifically with pandas, but with numpy, although I think this is the behavior you are looking for.

answered Oct 14 '20 at 08:05

sumnuz

2 Answers2