AutoClustering

In [ ]:
class AutoClustering(name: str,
                     cursor=None,
                     n_cluster: int = None,
                     init: str = "kmeanspp",
                     max_iter: int = 300,
                     tol: float = 1e-4,
                     preprocess_data: bool = True,
                     preprocess_dict: dict = {"identify_ts": False, "normalize_min_cat": 0, 
                                              "outliers_threshold": 3.0, "na_method": "drop",},
                     print_info: bool = True,)

Automatically creates k different groups with which to generalize the data.

Parameters

Name Type Optional Description
name
str
Name of the model.
cursor
DBcursor
Vertica database cursor.
n_cluster
int
Number of clusters. If empty, an optimal number of clusters will be determined using multiple k-means models.
init
str / list
The method for finding the initial cluster centers.
  • kmeanspp : Uses the k-means++ method to initialize the centers.
  • random : Randomly subsamples the data to find initial centers.
  • Alternatively, you can specify a list with the initial custer centers.
max_iter
int
The maximum number of iterations for the algorithm.
tol
float
Determines whether the algorithm has converged. The algorithm is considered converged after no center has moved more than a distance of 'tol' from the previous iteration.
preprocess_data
bool
If True, the data will be preprocessed.
preprocess_dict
dict
Dictionary to pass to the AutoDataPrep class in order to preprocess the data before the clustering.
print_info
bool
If True, prints the model information at each step.

Attributes

Name Type Description
preprocess_
object
Model used to preprocess the data.
model_
object
Final model used for the clustering.

Main Methods

Name Description
Trains the model.

AutoClustering also inherits the vModel methods.

Example

In [1]:
from verticapy.learn.delphi import AutoClustering

model = AutoClustering("titanic_autoClustering")
model.fit("public.titanic",)
Starting AutoClustering

Finding a suitable number of clusters

Building the Final Model


Out[1]:

=======
centers
=======
 pclass |survived|  age   | sibsp  | parch  |  fare  |  body  |sex_female|sex_male|ticket_113503|ticket_113760|ticket_113781|ticket_12749|ticket_1601|ticket_16966|ticket_220845|ticket_24160|ticket_347088|ticket_others|ticket_s.o.c._14879|cabin_a34|cabin_b96_b98|cabin_c101|cabin_c22_c26|cabin_c78|cabin_d |cabin_e34|cabin_f2|cabin_f33|cabin_g6|cabin_others|embarked_c|embarked_q|embarked_s|boat_10 |boat_11 |boat_13 |boat_14 |boat_15 | boat_3 | boat_5 | boat_8 | boat_9 | boat_c |boat_others|home.dest_?havana__cuba|home.dest_argentina|home.dest_asarum__sweden_brooklyn__ny|home.dest_auburn__ny|home.dest_aughnacliff__co_longford__ireland_new_york__ny|home.dest_austria_niagara_falls__ny|home.dest_bennington__vt|home.dest_bergen__norway|home.dest_bronx__ny|home.dest_new_york__ny|home.dest_others
--------+--------+--------+--------+--------+--------+--------+----------+--------+-------------+-------------+-------------+------------+-----------+------------+-------------+------------+-------------+-------------+-------------------+---------+-------------+----------+-------------+---------+--------+---------+--------+---------+--------+------------+----------+----------+----------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+-----------+-----------------------+-------------------+-------------------------------------+--------------------+--------------------------------------------------------+-----------------------------------+------------------------+------------------------+-------------------+----------------------+----------------
 0.84934|-0.75731|-0.77398| 0.94700|-0.49918|-0.38721|-1.14726|  1.00000 | 0.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.45369|-0.75731|-0.83255|-0.09980|-0.49918|-0.60191| 1.27752|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 0.98314| 2.51720|-0.49918| 1.93421| 0.67133|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 1.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   0.00000  |  0.00000 |  1.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.10023|-0.75731| 1.27130|-0.62320|-0.49918|-0.51867| 0.42680|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 0.73714|-0.62320| 2.86669|-0.43747| 0.92819|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 2.28340| 0.94700| 1.18376| 1.69076| 1.26725|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.50000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   0.50000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731| 1.54541|-0.62320|-0.49918|-0.47674|-0.92635|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      1.00000      |        0.00000       |     0.00000    
