Custom-functions-in-excel-with-python

An .xlsm an .py file with different ML models that can be run using functions in excel using the xlwings python library.

Custom functions models:

  • LinearRegression
  • Kmeans

to configurate excel so it can allow custom functions created in python, go to:
https://docs.xlwings.org/en/stable/udfs.html

you can find the video tutorial wich i was based on (for linear regression model):
https://www.youtube.com/watch?v=VIZLfL7ukoE&ab_channel=DatakickAnalytics

PD: i added more custom functions for the linear regression model explained in the video (r2, RSME, coefficients and intersect)

GitHub

View Github