问题报错：
报错：DataProcess git:(main) ✗ /usr/local/bin/python3 /Users/shishuming/Downloads/EY/DataProcess
/merge_tables.py
Traceback (most recent call last):
File "/Users/shishuming/Downloads/EY/DataProcess/merge_tables.py", line 4, in <module>
orders = pd.read_excel('2024 EY Forensic Data Analytics Case Study_Data.xlsx', sheet_name='商户订单')
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/util/_decorators.py", line 211, in wrapper
return func(*args, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/util/_decorators.py", line 331, in wrapper
return func(*args, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/io/excel/_base.py", line 482, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/io/excel/_base.py", line 1695, in __init__
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/io/excel/_openpyxl.py", line 556, in __init__
import_optional_dependency("openpyxl")
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/pandas/compat/_optional.py", line 171, in import_optional_dependency
raise ImportError(msg)
ImportError: Pandas requires version '3.0.7' or newer of 'openpyxl' (version '2.6.4' currently installed).
➜
报错信息表明您需要更新 `openpyxl` 库，因为 Pandas 依赖它来处理 Excel 文件。
解决步骤：
1. 更新 `openpyxl`：
运行以下命令，更新 `openpyxl` 至最新版本：
```bash
pip install --upgrade openpyxl
```
2. **验证更新是否成功：**
在终端中运行以下命令，检查 `openpyxl` 的版本：
```bash
pip show openpyxl
```
确保版本号为 `3.0.7` 或更高。
3. **重新运行脚本：**
再次运行 `merge_tables.py`，如果 `openpyxl` 已更新，问题应该会解决。
---
可能的其他问题：
- 如果仍然有问题，检查是否有多个 Python 版本，确保您更新的是脚本运行时所用的 Python 的环境。
- 使用如下命令查看当前 Python 版本对应的 `pip`：
```bash
/usr/local/bin/python3 -m pip install --upgrade openpyxl
```
