Loading...

verticapy.machine_learning.vertica.neighbors.KernelDensity.predict

KernelDensity.predict(vdf: Annotated[str | vDataFrame, ''], X: Annotated[str | list[str], 'STRING representing one column or a list of columns'] | None = None, name: str | None = None, inplace: bool = True) → vDataFrame

Predicts using the input relation.

Parameters

vdf: SQLRelation

Object used to run the prediction. You can also specify a customized relation, but you must enclose it with an alias. For example, (SELECT 1) x is valid, whereas (SELECT 1) and SELECT 1 are invalid.

X: SQLColumns, optional

list of the columns used to deploy the models. If empty, the model predictors are used.

name: str, optional

Name of the added :py:class`vDataColumn`. If empty, a name is generated.

inplace: bool, optional

If set to True, the prediction is added to the :py:class`vDataFrame`.

Returns

vDataFrame

the input object.

Examples

We import verticapy:

import verticapy as vp

For this example, we will use the winequality dataset.

import verticapy.datasets as vpd

data = vpd.load_winequality()
123
fixed_acidity
Numeric(8)
123
volatile_acidity
Numeric(9)
123
citric_acid
Numeric(8)
123
residual_sugar
Numeric(9)
123
chlorides
Float(22)
123
free_sulfur_dioxide
Numeric(9)
123
total_sulfur_dioxide
Numeric(9)
123
density
Float(22)
123
pH
Numeric(8)
123
sulphates
Numeric(8)
123
alcohol
Float(22)
123
quality
Integer
123
good
Integer
Abc
color
Varchar(20)
13.90.2250.44.20.0329.0118.00.9893.570.3612.881white
24.70.3350.141.30.03669.0168.00.992123.470.4610.550white
34.70.4550.181.90.03633.0106.00.987463.210.8314.071white
44.70.7850.03.40.03623.0134.00.989813.530.9213.860white
54.90.3450.341.00.06832.0143.00.991383.240.410.150white
64.90.3450.341.00.06832.0143.00.991383.240.410.150white
74.90.420.02.10.04816.042.00.991543.710.7414.071red
85.00.270.41.20.07642.0124.00.992043.320.4710.160white
95.00.310.06.40.04643.0166.00.9943.30.639.960white
105.00.40.54.30.04629.080.00.99023.490.6613.660red
115.00.440.0418.60.03938.0128.00.99853.370.5710.260white
125.10.110.321.60.02812.090.00.990083.570.5212.260white
135.10.140.250.70.03915.089.00.99193.220.439.260white
145.10.1650.225.70.04742.0146.00.99343.180.559.960white
155.10.330.221.60.02718.089.00.98933.510.3812.571white
165.10.330.221.60.02718.089.00.98933.510.3812.571white
175.10.330.221.60.02718.089.00.98933.510.3812.571white
185.10.390.211.70.02715.072.00.98943.50.4512.560white
195.20.20.273.20.04716.093.00.992353.440.5310.171white
205.20.210.311.70.04817.061.00.989533.240.3712.071white
215.20.220.466.20.06641.0187.00.993623.190.429.7333333333333350white
225.20.310.22.40.02727.0117.00.988863.560.4513.071white
235.20.320.251.80.10313.050.00.99573.380.559.250red
245.20.340.376.20.03142.0133.00.990763.250.4112.560white
255.20.360.021.60.03124.0104.00.98963.440.3512.260white
265.20.3650.0813.50.04137.0142.00.9973.460.399.960white
275.20.480.041.60.05419.0106.00.99273.540.6212.271red
285.20.50.182.00.03623.0129.00.989493.360.7713.471white
295.30.160.391.00.02840.0101.00.991563.570.5910.660white
305.30.160.391.00.02840.0101.00.991563.570.5910.660white
315.30.1650.241.10.05125.0105.00.99253.320.479.150white
325.30.230.560.90.04146.0141.00.991193.160.629.750white
335.30.30.31.20.02925.093.00.987423.310.413.671white
345.30.330.31.20.04825.0119.00.990453.320.6211.360white
355.30.360.276.30.02840.0132.00.991863.370.411.660white
365.30.360.276.30.02840.0132.00.991863.370.411.660white
375.30.40.253.90.03145.0130.00.990723.310.5811.7571white
385.30.470.112.20.04816.089.00.991823.540.8813.671red
395.30.470.112.20.04816.089.00.991823.540.8813.566666666666771red
405.30.7150.191.50.1617.062.00.993953.620.6111.050red
415.40.220.291.20.04569.0152.00.991783.760.6311.071white
425.40.5950.12.80.04226.080.00.99323.360.389.350white
435.40.740.091.70.08916.026.00.994023.670.5611.660red
445.50.120.331.00.03823.0131.00.991643.250.459.850white
455.50.120.331.00.03823.0131.00.991643.250.459.850white
465.50.140.274.60.02922.0104.00.99493.340.449.050white
475.50.140.274.60.02922.0104.00.99493.340.449.050white
485.50.160.311.20.02631.068.00.98983.330.4411.6560white
495.50.160.311.20.02631.068.00.98983.330.4411.633333333333360white
505.50.180.225.50.03710.086.00.991563.460.4412.250white
515.50.240.451.70.04622.0113.00.992243.220.4810.050white
525.50.290.31.10.02220.0110.00.988693.340.3812.871white
535.50.310.293.00.02716.0102.00.990673.230.5611.260white
545.50.320.454.90.02825.0191.00.99223.510.4911.571white
555.50.350.351.10.04514.0167.00.9923.340.689.960white
565.50.3750.381.70.03617.098.00.991423.290.3910.560white
575.60.150.265.550.05151.0139.00.993363.470.511.060white
585.60.150.315.30.0388.079.00.99233.30.3910.560white
595.60.160.271.40.04453.0168.00.99183.280.3710.160white
605.60.1750.290.80.04320.067.00.991123.280.489.960white
615.60.1850.197.10.04836.0110.00.994383.260.419.560white
625.60.1850.197.10.04836.0110.00.994383.260.419.560white
635.60.220.321.20.02429.097.00.988233.20.4613.0571white
645.60.260.181.40.03418.0135.00.991743.320.3510.260white
655.60.260.265.70.03112.080.00.99233.250.3810.850white
665.60.260.511.40.02925.093.00.994283.230.4910.560white
675.60.280.284.20.04452.0158.00.9923.350.4410.771white
685.60.30.16.40.04334.0142.00.993823.140.489.850white
695.60.350.145.00.04648.0198.00.99373.30.7110.350white
705.60.490.134.50.03917.0116.00.99073.420.913.771white
715.60.490.134.50.03917.0116.00.99073.420.913.771white
725.60.660.02.20.0873.011.00.993783.710.6312.871red
735.60.660.02.20.0873.011.00.993783.710.6312.871red
745.70.150.4711.40.03549.0128.00.994563.030.3410.581white
755.70.180.262.20.02321.095.00.98933.070.5412.360white
765.70.180.361.20.0469.071.00.991993.70.6810.971white
775.70.20.32.50.04638.0125.00.992763.340.59.960white
785.70.210.320.90.03838.0121.00.990743.240.4610.660white
795.70.210.374.50.0458.0140.00.993323.290.6210.660white
805.70.220.216.00.04441.0113.00.998623.220.468.960white
815.70.220.216.00.04441.0113.00.998623.220.468.960white
825.70.220.216.00.04441.0113.00.998623.220.468.960white
835.70.220.216.00.04441.0113.00.998623.220.468.960white
845.70.220.216.00.04441.0113.00.998623.220.468.960white
855.70.220.293.50.0427.0146.00.989993.170.3612.160white
865.70.230.289.650.02526.0121.00.99253.280.3811.360white
875.70.250.2612.50.04952.5106.00.996913.080.459.460white
885.70.250.2612.50.04952.5120.00.996913.080.459.460white
895.70.250.2711.50.0424.0120.00.994113.330.3110.860white
905.70.260.2417.80.05923.0124.00.997733.30.510.150white
915.70.260.2417.80.05923.0124.00.997733.30.510.150white
925.70.260.2417.80.05923.0124.00.997733.30.510.150white
935.70.270.321.20.04620.0155.00.99343.80.4110.260white
945.70.280.2417.50.04460.0167.00.99893.310.449.450white
955.70.320.181.40.02926.0104.00.99063.440.3711.060white
965.70.320.384.750.03323.094.00.9913.420.4211.871white
975.70.360.344.20.02621.077.00.99073.410.4511.960white
985.80.140.156.10.04227.0123.00.993623.060.69.960white
995.80.150.321.20.03714.0119.00.991373.190.510.260white
1005.80.170.341.80.04596.0170.00.990353.380.911.881white
Rows: 1-100 | Columns: 14

