擅长:python、mysql、java
<p>一种方法是传递数据帧<code>X</code>和数据帧{<cd2>}。在</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]}
return df_X, df_Y
#Build process using the data extracted in DataExtract
def Regression(X, Y):
from statsmodels.formula.api import ols
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
plt.scatter(x=X, y=Y)
plt.show()
if __name__ == '__main__':
X, Y = DataExtract()
Regression(X, Y)
Scatterplot(X, Y)
</code></pre>