Loading...

verticapy.machine_learning.vertica.svm.LinearSVC.predict

LinearSVC.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, cutoff: Annotated[int | float | Decimal, 'Python Numbers'] = 0.5, inplace: bool = True) → vDataFrame

Makes predictions on 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 vDataColumn. If empty, a name is generated.

cutoff: float, optional

Probability cutoff.

inplace: bool, optional

If set to True, the prediction is added to the vDataFrame.

Returns

vDataFrame

the input object.

Examples

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
train, test = data.train_test_split(test_size = 0.5)

Let’s import the model:

from verticapy.machine_learning.vertica import LogisticRegression

Then we can create the model:

model = LogisticRegression(
    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",
    ],
    "good",
    test,
)



=======
details
=======
   predictor    |coefficient|std_err | z_value |p_value 
----------------+-----------+--------+---------+--------
   Intercept    | 410.16528 |30.72445|13.34980 | 0.00000
 fixed_acidity  |  0.46087  | 0.05457| 8.44495 | 0.00000
volatile_acidity| -1.48014  | 0.42430|-3.48839 | 0.00049
  citric_acid   |  0.05850  | 0.43788| 0.13360 | 0.89372
 residual_sugar |  0.11873  | 0.01745| 6.80446 | 0.00000
   chlorides    | -1.23271  | 2.28219|-0.54014 | 0.58910
    density     |-417.45292 |31.26224|-13.35326| 0.00000


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


