Pandas version checks

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

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

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

Reproducible Example

import pandas as pd
df = pd.DataFrame([[1], [None]], dtype="Int64")
df.style.background_gradient()._compute()

Issue Description

style.background_gradient() fails on nullable series (ex: Int64) with null values and raises the following exception:

ValueError: cannot convert to '<class 'float'>'-dtype NumPy array with missing values. Specify an appropriate 'na_value' for this dtype.

It appears this originates in pandas.io.formats.style._background_gradient() due to the call to gmap = data.to_numpy(dtype=float) not providing a na_value

Expected Behavior

No exception is raised

Installed Versions

INSTALLED VERSIONS

commit : 8dab54d6573f7186ff0c3b6364d5e4dd635ff3e7 python : 3.9.9.final.0 python-bits : 64 OS : Darwin OS-release : 22.2.0 Version : Darwin Kernel Version 22.2.0: Fri Nov 11 02:03:51 PST 2022; root:xnu-8792.61.2~4/RELEASE_ARM64_T6000 machine : arm64 processor : arm byteorder : little LC_ALL : None LANG : en_CA.UTF-8 LOCALE : en_CA.UTF-8

pandas : 1.5.2 numpy : 1.22.1 pytz : 2022.7 dateutil : 2.8.2 setuptools : 65.7.0 pip : 22.1.1 Cython : None pytest : 7.2.0 hypothesis : None sphinx : None blosc : None feather : None xlsxwriter : None lxml.etree : None html5lib : None pymysql : None psycopg2 : 2.9.5 jinja2 : 3.1.2 IPython : 8.8.0 pandas_datareader: None bs4 : 4.11.1 bottleneck : None brotli : None fastparquet : 0.8.3 fsspec : 2022.11.0 gcsfs : 2022.11.0 matplotlib : 3.6.3 numba : None numexpr : None odfpy : None openpyxl : None pandas_gbq : None pyarrow : 10.0.1 pyreadstat : None pyxlsb : None s3fs : None scipy : 1.7.3 snappy : None sqlalchemy : 1.3.24 tables : None tabulate : 0.9.0 xarray : 2022.12.0 xlrd : None xlwt : None zstandard : None tzdata : None

0

Created https://github.com/pandas-dev/pandas/pull/50713 to fix this

0
© 2022 pullanswer.com - All rights reserved.