from leximpact_survey_scenario.graphiques_cas_type.decomposition import (
    decomposition_data,
    decompo_cotisations_employe,
    decompo_cotisation_employeur,
)

import plotly.graph_objects as go
iaidrdi has been updated in leximpact-survey-scenario
plus_values_prelevement_forfaitaire_unique_ir has been updated in leximpact-survey-scenario
rfr_plus_values_hors_rni has been updated in leximpact-survey-scenario
rpns_imposables has been updated in leximpact-survey-scenario
rpns_autres_revenus has been updated in leximpact-survey-scenario
prelevement_forfaitaire_non_liberatoire has been updated in leximpact-survey-scenario
paje_naissance has been updated in leximpact-survey-scenario
year = 2024
donnees_prive_non_cadre = decomposition_data(
    year=year,
    count=50,
    nb_smic_max=4,
    categorie_salarie="prive_non_cadre",
    parent1_age=40,
    couple=False,
    variables=decompo_cotisations_employe
    + decompo_cotisation_employeur
    + ["salaire_de_base"],
)
donnees_prive_cadre = decomposition_data(
    year=year,
    count=50,
    nb_smic_max=4,
    categorie_salarie="prive_cadre",
    parent1_age=40,
    couple=False,
    variables=decompo_cotisations_employe
    + decompo_cotisation_employeur
    + ["salaire_de_base"],
)
donnees_public_titulaire_etat = decomposition_data(
    year=year,
    count=50,
    nb_smic_max=4,
    categorie_salarie="public_titulaire_etat",
    parent1_age=40,
    couple=False,
    variables=decompo_cotisations_employe
    + decompo_cotisation_employeur
    + ["salaire_de_base", "traitement_indiciaire_brut"],
)
donnees_public_titulaire_etat = decomposition_data(
    year=year,
    count=50,
    nb_smic_max=4,
    categorie_salarie="public_titulaire_etat",
    parent1_age=40,
    couple=False,
    variables=decompo_cotisations_employe
    + decompo_cotisation_employeur
    + ["salaire_de_base", "traitement_indiciaire_brut"],
)
donnees_public_titulaire_etat
salaire_de_base cotisations_salariales mmid_salarie agirc_arrco_salarie apec_salarie contribution_equilibre_general_salarie contribution_equilibre_technique_salarie ircantec_salarie pension_salarie rafp_salarie ... vieillesse_plafonnee_employeur penibilite accident_du_travail ati_atiacl contribution_solidarite_autonomie famille mmid_employeur taxe_salaires forfait_social traitement_indiciaire_brut
0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 ... 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000
1 0.0 -51.667194 0.0 0.0 0.0 0.0 0.0 0.0 -47.495312 -4.171886 ... 0.0 0.0 0.0 -1.320000 -1.320000 -22.440002 -41.519993 0.0 0.0 427.885651
2 0.0 -103.334389 0.0 0.0 0.0 0.0 0.0 0.0 -94.990623 -8.343772 ... 0.0 0.0 0.0 -2.760000 -2.520000 -44.880005 -83.039986 0.0 0.0 855.771301
3 0.0 -155.001587 0.0 0.0 0.0 0.0 0.0 0.0 -142.485931 -12.515658 ... 0.0 0.0 0.0 -4.079999 -3.839999 -67.439995 -124.559990 0.0 0.0 1283.657104
4 0.0 -206.668777 0.0 0.0 0.0 0.0 0.0 0.0 -189.981247 -16.687544 ... 0.0 0.0 0.0 -5.520000 -5.160000 -89.879982 -166.079971 0.0 0.0 1711.542603
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
95 0.0 -9526.447266 0.0 0.0 0.0 0.0 0.0 0.0 -8739.138672 -787.309631 ... 0.0 0.0 0.0 -251.880020 -236.159973 -4133.399902 -7636.920410 0.0 0.0 78730.968750
96 0.0 -9681.768555 0.0 0.0 0.0 0.0 0.0 0.0 -8881.623047 -800.146057 ... 0.0 0.0 0.0 -256.079987 -240.000000 -4200.720215 -7761.479980 0.0 0.0 80014.625000
97 0.0 -9837.092773 0.0 0.0 0.0 0.0 0.0 0.0 -9024.110352 -812.982971 ... 0.0 0.0 0.0 -260.159973 -243.840027 -4268.159668 -7885.920410 0.0 0.0 81298.304688
98 0.0 -9992.415039 0.0 0.0 0.0 0.0 0.0 0.0 -9166.594727 -825.819519 ... 0.0 0.0 0.0 -264.240021 -247.799973 -4335.600098 -8010.479980 0.0 0.0 82581.945312
99 0.0 -10147.738281 0.0 0.0 0.0 0.0 0.0 0.0 -9309.082031 -838.655945 ... 0.0 0.0 0.0 -268.320007 -251.639999 -4402.919434 -8134.920410 0.0 0.0 83865.593750

100 rows × 34 columns

fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur privé non cadre",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisations_employe:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=donnees_prive_non_cadre.salaire_de_base,
                y=donnees_prive_non_cadre[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_non_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()

fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur privé cadre",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisations_employe:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=donnees_prive_cadre.salaire_de_base,
                y=donnees_prive_non_cadre[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()

fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur public d'Etat",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisations_employe:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=(donnees_public_titulaire_etat.traitement_indiciaire_brut),
                y=donnees_public_titulaire_etat[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()
Unable to display output for mime type(s): application/vnd.plotly.v1+json
Unable to display output for mime type(s): application/vnd.plotly.v1+json
Unable to display output for mime type(s): application/vnd.plotly.v1+json
fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur privé non cadre",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisation_employeur:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=donnees_prive_non_cadre.salaire_de_base,
                y=donnees_prive_non_cadre[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_non_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()

fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur privé cadre",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisation_employeur:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=donnees_prive_cadre.salaire_de_base,
                y=donnees_prive_non_cadre[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()

fig = go.Figure(
    layout=go.Layout(
        title="Cotisations employé secteur public d'Etat",
        template="plotly_white",
        legend=dict(orientation="h", yanchor="bottom", y=1.02, xanchor="right", x=1),
        width=800,
        margin=dict(l=10, r=10, t=20, b=10),
    )
)
for variable in decompo_cotisation_employeur:
    if variable != "cotisations_salariales":
        fig.add_trace(
            go.Scatter(
                x=(donnees_public_titulaire_etat.traitement_indiciaire_brut),
                y=donnees_public_titulaire_etat[variable],
                stackgroup="one",
                name=variable,
            )
        )

# fig.add_trace(go.Scatter(x = donnees_prive_cadre.salaire_de_base, y =donnees_prive_non_cadre["cotisations_salariales"], stackgroup='two', name="cotisations_salariales",mode='lines', line=dict(color="darkslateblue", width = 4)))
fig.show()
Unable to display output for mime type(s): application/vnd.plotly.v1+json
Unable to display output for mime type(s): application/vnd.plotly.v1+json
Unable to display output for mime type(s): application/vnd.plotly.v1+json