Serialization

Method Definition
vDataFrame.to_csv Creates a CSV file of the current vDataFrame relation.
vDataFrame.to_db Saves the vDataFrame current relation to the Vertica database.
vDataFrame.to_geopandas Converts the vDataFrame to a Geopandas DataFrame.
vDataFrame.to_json Creates a JSON file of the current vDataFrame relation.
vDataFrame.to_list Converts the vDataFrame to a Python list.
vDataFrame.to_numpy Converts the vDataFrame to a Numpy array.
vDataFrame.to_pandas Converts the vDataFrame to a pandas DataFrame.
vDataFrame.to_pickle Saves the vDataFrame to a Python pickle file.
vDataFrame.to_shp Creates a SHP file of the current vDataFrame relation.

vDataFrame Management

Method Definition
vDataFrame.del_catalog Delete the current vDataFrame catalog.
vDataFrame.load Loads a previous structure of the vDataFrame.
vDataFrame.save Saves the current structure of the vDataFrame.

vDataFrame Information

Method Definition
vDataFrame.catcol Returns the vDataFrame categorical vcolumns based on a cardinality threshold.
vDataFrame[].category Returns the vcolumn category.
vDataFrame[].ctype Returns the vcolumn DB type.
vDataFrame.current_relation Returns the current vDataFrame relation.
vDataFrame.datecol Returns all the vDataFrame vcolumns of type date.
vDataFrame.dtypes Returns the different vcolumns types.
vDataFrame[].dtype Displays and Returns the vcolumn Data type.
vDataFrame.empty Returns True if the vDataFrame is empty.
vDataFrame.expected_store_usage Returns the vDataFrame expected store usage.
vDataFrame.explain Provides information on how Vertica is computing the current vDataFrame relation.
vDataFrame.get_columns Returns the vDataFrame vcolumns.
vDataFrame[].get_len Returns a new vColumn that represents the length of each element.
vDataFrame.head Returns the vDataFrame head.
vDataFrame[].head Returns the vcolumn head.
vDataFrame.iloc Returns a part of the vDataFrame (delimited by an offset and a limit).
vDataFrame[].iloc Returns a part of the vcolumn (delimited by an offset and a limit).
vDataFrame.info Displays information about the different vDataFrame transformations.
vDataFrame[].isarray Returns True if the vColumn is an array, False otherwise.
vDataFrame[].isbool Returns True if the vColumn is boolean, False otherwise.
vDataFrame[].isdate Returns True if the vcolumn category is date, False otherwise.
vDataFrame[].isnum Returns True if the vcolumn is numerical, False otherwise.
vDataFrame[].isvmap Returns True if the vColumn category is VMap, False otherwise.
vDataFrame.memory_usage Returns the vDataFrame memory usage.
vDataFrame[].memory_usage Returns the vcolumn memory usage.
vDataFrame.numcol Returns the vDataFrame numerical vcolumns.
vDataFrame.tail Returns the vDataFrame tail.
vDataFrame[].tail Returns the vcolumn tail.
vDataFrame[].store_usage Returns the vcolumn expected store usage (unit: b).
vDataFrame.swap Swap the two input vcolumns.
vDataFrame.version Returns the Vertica version.

Display

Method Definition
vDataFrame.idisplay Displays the specified vDataFrame as an interactive table.