VerticaPy

VerticaPy is a Python library that exposes sci-kit like functionality to conduct data science projects on data stored in Vertica, thus taking advantage Vertica’

What is VerticaPy?

VerticaPy is a Python library that exposes sci-kit like functionality to conduct data science projects on data stored in Vertica, thus taking advantage Vertica’s speed and built-in analytics and machine learning capabilities.

Overview of VerticaPy

What it is

VerticaPy is a Python library that provides scikit-learn-like functionality for data science projects on data stored in Vertica, leveraging Vertica's speed and built-in analytics and machine learning capabilities. It supports the entire data science life cycle, uses a pipeline mechanism to sequence data transformation operations, and offers graphical options. The library is open-source under the Apache-2.0 license.

Key features

  • Easy data exploration and fast data preparation.
  • In-database machine learning and model evaluation.
  • Flexible use of either Python or SQL in the same environment.
  • SQL Magic for executing SQL queries directly from Jupyter notebooks.
  • SQL Plots for creating interactive plots from SQL commands.
  • Support for multiple database connections via DBLINK (e.g., PostgreSQL, MySQL, Vertica).
  • Integration with plotting libraries: matplotlib, highcharts, and plotly.

Use cases

VerticaPy is suitable for data science projects that require processing large datasets stored in Vertica without moving data out of the database. It is used for data exploration, preparation, machine learning model training and deployment, and generating visualizations. It also enables combining Python and SQL workflows in a single platform, and accessing multiple databases through DBLINK.

Getting started

To install VerticaPy with pip: shell # Latest release version pip3 install verticapy[all] # Latest commit on master branch pip3 install git+https://github.com/vertica/verticapy.git@master To install from source, run from the root directory: shell python3 setup.py install For detailed installation and connection instructions, see the repository README.

License and pricing

The license is Apache-2.0, and the pricing type is open source.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/verticaverticapy.svg)](https://yunodb.com/tools/verticaverticapy?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/verticaverticapy?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/verticaverticapy.svg" alt="Featured on YunoDB" height="20"></a>