1

Pasted Nov 2, 2026, 1:34 PM10 files1,174 lines

Scan to open on your phone

Point a camera at the QR code - it opens this exact paste, no app needed.

https://codepastes.com/hello
1
import pandas as pd
import numpy as np

from sklearn.preprocessing import StandardScaler, LabelEncoder
from sklearn.impute import SimpleImputer

# Sample open-access style dataset (HR/Employee Attrition style)
data = {
    'Age': [25, 32, np.nan, 45, 29, 38, np.nan, 51],
    'Department': ['Sales', 'IT', 'HR', 'IT', 'Sales', np.nan, 'HR', 'IT'],
    'Salary': [40000, 55000, 48000, np.nan, 42000, 60000, 47000, 72000],
    'YearsExperience': [1, 5, 3, 12, 2, 8, 4, 15],
    'Attrition': ['Yes', 'No', 'No', 'No', 'Yes', 'No', 'Yes', 'No']
}

# Create DataFrame
df = pd.DataFrame(data)

print("Original Dataset:\n")
print(df)

print("\nMissing values per column:\n")
print(df.isnull().sum())

# -------------------------------------------------
# Step 1: Handle Missing Values
# -------------------------------------------------

# Numerical columns - Mean Imputation
num_imputer = SimpleImputer(strategy='mean')
df['Age'] = num_imputer.fit_transform(df[['Age']])
df['Salary'] = num_imputer.fit_transform(df[['Salary']])

# Categorical column - Most Frequent Imputation
cat_imputer = SimpleImputer(strategy='most_frequent')
df['Department'] = cat_imputer.fit_transform(df[['Department']]).ravel()

print("\nAfter Handling Missing Values:\n")
print(df)

# -------------------------------------------------
# Step 2: Encode Categorical Variables
# -------------------------------------------------

# Label Encoding for Target Variable
le = LabelEncoder()
df['Attrition_Encoded'] = le.fit_transform(df['Attrition'])

# One-Hot Encoding for Department
df_encoded = pd.get_dummies(
    df,
    columns=['Department'],
    prefix='Dept'
)

print("\nAfter One-Hot Encoding 'Department':\n")
print(df_encoded)

# -------------------------------------------------
# Step 3: Feature Scaling
# -------------------------------------------------

scaler = StandardScaler()

num_cols = ['Age', 'Salary', 'YearsExperience']

df_encoded[num_cols] = scaler.fit_transform(df_encoded[num_cols])

print("\nAfter Feature Scaling (Standardization):\n")
print(df_encoded[num_cols].round(3))

print("\nFinal Model-Ready Dataset Shape:", df_encoded.shape)

26,889 chars · codepastes.com