双层帐篷 - Coleman OnePush Shelter M 2232951

import pandas as pd

excel_path = 'Tarif_pièces_détachées_2026_jusqu_a_ligne_371_FR.xlsx'
df_raw = pd.read_excel(excel_path)

# 在参考编号或产品描述列中查找包含 2232951 或相近字符串的所有匹配项
match = df_raw[df_raw.iloc[:, 0].astype(str).str.contains('2232951', na=False) | df_raw.iloc[:, 1].astype(str).str.contains('2232951', na=False)]
print("匹配项 2232951：")
print(match)

# 如果没有直接结果，则列出 2232917 附近的行（第 25 至 35 行）
print("\n文件中的相邻行：")
print(df_raw.iloc[24:35, :3])

匹配项 2232951:
   Unnamed: 0                       Unnamed: 1     Unnamed: 2 Unnamed: 3     361 Unnamed: 5 Unnamed: 6
29    2232951  DOUBLE TOIT - ONEPUSH SHELTER M  3138522138172        1.3  61.152    122.304        123

文件中的相邻行：
   Unnamed: 0                                    Unnamed: 1     Unnamed: 2
24    2232820               DOUBLE TOIT - ONEPUSH SHELTER L  3138522138165
25    2232914                DOUBLE TOIT - DARWIN 2 PLUS BO  3138522138110
26    2232915            DOUBLE TOIT - DARWIN SUMMER 3 PLUS  3138522138127
27    2232916                 DOUBLE TOIT - DARWIN SUMMER 3  3138522138134
28    2232917            DOUBLE TOIT - DARWIN SUMMER 4 PLUS  3138522138141
29    2232951               DOUBLE TOIT - ONEPUSH SHELTER M  3138522138172
30    2232952          ARMATURE DE TOIT - ONEPUSH SHELTER L  3138522138189
31    2232956  ARMATURE DE TOIT - ONEPUSH SH+B33:H62ELTER M  3138522138226
32    2232984               DOUBLE TOIT - VESPUCCI 6 - 2026  3138522138240
33    2232985               DOUBLE TOIT - VESPUCCI 4 - 2026  3138522138257
34    2232986                   ARCEAUX - VESPUCCI 6 - 2026  3138522138264