VerticaPy

Python API for Vertica Data Science at Scale

Example: Pipelines¶

Pipeline models makes model deployment even more efficient by combining several steps of the Data Science process (preprocessing, modeling...). In this example, we use the 'Winequality' dataset to demonstrate the methods available to Pipeline models.

In [20]:

from verticapy.datasets import load_winequality
winequality = load_winequality()
display(winequality)

	123 fixed_acidity Numeric(6,3)	123 volatile_acidity Numeric(7,4)	123 citric_acid Numeric(6,3)	123 residual_sugar Numeric(7,3)	123 chlorides Float	123 free_sulfur_dioxide Numeric(7,2)	123 total_sulfur_dioxide Numeric(7,2)	123 density Float	123 pH Numeric(6,3)	123 sulphates Numeric(6,3)	123 alcohol Float	123 quality Int	123 good Int	Abc color Varchar(20)
1	3.8	0.31	0.02	11.1	0.036	20.0	114.0	0.99248	3.75	0.44	12.4	6	0	white
2	3.9	0.225	0.4	4.2	0.03	29.0	118.0	0.989	3.57	0.36	12.8	8	1	white
3	4.2	0.17	0.36	1.8	0.029	93.0	161.0	0.98999	3.65	0.89	12.0	7	1	white
4	4.2	0.215	0.23	5.1	0.041	64.0	157.0	0.99688	3.42	0.44	8.0	3	0	white
5	4.4	0.32	0.39	4.3	0.03	31.0	127.0	0.98904	3.46	0.36	12.8	8	1	white
6	4.4	0.46	0.1	2.8	0.024	31.0	111.0	0.98816	3.48	0.34	13.1	6	0	white
7	4.4	0.54	0.09	5.1	0.038	52.0	97.0	0.99022	3.41	0.4	12.2	7	1	white
8	4.5	0.19	0.21	0.95	0.033	89.0	159.0	0.99332	3.34	0.42	8.0	5	0	white
9	4.6	0.445	0.0	1.4	0.053	11.0	178.0	0.99426	3.79	0.55	10.2	5	0	white
10	4.6	0.52	0.15	2.1	0.054	8.0	65.0	0.9934	3.9	0.56	13.1	4	0	red
11	4.7	0.145	0.29	1.0	0.042	35.0	90.0	0.9908	3.76	0.49	11.3	6	0	white
12	4.7	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	10.5	5	0	white
13	4.7	0.455	0.18	1.9	0.036	33.0	106.0	0.98746	3.21	0.83	14.0	7	1	white
14	4.7	0.6	0.17	2.3	0.058	17.0	106.0	0.9932	3.85	0.6	12.9	6	0	red
15	4.7	0.67	0.09	1.0	0.02	5.0	9.0	0.98722	3.3	0.34	13.6	5	0	white
16	4.7	0.785	0.0	3.4	0.036	23.0	134.0	0.98981	3.53	0.92	13.8	6	0	white
17	4.8	0.13	0.32	1.2	0.042	40.0	98.0	0.9898	3.42	0.64	11.8	7	1	white
18	4.8	0.17	0.28	2.9	0.03	22.0	111.0	0.9902	3.38	0.34	11.3	7	1	white
19	4.8	0.21	0.21	10.2	0.037	17.0	112.0	0.99324	3.66	0.48	12.2	7	1	white
20	4.8	0.225	0.38	1.2	0.074	47.0	130.0	0.99132	3.31	0.4	10.3	6	0	white
21	4.8	0.26	0.23	10.6	0.034	23.0	111.0	0.99274	3.46	0.28	11.5	7	1	white
22	4.8	0.29	0.23	1.1	0.044	38.0	180.0	0.98924	3.28	0.34	11.9	6	0	white
23	4.8	0.33	0.0	6.5	0.028	34.0	163.0	0.9937	3.35	0.61	9.9	5	0	white
24	4.8	0.34	0.0	6.5	0.028	33.0	163.0	0.9939	3.36	0.61	9.9	6	0	white
25	4.8	0.65	0.12	1.1	0.013	4.0	10.0	0.99246	3.32	0.36	13.5	4	0	white
26	4.9	0.235	0.27	11.75	0.03	34.0	118.0	0.9954	3.07	0.5	9.4	6	0	white
27	4.9	0.33	0.31	1.2	0.016	39.0	150.0	0.98713	3.33	0.59	14.0	8	1	white
28	4.9	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	10.4666666666667	5	0	white
29	4.9	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	10.4666666666667	5	0	white
30	4.9	0.345	0.34	1.0	0.068	32.0	143.0	0.99138	3.24	0.4	10.1	5	0	white
31	4.9	0.345	0.34	1.0	0.068	32.0	143.0	0.99138	3.24	0.4	10.1	5	0	white
32	4.9	0.42	0.0	2.1	0.048	16.0	42.0	0.99154	3.71	0.74	14.0	7	1	red
33	4.9	0.47	0.17	1.9	0.035	60.0	148.0	0.98964	3.27	0.35	11.5	6	0	white
34	5.0	0.17	0.56	1.5	0.026	24.0	115.0	0.9906	3.48	0.39	10.8	7	1	white
35	5.0	0.2	0.4	1.9	0.015	20.0	98.0	0.9897	3.37	0.55	12.05	6	0	white
36	5.0	0.235	0.27	11.75	0.03	34.0	118.0	0.9954	3.07	0.5	9.4	6	0	white
37	5.0	0.24	0.19	5.0	0.043	17.0	101.0	0.99438	3.67	0.57	10.0	5	0	white
38	5.0	0.24	0.21	2.2	0.039	31.0	100.0	0.99098	3.69	0.62	11.7	6	0	white
39	5.0	0.24	0.34	1.1	0.034	49.0	158.0	0.98774	3.32	0.32	13.1	7	1	white
40	5.0	0.255	0.22	2.7	0.043	46.0	153.0	0.99238	3.75	0.76	11.3	6	0	white
41	5.0	0.27	0.32	4.5	0.032	58.0	178.0	0.98956	3.45	0.31	12.6	7	1	white
42	5.0	0.27	0.32	4.5	0.032	58.0	178.0	0.98956	3.45	0.31	12.6	7	1	white
43	5.0	0.27	0.4	1.2	0.076	42.0	124.0	0.99204	3.32	0.47	10.1	6	0	white
44	5.0	0.29	0.54	5.7	0.035	54.0	155.0	0.98976	3.27	0.34	12.9	8	1	white
45	5.0	0.3	0.33	3.7	0.03	54.0	173.0	0.9887	3.36	0.3	13.0	7	1	white
46	5.0	0.31	0.0	6.4	0.046	43.0	166.0	0.994	3.3	0.63	9.9	6	0	white
47	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	10.7	6	0	white
48	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	10.7	6	0	white
49	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	10.7	6	0	white
50	5.0	0.33	0.18	4.6	0.032	40.0	124.0	0.99114	3.18	0.4	11.0	6	0	white
51	5.0	0.33	0.23	11.8	0.03	23.0	158.0	0.99322	3.41	0.64	11.8	6	0	white
52	5.0	0.35	0.25	7.8	0.031	24.0	116.0	0.99241	3.39	0.4	11.3	6	0	white
53	5.0	0.35	0.25	7.8	0.031	24.0	116.0	0.99241	3.39	0.4	11.3	6	0	white
54	5.0	0.38	0.01	1.6	0.048	26.0	60.0	0.99084	3.7	0.75	14.0	6	0	red
55	5.0	0.4	0.5	4.3	0.046	29.0	80.0	0.9902	3.49	0.66	13.6	6	0	red
56	5.0	0.42	0.24	2.0	0.06	19.0	50.0	0.9917	3.72	0.74	14.0	8	1	red
57	5.0	0.44	0.04	18.6	0.039	38.0	128.0	0.9985	3.37	0.57	10.2	6	0	white
58	5.0	0.455	0.18	1.9	0.036	33.0	106.0	0.98746	3.21	0.83	14.0	7	1	white
59	5.0	0.55	0.14	8.3	0.032	35.0	164.0	0.9918	3.53	0.51	12.5	8	1	white
60	5.0	0.61	0.12	1.3	0.009	65.0	100.0	0.9874	3.26	0.37	13.5	5	0	white
61	5.0	0.74	0.0	1.2	0.041	16.0	46.0	0.99258	4.01	0.59	12.5	6	0	red
62	5.0	1.02	0.04	1.4	0.045	41.0	85.0	0.9938	3.75	0.48	10.5	4	0	red
63	5.0	1.04	0.24	1.6	0.05	32.0	96.0	0.9934	3.74	0.62	11.5	5	0	red
64	5.1	0.11	0.32	1.6	0.028	12.0	90.0	0.99008	3.57	0.52	12.2	6	0	white
65	5.1	0.14	0.25	0.7	0.039	15.0	89.0	0.9919	3.22	0.43	9.2	6	0	white
66	5.1	0.165	0.22	5.7	0.047	42.0	146.0	0.9934	3.18	0.55	9.9	6	0	white
67	5.1	0.21	0.28	1.4	0.047	48.0	148.0	0.99168	3.5	0.49	10.4	5	0	white
68	5.1	0.23	0.18	1.0	0.053	13.0	99.0	0.98956	3.22	0.39	11.5	5	0	white
69	5.1	0.25	0.36	1.3	0.035	40.0	78.0	0.9891	3.23	0.64	12.1	7	1	white
70	5.1	0.26	0.33	1.1	0.027	46.0	113.0	0.98946	3.35	0.43	11.4	7	1	white
71	5.1	0.26	0.34	6.4	0.034	26.0	99.0	0.99449	3.23	0.41	9.2	6	0	white
72	5.1	0.29	0.28	8.3	0.026	27.0	107.0	0.99308	3.36	0.37	11.0	6	0	white
73	5.1	0.29	0.28	8.3	0.026	27.0	107.0	0.99308	3.36	0.37	11.0	6	0	white
74	5.1	0.3	0.3	2.3	0.048	40.0	150.0	0.98944	3.29	0.46	12.2	6	0	white
75	5.1	0.305	0.13	1.75	0.036	17.0	73.0	0.99	3.4	0.51	12.3333333333333	5	0	white
76	5.1	0.31	0.3	0.9	0.037	28.0	152.0	0.992	3.54	0.56	10.1	6	0	white
77	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	12.5	7	1	white
78	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	12.5	7	1	white
79	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	12.5	7	1	white
80	5.1	0.33	0.27	6.7	0.022	44.0	129.0	0.99221	3.36	0.39	11.0	7	1	white
81	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	11.5	6	0	white
82	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	11.5	6	0	white
83	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	11.5	6	0	white
84	5.1	0.39	0.21	1.7	0.027	15.0	72.0	0.9894	3.5	0.45	12.5	6	0	white
85	5.1	0.42	0.0	1.8	0.044	18.0	88.0	0.99157	3.68	0.73	13.6	7	1	red
86	5.1	0.42	0.01	1.5	0.017	25.0	102.0	0.9894	3.38	0.36	12.3	7	1	white
87	5.1	0.47	0.02	1.3	0.034	18.0	44.0	0.9921	3.9	0.62	12.8	6	0	red
88	5.1	0.51	0.18	2.1	0.042	16.0	101.0	0.9924	3.46	0.87	12.9	7	1	red
89	5.1	0.52	0.06	2.7	0.052	30.0	79.0	0.9932	3.32	0.43	9.3	5	0	white
90	5.1	0.585	0.0	1.7	0.044	14.0	86.0	0.99264	3.56	0.94	12.9	7	1	red
91	5.2	0.155	0.33	1.6	0.028	13.0	59.0	0.98975	3.3	0.84	11.9	8	1	white
92	5.2	0.155	0.33	1.6	0.028	13.0	59.0	0.98975	3.3	0.84	11.9	8	1	white
93	5.2	0.16	0.34	0.8	0.029	26.0	77.0	0.99155	3.25	0.51	10.1	6	0	white
94	5.2	0.17	0.27	0.7	0.03	11.0	68.0	0.99218	3.3	0.41	9.8	5	0	white
95	5.2	0.185	0.22	1.0	0.03	47.0	123.0	0.99218	3.55	0.44	10.15	6	0	white
96	5.2	0.2	0.27	3.2	0.047	16.0	93.0	0.99235	3.44	0.53	10.1	7	1	white
97	5.2	0.21	0.31	1.7	0.048	17.0	61.0	0.98953	3.24	0.37	12.0	7	1	white
98	5.2	0.22	0.46	6.2	0.066	41.0	187.0	0.99362	3.19	0.42	9.73333333333333	5	0	white
99	5.2	0.24	0.15	7.1	0.043	32.0	134.0	0.99378	3.24	0.48	9.9	6	0	white
100	5.2	0.24	0.45	3.8	0.027	21.0	128.0	0.992	3.55	0.49	11.2	8	1	white

