自己整理的PYTHON库

时间:2024-03-04 07:03:25

1、操作Excel

1)Openpyxl

地址:https://pypi.org/project/openpyxl/

文档:https://openpyxl.readthedocs.io/en/stable/

 

2、操作网络请求

1)requests

https://pypi.org/project/requests/

 

3、Python的测试框架

1)pytest

https://pypi.org/project/pytest/

 

 3、操作Mysql数据库

1)MySQL引擎库

  • https://pypi.org/project/mysqlclient/
  • https://pypi.org/project/PyMySQL/(推荐)
  • https://pypi.org/project/cymysql/  

2)MySQL使用库

地址:https://pypi.org/project/SQLAlchemy

文档:https://docs.sqlalchemy.org/en/13/

 

4、Web的UI自动化(最爱)

1)Selenium-wire

地址:https://pypi.org/project/selenium-wire/

文档:https://github.com/wkeeling/selenium-wire

 

5、操作时间、日期、时区

1)Arrow

地址:https://pypi.org/project/arrow/

文档:https://arrow.readthedocs.io/en/stable/

 

2)Pendulum

地址:https://pypi.org/project/pendulum/

文档:https://pendulum.eustace.io/docs/

 

6、Python编写GUI程序

1)PySimpleGUI

地址:https://pypi.org/project/PySimpleGUI/

文档:https://pysimplegui.readthedocs.io/en/latest/

 

7、网页的富文本编辑器

1)django-ckeditor

https://pypi.org/project/django-ckeditor-5/

文档:https://ckeditor.com/

 

8、剪贴板

1)pyperclip

https://pypi.org/project/pyperclip/

 

2)pyclip

https://pypi.org/project/pyclip/

 

9、键盘操作

1)PyAutoGUI

https://pypi.org/project/PyAutoGUI/

文档:https://pyautogui.readthedocs.io/en/latest/

 

10、图片识别

1)pytesseract

https://pypi.org/project/pytesseract/

文档:https://hub.fastgit.org/UB-Mannheim/tesseract/wiki

 

2) easyocr

https://pypi.org/project/easyocr/

文档:https://www.jaided.ai/easyocr/tutorial/

 

11、图表

1)pyecharts

 https://pypi.org/project/pyecharts/

 

文档:

https://pyecharts.org/#/

https://gallery.pyecharts.org/#/

 

12、单网页开始

1)pywebio

https://pypi.org/project/pywebio/

 

文档:

https://pywebio.readthedocs.io/en/latest/