Covid9.ipynb

covid9.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.7.5"
    },
    "colab": {
      "name": "Covid9.ipynb",
      "provenance": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/gist/leandrorodor/54831de41654d484a7b96dd86526fdd2/covid9.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "crnJ0n0rf9nW",
        "colab_type": "text"
      },
      "source": [
        "![Data-ScientistsCovid.png](attachment:Data-ScientistsCovid.png)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "H3N1FEgSf9nX",
        "colab_type": "text"
      },
      "source": [
        "# COVID-19"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bHEQLK5Ef9nX",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# Bibliotecas Necessárias\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n",
        "%matplotlib inline"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "WTrF-wXff9na",
        "colab_type": "text"
      },
      "source": [
        "## Dados dos Casos "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "x51DUyrff9na",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "casos = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv')\n",
        "casos.tail()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "x4lQAyM3f9nc",
        "colab_type": "text"
      },
      "source": [
        "## Casos no Brasil"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DPaXi-Cnf9nd",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "casosBrasil = casos[casos['Country/Region'] == 'Brazil']\n",
        "valCasosBrasil = np.sum(casosBrasil.iloc[ : , 4 : casosBrasil.shape[1]])\n",
        "valCasosBrasil.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QkHXcRl2f9ng",
        "colab_type": "text"
      },
      "source": [
        "## Obituários"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "L7dbOt_Af9nh",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mortes = pd.read_csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv\")\n",
        "mortes.tail()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Jbuydpf8f9nj",
        "colab_type": "text"
      },
      "source": [
        "## Obituários no Brasil"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IocuVThlf9nk",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mortesBrasil = mortes[mortes['Country/Region'] == 'Brazil']\n",
        "valMortesBrasil = np.sum(mortesBrasil.iloc[ : , 4 : mortesBrasil.shape[1]])\n",
        "valMortesBrasil.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "7d4P0Z2Nf9nm",
        "colab_type": "text"
      },
      "source": [
        "## Cálculo da Taxa de Mortalidade no Brasil"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jRSoZzeYf9nm",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mortalidade = (valMortesBrasil/valCasosBrasil)*100\n",
        "mortalidade.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "JN8UFhZrf9no",
        "colab_type": "text"
      },
      "source": [
        "## Pacientes Recuperados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SKs9z2GBf9np",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "recuperados = pd.read_csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv\")\n",
        "recuperados.tail()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tAGAKyZgf9nr",
        "colab_type": "text"
      },
      "source": [
        "## Pacientes Recuperados no Brasil"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4Wc47nK6f9nr",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "recuperadosBrasil = recuperados[recuperados['Country/Region'] == 'Brazil']\n",
        "valRecuperadosBrasil = np.sum(recuperadosBrasil.iloc[ : , 4 : recuperadosBrasil.shape[1]])\n",
        "valRecuperadosBrasil.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vzsdI6jcf9nt",
        "colab_type": "text"
      },
      "source": [
        "## Comparativo"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_w7Y99Fbf9nu",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "casosAtivos = valCasosBrasil - (valRecuperadosBrasil + valMortesBrasil)\n",
        "casosAtivos.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BfYDV0yjf9nw",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df = pd.concat([valCasosBrasil, casosAtivos, valRecuperadosBrasil, valMortesBrasil], axis=1)\n",
        "df.columns = ([\"casos\", \"ativos\", \"recuperados\", \"mortes\"])\n",
        "df.plot()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-O98147tf9ny",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}