Hugging Face's logo

Spaces:
donizetti-yoann
/
technova-ml-api
Sleeping

App Files Community
technova-ml-api
File size: 2,172 Bytes
5fa8558
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
 
-- =====================================================
-- MART — Dataset final pour le modèle ML
-- =====================================================

CREATE SCHEMA IF NOT EXISTS mart;

DROP TABLE IF EXISTS mart.employee_features;

CREATE TABLE mart.employee_features AS
SELECT
    -- Identifiant
    id_employee,

    -- =========================
    -- Variables de base (X)
    -- =========================
    age,

    lower(trim(genre)) AS genre,
    revenu_mensuel,
    lower(trim(statut_marital)) AS statut_marital,
    lower(trim(departement)) AS departement,
    lower(trim(poste)) AS poste,

    nombre_experiences_precedentes,
    annees_dans_l_entreprise,

    satisfaction_employee_environnement,
    satisfaction_employee_nature_travail,
    satisfaction_employee_equipe,
    satisfaction_employee_equilibre_pro_perso,

    heure_supplementaires,
    augmentation_salaire_precedente,
    nombre_participation_pee,
    nb_formations_suivies,
    distance_domicile_travail,
    niveau_education,

    lower(trim(domaine_etude)) AS domaine_etude,
    lower(trim(frequence_deplacement)) AS frequence_deplacement,

    -- =========================
    -- Features calculées
    -- =========================
    (
      (COALESCE(annees_sous_responsable_actuel, 0) + 1)::double precision
      /
      (COALESCE(annees_dans_l_entreprise, 0) + 1)::double precision
    ) AS ratio_manager_anciennete,

    (
      (COALESCE(annees_dans_l_entreprise, 0) - COALESCE(annees_dans_le_poste_actuel, 0))::double precision
      /
      (COALESCE(annees_dans_l_entreprise, 0) + 1)::double precision
    ) AS mobilite_relative,

    (COALESCE(note_evaluation_actuelle, 0) - COALESCE(note_evaluation_precedente, 0)) AS evolution_performance,

    (
      COALESCE(annees_depuis_la_derniere_promotion, 0)::double precision
      /
      (COALESCE(annees_dans_l_entreprise, 0) + 1)::double precision
    ) AS pression_stagnation,

    -- =========================
    -- Target (y)
    -- =========================
    a_quitte_l_entreprise

FROM staging.employee_base;

CREATE INDEX IF NOT EXISTS idx_mart_employee_features_id
ON mart.employee_features(id_employee);