Rows: 1-100 | Columns: 14

We'll start by doing the following to create a Pipeline model to predict the quality of each wine.

Normalize the data using a standard StandardScaler.
Create a linear regression model to predict wine quality.

In [21]:

from verticapy.learn.linear_model import LinearRegression
from verticapy.learn.preprocessing import StandardScaler
from verticapy.learn.pipeline import Pipeline

model1 = StandardScaler("public.StdWine")
model2 = LinearRegression("public.LR_winequality")

model = Pipeline([("WineNorm", model1),
                  ("WineLR", model2)])
model.fit("public.winequality", 
          ["alcohol"], 
          "quality")

Fitting the model creates new model attributes, which make methods easier to use.

In [22]:

model.X

Out[22]:

['"alcohol"']

In [23]:

model.y

Out[23]:

'"quality"'

In [24]:

model.input_relation

Out[24]:

'(SELECT "fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "alcohol", "quality", "good", "color" FROM public.winequality) VERTICAPY_SUBTABLE'

In [25]:

model.test_relation

Out[25]:

'(SELECT "fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "alcohol", "quality", "good", "color" FROM (SELECT APPLY_NORMALIZE("fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "alcohol", "quality", "good", "color" USING PARAMETERS model_name = \'public.StdWine\', match_by_pos = \'true\', key_columns = \'"fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "quality", "good", "color"\', exclude_columns = \'"fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "quality", "good", "color"\') FROM (SELECT "fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "free_sulfur_dioxide", "total_sulfur_dioxide", "density", "pH", "sulphates", "alcohol", "quality", "good", "color" FROM public.winequality) VERTICAPY_SUBTABLE) VERTICAPY_SUBTABLE) VERTICAPY_SUBTABLE'

