Can I draw a regression line and show parameters using scatterplot with a pandas dataframe?
I don't think that there's such a paramter for DataFrame.plot(). However, you can easily achieve this using Seaborn. Just pass the pandas dataframe to lmplot (assuming you have seaborn installed):
import seaborn as sns
sns.lmplot(x='one',y='two',data=df,fit_reg=True)
You can use sk-learn to get the regression line combined with scatter plot.
from sklearn.linear_model import LinearRegression
X = df.iloc[:, 1].values.reshape(-1, 1) # iloc[:, 1] is the column of X
Y = df.iloc[:, 4].values.reshape(-1, 1) # df.iloc[:, 4] is the column of Y
linear_regressor = LinearRegression()
linear_regressor.fit(X, Y)
Y_pred = linear_regressor.predict(X)
plt.scatter(X, Y)
plt.plot(X, Y_pred, color='red')
plt.show()