Loading...

verticapy.machine_learning.vertica.svm.LinearSVR.predict#

LinearSVR.predict(vdf: str | vDataFrame, X: str | list[str] | 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.80.310.0211.10.03620.0114.00.992483.750.4412.460white
23.90.2250.44.20.0329.0118.00.9893.570.3612.881white
34.20.170.361.80.02993.0161.00.989993.650.8912.071white
44.20.2150.235.10.04164.0157.00.996883.420.448.030white
54.40.320.394.30.0331.0127.00.989043.460.3612.881white
64.40.460.12.80.02431.0111.00.988163.480.3413.160white
74.40.540.095.10.03852.097.00.990223.410.412.271white
84.50.190.210.950.03389.0159.00.993323.340.428.050white
94.60.4450.01.40.05311.0178.00.994263.790.5510.250white
104.60.520.152.10.0548.065.00.99343.90.5613.140red
114.70.1450.291.00.04235.090.00.99083.760.4911.360white
124.70.3350.141.30.03669.0168.00.992123.470.4610.550white
134.70.4550.181.90.03633.0106.00.987463.210.8314.071white
144.70.60.172.30.05817.0106.00.99323.850.612.960red
154.70.670.091.00.025.09.00.987223.30.3413.650white
164.70.7850.03.40.03623.0134.00.989813.530.9213.860white
174.80.130.321.20.04240.098.00.98983.420.6411.871white
184.80.170.282.90.0322.0111.00.99023.380.3411.371white
194.80.210.2110.20.03717.0112.00.993243.660.4812.271white
204.80.2250.381.20.07447.0130.00.991323.310.410.360white
214.80.260.2310.60.03423.0111.00.992743.460.2811.571white
224.80.290.231.10.04438.0180.00.989243.280.3411.960white
234.80.330.06.50.02834.0163.00.99373.350.619.950white
244.80.340.06.50.02833.0163.00.99393.360.619.960white
254.80.650.121.10.0134.010.00.992463.320.3613.540white
264.90.2350.2711.750.0334.0118.00.99543.070.59.460white
274.90.330.311.20.01639.0150.00.987133.330.5914.081white
284.90.3350.141.30.03669.0168.00.992123.470.4610.466666666666750white
294.90.3350.141.30.03669.0168.00.992123.470.4610.466666666666750white
304.90.3450.341.00.06832.0143.00.991383.240.410.150white
314.90.3450.341.00.06832.0143.00.991383.240.410.150white
324.90.420.02.10.04816.042.00.991543.710.7414.071red
334.90.470.171.90.03560.0148.00.989643.270.3511.560white
345.00.170.561.50.02624.0115.00.99063.480.3910.871white
355.00.20.41.90.01520.098.00.98973.370.5512.0560white
365.00.2350.2711.750.0334.0118.00.99543.070.59.460white
375.00.240.195.00.04317.0101.00.994383.670.5710.050white
385.00.240.212.20.03931.0100.00.990983.690.6211.760white
395.00.240.341.10.03449.0158.00.987743.320.3213.171white
405.00.2550.222.70.04346.0153.00.992383.750.7611.360white
415.00.270.324.50.03258.0178.00.989563.450.3112.671white
425.00.270.324.50.03258.0178.00.989563.450.3112.671white
435.00.270.41.20.07642.0124.00.992043.320.4710.160white
445.00.290.545.70.03554.0155.00.989763.270.3412.981white
455.00.30.333.70.0354.0173.00.98873.360.313.071white
465.00.310.06.40.04643.0166.00.9943.30.639.960white
475.00.330.161.50.04910.097.00.99173.480.4410.760white
485.00.330.161.50.04910.097.00.99173.480.4410.760white
495.00.330.161.50.04910.097.00.99173.480.4410.760white
505.00.330.184.60.03240.0124.00.991143.180.411.060white
515.00.330.2311.80.0323.0158.00.993223.410.6411.860white
525.00.350.257.80.03124.0116.00.992413.390.411.360white
535.00.350.257.80.03124.0116.00.992413.390.411.360white
545.00.380.011.60.04826.060.00.990843.70.7514.060red
555.00.40.54.30.04629.080.00.99023.490.6613.660red
565.00.420.242.00.0619.050.00.99173.720.7414.081red
575.00.440.0418.60.03938.0128.00.99853.370.5710.260white
585.00.4550.181.90.03633.0106.00.987463.210.8314.071white
595.00.550.148.30.03235.0164.00.99183.530.5112.581white
605.00.610.121.30.00965.0100.00.98743.260.3713.550white
615.00.740.01.20.04116.046.00.992584.010.5912.560red
625.01.020.041.40.04541.085.00.99383.750.4810.540red
635.01.040.241.60.0532.096.00.99343.740.6211.550red
645.10.110.321.60.02812.090.00.990083.570.5212.260white
655.10.140.250.70.03915.089.00.99193.220.439.260white
665.10.1650.225.70.04742.0146.00.99343.180.559.960white
675.10.210.281.40.04748.0148.00.991683.50.4910.450white
685.10.230.181.00.05313.099.00.989563.220.3911.550white
695.10.250.361.30.03540.078.00.98913.230.6412.171white
705.10.260.331.10.02746.0113.00.989463.350.4311.471white
715.10.260.346.40.03426.099.00.994493.230.419.260white
725.10.290.288.30.02627.0107.00.993083.360.3711.060white
735.10.290.288.30.02627.0107.00.993083.360.3711.060white
745.10.30.32.30.04840.0150.00.989443.290.4612.260white
755.10.3050.131.750.03617.073.00.993.40.5112.333333333333350white
765.10.310.30.90.03728.0152.00.9923.540.5610.160white
775.10.330.221.60.02718.089.00.98933.510.3812.571white
785.10.330.221.60.02718.089.00.98933.510.3812.571white
795.10.330.221.60.02718.089.00.98933.510.3812.571white
805.10.330.276.70.02244.0129.00.992213.360.3911.071white
815.10.350.266.80.03436.0120.00.991883.380.411.560white
825.10.350.266.80.03436.0120.00.991883.380.411.560white
835.10.350.266.80.03436.0120.00.991883.380.411.560white
845.10.390.211.70.02715.072.00.98943.50.4512.560white
855.10.420.01.80.04418.088.00.991573.680.7313.671red
865.10.420.011.50.01725.0102.00.98943.380.3612.371white
875.10.470.021.30.03418.044.00.99213.90.6212.860red
885.10.510.182.10.04216.0101.00.99243.460.8712.971red
895.10.520.062.70.05230.079.00.99323.320.439.350white
905.10.5850.01.70.04414.086.00.992643.560.9412.971red
915.20.1550.331.60.02813.059.00.989753.30.8411.981white
925.20.1550.331.60.02813.059.00.989753.30.8411.981white
935.20.160.340.80.02926.077.00.991553.250.5110.160white
945.20.170.270.70.0311.068.00.992183.30.419.850white
955.20.1850.221.00.0347.0123.00.992183.550.4410.1560white
965.20.20.273.20.04716.093.00.992353.440.5310.171white
975.20.210.311.70.04817.061.00.989533.240.3712.071white
985.20.220.466.20.06641.0187.00.993623.190.429.7333333333333350white
995.20.240.157.10.04332.0134.00.993783.240.489.960white
1005.20.240.453.80.02721.0128.00.9923.550.4911.281white
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,
)

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.20.2150.235.10.04164.0157.00.996883.420.448.030white5.18391567217182
24.70.1450.291.00.04235.090.00.99083.760.4911.360white5.97506076800997
34.70.4550.181.90.03633.0106.00.987463.210.8314.071white6.25866277314879
44.70.60.172.30.05817.0106.00.99323.850.612.960red5.35925783218914
54.70.670.091.00.025.09.00.987223.30.3413.650white6.09795883115189
64.80.130.321.20.04240.098.00.98983.420.6411.871white6.14547083094277
74.80.210.2110.20.03717.0112.00.993243.660.4812.271white6.00719503892881
84.80.340.06.50.02833.0163.00.99393.360.619.960white5.68212570429591
94.90.420.02.10.04816.042.00.991543.710.7414.071red5.77557452597756
105.00.2550.222.70.04346.0153.00.992383.750.7611.360white5.79302212785689
115.00.30.333.70.0354.0173.00.98873.360.313.071white6.30206185303811
125.00.330.161.50.04910.097.00.99173.480.4410.760white5.78734484463428
135.00.330.2311.80.0323.0158.00.993223.410.6411.860white6.01048420770667
145.00.350.257.80.03124.0116.00.992413.390.411.360white5.93176810673441
155.00.350.257.80.03124.0116.00.992413.390.411.360white5.93176810673441
165.00.40.54.30.04629.080.00.99023.490.6613.660red6.01589618409466
175.10.330.221.60.02718.089.00.98933.510.3812.571white6.13249612101441
185.20.1550.331.60.02813.059.00.989753.30.8411.981white6.20300804303653
195.20.160.340.80.02926.077.00.991553.250.5110.160white5.90971686200572
205.20.210.311.70.04817.061.00.989533.240.3712.071white6.20008073373947
215.20.2850.295.150.03564.0138.00.98953.190.3412.481white6.29817032988876
225.30.2750.247.40.03828.0114.00.993133.380.5111.060white5.91472767363518
235.30.40.253.90.03145.0130.00.990723.310.5811.7571white6.00203008196803
245.40.170.272.70.04928.0104.00.992243.460.5510.360white5.92705700983041
255.40.180.244.80.04130.0113.00.994453.420.49.460white5.70367351300635
265.40.1850.197.10.04836.0110.00.994383.260.419.560white5.81770196575627
275.40.240.182.30.0522.0145.00.992073.240.4610.350white5.89237280571561
285.40.530.162.70.03634.0128.00.988563.20.5313.281white6.17984353695465
295.40.580.081.90.05920.031.00.994843.50.6410.260red5.23638517610286
305.50.160.224.50.0330.0102.00.99383.240.369.460white5.81339457780376
315.50.160.261.50.03235.0100.00.990763.430.7712.060white6.10459414394089
325.50.210.251.20.0418.075.00.990063.310.5611.360white6.1532160702657
335.50.230.192.20.04439.0161.00.992093.190.4310.460white5.90480831296955
345.50.3150.382.60.03310.069.00.99093.120.5910.860white5.99485089768487
355.50.350.351.10.04514.0167.00.9923.340.689.960white5.7529339451039
365.50.420.091.60.01918.068.00.99063.330.5111.471white5.95316270821567
375.60.130.274.80.02822.0104.00.99483.340.459.260white5.71543368109528
385.60.150.265.550.05151.0139.00.993363.470.511.060white5.93840201610314
395.60.150.315.30.0388.079.00.99233.30.3910.560white6.06824397234783
405.60.180.310.20.02828.0131.00.99543.490.4210.871white5.82302194281604
415.60.1850.197.10.04836.0110.00.994383.260.419.560white5.84525188840638
425.60.1850.491.10.0328.0117.00.99183.550.4510.360white5.90142320003429
435.60.190.270.90.0452.0103.00.990263.50.3911.250white6.13841386933609
445.60.190.474.50.0319.0112.00.99223.560.4511.260white5.99231419056241
455.60.20.6610.20.04378.0175.00.99452.980.4310.471white5.88259450872184
465.60.210.41.30.04181.0147.00.99013.220.9511.681white6.1438563806592
475.60.2450.259.70.03212.068.00.9943.310.3410.550white5.95525746173212
485.60.260.010.20.03813.0111.00.993153.440.4612.460white6.1219871948758
495.60.260.2710.60.0327.0119.00.99473.40.3410.771white5.88126090970323
505.60.260.511.40.02925.093.00.994283.230.4910.560white5.94145496211132
515.60.280.273.90.04352.0158.00.992023.350.4410.771white5.95183142189859
525.60.350.371.00.0386.072.00.99023.370.3411.450white6.01203690280332
535.60.850.051.40.04512.088.00.99243.560.8212.981red5.37871400394798
545.70.160.321.20.0367.089.00.991113.260.4811.050white6.06139024266662
555.70.210.251.10.03526.081.00.99023.310.5211.460white6.15631775177823
565.70.220.216.00.04441.0113.00.998623.220.468.960white5.62138070770206
575.70.220.216.00.04441.0113.00.998623.220.468.960white5.62138070770206
585.70.220.2216.650.04439.0110.00.998553.240.489.060white5.65661583720089
595.70.230.257.950.04216.0108.00.994863.440.6110.360white5.78430103817632
605.70.320.181.40.02926.0104.00.99063.440.3711.060white6.03737356520722
615.70.330.151.90.0520.093.00.99343.380.629.950white5.66363132505307
625.70.3350.341.00.0413.0174.00.9923.270.6610.050white5.78885054554183
635.70.360.344.20.02621.077.00.99073.410.4511.960white6.0905392358267
645.70.3850.0412.60.03422.0115.00.99643.280.639.960white5.67985074452261
655.70.430.35.70.03924.098.00.9923.540.6112.371white5.92551403953655
665.80.170.361.30.03611.070.00.992023.430.6810.471white5.93790332056432
675.80.190.494.90.0444.0118.00.99353.340.389.571white5.85231877601001
685.80.20.161.40.04244.099.00.989123.230.3712.260white6.35656645592584
695.80.220.290.90.03434.089.00.989363.140.3611.171white6.26582086474758
705.80.230.22.00.04339.0154.00.992263.210.3910.260white5.9119668927444
715.80.230.271.80.04324.069.00.99333.380.319.460white5.74673653464043
725.80.230.313.50.04435.0158.00.989983.190.3712.171white6.28198155656182
735.80.260.249.20.04455.0152.00.99613.310.389.450white5.65642376525133
745.80.260.249.20.04455.0152.00.99613.310.389.450white5.65642376525133
755.80.260.32.60.03475.0129.00.99023.20.3811.540white6.18917182538874
765.80.270.214.950.04422.0179.00.99623.370.3710.250white5.89092077483957
775.80.270.2212.70.05842.0206.00.99463.320.3812.360white6.01614310100302
785.80.2750.35.40.04341.0149.00.99263.330.4210.871white5.9626454327198
795.80.280.181.20.0587.0108.00.992883.230.589.5540white5.75517275946265
805.80.290.151.10.02912.083.00.98983.30.411.460white6.17831106682388
815.80.290.261.70.0633.011.00.99153.390.5413.560red5.95197510360222
825.80.290.271.60.06217.0140.00.991383.230.3511.160white5.96295378055328
835.80.30.421.10.03619.0113.00.988713.10.4612.671white6.28490676551962
845.80.310.324.50.02428.094.00.989063.250.5213.771white6.38968526321176
855.80.3150.271.550.02615.070.00.989943.370.411.981white6.14099181469552
865.80.320.284.30.03246.0115.00.989463.160.5713.081white6.32343200480759
875.80.340.167.00.03726.0116.00.99493.460.4510.071white5.67831925823137
885.80.360.51.00.12763.0178.00.992123.10.459.750white5.74988007031035
895.80.3850.253.70.03138.0122.00.991283.20.6311.260white5.99508874401775
905.90.130.281.90.0520.078.00.99183.430.6410.860white6.05268088186486
915.90.140.21.60.0426.0114.00.991053.250.4511.460white6.148228656642
925.90.190.370.80.0273.021.00.98973.090.3110.850white6.23847464972209
935.90.20.281.00.04345.0100.00.990333.40.4111.460white6.16525309834981
945.90.20.41.30.04723.092.00.992323.20.4510.060white5.88119136603939
955.90.210.284.60.05340.0199.00.99643.720.710.040white5.4613552379767
965.90.220.31.30.05242.086.00.990693.310.4711.5560white6.10993538007995
975.90.230.241.60.03732.0115.00.990763.210.5111.460white6.11296004757094
985.90.230.243.80.03861.0152.00.991393.310.511.371white6.12026754317927
995.90.240.2612.30.05334.0134.00.99723.340.459.560white5.66386966241285
1005.90.240.32.00.03328.092.00.992253.390.6910.971white5.90394270315974
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.