Skip to content

Latest commit

 

History

History
182 lines (133 loc) · 4.21 KB

README.md

File metadata and controls

182 lines (133 loc) · 4.21 KB
Raw

COVIT-19 Analysis Dashboard

DataStudio Dashboard

Analysis of public Datasets

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