Bug#1087640: python3-pandas: versions of python3-pandas and python3-xlrd not compatible

[Hugh Pumphrey]

Package: python3-pandas
Version: 1.5.3+dfsg-2
Severity: normal
X-Debbugs-Cc: Hugh.Pumphrey at gmail.com

Dear Maintainer,

This bug may or may not be a duplicate of #1017470 --- I am not sure. 

The bug may be triggered by a python script that includes the lines

import pandas as pd
df=pd.read_excel("blah.xls")

. . . where blah.xls is a valid file in the old Excel format. Note that

df=pd.read_excel("blah.xlsx") 

where blah.xlsx is a valid file in the current Excel format works fine. 

I reproduce the full error message below, but the critical line is

ImportError: Pandas requires version '2.0.1' or newer of 'xlrd' (version 
'1.2.0' currently installed).

So this is not really a bug in either python3-pandas or python3-xlrd; it is a
problem that Stable contains a version of xlrd which cannot be used 
by the version of pandas in Stable. 

Best wishes

Hugh Pumphrey


-- System Information:
Debian Release: 12.8
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.1.0-22-amd64 (SMP w/4 CPU threads; PREEMPT)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages python3-pandas depends on:
ii  python3                3.11.2-1+b1
ii  python3-dateutil       2.8.2-2
ii  python3-numpy          1:1.24.2-1+deb12u1
ii  python3-pandas-lib     1.5.3+dfsg-2
ii  python3-pkg-resources  66.1.1-1
ii  python3-six            1.16.0-4
ii  python3-tz             2022.7.1-4

Versions of packages python3-pandas recommends:
ii  python3-bottleneck  1.3.5+ds1-2+b1
ii  python3-bs4         4.11.2-2
ii  python3-html5lib    1.1-3
ii  python3-jinja2      3.1.2-1
ii  python3-lxml        4.9.2-1+b1
ii  python3-matplotlib  3.6.3-1+b1
ii  python3-numexpr     2.8.4-1+b2
ii  python3-odf         1.4.2-2
ii  python3-openpyxl    3.0.9-1
ii  python3-scipy       1.10.1-2
ii  python3-tables      3.7.0-5

Versions of packages python3-pandas suggests:
pn  python-pandas-doc    <none>
ii  python3-statsmodels  0.13.5+dfsg-7

-- no debconf information