pydbsmgr 1.1.0

Python package for database control and DataFrame processing

pydbsmgr

Python package for database control and administration as well as for DataFrame processing. Also contains a simpler Python SDK for Azure Cloud tools such as uploading .parquet, .csv and .xlsx files, downloading them and DataFrame cleansing, for more information review our documentation.

Prerequisites

Before you begin, ensure you have met the following requirements:

• You have a Windows/Linux/Mac machine running Python 3.10+.
• You have installed the latest versions of pip and virtualenv or conda (Anaconda).

Installation

This package can be easily installed with pip:

pip install pydbsmgr

Installation from GitHub

If you prefer, you can do it in this other way:

pip install git+https://github.com/jzsmoreno/pydbsmgr

You can contribute to this repository

Through the following steps:

1. Clone this repository (requires git):

git clone https://github.com/jzsmoreno/pydbsmgr.git
cd pydbsmgr

1. Create and activate a python virtual environment (The activation may vary depending on your OS here is the example for Linux):

python3 -m venv venv
source ./venv/bin/activate

3. Install all the requirements:

pip3 install -r requirements.txt

4. Now you can test it with any python file you want. But you can also use it in a jupyter notebook, just install jupyterlab

pip3 install jupyterlab

5. Open the jupyter lab instance (you can see that already exists an example.ipynb, where you can see some of the things you can do):

jupyter lab