===========
call_string
===========
logistic_reg('"public"."_verticapy_tmp_logisticregression_v_mldb_13e8c6c2979c11efa8720242ac120002_"', '"public"."_verticapy_tmp_view_v_mldb_143def08979c11efa8720242ac120002_"', '"good"', '"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  |  5  
rejected_row_count|  0  
accepted_row_count|3248 
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
Integer
14.70.3350.141.30.03669.0168.00.992123.470.4610.550white0
24.70.7850.03.40.03623.0134.00.989813.530.9213.860white0
34.90.3450.341.00.06832.0143.00.991383.240.410.150white0
44.90.420.02.10.04816.042.00.991543.710.7414.071red0
55.00.440.0418.60.03938.0128.00.99853.370.5710.260white0
65.10.140.250.70.03915.089.00.99193.220.439.260white0
75.10.330.221.60.02718.089.00.98933.510.3812.571white0
85.20.210.311.70.04817.061.00.989533.240.3712.071white0
95.20.220.466.20.06641.0187.00.993623.190.429.7333333333333350white0
105.20.310.22.40.02727.0117.00.988863.560.4513.071white0
115.20.50.182.00.03623.0129.00.989493.360.7713.471white0
125.30.30.31.20.02925.093.00.987423.310.413.671white1
135.30.360.276.30.02840.0132.00.991863.370.411.660white0
145.30.360.276.30.02840.0132.00.991863.370.411.660white0
155.30.470.112.20.04816.089.00.991823.540.8813.671red0
165.30.470.112.20.04816.089.00.991823.540.8813.566666666666771red0
175.30.7150.191.50.1617.062.00.993953.620.6111.050red0
185.40.220.291.20.04569.0152.00.991783.760.6311.071white0
195.40.5950.12.80.04226.080.00.99323.360.389.350white0
205.40.740.091.70.08916.026.00.994023.670.5611.660red0
215.50.160.311.20.02631.068.00.98983.330.4411.633333333333360white0
225.50.240.451.70.04622.0113.00.992243.220.4810.050white0
235.50.310.293.00.02716.0102.00.990673.230.5611.260white0
245.50.350.351.10.04514.0167.00.9923.340.689.960white0
255.50.3750.381.70.03617.098.00.991423.290.3910.560white0
265.60.160.271.40.04453.0168.00.99183.280.3710.160white0
275.60.1750.290.80.04320.067.00.991123.280.489.960white0
285.60.260.181.40.03418.0135.00.991743.320.3510.260white0
295.60.490.134.50.03917.0116.00.99073.420.913.771white0
305.60.660.02.20.0873.011.00.993783.710.6312.871red0
315.60.660.02.20.0873.011.00.993783.710.6312.871red0
325.70.180.361.20.0469.071.00.991993.70.6810.971white0
335.70.20.32.50.04638.0125.00.992763.340.59.960white0
345.70.210.320.90.03838.0121.00.990743.240.4610.660white0
355.70.210.374.50.0458.0140.00.993323.290.6210.660white0
365.70.220.216.00.04441.0113.00.998623.220.468.960white0
375.70.220.216.00.04441.0113.00.998623.220.468.960white0
385.70.220.216.00.04441.0113.00.998623.220.468.960white0
395.70.220.293.50.0427.0146.00.989993.170.3612.160white0
405.70.250.2612.50.04952.5120.00.996913.080.459.460white0
415.70.260.2417.80.05923.0124.00.997733.30.510.150white0
425.70.260.2417.80.05923.0124.00.997733.30.510.150white0
435.70.260.2417.80.05923.0124.00.997733.30.510.150white0
445.70.280.2417.50.04460.0167.00.99893.310.449.450white0
455.80.140.156.10.04227.0123.00.993623.060.69.960white0
465.80.150.321.20.03714.0119.00.991373.190.510.260white0
475.80.170.341.80.04596.0170.00.990353.380.911.881white0
485.80.220.290.90.03434.089.00.989363.140.3611.171white0
495.80.220.291.30.03625.068.00.988653.240.3512.660white0
505.80.220.31.10.04736.0131.00.9923.260.4510.450white0
515.80.260.291.00.04235.0101.00.990443.360.4811.471white0
525.80.280.181.20.0587.0108.00.992883.230.589.5540white0
535.80.290.212.60.02512.0120.00.98943.390.7914.071white0
545.80.290.333.70.02930.088.00.989943.250.4212.360white0
555.80.320.22.60.02717.0123.00.989363.360.7813.971white0
565.80.320.284.30.03246.0115.00.989463.160.5713.081white0
575.80.320.284.30.03246.0115.00.989463.160.5713.081white0
585.80.320.384.750.03323.094.00.9913.420.4211.871white0
595.90.150.315.80.04153.0155.00.99453.520.4610.560white0
605.90.170.31.40.04225.0119.00.99313.680.7210.560white0
615.90.190.211.70.04557.0135.00.993413.320.449.550white0
625.90.190.370.80.0273.021.00.98973.090.3110.850white0
635.90.210.237.90.03322.0130.00.99443.380.5910.960white0
645.90.220.186.40.04128.0120.00.994033.270.59.950white0
655.90.230.243.80.03861.0152.00.991393.310.511.371white0
665.90.260.242.40.04627.0132.00.992343.630.7311.350white0
675.90.290.337.40.03758.0205.00.994953.260.419.650white0
685.90.340.33.80.03557.0135.00.990163.090.3412.060white0
695.90.620.283.50.03955.0152.00.99073.440.4412.060white0
705.90.6550.05.60.0338.031.00.99363.320.5110.540white0
716.00.160.36.70.04343.0153.00.99513.630.4610.650white0
726.00.160.36.70.04343.0153.00.99513.630.4610.650white0
736.00.190.291.10.04767.0152.00.99163.540.5911.171white0
746.00.20.266.80.04922.093.00.99283.150.4211.060white0
756.00.20.266.80.04922.093.00.99283.150.4211.060white0
766.00.20.266.80.04922.093.00.99283.150.4211.060white0
776.00.20.266.80.04922.093.00.99283.150.4211.060white0
786.00.210.2412.10.0555.0164.00.9973.340.399.450white0
796.00.210.380.80.0222.098.00.989413.260.3211.860white0
806.00.250.45.70.05256.0152.00.993983.160.8810.560white0
816.00.260.241.30.05366.0150.00.99243.210.6210.460white0
826.00.260.323.80.02948.0180.00.990113.150.3412.060white0
836.00.260.52.20.04859.0153.00.99283.080.619.850white0
846.00.270.191.70.0224.0110.00.98983.320.4712.671white0
856.00.280.2212.150.04842.0163.00.99573.20.4610.150white0
866.00.280.2715.50.03631.0134.00.994083.190.4413.071white0
876.00.30.332.10.04231.0127.00.989643.320.4212.560white0
886.00.330.389.70.0429.0124.00.99543.470.4811.060white0
896.00.360.166.30.03636.0191.00.99423.170.629.850white0
906.00.390.131.20.04260.0172.00.991143.060.5210.650white0
916.00.390.1712.00.04665.0246.00.99763.150.389.060white0
926.00.40.31.60.04730.0117.00.99313.170.4810.160white0
936.00.410.211.90.0529.0122.00.99283.420.5210.560white0
946.00.590.00.80.03730.095.00.990323.10.410.940white0
956.00.670.071.20.069.0108.00.99313.110.358.740white0
966.10.1050.311.30.03755.0145.00.99123.410.4111.171white0
976.10.140.251.30.04737.0173.00.99253.350.4610.060white0
986.10.160.241.40.04617.077.00.993193.660.5710.360white0
996.10.20.349.50.04138.0201.00.9953.140.4410.130white0
1006.10.220.41.850.03125.0111.00.989663.030.311.871white0
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.