# Q11. Student Performance Prediction Using Regression

# Step 1: Import Libraries
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns

from sklearn.model_selection import train_test_split
from sklearn.linear_model import LinearRegression
from sklearn.metrics import r2_score, mean_squared_error, mean_absolute_error

# Step 2: Load Dataset
df = pd.read_csv("student-mat.csv", sep=";")

print(df.head())
print("Shape:", df.shape)
print(df.dtypes)
print(df.describe())

# Step 3: Check Missing and Duplicate Values
print("Null Values:\n", df.isnull().sum())
print("Duplicate Rows:", df.duplicated().sum())

# Remove Null and Duplicate Rows
df = df.dropna()
df = df.drop_duplicates()

# Step 4: EDA
sns.scatterplot(data=df, x="studytime", y="G3")
plt.title("Study Time vs Final Marks")
plt.show()

sns.scatterplot(data=df, x="absences", y="G3")
plt.title("Absences vs Final Marks")
plt.show()

sns.scatterplot(data=df, x="G1", y="G3")
plt.title("Previous Marks vs Final Marks")
plt.show()

# Step 5: Select Features and Target
X = df[["studytime", "absences", "G1", "G2"]]
y = df["G3"]

# Step 6: Split Dataset
X_train, X_test, y_train, y_test = train_test_split(
    X, y, test_size=0.2, random_state=42
)

# Step 7: Train Linear Regression Model
model = LinearRegression()
model.fit(X_train, y_train)

# Step 8: Predict Student Marks
y_pred = model.predict(X_test)
print("\nPredicted Marks:\n", y_pred[:10])

# Step 9: Evaluate Model
print("\nR2 Score:", r2_score(y_test, y_pred))
print("RMSE:", np.sqrt(mean_squared_error(y_test, y_pred)))
print("MAE:", mean_absolute_error(y_test, y_pred))

# Step 10: Identify Important Features
plt.bar(X.columns, model.coef_)
plt.show()


# Step 11: Actual vs Predicted Plot
plt.scatter(y_test, y_pred)
plt.xlabel("Actual Marks")
plt.ylabel("Predicted Marks")
plt.title("Actual vs Predicted Student Marks")
plt.show()

# Conclusion
print("Linear Regression predicts final marks using student attributes.")
print("Positive coefficients increase predicted marks, while negative")
print("coefficients decrease predicted marks, keeping other features fixed.")

new = []
for student in range(3):
    new.append([
        float(input("studytime: ")),
        float(input("absences: ")),
        float(input("G1: ")),
        float(input("G2: "))
    ])

ans = model.predict(pd.DataFrame(new, columns=X.columns))
print(ans)




