# Q14. Loan Approval Prediction Using Decision Tree
# Install separately if needed: python -m pip install openpyxl
# Step 1: Import Libraries
import pandas as pd
import matplotlib.pyplot as plt

from sklearn.model_selection import train_test_split
from sklearn.tree import DecisionTreeClassifier, plot_tree
from sklearn.preprocessing import LabelEncoder
from sklearn.metrics import accuracy_score, precision_score, recall_score
from sklearn.metrics import f1_score, confusion_matrix, classification_report

# Step 2: Create Dataset OR Read CSV File

df = pd.read_csv("loan_data.csv")

# If using a CSV, make sure the target column is named Loan_Status.
# Common Loan_Status values are Y/N or Approved/Rejected.

print(df.head())
print("\nDataset Shape:", df.shape)
print("\nMissing Values:\n", df.isnull().sum())

# Step 3: Handle Missing Values
for col in df.columns:
    if not pd.api.types.is_numeric_dtype(df[col]):
        df[col] = df[col].fillna(df[col].mode()[0])
    else:
        df[col] = df[col].fillna(df[col].median())

df = df.drop_duplicates()

# Step 4: Encode Categorical Variables
le = LabelEncoder()

for col in df.select_dtypes(include=["object", "string", "category"]).columns:
    df[col] = le.fit_transform(df[col])

# Step 5: Select Features and Target
X = df.drop("Loan_Status", axis=1)
y = df["Loan_Status"]

# 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 Decision Tree Classifier
model = DecisionTreeClassifier(criterion="gini", random_state=42)
model.fit(X_train, y_train)

# Step 8: Visualize Decision Tree
plt.figure(figsize=(14, 8))
plot_tree(
    model,
    feature_names=X.columns,
    class_names=[str(label) for label in model.classes_],
    filled=True
)
plt.title("Loan Approval Decision Tree")
plt.show()


plt.figure(figsize=(15, 8))
plot_tree(model, feature_names=X.columns, filled=True)
plt.show()


# Step 9: Predict Test Records
y_pred = model.predict(X_test)

print("\nActual Values:", y_test.tolist())
print("Predicted Values:", y_pred.tolist())

# Step 10: Evaluate Model
print("\nAccuracy:", accuracy_score(y_test, y_pred))
print("Precision:", precision_score(y_test, y_pred, zero_division=0))
print("Recall:", recall_score(y_test, y_pred, zero_division=0))
print("F1-Score:", f1_score(y_test, y_pred, zero_division=0))

print("\nConfusion Matrix:\n", confusion_matrix(y_test, y_pred))
print("\nClassification Report:\n", classification_report(
    y_test, y_pred, zero_division=0
))

# Conclusion
print("Decision Tree predicts loan approval using applicant information.")







