Skip to content

Instantly share code, notes, and snippets.

@alonsosilvaallende

alonsosilvaallende/untitled12.ipynb

Created June 9, 2021 20:35
Show Gist options
  • Save alonsosilvaallende/442740258a1948295e8b593917956b5b to your computer and use it in GitHub Desktop.
Save alonsosilvaallende/442740258a1948295e8b593917956b5b to your computer and use it in GitHub Desktop.
Download ZIP
Untitled12.ipynb
Display the source blob
Display the rendered blob
Raw
untitled12.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "Untitled12.ipynb",
"provenance": [],
"authorship_tag": "ABX9TyNOyfXpSH7f6Ae0hx/zb/d9",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/alonsosilvaallende/442740258a1948295e8b593917956b5b/untitled12.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"metadata": {
"id": "cavBXDDXc7i0"
},
"source": [
"import numpy as np\n",
"import pandas as pd"
],
"execution_count": 1,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "yyNM3Ywic-TR"
},
"source": [
"data_raw = pd.read_csv(\"https://raw.githubusercontent.com/juancri/covid19-vaccination/master/output/chile-vaccination-type.csv\")"
],
"execution_count": 2,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "STuqDF5gdtEl",
"outputId": "3ed1b825-7a9c-4d24-8943-f744390e47c2"
},
"source": [
"data_raw.iloc[2:,2:].sum(axis=0) == data_raw.iloc[0:2,2:].sum(axis=0)"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2020-12-24 True\n",
"2020-12-25 True\n",
"2020-12-26 True\n",
"2020-12-27 True\n",
"2020-12-28 True\n",
" ... \n",
"2021-06-04 False\n",
"2021-06-05 False\n",
"2021-06-06 False\n",
"2021-06-07 False\n",
"2021-06-08 False\n",
"Length: 167, dtype: bool"
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "IOpwguGRfESR",
"outputId": "c35fa709-8f27-4234-c1f3-513b838adc8c"
},
"source": [
"(data_raw.iloc[2:,2:].sum(axis=0) == data_raw.iloc[0:2,2:].sum(axis=0)).iloc[-10:]"
],
"execution_count": 4,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2021-05-30 True\n",
"2021-05-31 False\n",
"2021-06-01 False\n",
"2021-06-02 False\n",
"2021-06-03 False\n",
"2021-06-04 False\n",
"2021-06-05 False\n",
"2021-06-06 False\n",
"2021-06-07 False\n",
"2021-06-08 False\n",
"dtype: bool"
]
},
"metadata": {
"tags": []
},
"execution_count": 4
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "geYByWlQdA8O",
"outputId": "18eca47c-467b-4287-e8a8-e3e621a7f761"
},
"source": [
"(data_raw.iloc[2:,2:].sum(axis=0) - data_raw.iloc[0:2,2:].sum(axis=0)).iloc[-10:]"
],
"execution_count": 5,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"2021-05-30 0\n",
"2021-05-31 72\n",
"2021-06-01 10428\n",
"2021-06-02 33678\n",
"2021-06-03 73209\n",
"2021-06-04 107466\n",
"2021-06-05 117367\n",
"2021-06-06 119157\n",
"2021-06-07 146494\n",
"2021-06-08 165762\n",
"dtype: int64"
]
},
"metadata": {
"tags": []
},
"execution_count": 5
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 363
},
"id": "cDd7p--Vdig_",
"outputId": "9216e822-5ac2-4ece-bfa9-a03eda0f3527"
},
"source": [
"data_raw.T.iloc[-10:]"
],
"execution_count": 6,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2021-05-30</th>\n",
" <td>10533521</td>\n",
" <td>7951784</td>\n",
" <td>1959262</td>\n",
" <td>1332878</td>\n",
" <td>8340316</td>\n",
" <td>6615680</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>233943</td>\n",
" <td>3226</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-05-31</th>\n",
" <td>10688795</td>\n",
" <td>8011121</td>\n",
" <td>2012862</td>\n",
" <td>1346712</td>\n",
" <td>8402208</td>\n",
" <td>6657216</td>\n",
" <td>0</td>\n",
" <td>72</td>\n",
" <td>273725</td>\n",
" <td>7193</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-01</th>\n",
" <td>10827266</td>\n",
" <td>8082261</td>\n",
" <td>2100739</td>\n",
" <td>1361072</td>\n",
" <td>8412193</td>\n",
" <td>6709245</td>\n",
" <td>0</td>\n",
" <td>10428</td>\n",
" <td>314334</td>\n",
" <td>11944</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-02</th>\n",
" <td>10935694</td>\n",
" <td>8153790</td>\n",
" <td>2171939</td>\n",
" <td>1369248</td>\n",
" <td>8420512</td>\n",
" <td>6769041</td>\n",
" <td>0</td>\n",
" <td>33678</td>\n",
" <td>343243</td>\n",
" <td>15501</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-03</th>\n",
" <td>10990735</td>\n",
" <td>8222047</td>\n",
" <td>2212056</td>\n",
" <td>1376087</td>\n",
" <td>8433773</td>\n",
" <td>6829797</td>\n",
" <td>0</td>\n",
" <td>73209</td>\n",
" <td>344906</td>\n",
" <td>16163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-04</th>\n",
" <td>11032664</td>\n",
" <td>8290144</td>\n",
" <td>2230588</td>\n",
" <td>1381530</td>\n",
" <td>8456158</td>\n",
" <td>6891913</td>\n",
" <td>0</td>\n",
" <td>107466</td>\n",
" <td>345918</td>\n",
" <td>16701</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-05</th>\n",
" <td>11047318</td>\n",
" <td>8303146</td>\n",
" <td>2234270</td>\n",
" <td>1382836</td>\n",
" <td>8466921</td>\n",
" <td>6903499</td>\n",
" <td>0</td>\n",
" <td>117367</td>\n",
" <td>346127</td>\n",
" <td>16811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-06</th>\n",
" <td>11049291</td>\n",
" <td>8304362</td>\n",
" <td>2234757</td>\n",
" <td>1382926</td>\n",
" <td>8468382</td>\n",
" <td>6904620</td>\n",
" <td>0</td>\n",
" <td>119157</td>\n",
" <td>346152</td>\n",
" <td>16816</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-07</th>\n",
" <td>11102474</td>\n",
" <td>8403748</td>\n",
" <td>2239009</td>\n",
" <td>1389863</td>\n",
" <td>8516020</td>\n",
" <td>6996433</td>\n",
" <td>0</td>\n",
" <td>146494</td>\n",
" <td>347445</td>\n",
" <td>17452</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2021-06-08</th>\n",
" <td>11159149</td>\n",
" <td>8504106</td>\n",
" <td>2243746</td>\n",
" <td>1397592</td>\n",
" <td>8566826</td>\n",
" <td>7088543</td>\n",
" <td>0</td>\n",
" <td>165762</td>\n",
" <td>348577</td>\n",
" <td>17971</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 0 1 2 3 ... 6 7 8 9\n",
"2021-05-30 10533521 7951784 1959262 1332878 ... 0 0 233943 3226\n",
"2021-05-31 10688795 8011121 2012862 1346712 ... 0 72 273725 7193\n",
"2021-06-01 10827266 8082261 2100739 1361072 ... 0 10428 314334 11944\n",
"2021-06-02 10935694 8153790 2171939 1369248 ... 0 33678 343243 15501\n",
"2021-06-03 10990735 8222047 2212056 1376087 ... 0 73209 344906 16163\n",
"2021-06-04 11032664 8290144 2230588 1381530 ... 0 107466 345918 16701\n",
"2021-06-05 11047318 8303146 2234270 1382836 ... 0 117367 346127 16811\n",
"2021-06-06 11049291 8304362 2234757 1382926 ... 0 119157 346152 16816\n",
"2021-06-07 11102474 8403748 2239009 1389863 ... 0 146494 347445 17452\n",
"2021-06-08 11159149 8504106 2243746 1397592 ... 0 165762 348577 17971\n",
"\n",
"[10 rows x 10 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 6
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment