Ë
|
Wñúhç ã ó| d Z ddlmZmZ ddlZddlZddlm Z ddl
|
m Z ddl m Z ddlmZ ddlmZ G d d
|
e e « Zy) zwClassifier utilities for MySQL Connector/Python.
|
|
Provides a scikit-learn compatible classifier backed by HeatWave ML.
|
é )ÚOptionalÚUnionN)ÚClassifierMixin)Ú MyBaseMLModel)ÚML_TASK)Ú copy_dict)ÚMySQLConnectionAbstractc óP e Zd ZdZ ddedee dee dee dee f
|
dZd e e
|
j e j f d
|
e j fd Zd e e
|
j e j f d
|
e j fd Zd e e
|
j e j f d
|
e
|
j fd Zy)Ú MyClassifiera
|
MySQL HeatWave scikit-learn compatible classifier estimator.
|
|
Provides prediction and probability output from a model deployed in MySQL,
|
and manages fit, explain, and prediction options as per HeatWave ML interface.
|
|
Attributes:
|
predict_extra_options (dict): Dictionary of optional parameters passed through
|
to the MySQL backend for prediction and probability inference.
|
_model (MyModel): Underlying interface for database model operations.
|
fit_extra_options (dict): See MyBaseMLModel.
|
|
Args:
|
db_connection (MySQLConnectionAbstract): Active MySQL connector DB connection.
|
model_name (str, optional): Custom name for the model.
|
fit_extra_options (dict, optional): Extra options for fitting.
|
explain_extra_options (dict, optional): Extra options for explanations.
|
predict_extra_options (dict, optional): Extra options for predict/predict_proba.
|
|
Methods:
|
predict(X): Predict class labels.
|
predict_proba(X): Predict class probabilities.
|
NÚ db_connectionÚ
|
model_nameÚfit_extra_optionsÚexplain_extra_optionsÚpredict_extra_optionsc ó t j | |t j ||¬« t |« | _ t |« | _ y)a
|
Initialize a MyClassifier.
|
|
Args:
|
db_connection: Active MySQL connector database connection.
|
model_name: Optional, custom model name.
|
fit_extra_options: Optional fit options.
|
explain_extra_options: Optional explain options.
|
predict_extra_options: Optional predict/predict_proba options.
|
|
Raises:
|
DatabaseError:
|
If a database connection issue occurs.
|
If an operational error occurs during execution.
|
)r r N)r Ú__init__r ÚCLASSIFICATIONr r r )Úselfr r r r r s úIH:\Change_password\venv_build\Lib\site-packages\mysql/ai/ml/classifier.pyr zMyClassifier.__init__G sE ô. × Ñ Ø Ø Ü × "Ñ "Ø!Ø /õ
|
ô &/Ð/DÓ%EÔ"Ü%.Ð/DÓ%EÕ"ó ÚXÚreturnc óv | j j || j ¬« }|d j « S )a
|
Predict class labels for the input features using the MySQL model.
|
|
References:
|
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
|
A full list of supported options can be found under "ML_PREDICT_TABLE Options"
|
|
Args:
|
X: Input samples as a numpy array or pandas DataFrame.
|
|
Returns:
|
ndarray: Array of predicted class labels, shape (n_samples,).
|
|
Raises:
|
DatabaseError:
|
If provided options are invalid or unsupported,
|
or if the model is not initialized, i.e., fit or import has not
|
been called
|
If a database connection issue occurs.
|
If an operational error occurs during execution.
|
©ÚoptionsÚ
|
Prediction)Ú_modelÚpredictr Úto_numpy)r r Úresults r r zMyClassifier.predicth s7 ð0 ×$Ñ$ Q°×0JÑ0JÐ$ÓKØlÑ#×,Ñ,Ó.Ð.r c óþ | j j || j ¬« }t |d j d d j « « t j |d j fd« « S )a*
|
Predict class probabilities for the input features using the MySQL model.
|
|
References:
|
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
|
A full list of supported options can be found under "ML_PREDICT_TABLE Options"
|
|
Args:
|
X: Input samples as a numpy array or pandas DataFrame.
|
|
Returns:
|
ndarray: Array of shape (n_samples, n_classes) with class probabilities.
|
|
Raises:
|
DatabaseError:
|
If provided options are invalid or unsupported,
|
or if the model is not initialized, i.e., fit or import has not
|
been called
|
If a database connection issue occurs.
|
If an operational error occurs during execution.
|
r Ú
|
ml_resultsr Ú probabilitiesc ó: D cg c]
|
}| d | c}S c c}w )Nr# © )Ú ml_resultÚ
|
class_nameÚclassess r ú<lambda>z,MyClassifier.predict_proba.<locals>.<lambda>¡ s' ø ØMTö#Ø?IIoÑ.¨zÓ:ò# ùò #s ) r r r ÚsortedÚilocÚkeysÚnpÚstackÚmap)r r r r( s @r Ú predict_probazMyClassifier.predict_proba su ø ð0 ×$Ñ$ Q°×0JÑ0JÐ$ÓKä Ñ-×2Ñ2°1Ñ5°oÑF×KÑKÓMÓNäxxØ <Ñ × $Ñ $óó ó
|
ð
|
r c óR | j j || j ¬« y)ai
|
Explain model predictions using provided data.
|
|
References:
|
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
|
A full list of supported options can be found under "ML_EXPLAIN_TABLE Options"
|
|
Args:
|
X: DataFrame for which predictions should be explained.
|
|
Returns:
|
DataFrame containing explanation details (feature attributions, etc.)
|
|
Raises:
|
DatabaseError:
|
If provided options are invalid or unsupported,
|
or if the model is not initialized, i.e., fit or import has not
|
been called
|
If a database connection issue occurs.
|
If an operational error occurs during execution.
|
|
Notes:
|
Temporary input/output tables are cleaned up after explanation.
|
r N)r Úexplain_predictionsr )r r s r r2 z MyClassifier.explain_predictions§ s! ð6 ×'Ñ'¨°4×3MÑ3MÐ'ÕNr )NNNN)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r r ÚstrÚdictr r ÚpdÚ DataFramer- Úndarrayr r0 r2 r% r r r r . sæ ñð6 %)Ø,0Ø04Ø04ñ Fà.ð Fð SMð Fð $ D>ð Fð
|
(¨~ð Fð (¨~ó FðB/Ør|| R§Z¡ZÐ/Ñ0ð/à ó/ð6"
|
Ør|| R§Z¡ZÐ/Ñ0ð"
|
à ó"
|
ðHOØr|| R§Z¡ZÐ/Ñ0ðOà ôOr r )r6 Útypingr r Únumpyr- Úpandasr9 Ú sklearn.baser Úmysql.ai.ml.baser Úmysql.ai.ml.modelr Úmysql.ai.utilsr Úmysql.connector.abstractsr r r% r r ú<module>rD s6 ðñ:÷ #ã Û Ý (å *Ý %Ý $å =ôTO= /õ TOr
|