Divide your dataset into training and testing subsets.

data = vpd.load_winequality()
train, test = data.train_test_split(test_size = 0.2)

Let’s import the model:

from verticapy.machine_learning.vertica import LinearRegression

Then we can create the model:

model = LinearRegression(
    tol = 1e-6,
    max_iter = 100,
    solver = 'newton',
    fit_intercept = True,
)

We can now fit the model:

model.fit(
    train,
    [
        "fixed_acidity",
        "volatile_acidity",
        "citric_acid",
        "residual_sugar",
        "chlorides",
        "density",
    ],
    "quality",
    test,
)



=======
details
=======
   predictor    |coefficient|std_err | t_value |p_value 
----------------+-----------+--------+---------+--------
   Intercept    | 147.96958 | 6.90075|21.44254 | 0.00000
 fixed_acidity  |  0.13966  | 0.01235|11.30735 | 0.00000
volatile_acidity| -0.73953  | 0.08821|-8.38390 | 0.00000
  citric_acid   | -0.18589  | 0.09424|-1.97259 | 0.04860
 residual_sugar |  0.04465  | 0.00386|11.57838 | 0.00000
   chlorides    | -0.14789  | 0.39129|-0.37796 | 0.70547
    density     |-143.84513 | 7.01850|-20.49513| 0.00000


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


