Predicting when CoronaVirus Cases will hit Zero using Python and Power BI

In this video, we have created a custom model that models the trends of Wuhan (virus birth) in order to apply them on other states and countries. The reason we used Wuhan is because it’s the only country that managed to bring their cases down to zero; assuming we trust their numbers.The aim of this model is to predict when (date) coronavirus confirm cases will hit zero by state and country and what will the numbers look like.

Support the channel on Patreon:

Data Analytics Course Link:

Predicting when CoronaVirus Cases will hit Zero using Python and Power BI
PLEASE DO NOT USE THIS MODEL TO TAKE ANY DECISIONS. THIS MODEL IS BASED ON A LOT OF ASSUMPTIONS. MAKE SURE YOU READ THE NOTES AND UNDERSTAND THEM.

**** Do not use the Estimations below to make any decisions ****

Model Aim:
- The aim of this model is to give an estimation of when CoronaVirus cases will hit zero per Country & State

- This model takes Hubei's (China) trends and applies them in each state. Hubei is the only state that reached zero cases up until now.

Assumptions:
- We assume that other countries/states will follow Hubei's trend - Which is not the safest assumption to make

- We assume that current conditions will stay the same (Social distancing & contact tracing)

Other Notes:
- We do not take into account the following: Second wave, weather, population, social distancing measures & vaccine discovery

- Est Recoveries are not calculated correctly. Working on it

- Watch the YouTube video below for full methodology & code

FREE TUTORIALS:

How to download and install Python through Anaconda:

Numpy Tutorial:

Pandas Tutorial:

Joins / Merges Tutorial:

MatPlotLib Tutorial:

Seaborn Tutorial:

Machine Learning – Linear Regression Tutorial:

Machine Learning – Logistic Regression Tutorial:

Yiannis Pitsillides on Social Media:

[andreasp.]

Very well done Yiannis. Very current and absolutely useful. You definitely deserve much more subscribers. I am sure u will soon achieve them as from what I see u deserve it!!!

[obinnaamadi]

Respect from here, Yiannis!
I'm learning a lot from you, God bless you.

[RupinderKaur-elrb]

I am indian.Now I am pursuing data analytics program from douglas college in Vancouver I feel your videos really fruitful for me for start my career in data analytics field

[lampuiking]

Hi bro, may i know where i can find your jupyter notebook folr this project? I cannot find it in ur repository

[jerrymadu]

I've been following all your videos on data enthusiastic hub, quite educative. Can you do a video on how you integrate excel to sql, so that when you refresh excel dashboard it will automatically update sql data. it will help me a lot. Thanks

[YiannisPi]

Hey Everyone, please share your thoughts about the model / dashboard in the comments below!

[louisz]

This is amazing! ! Thanks for ur great work!

[BenComedy-iehy]

Sorry but coronavirus entered second wave before ur date

[nazarzaki]

Thank you so much Yiannis. This is helpful indeed!

[lampuiking]

may i know where i can find your jupyter notebook?

[tigsik]

Just found your YT channel just subscribed too.