List view
This version will introduce ML Pipelines and a robust QPROF object. Many Unit Tests will help to stabilise the product.
Due by November 8, 2024•72/72 issues closedThis version will fix multiple bugs and make the QPROF object more complete (tests) and robust.
Due by August 9, 2024•27/27 issues closedThis patch aims to enhance the documentation and bolster version robustness with additional unit tests. While it won't introduce new features, there might be the addition of some new options.
Due by March 15, 2024•17/17 issues closedThis patch aims to enhance the documentation and bolster version robustness with additional unit tests. While it won't introduce new features, there might be the addition of some new options.
Due by January 8, 2024•142/142 issues closed- No due date•23/23 issues closed
Note: Due dates and planned features are subject to change.
No due date•11/11 issues closedNote: Due dates and planned features are subject to change.
No due date•32/32 issues closedNote: Due dates and planned features are subject to change.
Due by September 9, 2022•6/6 issues closedvDataFrame: - It is now possible to create vDataFrame from different types of objects (tablesample, pandas, dict, list, numpy.array) - init_interactive(all_interactive=True): this will enable interactive table on all vdataframes. - vdf.idisplay(): use this method if you only one to activate interactive table on the current vdataframe. vModels: - Isolation Forest is now available. It is possible to convert it to memModel. - Adding parameter fit_intercept for linear models Options: - count_on and footer_on to display the count and the footer. - interactive: If set to True, verticaPy outputs will be displayed on interactive tables. Stats: - adding atan2
Due by August 19, 2022•23/23 issues closed# New Functions ## Utilities - create_schema: Creates a new schema. - create_table: Creates a new table. - help_start function is updated with new links. - Simplifying the installation. ## Connection - verticalab_connection: automatically connect to the verticalab environment. - current_connection: Gets the current connection. - current_cursor: Gets the current cursor. - new_connection: Creates a new connection. - delete_connection: Deletes a connection. - close_connection: Closes the general connection. - set_connection: Sets a customised connection ## vDataFrame - vDataFrame.count_percent: computes count and percent of missing values. ## Tablesample - tablesample.sort: sort the tablesample. - tablesample.append: append the input tablesample. - tablesample.shape: Returns the tablesample shape. - tablesample.decimal_to_float: Converts all the Decimal values of a tablesample to float. # New parameters & options ## Utilities - create_table: New parameters - raise_error - insert_into has new parameters. - New option for the set_option function: 'overwrite_model' to automatically overwrite models when creating a new one. ## vDataFrame - vDataFrame.acf, vDataFrame.corr, vDataFrame.corr_pvalue, vdf.hchart: new possible value for param 'method' - 'spearmanD' - New parameter 'processes' for vDataFrame.agg and vDataFrame.describe to be able to send multiple queries at the same time. Method .agg/aggregate can now also deal with incompatible aggregations. - vColumn/vDataFrame.nunique & .quantile allow to compute respectively the exact cardinality and exact quantile (extra parameter approx). - vDataFrame.to_json and vDataFrame.to_csv only takes one argument for the file name and folder instead of two. - vDataFrame.pivot_table: extra parameter. - vDataFrame.asfreq is renamed interpolate (asfreq is still working) - Possibility to create a vDataFrame from a sql query using the new parameter sql. ## vModel - New alias for vModel.classification_report/regression_report : .report - vModel.predict_proba: Predicts the model probabilities. # Deprecated & Renaming - new_auto_connection - available_auto_connection is renamed available_connections - hchart.py is renamed highchart.py and vCharts.py is renamed hchart.py. - vDataFrame.count only returns the count - vDataFrame.set_cursor - vModel.to_sklearn - vModel.to_shapExplainer - vModel.predict computes only the prediction and no more the probabilities. - Parameter 'cursor' is removed from the entire API. - vHelp is renamed help_start. - New name: vdf_from_relation -> vDataFrameSQL # SQL Magic - It is now possible to use variables. - -i option to read input SQL file. - -o option to export to CSV or JSON - It is possible to query: tablesample, pandas, vDataFrames - SQL comment '--' are now supported. - SQL Magic returns vDataFrame instead of tablesamples: the option '-vdf' is erased. # HCHART Magic - It is possible to use variables. # Toolbox Renaming & Rellocation - new file logo.py to generate the verticapy logo. - str_column-> quote_ident - columns_check -> vDataFrame.are_namecols_in, is_nb_cols_correct - vdf_columns_names -> vDataFrame.format_colnames - column_check_ambiguous -> is_colname_in - str_function -> get_verticapy_function - nearest_column -> vDataFrame.get_nearest_column - sort_str -> vDataFrame.__get_sort_syntax__ - vModel.get_vertica_param_dict - type_code_dtype -> type_code_to_dtype - str_category -> get_category_from_python_type - get_category_from_type -> get_category_from_vertica_type - chaid_columns -> vDataFrame.chaid_columns - get_category_from_type -> get_category_from_python_type
Due by April 29, 2022•42/42 issues closedNew expected features: - improved pandas_to_vertica function - ingestion of numpy arrays - improved to_csv, to_json functions - improved read_csv function - sklearn_to_memModel function
Due by March 25, 2022•74/74 issues closedVerticaPy 0.8.0 will include the following features: - CHAID Trees - Improved rendering capabilities for tree based models - more parameters for XGB
Due by October 22, 2021•8/8 issues closedthe version 0.7.1 will include the following feature: - memModels will allow the ingestion of NaiveBayes models. - vModel.to_memmodel to convert any Vertica Model to independant memModels. - XGBoost.to_json to export XGBoost to the open source JSON format
Due by October 1, 2021•5/5 issues closed- Due by May 4, 2021
- Due by June 28, 2020•1/1 issues closed
- Due by April 2, 2021•2/2 issues closed
- Due by February 17, 2021•3/3 issues closed
- Due by November 9, 2020•1/1 issues closed
- Due by September 29, 2020•3/3 issues closed
- Due by August 25, 2020•5/5 issues closed
- Due by June 4, 2021•4/4 issues closed
- Due by June 24, 2021•17/17 issues closed
- Due by August 20, 2021•20/20 issues closed