Loading...

verticapy.machine_learning.vertica.linear_model.LogisticRegression.predict_proba#

LogisticRegression.predict_proba(vdf: str | vDataFrame, X: str | list[str] | None = None, name: str | None = None, pos_label: bool | float | str | timedelta | datetime | None = None, inplace: bool = True) vDataFrame#

Returns the model’s probabilities 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 vDataColumn. If empty, a name is generated.

pos_label: PythonScalar, optional

Class label. For binary classification, this can be either 1 or 0.

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.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
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,
)

model.predict_proba(
    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_0
Float(22)
123
prediction_1
Float(22)
13.90.2250.44.20.0329.0118.00.9893.570.3612.881white0.621483131960790.37851686803921
24.20.2150.235.10.04164.0157.00.996883.420.448.030white0.973745031770210.0262549682297903
34.40.540.095.10.03852.097.00.990223.410.412.271white0.7648447169582570.235155283041743
44.60.520.152.10.0548.065.00.99343.90.5613.140red0.9421175207467930.0578824792532071
54.70.3350.141.30.03669.0168.00.992123.470.4610.550white0.8840738096199150.115926190380085
64.70.670.091.00.025.09.00.987223.30.3413.650white0.5940715643953570.405928435604643
74.80.260.2310.60.03423.0111.00.992743.460.2811.571white0.7436431325912160.256356867408784
84.80.290.231.10.04438.0180.00.989243.280.3411.960white0.6855198063165110.314480193683489
94.80.340.06.50.02833.0163.00.99393.360.619.960white0.8948581083249320.105141891675068
104.90.2350.2711.750.0334.0118.00.99543.070.59.460white0.8748594852488180.125140514751182
114.90.3450.341.00.06832.0143.00.991383.240.410.150white0.854317789750360.14568221024964
125.00.240.212.20.03931.0100.00.990983.690.6211.760white0.7731048137130030.226895186286997
135.00.240.341.10.03449.0158.00.987743.320.3213.171white0.4903835547944270.509616445205573
145.00.30.333.70.0354.0173.00.98873.360.313.071white0.5295709394236660.470429060576334
155.00.310.06.40.04643.0166.00.9943.30.639.960white0.8956797932003810.104320206799619
165.00.330.161.50.04910.097.00.99173.480.4410.760white0.8530851674162570.146914832583743
175.00.330.161.50.04910.097.00.99173.480.4410.760white0.8530851674162570.146914832583743
185.00.330.2311.80.0323.0158.00.993223.410.6411.860white0.7536388855542470.246361114445753
195.00.350.257.80.03124.0116.00.992413.390.411.360white0.7799338644934710.220066135506529
205.00.350.257.80.03124.0116.00.992413.390.411.360white0.7799338644934710.220066135506529
215.00.380.011.60.04826.060.00.990843.70.7514.060red0.8145421722018280.185457827798172
225.00.40.54.30.04629.080.00.99023.490.6613.660red0.6920553775661850.307944622433815
235.00.440.0418.60.03938.0128.00.99853.370.5710.260white0.9387767397595420.0612232602404582
245.00.550.148.30.03235.0164.00.99183.530.5112.581white0.771803896257970.22819610374203
255.00.740.01.20.04116.046.00.992584.010.5912.560red0.9338305699111630.0661694300888368
265.10.140.250.70.03915.089.00.99193.220.439.260white0.8341936376095310.165806362390469
275.10.260.331.10.02746.0113.00.989463.350.4311.471white0.6540461417854690.345953858214531
285.10.290.288.30.02627.0107.00.993083.360.3711.060white0.7944658091716170.205534190828383
295.10.290.288.30.02627.0107.00.993083.360.3711.060white0.7944658091716170.205534190828383
305.10.30.32.30.04840.0150.00.989443.290.4612.260white0.6506346278770240.349365372122976
315.10.3050.131.750.03617.073.00.993.40.5112.333333333333350white0.7144486485510660.285551351448934
325.10.310.30.90.03728.0152.00.9923.540.5610.160white0.8600168371605670.139983162839433
335.10.330.221.60.02718.089.00.98933.510.3812.571white0.6502359410019780.349764058998022
345.10.330.221.60.02718.089.00.98933.510.3812.571white0.6502359410019780.349764058998022
355.10.330.276.70.02244.0129.00.992213.360.3911.071white0.7702988312736610.229701168726339
365.10.350.266.80.03436.0120.00.991883.380.411.560white0.7561627235165750.243837276483425
375.10.420.011.50.01725.0102.00.98943.380.3612.371white0.6876604007360350.312339599263965
385.20.1550.331.60.02813.059.00.989753.30.8411.981white0.6322937209302260.367706279069774
395.20.1850.221.00.0347.0123.00.992183.550.4410.1560white0.8436940271833130.156305972816687
405.20.20.273.20.04716.093.00.992353.440.5310.171white0.8281362110062770.171863788993723
415.20.220.466.20.06641.0187.00.993623.190.429.7333333333333350white0.8587275805974390.141272419402561
425.20.240.157.10.04332.0134.00.993783.240.489.960white0.8551834175244150.144816582475585
435.20.240.453.80.02721.0128.00.9923.550.4911.281white0.7843274715419660.215672528458034
445.20.280.291.10.02818.069.00.991683.240.5410.060white0.8257489198473680.174251080152632
455.20.30.341.50.03818.096.00.989423.560.4813.081white0.6506713123564340.349328687643566
465.20.310.365.10.03146.0145.00.98973.140.3112.471white0.5757277750839880.424272224916012
475.20.3350.21.70.03317.074.00.990023.340.4812.360white0.7113441902795530.288655809720447
485.20.340.376.20.03142.0133.00.990763.250.4112.560white0.6572795122671720.342720487732828
495.20.380.267.70.05320.0103.00.99253.270.4512.260white0.7946187290438850.205381270956115
505.20.4050.151.450.03810.044.00.991253.520.411.640white0.8253001837637220.174699816236278
515.20.440.041.40.03643.0119.00.98943.360.3312.181white0.7005574560492370.299442543950763
525.20.440.041.40.03643.0119.00.98943.360.3312.181white0.7005574560492370.299442543950763
535.20.6450.02.150.0815.028.00.994443.780.6112.560red0.9632359693332690.0367640306667308
545.30.160.391.00.02840.0101.00.991563.570.5910.660white0.7885532369932870.211446763006713
555.30.1650.241.10.05125.0105.00.99253.320.479.150white0.8604415777106110.139558422289389
565.30.20.313.60.03622.091.00.992783.410.59.860white0.8344406245345520.165559375465448
575.30.2750.247.40.03828.0114.00.993133.380.5111.060white0.8079322817158070.192067718284193
585.30.30.164.20.02937.0100.00.99053.30.3611.881white0.674504709479310.32549529052069
595.30.30.21.10.07748.0166.00.99443.30.548.740white0.9463672646560710.0536327353439292
605.30.30.31.20.02925.093.00.987423.310.413.671white0.4416190862122080.558380913787792
615.30.310.3810.50.03153.0140.00.993213.340.4611.760white0.7496859701258980.250314029874102
625.30.310.3810.50.03153.0140.00.993213.340.4611.760white0.7496859701258980.250314029874102
635.30.360.276.30.02840.0132.00.991863.370.411.660white0.748943905623830.25105609437617
645.30.40.253.90.03145.0130.00.990723.310.5811.7571white0.7229486617923830.277051338207617
655.30.430.111.10.0296.051.00.990763.510.4811.240white0.7953185122472590.204681487752741
665.30.470.11.30.03611.074.00.990823.480.5411.240white0.8075693867158530.192430613284147
675.30.580.076.90.04334.0149.00.99443.340.579.750white0.9195420919077370.0804579080922632
685.30.5850.077.10.04434.0145.00.99453.340.579.760white0.9215908691432260.078409130856774
695.30.7150.191.50.1617.062.00.993953.620.6111.050red0.9688835754445850.0311164245554151
705.30.760.032.70.04327.093.00.99323.340.389.250white0.933555383488430.0664446165115701
715.40.1850.197.10.04836.0110.00.994383.260.419.560white0.8692113855206710.130788614479329
725.40.220.291.20.04569.0152.00.991783.760.6311.071white0.8179565306640280.182043469335972
735.40.220.356.50.02926.087.00.990923.290.4412.571white0.613867557490080.38613244250992
745.40.240.182.30.0522.0145.00.992073.240.4610.350white0.826775005094320.17322499490568
755.40.2650.287.80.05227.091.00.994323.190.3810.460white0.8672909242285680.132709075771432
765.40.270.224.60.02229.0107.00.988893.330.5413.860white0.4757194945774330.524280505422567
775.40.290.381.20.02931.0132.00.988953.280.3612.460white0.5823181067766270.417681893223373
785.40.290.381.20.02931.0132.00.988953.280.3612.460white0.5823181067766270.417681893223373
795.40.30.31.20.02925.093.00.987423.310.413.671white0.4323476398023020.567652360197698
805.40.310.473.00.05346.0144.00.99313.290.7610.050white0.8740919784818320.125908021518168
815.40.3750.43.30.05429.0147.00.994823.420.529.150white0.9377369794300930.0622630205699071
825.40.4150.191.60.03927.088.00.992653.540.4110.071white0.8856377734653420.114362226534658
835.40.50.135.00.02812.0107.00.990793.480.8813.571white0.7226070772942150.277392922705785
845.40.530.162.70.03634.0128.00.988563.20.5313.281white0.5879799968706430.412020003129357
855.40.590.077.00.04536.0147.00.99443.340.579.760white0.9172909909526660.082709009047334
865.40.5950.12.80.04226.080.00.99323.360.389.350white0.9152835323130160.0847164676869836
875.40.740.01.20.04116.046.00.992584.010.5912.560red0.9238844378141280.0761155621858721
885.40.740.091.70.08916.026.00.994023.670.5611.660red0.96056227007860.0394377299213996
895.40.8350.081.20.04613.093.00.99243.570.8513.071red0.9264861548405010.0735138451594988
905.50.140.274.60.02922.0104.00.99493.340.449.050white0.9018988989800920.098101101019908
915.50.160.261.50.03235.0100.00.990763.430.7712.060white0.7100540997142290.289945900285771
925.50.170.232.90.03910.0108.00.992433.280.510.050white0.8132512033112310.186748796688769
935.50.170.232.90.03910.0108.00.992433.280.510.050white0.8132512033112310.186748796688769
945.50.240.451.70.04622.0113.00.992243.220.4810.050white0.8305174805931580.169482519406842
955.50.30.251.90.02933.0118.00.989723.360.6612.560white0.6397533631891890.360246636810811
965.50.3150.382.60.03310.069.00.99093.120.5910.860white0.7283264867957610.271673513204239
975.50.320.131.30.03745.0156.00.991843.260.3810.750white0.8323414254077590.167658574592241
985.50.320.454.90.02825.0191.00.99223.510.4911.571white0.774194244517860.22580575548214
995.50.3350.32.50.07127.0128.00.99243.140.519.660white0.8583137312689780.141686268731022
1005.50.350.351.10.04514.0167.00.9923.340.689.960white0.8464492295374440.153550770462556
Rows: 1-100 | Columns: 16

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.