Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

BUG: round not functioning as expected #55114

Copy link
Copy link
Open
@galipremsagar

Description

@galipremsagar
Issue body actions

Pandas version checks

  • I have checked that this issue has not already been reported.

  • I have confirmed this bug exists on the latest version of pandas.

  • I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

In [2]: import pandas as pd
In [3]: pd.__version__
Out[3]: '2.1.0'
In [4]: import decimal
In [6]: import numpy as np
In [7]: pdf = pd.DataFrame(
   ...:         {
   ...:             "a": [1.2234242333234, 323432.3243423, np.nan],
   ...:             "b": ["a", "b", "c"],
   ...:             "c": pd.Series([34224, 324324, 324342], dtype="datetime64[ns]"),
   ...:             "d": pd.Series([224.242, None, 2424.234324], dtype="category"),
   ...:             "e": [
   ...:                 decimal.Decimal("342.3243234234242"),
   ...:                 decimal.Decimal("89.32432497687622"),
   ...:                 None,
   ...:             ],
   ...:         }
   ...:     )
In [8]: round(pdf, 2)
Out[8]: 
           a  b                             c            d                  e
0       1.22  a 1970-01-01 00:00:00.000034224   224.242000  342.3243234234242
1  323432.32  b 1970-01-01 00:00:00.000324324          NaN  89.32432497687622
2        NaN  c 1970-01-01 00:00:00.000324342  2424.234324               None
In [9]: round(pdf.a, 2)
Out[9]: 
0         1.22
1    323432.32
2          NaN
Name: a, dtype: float64
In [10]: round(pdf.b, 2)
Traceback (most recent call last):
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/IPython/core/interactiveshell.py", line 3378, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-10-9c75601ee514>", line 1, in <module>
    round(pdf.b, 2)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/generic.py", line 1663, in __round__
    return self.round(decimals).__finalize__(self, method="__round__")
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/series.py", line 2688, in round
    result = self._values.round(decimals)
TypeError: can't multiply sequence by non-int of type 'float'
In [11]: round(pdf.c, 2)
Traceback (most recent call last):
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/IPython/core/interactiveshell.py", line 3378, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-11-6d1f4094de81>", line 1, in <module>
    round(pdf.c, 2)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/generic.py", line 1663, in __round__
    return self.round(decimals).__finalize__(self, method="__round__")
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/series.py", line 2688, in round
    result = self._values.round(decimals)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/arrays/datetimelike.py", line 2140, in round
    return self._round(freq, RoundTo.NEAREST_HALF_EVEN, ambiguous, nonexistent)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/arrays/datetimelike.py", line 2122, in _round
    offset = to_offset(freq)
  File "offsets.pyx", line 4460, in pandas._libs.tslibs.offsets.to_offset
  File "offsets.pyx", line 4562, in pandas._libs.tslibs.offsets.to_offset
ValueError: Invalid frequency: 2
In [12]: round(pdf.d, 2)
Traceback (most recent call last):
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/IPython/core/interactiveshell.py", line 3378, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-12-9fba030eaf35>", line 1, in <module>
    round(pdf.d, 2)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/generic.py", line 1663, in __round__
    return self.round(decimals).__finalize__(self, method="__round__")
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/series.py", line 2688, in round
    result = self._values.round(decimals)
AttributeError: 'Categorical' object has no attribute 'round'
In [13]: round(pdf.e, 2)
Traceback (most recent call last):
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/IPython/core/interactiveshell.py", line 3378, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-13-d91def30b1e6>", line 1, in <module>
    round(pdf.e, 2)
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/generic.py", line 1663, in __round__
    return self.round(decimals).__finalize__(self, method="__round__")
  File "/Users/pgali/PycharmProjects/pythonProject/venv/lib/python3.10/site-packages/pandas/core/series.py", line 2688, in round
    result = self._values.round(decimals)
TypeError: unsupported operand type(s) for *: 'decimal.Decimal' and 'float'


In [4]: round(decimal.Decimal("23234.323224"), 2)
Out[4]: Decimal('23234.32')

Issue Description

  1. Looks like DataFrame.round is able to ignore errors and return the existing columns if rounding isn't possible, but Series.round is throwing errors, would it be possible to do the same incase of Series too?
  2. rounding on decimals doesn't seem to happen both incase of Series & DataFrame

Expected Behavior

  1. Consistent behavior with Series.round & DataFrame.round.
  2. The rounding of decimals work should work as shown above.

Installed Versions

INSTALLED VERSIONS

commit : ba1cccd
python : 3.10.2.final.0
python-bits : 64
OS : Darwin
OS-release : 22.6.0
Version : Darwin Kernel Version 22.6.0: Wed Jul 5 22:22:05 PDT 2023; root:xnu-8796.141.3~6/RELEASE_ARM64_T6000
machine : arm64
processor : arm
byteorder : little
LC_ALL : None
LANG : None
LOCALE : en_US.UTF-8
pandas : 2.1.0
numpy : 1.23.2
pytz : 2022.2.1
dateutil : 2.8.2
setuptools : 60.2.0
pip : 21.3.1
Cython : None
pytest : None
hypothesis : None
sphinx : None
blosc : None
feather : None
xlsxwriter : None
lxml.etree : None
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : None
IPython : 8.5.0
pandas_datareader : None
bs4 : None
bottleneck : None
dataframe-api-compat: None
fastparquet : None
fsspec : None
gcsfs : None
matplotlib : None
numba : None
numexpr : 2.8.4
odfpy : None
openpyxl : None
pandas_gbq : None
pyarrow : 11.0.0
pyreadstat : None
pyxlsb : None
s3fs : None
scipy : None
sqlalchemy : None
tables : None
tabulate : None
xarray : None
xlrd : None
zstandard : None
tzdata : 2023.3
qtpy : None
pyqt5 : None

Metadata

Metadata

Assignees

Labels

BugDataFrameDataFrame data structureDataFrame data structure

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.