-0.93110|-0.75731| 0.50871| 0.94700|-0.49918| 0.39609|-1.27569|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.50000 |  0.00000 |  0.50000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        1.00000       |     0.00000    
-0.33762|-0.75731| 1.89683|-0.62320|-0.49918|-0.56312|-1.15753|  1.00000 | 0.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.37456|-0.75731|-0.05708|-0.62320|-0.49918|-0.48373| 1.34225|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.10000        |      0.00000      |        0.00000       |     0.90000    
 0.84934|-0.75731| 0.39977|-0.62320|-0.49918|-0.51713|-0.04994|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731|-1.09026| 0.94700|-0.49918|-0.43891| 1.67823|  1.00000 | 0.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731| 0.17486| 0.94700|-0.49918|-0.06271| 1.28009|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.25000 |  0.00000 |  0.75000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731|-0.15899|-0.62320|-0.49918|-0.65547|-1.38357|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.50000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     0.50000    
 0.84934|-0.75731|-0.35227| 0.94700| 1.18376|-0.34873| 0.29631|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 1.96712|-0.62320| 2.86669| 2.66535|-0.43832|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 0.56143|-0.62320| 1.18376| 3.92777|-0.18145|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731|-0.80912|-0.62320|-0.49918|-0.66417| 1.38027|  1.00000 | 0.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  1.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 1.93900|-0.62320|-0.16259| 0.78400| 0.39186|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731|-0.14142|-0.62320|-0.49918|-0.51208|-0.57702|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731|-1.96882| 4.08740| 1.18376|-0.23093|-1.65071|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 2.05497|-0.62320|-0.49918| 0.08516| 0.95902|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 0.73714|-0.62320|-0.49918|-0.64951|-0.99314|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  1.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         1.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     0.00000    
 0.84934|-0.75731| 0.17486|-0.62320|-0.49918|-0.64827|-1.01882|  0.50000 | 0.50000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  1.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 0.49114| 2.51720|-0.49918|-0.64401|-0.68490|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 1.12370|-0.62320|-0.49918|-0.07622|-0.86984|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         1.00000        |         0.00000        |      0.00000      |        0.00000       |     0.00000    
-1.52458|-0.75731| 0.91285| 0.94700|-0.49918| 2.01707|-0.48969|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.50000 |  0.00000 |  0.50000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731|-0.10628|-0.62320|-0.49918|-0.02217| 0.25008|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        1.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     0.00000    
 0.84934|-0.75731|-0.21463|-0.62320|-0.49918|-0.62304|-0.93920|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.08333      |               0.08333               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     0.83333    
-0.33762|-0.75731|-0.00085|-0.62320|-0.49918|-0.48459|-0.92122|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       1.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     0.00000    
-1.52458|-0.75731| 0.99820|-0.62320|-0.49918| 0.09984|-0.31355|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731|-0.08285|-0.62320|-0.49918|-0.67416| 0.24323|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 1.19399| 0.94700|-0.49918|-0.43747|-1.61988|  1.00000 | 0.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731| 0.13972|-0.62320|-0.49918|-0.01811|-0.24824|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731|-0.56312|-0.62320|-0.49918| 3.36770| 0.69188|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731|-0.90283| 0.42360| 1.18376| 0.45296|-0.76367|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 0.42086|-0.62320|-0.49918|-0.66600| 1.47274|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  1.00000 |  0.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 1.40484| 0.94700|-0.49918|-0.43747|-0.46914|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-1.52458|-0.75731|-0.00085| 0.94700| 2.86669| 3.86769|-0.30475|  0.00000 | 1.00000|   0.00000   |   0.00000   |   1.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   0.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   1.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   0.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731| 0.94799| 0.94700|-0.49918|-0.07622|-0.98286|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
-0.33762|-0.75731| 0.13972| 2.51720|-0.49918| 1.41590| 0.93847|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   0.00000   |      1.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  0.00000 |  1.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    
 0.84934|-0.75731| 2.84568|-0.62320|-0.49918|-0.64951| 0.06513|  0.00000 | 1.00000|   0.00000   |   0.00000   |   0.00000   |   0.00000  |  0.00000  |   0.00000  |   0.00000   |   0.00000  |   0.00000   |   1.00000   |      0.00000      | 0.00000 |   0.00000   |  0.00000 |   0.00000   | 0.00000 | 0.00000| 0.00000 | 0.00000| 0.00000 | 0.00000|   1.00000  |  0.00000 |  1.00000 |  0.00000 | 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000| 0.00000|  1.00000  |        0.00000        |      0.00000      |               0.00000               |       0.00000      |                         0.00000                        |              0.00000              |         0.00000        |         0.00000        |      0.00000      |        0.00000       |     1.00000    