Since we didn't write a test relation when fitting the model, the model will use the training relation as the test relation.

Let's compute the R2 of the model.

In [26]:

model.score(method = "r2")

Out[26]:

0.197418947221811

The 'score' method uses the 'y' attribute and the model prediction in the 'test_relation' to compute the accuracy of the model. You can change these attributes at any time to deploy the models on different columns.

You can access Pipeline models using indexes.

In [27]:

model[-1]

Out[27]:


=======
details
=======
predictor|coefficient|std_err | t_value |p_value 
---------+-----------+--------+---------+--------
Intercept|  5.81838  | 0.00971|599.43139| 0.00000
 alcohol |  0.38800  | 0.00971|39.97052 | 0.00000


==============
regularization
==============
type| lambda 
----+--------
none| 1.00000


===========
call_string
===========
linear_reg('public.LR_winequality', '"public"._VERTICAPY_TEMPORARY_VIEW_dbadmin_912240', '"quality"', '"alcohol"'
USING PARAMETERS optimizer='newton', epsilon=1e-06, max_iterations=100, regularization='none', lambda=1, alpha=0.5)

===============
Additional Info
===============
       Name       |Value
------------------+-----
 iteration_count  |  1  
rejected_row_count|  0  
accepted_row_count|6497

Models have many useful attributes. For example, the 'coef_' attribute of our last step gives us the p-value of the model.

