Pandas在PyQt中的应用 ----PyQt5快速开发与实战page455

Pandas在PyQt中的应用 ----PyQt5快速开发与实战page455

pip install pandas
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pandas
pip install qtpandas
pip install pandas -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

pip install pandas -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

pip install pandas -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com
pip install matplotlib -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

pip install pyqtgraph -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

pip install plotly -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

Looking in indexes: http://pypi.douban.com/simple/
Collecting matplotlib
  Downloading http://pypi.doubanio.com/packages/b4/4d/8a2c06cb69935bb762738a8b9d5f8ce2a66be5a1410787839b71e146f000/matplotlib-3.2.1-cp37-cp37m-win_amd64.whl (9.2 MB)
     |████████████████████████████████| 9.2 MB 1.1 MB/s
Requirement already satisfied: numpy>=1.11 in d:\python_env\py372_64_env\lib\site-packages (from matplotlib) (1.18.4)
Requirement already satisfied: python-dateutil>=2.1 in d:\python_env\py372_64_env\lib\site-packages (from matplotlib) (2.8.1)
Collecting kiwisolver>=1.0.1
  Downloading http://pypi.doubanio.com/packages/7e/e5/d8bd2d063da3b6761270f29038d2bb9785c88ff385009bf61589cde6e6ef/kiwisolver-1.2.0-cp37-none-win_amd64.whl (57 kB)
     |████████████████████████████████| 57 kB 647 kB/s
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in d:\python_env\py372_64_env\lib\site-packages (from matplotlib) (2.4.7)
Collecting cycler>=0.10
  Downloading http://pypi.doubanio.com/packages/f7/d2/e07d3ebb2bd7af696440ce7e754c59dd546ffe1bbe732c8ab68b9c834e61/cycler-0.10.0-py2.py3-none-any.whl (6.5 kB)
Requirement already satisfied: six>=1.5 in d:\python_env\py372_64_env\lib\site-packages (from python-dateutil>=2.1->matplotlib) (1.14.0)
Installing collected packages: kiwisolver, cycler, matplotlib
Successfully installed cycler-0.10.0 kiwisolver-1.2.0 matplotlib-3.2.1

pip更新指令:
python -m pip install --upgrade pip

输入运行后如果出现错误 “no module named pip”, 则运行以下指令:
python -m ensurepip
easy_install pip

easy_install 和 pip 都是用来管理、下载安装公共资源库pypi的相关资源包,pip是easy_install的改进版

Successfully built pandas python-magic
Installing collected packages: pandas, wcwidth, py, pluggy, atomicwrites, attrs, more-itertools, pyparsing, packaging, pytest, coverage, pytest-cov, easygui, python-magi
c, pytest-qt, qtpandas
  Attempting uninstall: pandas
    Found existing installation: pandas 1.0.3
    Uninstalling pandas-1.0.3:
      Successfully uninstalled pandas-1.0.3
Successfully installed 
atomicwrites-1.4.0 
attrs-19.3.0 
coverage-5.1 
easygui-0.98.1 
more-itertools-8.2.0 
packaging-20.3 
pandas-0.17.1 
pluggy-0.13.1 
py-1.8.1 
pyparsing-2.4.7 
pytest-5.4.2 
pytest-cov-2.8.1 
pytest-qt-1.2.2 
python-magic-0.4.6 
qtpandas-1.0.3 
wcwidth-0.1.9

而1.03只能用于pyqt4，不能用于pyqt5，而我需要的是能支持pyqt5的库。

实际上qtpands最新版1.04已经开始支持pyqt5，只是没有放到pip的安装公网镜像上，不过在GitHub上有最新版的qtpands。

于是我就用git命令在GitHub上克隆最新版本的qtpandas（1.04版本）

git clone https://github.com/draperjames/qtpandas.git

Utilities to use pandas (the data analysis/manipulation library for Python) with Qt.

pip install pandas -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com

Looking in indexes: http://pypi.douban.com/simple/
Collecting pandas
  Downloading http://pypi.doubanio.com/packages/69/69/c35fbbc9bec374c44e9c800e491e914a521dc3926fc6cee80d4821771295/pandas-1.0.3-cp37-cp37m-win_amd64.whl (8.7 MB)
     |████████████████████████████████| 8.7 MB 1.1 MB/s
Requirement already satisfied: python-dateutil>=2.6.1 in d:\python_env\py372_64_env\lib\site-packages (from pandas) (2.8.1)
Requirement already satisfied: pytz>=2017.2 in d:\python_env\py372_64_env\lib\site-packages (from pandas) (2020.1)
Requirement already satisfied: numpy>=1.13.3 in d:\python_env\py372_64_env\lib\site-packages (from pandas) (1.18.4)
Requirement already satisfied: six>=1.5 in d:\python_env\py372_64_env\lib\site-packages (from python-dateutil>=2.6.1->pandas) (1.14.0)
Installing collected packages: pandas
Successfully installed pandas-1.0.3

Package               Version
--------------------- ----------
-ip                   20.0.2
appdirs               1.4.3
argcomplete           1.11.1
atomicwrites          1.4.0
attrs                 19.3.0
certifi               2019.11.28
chardet               3.0.4
click                 7.1.1
colorama              0.4.3
coverage              5.1
easygui               0.98.1
idna                  2.9
importlib-metadata    1.6.0
more-itertools        8.2.0
numpy                 1.18.4
packaging             20.3
pandas                1.0.3
Pillow                7.1.2
pip                   20.1
pluggy                0.13.1
py                    1.8.1
pyparsing             2.4.7
PyQt5                 5.14.1
PyQt5-sip             12.7.1
PyQt5-stubs           5.14.1.0
pyqt5-tools           5.13.0.1.5
PyQtWebEngine         5.14.0
pyserial              3.4
pytest                5.4.2
pytest-cov            2.8.1
pytest-qt             1.2.2
python-dateutil       2.8.1
python-dotenv         0.12.0
python-escpos         2.2.0
python-magic          0.4.6
python-printer-escpos 0.0.3
pytz                  2020.1
pyusb                 1.0.2
pywin32               227
PyYAML                5.3.1
qrcode                6.1
requests              2.23.0
setuptools            46.1.3
six                   1.14.0
urllib3               1.25.8
wcwidth               0.1.9
wheel                 0.34.2
zipp                  3.1.0