=======
metrics
=======
Evaluation metrics:
     Total Sum of Squares: 647.20355
     Within-Cluster Sum of Squares: 
         Cluster 0: 0
         Cluster 1: 2.7696446
         Cluster 2: 0
         Cluster 3: 3.1936095
         Cluster 4: 0
         Cluster 5: 1.8817375
         Cluster 6: 0.65045775
         Cluster 7: 2.1659412
         Cluster 8: 0
         Cluster 9: 6.5058743
         Cluster 10: 1.1352873
         Cluster 11: 0
         Cluster 12: 2.0113365
         Cluster 13: 1.3656434
         Cluster 14: 0.81973789
         Cluster 15: 0
         Cluster 16: 0
         Cluster 17: 0
         Cluster 18: 10.383051
         Cluster 19: 5.2081502
         Cluster 20: 0
         Cluster 21: 1.1965557
         Cluster 22: 0
         Cluster 23: 1.0437978
         Cluster 24: 0
         Cluster 25: 0
         Cluster 26: 2.4979456
         Cluster 27: 0
         Cluster 28: 7.2221865
         Cluster 29: 0
         Cluster 30: 7.4018424
         Cluster 31: 0.31199429
         Cluster 32: 0
         Cluster 33: 0.50274243
         Cluster 34: 0
         Cluster 35: 8.2171053
         Cluster 36: 0.89503305
         Cluster 37: 0
         Cluster 38: 0
         Cluster 39: 0.98831955
         Cluster 40: 0
         Cluster 41: 0
     Total Within-Cluster Sum of Squares: 68.367994
     Between-Cluster Sum of Squares: 578.83556
     Between-Cluster SS / Total SS: 89.44%
 Number of iterations performed: 3
 Converged: True
 Call:
kmeans('public.titanic_autoClustering', '"public"._VERTICAPY_TEMPORARY_VIEW_dbadmin_253982', '"pclass", "survived", "age", "sibsp", "parch", "fare", "body", "sex_female", "sex_male", "ticket_113503", "ticket_113760", "ticket_113781", "ticket_12749", "ticket_1601", "ticket_16966", "ticket_220845", "ticket_24160", "ticket_347088", "ticket_Others", "ticket_S.O.C._14879", "cabin_A34", "cabin_B96_B98", "cabin_C101", "cabin_C22_C26", "cabin_C78", "cabin_D", "cabin_E34", "cabin_F2", "cabin_F33", "cabin_G6", "cabin_Others", "embarked_C", "embarked_Q", "embarked_S", "boat_10", "boat_11", "boat_13", "boat_14", "boat_15", "boat_3", "boat_5", "boat_8", "boat_9", "boat_C", "boat_Others", "home.dest_?Havana__Cuba", "home.dest_Argentina", "home.dest_Asarum__Sweden_Brooklyn__NY", "home.dest_Auburn__NY", "home.dest_Aughnacliff__Co_Longford__Ireland_New_York__NY", "home.dest_Austria_Niagara_Falls__NY", "home.dest_Bennington__VT", "home.dest_Bergen__Norway", "home.dest_Bronx__NY", "home.dest_New_York__NY", "home.dest_Others"', 42
USING PARAMETERS max_iterations=300, epsilon=0.0001, init_method='kmeanspp', distance_method='euclidean')