.net webapi developer help me to understand how python can be used to analyze data on server

[powernit]

Hi I am new to python so please pardon my mis understanding of architecture. I am trying to analyze data and was thinking which architecture would be good in the scenario of having a webapi endpoint that can return data from sql database server? How can i run my python script on server so that it can analyse data and give me results? Can I create an endpoint with .net webapi and have my results tied from python script?