擅长:python、mysql、java
<p>您真正需要做的就是用需要传递的X,Y参数调用要运行的main函数。然后,在这些函数中,将它传递给DataExtract函数,该函数将创建并返回数据帧,然后从那里继续。在</p>
<pre><code>import pandas as pd
#Extracting the data - Real query would be extracting X and Y from a SQL query and converting to a pandas frame
def DataExtract(Y, X):
d = {Y : [1, 3, 3, 9, 5], X : [6, 7, 8, 9, 10]}
df = pd.DataFrame(d)
return df
#Build process using the data extracted in DataExtract
def Regression(X, Y):
from statsmodels.formula.api import ols
df = DataExtract(X, Y)
df.columns = ['Y','X']
model = ols("Y ~ X", df).fit()
print(model.summary())
#Plot a graph for a given dataframe
def ScatterPlot(X, Y):
import matplotlib.pyplot as plt
df = DataExtract(X, Y)
df.columns = ['Y', 'X']
df.plot.scatter(x='X', y='Y')
plt.show()
</code></pre>
<p>…如果用户想同时做这两件事,你可以这样做:</p>
^{pr2}$