COVIT-19 Analysis Dashboard

DataStudio Dashboard

Analysis of public Datasets

• Disclaimer
• Versions
  • Automatized V2
  • Manual V1
• V2 - Python, Google Sheets AND DataStudio
  • Requirements and configurations
  • How to run
  • DEMO
  • Preview
• V1 - Notebook Description (deprecated)
  • Considerations
  • Requirements
  • DEMO
  • Preview
    • Propagation day 0 so far
    • Virus impact
    • Virus propagation
    • Worse of cases
• Tecnical Notes
  • Jupyter Notebook
  • Colab
• How to contribute

Disclaimer

The present notebook is for educational purposes

• You can send your contributions with a pull request or on twitter @eocode

Versions

Automatized V2

• Python, Googhe Sheets AND DataStudio

Manual V1

• Jupyter notebook AND Google COLAB

V2 - Python, Google Sheets AND DataStudio

Requirements and configurations

Create a Google Cloud Project here: https://console.developers.google.com/

• Enable Drive API and generate json
• Enable Google Sheets API

Copy *.json to root app

On file main.py edit the name api.json for your file name and GSheets data

How to run

run this command for install dependences

python -m venv env pip install -r requirements.txt

Open your Google Sheets and Share with client_email inside on your file .json

run

python main.py

• Connect Dataset in Google Sheets to DataStudio

DEMO

DataStudio Dashboard

Preview

Dashboard

V1 - Notebook Description (deprecated)

This repo contains a notebook with analisys of COVIT-19 propagation in Mexico and other countries

Considerations

• Deaths in México start analysis
• Deaths start day 0
• Impact = Deaths / Cases This detection dependence by country tests

Requirements

This repo is build with Jupyter Notebook and Anaconda/Python 3, for run open next file:

COVIT-19 Analisys.ipynb

The notebook make this:

• Download the data
• Clean and Filter the data
• Analisys the data
• Visualize the data

DEMO

https://colab.research.google.com/drive/1KsGxBwe0cNkQVemaM5HRax11025qNSmn#scrollTo=AIo7aJ2h1iS3

Preview

Propagation day 0 so far

Mexico Propagation vs other countries

Data

Virus impact

Relationship cases and deaths

Cases vs Deaths = Impact

Virus propagation

The best of cases is Japan tendency

Propagation in other countries after days arrived Mexico

Data

Worse of cases

Compare China and Italy

Worse of case

---

Tecnical Notes

Jupyter Notebook

• Excecute commands

! pwd

• Cells Support markdown
• Export to LATEX, HTML, PDF, etc
• Cells operations, merge, add, edit, update, delete
• View metadata
• Find and replace data
• Kernel operations (Instance of python) interrupt, stop, restart ...

Colab

• Snippets
• Execute Python and JS
• Dinamic Variables with forms
• Connect to local python kernel
• temporal code

How to contribute

Send me a pull request with your changes or catact me on Twitter or Linkedin as EOCode