1
Pasted Nov 2, 2026, 1:20 PM3 files270 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/hii1Python
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)7,056 chars · codepastes.com