In [28]:

model[-1].coef_

Out[28]:

	Abc predictor Varchar(65000)	123 coefficient Float	123 std_err Float	123 t_value Float	123 p_value Float
1	Intercept	5.81837771279052	0.0097064948926276	599.431388689008	0.0
2	alcohol	0.388003489835576	0.00970724197709228	39.9705179649595	1.496509342523e-312

Rows: 1-2 | Columns: 5

The 'report' method allows to evaluate the quality of our model.

In [30]:

model.report()

Out[30]:

	value
explained_variance	0.197418947221787
max_error	3.50420028103088
median_absolute_error	0.495799718969121
mean_absolute_error	0.618753622791327
mean_squared_error	0.611933859491369
root_mean_squared_error	0.7822620146033994
r2	0.197418947221811
r2_adj	0.1972953781605672

Rows: 1-8 | Columns: 2

The Pipeline's final estimator determines which methods you'll have available to you to apply on the vDataFrame. For example, if your Pipeline model's final estimator implements a prediction method, you can use the Pipeline's 'predict' method on your vDataFrame.

In [31]:

model.predict(winequality, 
              name = "pred_quality")

Out[31]:

	123 fixed_acidity Numeric(6,3)	123 volatile_acidity Numeric(7,4)	123 citric_acid Numeric(6,3)	123 residual_sugar Numeric(7,3)	123 chlorides Float	123 free_sulfur_dioxide Numeric(7,2)	123 total_sulfur_dioxide Numeric(7,2)	123 density Float	123 pH Numeric(6,3)	123 sulphates Numeric(6,3)	123 alcohol Float	123 quality Int	123 good Int	Abc color Varchar(20)	123 pred_quality Float
