def mortality()

in api/streamlit_experiments/covid.py [0:0]


def mortality(df):
    df["Mortality Rate"]=(df["Deaths"]/df["Confirmed"])*100
    df["Recovery Rate"]=(df["Recovered"]/df["Confirmed"])*100
    df["Active Cases"]=df["Confirmed"]-df["Recovered"]-df["Deaths"]
    df["Closed Cases"]=df["Recovered"]+df["Deaths"]

    st.write("Average Mortality Rate = ",f'{df["Mortality Rate"].mean():.2f}')
    st.write("Median Mortality Rate = ",f'{df["Mortality Rate"].median():.2f}')
    st.write("Average Recovery Rate = ",f'{df["Recovery Rate"].mean():.2f}')
    st.write("Median Recovery Rate = ",f'{df["Recovery Rate"].median():.2f}')

    #Plotting Mortality and Recovery Rate 
    fig = make_subplots(rows=2, cols=1,
                    subplot_titles=("Recovery Rate", "Mortatlity Rate"))
    fig.add_trace(
        go.Scatter(x=df.index, y=(df["Recovered"]/df["Confirmed"])*100,name="Recovery Rate"),
        row=1, col=1
    )
    fig.add_trace(
        go.Scatter(x=df.index, y=(df["Deaths"]/df["Confirmed"])*100,name="Mortality Rate"),
        row=2, col=1
    )
    fig.update_layout(height=1000,legend=dict(x=0,y=0.5,traceorder="normal"))
    fig.update_xaxes(title_text="Date", row=1, col=1)
    fig.update_yaxes(title_text="Recovery Rate", row=1, col=1)
    fig.update_xaxes(title_text="Date", row=1, col=2)
    fig.update_yaxes(title_text="Mortality Rate", row=1, col=2)

    st.write(fig)