在使用镜像网站PIP安装requirements.txt时报错

问题遇到的现象和发生背景

inflect==5.3.0
librosa==0.8.1
matplotlib==3.5.1
numpy==1.20.3
Pillow==8.4.0
PyQt5==5.15.6
scikit-learn==1.0.2
scipy==1.7.3
sounddevice==0.4.3
SoundFile==0.10.3.post1
tqdm==4.62.3
umap-learn==0.5.2
Unidecode==1.3.2
urllib3==1.26.7
visdom==0.1.8.9
webrtcvad==2.0.10
上为requirements.txt的内容,由于使用外网太慢无法安装,使用国内镜像网站,使用代码:
pip install -r requirements.txt -i https://pypi.tuna.tsinghua.edu.cn/simple superset和pip install -r requirements.txt -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com时均出现以下错误

运行结果及报错内容 Could not find a version that satisfies the requirement sip<7,>=6.4 (from versions: 4.19.7, 4.19.8, 5.0.0, 5.0.1, 5.1.0, 5.1.1, 5.1.2, 5.2.0, 5.3.0, 5.4.0, 5.5.0, 6.0.0, 6.0.1, 6.0.2, 6.0.3, 6.1.0, 6.1.1, 6.2.0)

No matching distribution found for sip<7,>=6.4

我的解答思路和尝试过的方法

我尝试单独安装此库,使用pip install sip==6.4 -i https://pypi.tuna.tsinghua.edu.cn/simple superset,但报错_*error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/_和Command "f:\python.exe -u -c "import setuptools, tokenize;file='C:\Users\Administrator\AppData\Local\Temp\pip-install-qn_9x_2a\sip\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record C:\Users\Administrator\AppData\Local\Temp\pip-record-cl2z6o85\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\Administrator\AppData\Local\Temp\pip-install-qn_9x_2a\sip\和resampy 0.2.2 requires numba>=0.32, which is not installed.*
resampy 0.2.2 requires numpy>=1.10, which is not installed.
resampy 0.2.2 requires scipy>=0.13, which is not installed.
resampy 0.2.2 requires six>=1.3, which is not installed.

我想要达到的结果

完成安装