I've currently trained & tested several supervised models using sklearn and xgboost (using the same data). The xgboost model performs slightly better than sklearn's LassoCV. I'm trying to find a way to export the model object so that it can be interacted with by non-technical folks in either Excel and/or VBA. Specifically, non-technical folk need to be able to enter all feature values for a new observation, and have the exported sklearn or xgboost model output a new prediction. I know I can save sklearn and xgboost objects down as .pkl. Is there an interface or API that can take input from excel, pass it to the .pkl model file, and return the correct scalar prediction? There are about 40-50 features that will need to be inputted and passed to the exported model. After exporting the model from python, it will not need to retrained, only used for prediction. Continue reading...