===========
call_string
===========
linear_reg('"public"."_verticapy_tmp_linearregression_v_mldb_0805330a979b11efa8720242ac120002_"', '"public"."_verticapy_tmp_view_v_mldb_084795a6979b11efa8720242ac120002_"', '"quality"', '"fixed_acidity", "volatile_acidity", "citric_acid", "residual_sugar", "chlorides", "density"'
USING PARAMETERS optimizer='newton', epsilon=1e-06, max_iterations=100, regularization='none', lambda=1, alpha=0.5, fit_intercept=true)

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

Prediction is straight-forward:

model.predict(
    test,
    [
        "fixed_acidity",
        "volatile_acidity",
        "citric_acid",
        "residual_sugar",
        "chlorides",
        "density",
    ],
    "prediction",
)
123
fixed_acidity
Numeric(8)
123
volatile_acidity
Numeric(9)
123
citric_acid
Numeric(8)
123
residual_sugar
Numeric(9)
123
chlorides
Float(22)
123
free_sulfur_dioxide
Numeric(9)
123
total_sulfur_dioxide
Numeric(9)
123
density
Float(22)
123
pH
Numeric(8)
123
sulphates
Numeric(8)
123
alcohol
Float(22)
123
quality
Integer
123
good
Integer
Abc
color
Varchar(20)
123
prediction
Float(22)
14.90.470.171.90.03560.0148.00.989643.270.3511.560white5.99948797141519
25.00.610.121.30.00965.0100.00.98743.260.3713.550white6.21847881560126
35.10.250.361.30.03540.078.00.98913.230.6412.171white6.20568064244034
45.10.260.346.40.03426.099.00.994493.230.419.260white5.65456458400391
55.10.350.266.80.03436.0120.00.991883.380.411.560white5.99617552502613
65.20.1850.221.00.0347.0123.00.992183.550.4410.1560white5.838040864167
75.20.280.291.10.02818.069.00.991683.240.5410.060white5.83145648817242
85.20.4050.151.450.03810.044.00.991253.520.411.640white5.84104322788335
95.20.60.077.00.04433.0147.00.99443.330.589.750white5.50553931644524
105.30.240.331.30.03325.097.00.99063.590.3811.081white6.0311119227004
115.30.5850.077.10.04434.0145.00.99453.340.579.760white5.52067882397802
125.30.760.032.70.04327.093.00.99323.340.389.250white5.38936206746712
135.40.290.381.20.02931.0132.00.988953.280.3612.460white6.23227671447282
145.50.160.261.50.03235.0100.00.990763.430.7712.060white6.1172817882092
155.60.190.261.40.0312.076.00.99053.250.3710.971white6.14229135608301
165.60.270.370.90.02511.049.00.988453.290.3313.160white6.33597513415077
175.60.280.273.90.04352.0158.00.992023.350.4410.771white5.96494383157082
185.60.6950.066.80.0429.084.00.994323.440.4410.250white5.49587712092705
195.70.220.2216.650.04439.0110.00.998553.240.489.060white5.66246641724103
205.70.310.297.30.0533.0143.00.993323.310.511.066666666666760white5.91679745451427
215.70.370.31.10.02924.088.00.988833.180.3911.760white6.24267792283393
225.70.3850.0412.60.03422.0115.00.99643.280.639.960white5.70379841263946
235.70.450.421.10.05161.0197.00.99323.020.49.050white5.52935130987382
245.80.20.31.50.03121.057.00.991153.440.5511.060white6.06620965609778
255.80.210.321.60.04538.095.00.989463.230.9412.481white6.3005897162426
265.80.240.391.50.05437.0158.00.99323.210.529.360white5.72161397506747
275.80.250.2811.10.05645.0175.00.997553.420.439.550white5.5373294479329
285.80.260.249.20.04455.0152.00.99613.310.389.450white5.66287606728093
295.80.280.272.60.05430.0156.00.99143.530.4212.450white6.02238101849466
305.80.360.263.30.03840.0153.00.99113.340.5511.360white6.04185528254678
315.80.360.51.00.12763.0178.00.992123.10.459.750white5.73465103594032
325.80.380.261.10.05820.0140.00.992713.270.439.760white5.69427584355003
335.90.20.231.50.03738.093.00.990213.360.4912.060white6.22751471110544
345.90.250.1912.40.04750.0162.00.99733.350.389.550white5.66336865009134
355.90.250.271.50.02937.081.00.98923.20.4612.260white6.32956903505507
365.90.270.279.00.05143.0136.00.99413.250.5310.760white5.94159358268075
375.90.360.045.70.04621.087.00.99343.220.5110.250white5.87186134666095
385.90.4150.131.40.0411.064.00.99223.290.5210.550white5.79594313118093
395.90.650.235.00.03520.0128.00.990163.460.4812.860white6.05850370739313
406.00.240.411.30.03642.0118.00.990183.040.6411.733333333333360white6.17397062484679
416.00.280.2417.80.04742.0111.00.998963.10.458.960white5.64820583660983
426.00.330.265.10.05116.0119.00.994163.150.419.250white5.73026209933312
436.00.330.265.10.05116.0119.00.994163.150.419.250white5.73026209933312
446.00.340.6615.90.04626.0164.00.99793.140.58.860white5.5935389783854
456.00.360.393.20.02720.0125.00.9913.380.3911.371white6.05716625358966
466.00.420.192.00.07522.047.00.995223.390.7810.060red5.38226177007482
476.00.450.421.10.05161.0197.00.99323.020.49.050white5.57124793474205
486.10.180.382.30.03328.0111.00.989623.160.4912.460white6.36353658924236
496.10.240.329.00.03141.0134.00.992343.250.2612.371white6.23854135084653
506.10.250.1810.50.04941.0124.00.99633.140.3510.550white5.75186413609885
516.10.260.512.20.0561.0154.00.99293.080.69.860white5.80141623797874
526.10.340.251.80.0844.028.00.994643.360.4410.150red5.51740473165196
536.10.340.464.70.02921.094.00.9913.290.6212.360white6.13959624419334
546.10.380.143.90.0627.0113.00.993443.070.349.240white5.77820985022944
556.10.40.161.80.06911.025.00.99553.420.7410.171red5.36827454088856
566.10.410.01.60.06336.087.00.99143.270.6710.860white5.97234337412766
576.10.560.02.20.0796.09.00.99483.590.5411.560red5.39676634457021
586.20.190.294.30.04533.0126.00.996583.180.429.360white5.47320961399666
596.20.20.335.40.02821.075.00.990123.360.4113.571white6.43925240646348
606.20.240.2512.50.05547.0134.00.997583.30.519.050white5.66451278604936
616.20.250.4415.80.05739.0167.00.998043.140.519.250white5.70269379696859
626.20.30.2613.40.04657.0206.00.997753.170.439.560white5.63534837022647
636.20.370.246.10.03219.086.00.989343.040.2613.481white6.47312778431368
646.20.370.36.60.34679.0200.00.99543.290.589.650white5.56616202491094
656.20.460.292.10.07432.098.00.995783.330.629.850red5.28608236610339
666.20.580.01.60.0658.018.00.99663.560.849.450red5.11229766392779
676.30.210.281.50.05146.0142.00.99283.230.4210.160white5.8920575638202
686.30.240.558.10.0467.0216.00.995963.240.59.250white5.66147766833771
696.30.280.296.80.05140.0143.00.993743.430.5911.060white5.93988655131733
706.30.320.2612.30.04424.0205.00.996113.110.589.950white5.82160489146352
716.30.330.217.90.06636.0161.00.99913.140.518.850white5.64207863743061
726.30.390.246.90.0699.0117.00.99423.150.3510.240white5.80346705034245
736.30.410.160.90.03225.098.00.992743.160.429.550white5.75110564139794
746.30.680.013.70.10332.054.00.995863.510.6611.360red5.2450511612569
756.40.130.471.60.09240.0158.00.99283.210.369.860white5.92826823524092
766.40.150.291.80.04421.0115.00.991663.10.3810.250white6.12695132212812
776.40.180.329.60.05224.090.00.99633.350.499.460white5.77887038633153
786.40.260.225.10.03723.0131.00.99443.290.3210.150white5.81287499740606
796.40.290.243.20.03731.095.00.989422.90.6612.671white6.41847600404947
806.40.290.443.60.275.0181.00.99423.020.419.150white5.68747334484638
816.40.310.091.40.06615.028.00.994593.420.710.071red5.60322256150008
826.40.310.281.50.03712.0119.00.99193.320.5110.471white5.96360079330651
836.40.380.268.20.04328.098.00.992342.990.3111.460white6.15055828427035
846.40.420.468.40.0558.0180.00.994953.180.469.760white5.71625840791697
856.40.550.269.60.02720.0104.00.99243.220.7313.160white6.0810895728238
866.50.170.548.50.08264.0163.00.99592.890.398.860white5.76331617124816
876.50.240.3917.30.05222.0126.00.998883.110.479.260white5.70817191644264
886.50.270.196.60.04598.0175.00.993643.160.3410.160white6.00014311644688
896.50.280.268.80.0444.0139.00.99563.320.3710.260white5.79677860017847
906.50.280.343.60.0429.0121.00.991113.280.4812.171white6.19556760315498
916.50.320.1211.50.03335.0165.00.99743.220.329.050white5.65590373317167
926.50.320.231.20.05439.0208.00.992723.180.469.960white5.84560202962354
936.50.430.313.60.04619.0143.00.990223.150.3412.081white6.21734905428767
946.50.520.111.80.07313.038.00.99553.340.529.350red5.34409564538797
956.50.580.02.20.0963.013.00.995573.620.6211.540red5.3245629156354
966.60.160.41.50.04448.0143.00.99123.540.5212.471white6.17981129416142
976.60.170.352.60.0333.078.00.991463.220.7211.360white6.19550144225792
986.60.240.2710.30.04754.0219.00.997423.040.458.850white5.6426152068903
996.60.260.2218.150.0523.0139.00.999043.060.59.250white5.75418545712085
1006.60.260.2511.60.04545.0178.00.996913.330.439.860white5.76325022757339
Rows: 1-100 | Columns: 15

Important

For this example, a specific model is utilized, and it may not correspond exactly to the model you are working with. To see a comprehensive example specific to your class of interest, please refer to that particular class.