Groups > linux.debian.maint.python > #14946

Updating python3-xlrd for pandas 1.5 compatibility

Path	csiph.com!fu-berlin.de!bofh.it!news.nic.it!robomod
From	Diane Trout <diane@ghic.org>
Newsgroups	linux.debian.devel, linux.debian.maint.python
Subject	Updating python3-xlrd for pandas 1.5 compatibility
Date	Thu, 23 Feb 2023 09:00:01 +0100
Message-ID	<G2e3v-7SrP-3@gated-at.bofh.it> (permalink)
X-Mailbox-Line	From debian-devel-request@lists.debian.org Thu Feb 23 07:51:34 2023
Old-Return-Path	<diane@ghic.org>
X-Amavis-Spam-Status	No, score=-6.563 tagged_above=-10000 required=5.3 tests=[BAYES_00=-2, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, LDO_WHITELIST=-5, SARE_MSGID_LONG40=0.637] autolearn=ham autolearn_force=no
X-Policyd-Weight	using cached result; rate: -4.6
X-Greylist	delayed 2339 seconds by postgrey-1.36 at bendel; Thu, 23 Feb 2023 07:51:14 UTC
Content-Type	text/plain; charset="UTF-8"
Content-Transfer-Encoding	quoted-printable
User-Agent	Evolution 3.46.3-1
MIME-Version	1.0
X-Mailing-List	<debian-devel@lists.debian.org> archive/latest/355147
List-ID	<debian-devel.lists.debian.org>
List-URL	<https://lists.debian.org/debian-devel/>
List-Archive	https://lists.debian.org/msgid-search/8c072ba8f40ea437f8e5b4eed85ce29cfa7d68d6.camel@ghic.org
Approved	robomod@news.nic.it
Lines	44
Organization	linux.* mail to news gateway
Sender	robomod@news.nic.it
X-Original-Cc	Debian Python <debian-python@lists.debian.org>
X-Original-Date	Wed, 22 Feb 2023 23:12:11 -0800
X-Original-Message-ID	<8c072ba8f40ea437f8e5b4eed85ce29cfa7d68d6.camel@ghic.org>
Xref	csiph.com linux.debian.devel:107295 linux.debian.maint.python:14946

Cross-posted to 2 groups.

Show key headers only | View raw

Hi,

the version of python3-xlrd 1.2.0-3 in unstable/testing is too old to
be used with pandas 1.5.3. (See Bug #1031701). As it is a really common
workflow to use pandas to read excel files, it'd be nice if the version
of xlrd in bookworm was compatible.

Because of the freeze I wanted to check if it was appropriate to upload
the new version, and what kind of warning I should give to the other
developers.

THe xlrd changelog says the biggest change in going from 1.2 to 2.0 was
they removed the ability to read the newer XML excel files .xslx from
xlrd in favor of using openpyxl

I updated the source package python-xlrd to 2.0.1 and sent it through
experimental, where there were no issues detected by packages that had
CI tests.

Unfortunately there's packages without tests.

Here's the list of packages I found that have any relationship to
python-xlrd, if it looked like the autopkgtests actually tested using
the xlrd library and what the level of declared dependency is. (none
means the package lacks autopackage tests)

| nemo                 | none     | Recommends    |
| odoo-14              | none     | Depends       |
| ofxstatement-plugins | none     | Depends       |
| psychopy             | unlikely | Depends       |
| python3-agateexcel   | yes      | Depends       |
| python3-canmatrix    | no       | Recommends    |
| python3-drslib       | no       | Recommends    |
| python3-glue         | yes      | Depends       |
| python3-pyspectral   | probably | Suggests      |
| python3-rows         | unlikely | Recommends    |
| python3-tablib       | unlikely | Depends       |
| visidata             | none     | Build-Depends |
| vistrails            | none     | Build-Depends |
| python-xrt           | none     | Build-Depends |
| pyutilib             | none     | Build-Depends |

Thanks
Diane

Back to linux.debian.maint.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Updating python3-xlrd for pandas 1.5 compatibility Diane Trout <diane@ghic.org> - 2023-02-23 09:00 +0100
  Re: Updating python3-xlrd for pandas 1.5 compatibility Martin <debacle@debian.org> - 2023-02-23 10:40 +0100
  Re: Updating python3-xlrd for pandas 1.5 compatibility Shengjing Zhu <zhsj@debian.org> - 2023-02-24 20:00 +0100
  Re: Updating python3-xlrd for pandas 1.5 compatibility Shengjing Zhu <zhsj@debian.org> - 2023-02-24 20:00 +0100
  Re: Updating python3-xlrd for pandas 1.5 compatibility Diane Trout <diane@ghic.org> - 2023-02-25 00:30 +0100

csiph-web