1	3.8	0.31	0.02	11.1	0.036	20.0	114.0	0.99248	3.75	0.44	1.59988293118889	6	0	white	6.43913787342018
2	3.9	0.225	0.4	4.2	0.03	29.0	118.0	0.989	3.57	0.36	1.93525314983446	8	1	white	6.56926268864158
3	4.2	0.17	0.36	1.8	0.029	93.0	161.0	0.98999	3.65	0.89	1.26451271254333	7	1	white	6.30901305819878
4	4.2	0.215	0.23	5.1	0.041	64.0	157.0	0.99688	3.42	0.44	-2.08918947391232	3	0	white	5.00776490598479
5	4.4	0.32	0.39	4.3	0.03	31.0	127.0	0.98904	3.46	0.36	1.93525314983446	8	1	white	6.56926268864158
6	4.4	0.46	0.1	2.8	0.024	31.0	111.0	0.98816	3.48	0.34	2.18678081381863	6	0	white	6.66685630005763
7	4.4	0.54	0.09	5.1	0.038	52.0	97.0	0.99022	3.41	0.4	1.43219782186611	7	1	white	6.37407546580948
8	4.5	0.19	0.21	0.95	0.033	89.0	159.0	0.99332	3.34	0.42	-2.08918947391232	5	0	white	5.00776490598479
9	4.6	0.445	0.0	1.4	0.053	11.0	178.0	0.99426	3.79	0.55	-0.244653271361713	5	0	white	5.72345138970248
10	4.6	0.52	0.15	2.1	0.054	8.0	65.0	0.9934	3.9	0.56	2.18678081381863	4	0	red	6.66685630005763
11	4.7	0.145	0.29	1.0	0.042	35.0	90.0	0.9908	3.76	0.49	0.677614829913591	6	0	white	6.08129463156133
12	4.7	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	0.00687439262246108	5	0	white	5.82104500111853
13	4.7	0.455	0.18	1.9	0.036	33.0	106.0	0.98746	3.21	0.83	2.94136380577115	7	1	white	6.95963713430578
14	4.7	0.6	0.17	2.3	0.058	17.0	106.0	0.9932	3.85	0.6	2.01909570449585	6	0	red	6.60179389244693
15	4.7	0.67	0.09	1.0	0.02	5.0	9.0	0.98722	3.3	0.34	2.60599358712559	5	0	white	6.82951231908438
16	4.7	0.785	0.0	3.4	0.036	23.0	134.0	0.98981	3.53	0.92	2.77367869644837	6	0	white	6.89457472669508
17	4.8	0.13	0.32	1.2	0.042	40.0	98.0	0.9898	3.42	0.64	1.09682760322055	7	1	white	6.24395065058808
18	4.8	0.17	0.28	2.9	0.03	22.0	111.0	0.9902	3.38	0.34	0.677614829913591	7	1	white	6.08129463156133
19	4.8	0.21	0.21	10.2	0.037	17.0	112.0	0.99324	3.66	0.48	1.43219782186611	7	1	white	6.37407546580948
20	4.8	0.225	0.38	1.2	0.074	47.0	130.0	0.99132	3.31	0.4	-0.160810716700321	6	0	white	5.75598259350783
21	4.8	0.26	0.23	10.6	0.034	23.0	111.0	0.99274	3.46	0.28	0.845299939236373	7	1	white	6.14635703917203
22	4.8	0.29	0.23	1.1	0.044	38.0	180.0	0.98924	3.28	0.34	1.18067015788194	6	0	white	6.27648185439343
23	4.8	0.33	0.0	6.5	0.028	34.0	163.0	0.9937	3.35	0.61	-0.496180935345886	5	0	white	5.62585777828644
24	4.8	0.34	0.0	6.5	0.028	33.0	163.0	0.9939	3.36	0.61	-0.496180935345886	6	0	white	5.62585777828644
25	4.8	0.65	0.12	1.1	0.013	4.0	10.0	0.99246	3.32	0.36	2.5221510324642	4	0	white	6.79698111527903
26	4.9	0.235	0.27	11.75	0.03	34.0	118.0	0.9954	3.07	0.5	-0.915393708652842	6	0	white	5.46320175925969
27	4.9	0.33	0.31	1.2	0.016	39.0	150.0	0.98713	3.33	0.59	2.94136380577115	8	1	white	6.95963713430578
28	4.9	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	-0.0210731255979743	5	0	white	5.81020126651676
29	4.9	0.335	0.14	1.3	0.036	69.0	168.0	0.99212	3.47	0.46	-0.0210731255979743	5	0	white	5.81020126651676
30	4.9	0.345	0.34	1.0	0.068	32.0	143.0	0.99138	3.24	0.4	-0.328495826023104	5	0	white	5.69092018589713
31	4.9	0.345	0.34	1.0	0.068	32.0	143.0	0.99138	3.24	0.4	-0.328495826023104	5	0	white	5.69092018589713
32	4.9	0.42	0.0	2.1	0.048	16.0	42.0	0.99154	3.71	0.74	2.94136380577115	7	1	red	6.95963713430578
33	4.9	0.47	0.17	1.9	0.035	60.0	148.0	0.98964	3.27	0.35	0.845299939236373	6	0	white	6.14635703917203
34	5.0	0.17	0.56	1.5	0.026	24.0	115.0	0.9906	3.48	0.39	0.258402056606635	7	1	white	5.91863861253458
35	5.0	0.2	0.4	1.9	0.015	20.0	98.0	0.9897	3.37	0.55	1.30643398987403	6	0	white	6.32527866010146
36	5.0	0.235	0.27	11.75	0.03	34.0	118.0	0.9954	3.07	0.5	-0.915393708652842	6	0	white	5.46320175925969
37	5.0	0.24	0.19	5.0	0.043	17.0	101.0	0.99438	3.67	0.57	-0.412338380684495	5	0	white	5.65838898209179
38	5.0	0.24	0.21	2.2	0.039	31.0	100.0	0.99098	3.69	0.62	1.01298504855915	6	0	white	6.21141944678273
39	5.0	0.24	0.34	1.1	0.034	49.0	158.0	0.98774	3.32	0.32	2.18678081381863	7	1	white	6.66685630005763
40	5.0	0.255	0.22	2.7	0.043	46.0	153.0	0.99238	3.75	0.76	0.677614829913591	6	0	white	6.08129463156133
41	5.0	0.27	0.32	4.5	0.032	58.0	178.0	0.98956	3.45	0.31	1.76756804051168	7	1	white	6.50420028103088
42	5.0	0.27	0.32	4.5	0.032	58.0	178.0	0.98956	3.45	0.31	1.76756804051168	7	1	white	6.50420028103088
43	5.0	0.27	0.4	1.2	0.076	42.0	124.0	0.99204	3.32	0.47	-0.328495826023104	6	0	white	5.69092018589713
44	5.0	0.29	0.54	5.7	0.035	54.0	155.0	0.98976	3.27	0.34	2.01909570449585	8	1	white	6.60179389244693
45	5.0	0.3	0.33	3.7	0.03	54.0	173.0	0.9887	3.36	0.3	2.10293825915724	7	1	white	6.63432509625228
46	5.0	0.31	0.0	6.4	0.046	43.0	166.0	0.994	3.3	0.63	-0.496180935345886	6	0	white	5.62585777828644
47	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	0.174559501945243	6	0	white	5.88610740872923
48	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	0.174559501945243	6	0	white	5.88610740872923
49	5.0	0.33	0.16	1.5	0.049	10.0	97.0	0.9917	3.48	0.44	0.174559501945243	6	0	white	5.88610740872923
50	5.0	0.33	0.18	4.6	0.032	40.0	124.0	0.99114	3.18	0.4	0.426087165929417	6	0	white	5.98370102014528
51	5.0	0.33	0.23	11.8	0.03	23.0	158.0	0.99322	3.41	0.64	1.09682760322055	6	0	white	6.24395065058808
52	5.0	0.35	0.25	7.8	0.031	24.0	116.0	0.99241	3.39	0.4	0.677614829913591	6	0	white	6.08129463156133
53	5.0	0.35	0.25	7.8	0.031	24.0	116.0	0.99241	3.39	0.4	0.677614829913591	6	0	white	6.08129463156133
54	5.0	0.38	0.01	1.6	0.048	26.0	60.0	0.99084	3.7	0.75	2.94136380577115	6	0	red	6.95963713430578
55	5.0	0.4	0.5	4.3	0.046	29.0	80.0	0.9902	3.49	0.66	2.60599358712559	6	0	red	6.82951231908438
56	5.0	0.42	0.24	2.0	0.06	19.0	50.0	0.9917	3.72	0.74	2.94136380577115	8	1	red	6.95963713430578
57	5.0	0.44	0.04	18.6	0.039	38.0	128.0	0.9985	3.37	0.57	-0.244653271361713	6	0	white	5.72345138970248
58	5.0	0.455	0.18	1.9	0.036	33.0	106.0	0.98746	3.21	0.83	2.94136380577115	7	1	white	6.95963713430578
59	5.0	0.55	0.14	8.3	0.032	35.0	164.0	0.9918	3.53	0.51	1.68372548585029	8	1	white	6.47166907722553
60	5.0	0.61	0.12	1.3	0.009	65.0	100.0	0.9874	3.26	0.37	2.5221510324642	5	0	white	6.79698111527903
61	5.0	0.74	0.0	1.2	0.041	16.0	46.0	0.99258	4.01	0.59	1.68372548585029	6	0	red	6.47166907722553
62	5.0	1.02	0.04	1.4	0.045	41.0	85.0	0.9938	3.75	0.48	0.00687439262246108	4	0	red	5.82104500111853
63	5.0	1.04	0.24	1.6	0.05	32.0	96.0	0.9934	3.74	0.62	0.845299939236373	5	0	red	6.14635703917203
64	5.1	0.11	0.32	1.6	0.028	12.0	90.0	0.99008	3.57	0.52	1.43219782186611	6	0	white	6.37407546580948
65	5.1	0.14	0.25	0.7	0.039	15.0	89.0	0.9919	3.22	0.43	-1.08307881797563	6	0	white	5.39813935164899
66	5.1	0.165	0.22	5.7	0.047	42.0	146.0	0.9934	3.18	0.55	-0.496180935345886	6	0	white	5.62585777828644
67	5.1	0.21	0.28	1.4	0.047	48.0	148.0	0.99168	3.5	0.49	-0.0769681620389298	5	0	white	5.78851379731318
68	5.1	0.23	0.18	1.0	0.053	13.0	99.0	0.98956	3.22	0.39	0.845299939236373	5	0	white	6.14635703917203
69	5.1	0.25	0.36	1.3	0.035	40.0	78.0	0.9891	3.23	0.64	1.34835526720472	7	1	white	6.34154426200413
70	5.1	0.26	0.33	1.1	0.027	46.0	113.0	0.98946	3.35	0.43	0.761457384574982	7	1	white	6.11382583536668
71	5.1	0.26	0.34	6.4	0.034	26.0	99.0	0.99449	3.23	0.41	-1.08307881797563	6	0	white	5.39813935164899
72	5.1	0.29	0.28	8.3	0.026	27.0	107.0	0.99308	3.36	0.37	0.426087165929417	6	0	white	5.98370102014528
73	5.1	0.29	0.28	8.3	0.026	27.0	107.0	0.99308	3.36	0.37	0.426087165929417	6	0	white	5.98370102014528
74	5.1	0.3	0.3	2.3	0.048	40.0	150.0	0.98944	3.29	0.46	1.43219782186611	6	0	white	6.37407546580948
75	5.1	0.305	0.13	1.75	0.036	17.0	73.0	0.99	3.4	0.51	1.54398789474794	5	0	white	6.4174504042166
76	5.1	0.31	0.3	0.9	0.037	28.0	152.0	0.992	3.54	0.56	-0.328495826023104	6	0	white	5.69092018589713
77	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	1.68372548585029	7	1	white	6.47166907722553
78	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	1.68372548585029	7	1	white	6.47166907722553
79	5.1	0.33	0.22	1.6	0.027	18.0	89.0	0.9893	3.51	0.38	1.68372548585029	7	1	white	6.47166907722553
80	5.1	0.33	0.27	6.7	0.022	44.0	129.0	0.99221	3.36	0.39	0.426087165929417	7	1	white	5.98370102014528
81	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	0.845299939236373	6	0	white	6.14635703917203
82	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	0.845299939236373	6	0	white	6.14635703917203
83	5.1	0.35	0.26	6.8	0.034	36.0	120.0	0.99188	3.38	0.4	0.845299939236373	6	0	white	6.14635703917203
84	5.1	0.39	0.21	1.7	0.027	15.0	72.0	0.9894	3.5	0.45	1.68372548585029	6	0	white	6.47166907722553
85	5.1	0.42	0.0	1.8	0.044	18.0	88.0	0.99157	3.68	0.73	2.60599358712559	7	1	red	6.82951231908438
86	5.1	0.42	0.01	1.5	0.017	25.0	102.0	0.9894	3.38	0.36	1.5160403765275	7	1	white	6.40660666961483
87	5.1	0.47	0.02	1.3	0.034	18.0	44.0	0.9921	3.9	0.62	1.93525314983446	6	0	red	6.56926268864158
88	5.1	0.51	0.18	2.1	0.042	16.0	101.0	0.9924	3.46	0.87	2.01909570449585	7	1	red	6.60179389244693
89	5.1	0.52	0.06	2.7	0.052	30.0	79.0	0.9932	3.32	0.43	-0.999236263314233	5	0	white	5.43067055545434
90	5.1	0.585	0.0	1.7	0.044	14.0	86.0	0.99264	3.56	0.94	2.01909570449585	7	1	red	6.60179389244693
91	5.2	0.155	0.33	1.6	0.028	13.0	59.0	0.98975	3.3	0.84	1.18067015788194	8	1	white	6.27648185439343
92	5.2	0.155	0.33	1.6	0.028	13.0	59.0	0.98975	3.3	0.84	1.18067015788194	8	1	white	6.27648185439343
93	5.2	0.16	0.34	0.8	0.029	26.0	77.0	0.99155	3.25	0.51	-0.328495826023104	6	0	white	5.69092018589713
94	5.2	0.17	0.27	0.7	0.03	11.0	68.0	0.99218	3.3	0.41	-0.580023490007277	5	0	white	5.59332657448109
95	5.2	0.185	0.22	1.0	0.03	47.0	123.0	0.99218	3.55	0.44	-0.286574548692408	6	0	white	5.70718578779981
96	5.2	0.2	0.27	3.2	0.047	16.0	93.0	0.99235	3.44	0.53	-0.328495826023104	7	1	white	5.69092018589713
97	5.2	0.21	0.31	1.7	0.048	17.0	61.0	0.98953	3.24	0.37	1.26451271254333	7	1	white	6.30901305819878
98	5.2	0.22	0.46	6.2	0.066	41.0	187.0	0.99362	3.19	0.42	-0.635918526448207	5	0	white	5.57163910527752
99	5.2	0.24	0.15	7.1	0.043	32.0	134.0	0.99378	3.24	0.48	-0.496180935345886	6	0	white	5.62585777828644
100	5.2	0.24	0.45	3.8	0.027	21.0	128.0	0.992	3.55	0.49	0.593772275252199	8	1	white	6.04876342775598

Rows: 1-100 | Columns: 15