Python Libraries that can automate your life
1) Openpxl
Automate excel reporting
Openpyxl is a python library that can help us automate our excel reporting. With openpyxl, we can read an Excel file, write excel formulas, make charts, and format a worksheet using python.
Installation
- pip install openpyxl
2) SMTPLIB
Email automation
smtplib is a built-in python module used for sending emails using the Simple Mail Transfer Protocol (SMTP).
- You dont need to install smtplib or email because thay come with python.
3) Camelot
Automate table extraction from
PDFs
These tables can be exported into a Pandas dataframe and other formats such as CSV, JSON, Excel, HTML, Markdown, and SQLite.
Installation
- pip install "camelot-py[base]"
4) Requests: Make Your Life Easier With an API
Automation sometimes involves working with an API. APIs can help you collect real-world data and also simplify the development process of an application.
To work with an API you need to send requests to a server and then read the responses. The message sent by a client to a server is known as an HTTP request.
With the Requests library, we can interact with an API by sending HTTP requests and accessing the response data. This library has useful features such as passing parameters in URLs, sending custom headers, form data, and more.
Installation
To install Requests, we only need to run the command below in our terminal.
- python -m pip install requests