Mostly asked questions about projects in my resume and digged deeper on why I did what I did in the project, and asked you to identify important features for a case study solution.
Use feature_catalog and feature_evaluations to identify important features. Include active features with missing rates at or below 0.30 and average importance scores of at least 0.60, then retain the three highest-scoring features.
feature_name, feature_type, avg_importance, evaluation_count, and importance_rank.importance_rank ascending, then feature_id ascending for ties.| Column | Type | Description |
|---|---|---|
| feature_idPK | INT | Unique feature identifier |
| feature_name | VARCHAR(100) | Feature name |
| feature_type | VARCHAR(30) | Feature data type classification |
| missing_rate | DECIMAL(4,3) | Fraction of feature values that are missing |
| is_active | BOOLEAN | Whether the feature is currently eligible for use |
| Column | Type | Description |
|---|---|---|
| evaluation_idPK | INT | Unique evaluation identifier |
| feature_id | INT | Referenced feature identifier |
| importance_score | DECIMAL(4,3) | Importance score assigned during an evaluation |
| evaluator_name | VARCHAR(100) | Name of the evaluator |