Loading...

verticapy.machine_learning.vertica.linear_model.LogisticRegression.predict

LogisticRegression.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    | 390.68675 |30.87539|12.65366 | 0.00000
 fixed_acidity  |  0.41169  | 0.05268| 7.81447 | 0.00000
volatile_acidity| -1.06139  | 0.42515|-2.49654 | 0.01254
  citric_acid   |  0.08364  | 0.42470| 0.19694 | 0.84387
 residual_sugar |  0.10736  | 0.01700| 6.31602 | 0.00000
   chlorides    | -4.13771  | 2.58378|-1.60142 | 0.10928
    density     |-397.43471 |31.40660|-12.65450| 0.00000


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


===========
call_string
===========
logistic_reg('"public"."_verticapy_tmp_logisticregression_v_mldb_acad02ae979911efa8720242ac120002_"', '"public"."_verticapy_tmp_view_v_mldb_acee3b70979911efa8720242ac120002_"', '"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|3246 
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.420.02.10.04816.042.00.991543.710.7414.071red0
45.00.270.41.20.07642.0124.00.992043.320.4710.160white0
55.00.310.06.40.04643.0166.00.9943.30.639.960white0
65.00.40.54.30.04629.080.00.99023.490.6613.660red0
75.10.110.321.60.02812.090.00.990083.570.5212.260white0
85.10.140.250.70.03915.089.00.99193.220.439.260white0
95.10.1650.225.70.04742.0146.00.99343.180.559.960white0
105.10.330.221.60.02718.089.00.98933.510.3812.571white0
115.10.390.211.70.02715.072.00.98943.50.4512.560white0
125.20.210.311.70.04817.061.00.989533.240.3712.071white0
135.20.310.22.40.02727.0117.00.988863.560.4513.071white0
145.20.360.021.60.03124.0104.00.98963.440.3512.260white0
155.30.160.391.00.02840.0101.00.991563.570.5910.660white0
165.30.160.391.00.02840.0101.00.991563.570.5910.660white0
175.30.1650.241.10.05125.0105.00.99253.320.479.150white0
185.30.230.560.90.04146.0141.00.991193.160.629.750white0
195.30.30.31.20.02925.093.00.987423.310.413.671white1
205.30.330.31.20.04825.0119.00.990453.320.6211.360white0
215.30.360.276.30.02840.0132.00.991863.370.411.660white0
225.30.470.112.20.04816.089.00.991823.540.8813.566666666666771red0
235.40.220.291.20.04569.0152.00.991783.760.6311.071white0
245.40.740.091.70.08916.026.00.994023.670.5611.660red0
255.50.120.331.00.03823.0131.00.991643.250.459.850white0
265.50.140.274.60.02922.0104.00.99493.340.449.050white0
275.50.160.311.20.02631.068.00.98983.330.4411.6560white0
285.50.160.311.20.02631.068.00.98983.330.4411.633333333333360white0
295.50.180.225.50.03710.086.00.991563.460.4412.250white0
305.50.240.451.70.04622.0113.00.992243.220.4810.050white0
315.60.150.265.550.05151.0139.00.993363.470.511.060white0
325.60.160.271.40.04453.0168.00.99183.280.3710.160white0
335.60.1750.290.80.04320.067.00.991123.280.489.960white0
345.60.1850.197.10.04836.0110.00.994383.260.419.560white0
355.60.220.321.20.02429.097.00.988233.20.4613.0571white1
365.60.260.181.40.03418.0135.00.991743.320.3510.260white0
375.60.260.265.70.03112.080.00.99233.250.3810.850white0
385.60.490.134.50.03917.0116.00.99073.420.913.771white0
395.60.490.134.50.03917.0116.00.99073.420.913.771white0
405.60.660.02.20.0873.011.00.993783.710.6312.871red0
415.70.180.361.20.0469.071.00.991993.70.6810.971white0
425.70.20.32.50.04638.0125.00.992763.340.59.960white0
435.70.210.320.90.03838.0121.00.990743.240.4610.660white0
445.70.220.216.00.04441.0113.00.998623.220.468.960white0
455.70.220.216.00.04441.0113.00.998623.220.468.960white0
465.70.220.216.00.04441.0113.00.998623.220.468.960white0
475.70.220.216.00.04441.0113.00.998623.220.468.960white0
485.70.230.289.650.02526.0121.00.99253.280.3811.360white0
495.70.250.2612.50.04952.5106.00.996913.080.459.460white0
505.70.260.2417.80.05923.0124.00.997733.30.510.150white0
515.70.270.321.20.04620.0155.00.99343.80.4110.260white0
525.70.320.181.40.02926.0104.00.99063.440.3711.060white0
535.70.320.384.750.03323.094.00.9913.420.4211.871white0
545.80.170.341.80.04596.0170.00.990353.380.911.881white0
555.80.220.31.10.04736.0131.00.9923.260.4510.450white0
565.80.260.181.20.03140.0114.00.99083.420.411.071white0
575.80.260.181.20.03140.0114.00.99083.420.411.071white0
585.80.280.181.20.0587.0108.00.992883.230.589.5540white0
595.80.280.284.20.04452.0158.00.9923.350.4410.771white0
605.80.280.31.50.02631.0114.00.989523.320.612.571white0
615.80.290.212.60.02512.0120.00.98943.390.7914.071white0
625.80.310.331.20.03623.099.00.99163.180.610.560white0
635.80.320.22.60.02717.0123.00.989363.360.7813.971white0
645.80.320.284.30.03246.0115.00.989463.160.5713.081white0
655.80.320.284.30.03246.0115.00.989463.160.5713.081white0
665.80.320.384.750.03323.094.00.9913.420.4211.871white0
675.80.360.380.90.0373.075.00.99043.280.3411.440white0
685.80.3850.253.70.03138.0122.00.991283.20.6311.260white0
695.80.610.018.40.04131.0104.00.99093.260.7214.0571white0
705.80.680.021.80.08721.094.00.99443.540.5210.050red0
715.90.150.315.80.04153.0155.00.99453.520.4610.560white0
725.90.170.31.40.04225.0119.00.99313.680.7210.560white0
735.90.190.370.80.0273.021.00.98973.090.3110.850white0
745.90.210.237.90.03322.0130.00.99443.380.5910.960white0
755.90.210.284.60.05340.0199.00.99643.720.710.040white0
765.90.270.275.00.03514.097.00.990583.10.3311.871white0
775.90.290.283.20.03516.0117.00.989593.260.4212.660white0
785.90.290.337.40.03758.0205.00.994953.260.419.650white0
795.90.310.37.70.04760.0206.00.9953.20.399.660white0
805.90.330.328.10.0389.034.00.99113.220.3612.771white0
815.90.340.33.80.03557.0135.00.990163.090.3412.060white0
825.90.370.11.60.05739.0128.00.99243.240.4810.150white0
835.90.370.321.60.02941.0102.00.989163.410.5512.771white0
845.90.4150.020.80.03822.063.00.99323.360.369.350white0
855.90.440.01.60.0423.011.00.99443.480.8511.760red0
865.90.460.142.70.04227.0160.00.99313.460.5110.671white0
875.90.540.00.80.03212.082.00.992863.250.368.850white0
885.90.620.283.50.03955.0152.00.99073.440.4412.060white0
895.90.6550.05.60.0338.031.00.99363.320.5110.540white0
906.00.160.36.70.04343.0153.00.99513.630.4610.650white0
916.00.160.371.50.02543.0117.00.99283.460.519.760white0
926.00.170.299.70.04433.098.00.995363.120.369.260white0
936.00.180.271.50.08940.0143.00.99233.490.6210.860white0
946.00.20.266.80.04922.093.00.99283.150.4211.060white0
956.00.20.266.80.04922.093.00.99283.150.4211.060white0
966.00.20.331.10.03945.0126.00.990513.310.4511.671white0
976.00.210.380.80.0222.098.00.989413.260.3211.860white0
986.00.250.45.70.05256.0152.00.993983.160.8810.560white0
996.00.260.323.80.02948.0180.00.990113.150.3412.060white0
1006.00.260.341.30.0466.029.00.99243.290.6310.450white0
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.