Skip to content

BUG: Weird Behavior of astype(bool) for np.nan #48052

Open
@redreamality

Description

@redreamality

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

import pandas as pd
import numpy as np

print(pd.DataFrame([np.nan,0,1,[],None]).astype(bool))

Issue Description

   0

0 True
1 False
2 True
3 False
4 False

Expected Behavior

   0

0 False
1 True
2 True
3 False
4 False

Installed Versions

>>> pd.__version__ '1.4.2' >>> pd.show_versions() C:\tools\Anaconda3\lib\site-packages\_distutils_hack\__init__.py:17: UserWarning: Distutils was imported before Setuptools, but importing Setuptools also replaces the `distutils` module in `sys.modules`. This may lead to undesirable behaviors or errors. To avoid these issues, avoid using distutils directly, ensure that setuptools is installed in the traditional way (e.g. not an editable install), and/or make sure that setuptools is always imported before distutils. warnings.warn( C:\tools\Anaconda3\lib\site-packages\_distutils_hack\__init__.py:30: UserWarning: Setuptools is replacing distutils. warnings.warn("Setuptools is replacing distutils.") Traceback (most recent call last): File "", line 1, in File "C:\tools\Anaconda3\lib\site-packages\pandas\util\_print_versions.py", line 109, in show_versions deps = _get_dependency_info() File "C:\tools\Anaconda3\lib\site-packages\pandas\util\_print_versions.py", line 88, in _get_dependency_info mod = import_optional_dependency(modname, errors="ignore") File "C:\tools\Anaconda3\lib\site-packages\pandas\compat\_optional.py", line 138, in import_optional_dependency module = importlib.import_module(name) File "C:\tools\Anaconda3\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "", line 1030, in _gcd_import File "", line 1007, in _find_and_load File "", line 986, in _find_and_load_unlocked File "", line 680, in _load_unlocked File "", line 850, in exec_module File "", line 228, in _call_with_frames_removed File "C:\tools\Anaconda3\lib\site-packages\setuptools\__init__.py", line 8, in import _distutils_hack.override # noqa: F401 File "C:\tools\Anaconda3\lib\site-packages\_distutils_hack\override.py", line 1, in __import__('_distutils_hack').do_override() File "C:\tools\Anaconda3\lib\site-packages\_distutils_hack\__init__.py", line 72, in do_override ensure_local_distutils() File "C:\tools\Anaconda3\lib\site-packages\_distutils_hack\__init__.py", line 59, in ensure_local_distutils assert '_distutils' in core.__file__, core.__file__ AssertionError: C:\tools\Anaconda3\lib\distutils\core.py

Metadata

Metadata

Assignees

No one assigned

    Labels

    Missing-datanp.nan, pd.NaT, pd.NA, dropna, isnull, interpolateUpstream issueIssue related to pandas dependency

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions