What's New in VerticaPy v0.12.x

VerticaPy now supports external Databases! It is now possible to create external vDataFrames and to query any "external" table using an easy syntax. Check out this notebook to see the new functionality in action.

New features:

vDataFrame

• [New Method] vDataFrame.merge_similar_names allows you to merge columns with similar names.
• [New Parameters] vDataFrame.flat_vmap has a new exclude_columns parameter.
• [New Support] vDataFrame[].astype offers a more flexible data type casting. It is now possible to convert a string to a VMap.
• [New Parameters] vDataFrame: The vDataFrame object has new parameter that allows you to create External vDataFrames and to connect to external Databases.

Utilities

• [New function] read_avro: You can now ingest AVRO files.
• [Enhancement] read_csv: The parser can automatically guess the delimiter.
• [New Option] set_option: You can now choose what to save in the QUERY PROFILE logs.

SQL Magic

• [New Syntax] SQL Magic allows you to query external sources. Check out this notebook to see the new functionality in action.

GitHub and Unit Tests

• More unit tests have been added.