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.

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

Reproducible Example

df = pd.read_excel(r'C:\Users\ryjfgjl\Desktop\汽车计提1-2月明细(1).xlsx', sheet_name=3, na_filter=False, engine='calamine', dtype=object)
print(df)

Issue Description

Excel data Image

df: Image

Expected Behavior

change engine to openpyxl is correct

Image

Installed Versions

2.2.3

Comment From: asishm

Thanks for the report. Are you able to share the excel file (preferably without the vlookups) or code to generate the excel file?

Comment From: ryjfgjl

import pandas as pd

file = r'C:\Users\ryjfgjl\Desktop\test.xlsx' df_without_vlookup = pd.read_excel(file, engine='calamine', sheet_name='Sheet1', dtype=object) print(df_without_vlookup) df_with_vlookup = pd.read_excel(file, engine='calamine', sheet_name='Sheet2', dtype=object) print(df_with_vlookup)

test.xlsx

Comment From: dimastbk

Hi. It has been fixed in upstream tafia/calamine#472, but it hasn't been released yet.

UPD: Should be fixed in https://github.com/dimastbk/python-calamine/releases/tag/v0.3.2.

Comment From: chilin0525

@dimastbk You're right — the bug was resolved in version 0.3.2.

  • 0.3.1: python id code 0 1 05291912 1 2 05291913 2 3 05291914 3 4 05291915 id code 0 1 5291912 1 2 5291913 2 3 5291914
  • 0.3.2 python id code 0 1 05291912 1 2 05291913 2 3 05291914 3 4 05291915 id code 0 1 05291912 1 2 05291913 2 3 05291914

Comment From: chilin0525

take

Comment From: datapythonista

Sorry we didn't have this discussion earlier @chilin0525, but seems like we don't want to fix this, as it involves not allowing users to install a version we wish to support.