Install & Compatibility
Where this runs
tested against v1.1.1 · pip install
no network on importno background threads
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
muslpy 3.10–3.95 runs
installs and imports cleanly · install 0.0s · import 0.000s · 504.2MB
glibcpy 3.10–3.95 runs
installs and imports cleanly · install 20.3s · import 0.000s · 488MB
510MB installed
● package 510MB
Code
Verified usage
Verified import paths — ran on the pinned version, not inferred.
vDataFrame
✓ from verticapy import vDataFrame
✗ from verticapy import vDataFrame
Quickstart: connect to Vertica, load a table into vDataFrame, explore.
from verticapy import vDataFrame, set_option
# Optional: configure display
set_option('max_cellwidth', 50)
# Connect using parameters (replace with actual credentials)
from vertica_python import connect
conn_info = {
'host': 'localhost',
'port': 5433,
'user': 'dbadmin',
'password': '',
'database': 'vmart',
'ssl': False
}
cur = connect(**conn_info).cursor()
# Create vDataFrame from a table
vdf = vDataFrame('public.my_table', cur)
# Quick exploration
print(vdf.shape())
print(vdf.describe())
Debug
Known issues
breakingImport paths changed significantly in 1.0.0. Many functions moved from submodules to top-level or were renamed.fixRun `verticapy.upgrade()` or consult the migration guide. For example, `from verticapy import vDataFrame` instead of `from verticapy.core import vDataFrame`.
affects: <1.0.0 -> >=1.0.0
gotchaThe database connection must be passed explicitly when creating a vDataFrame. It is easy to forget and assume an implicit connection.fixAlways provide a cursor or connection object: `vDataFrame('table', cursor)`. affects: all
gotchavDataFrame methods mutate the object in-place by default, unlike pandas which returns a new object.fixBe aware that operations like `drop()` modify the current vDataFrame; use `.copy()` if you need to preserve the original.
affects: all
Upgrade
Version history
1.1.1latest on PyPI · released Jan 24, 2025
Audit
Dependencies
vertica-pythonrequiredDatabase driver for connecting to Vertica.
matplotliboptionalPlotting backend.
plotlyoptionalAlternative plotting backend.