Pandemic, pandemonium and the panacea — an EDA

Nidhi Pai
Analytics Vidhya
Published in
7 min readMay 16, 2021

--

Credits: here

All our lives turned topsy-turvy more than a year ago. Courtesy: the unexpected arrival of the coronavirus. A game of dominoes, each and every one of us was and still is affected by this deadly disease that has long been declared a pandemic. As of 15 May 2021, more than 161 million cases have been confirmed, with more than 3.35 million deaths attributed to COVID-19, making it one of the deadliest pandemics in history.

Thanks to the frontline workers and so many more individuals, we’ve managed to keep humankind and humanity thriving. This being said, we also have our own selves to thank for braving through this and fighting all odds to mould our lifestyles and adapt to the situation. To assist this process, vaccinations turned out to be the game changers with regard to the Coronavirus. One by one, the vaccines have kept rolling out in the market and each and every single one has proved to be efficient in bringing down the number of active cases.

I was genuinely intrigued and drawn to these two datasets, (1) and (2), on Kaggle and this supported my aim of convincing people to get themselves vaccinated.

In this blog post, I would like to share some of the key insights I gained during my exploration of the vaccination dataset and the conclusions put forth by each visualisation. With the data still updating on a day-to-day basis, let’s hope to see a positive spin on this situation.

Attached herewith is my code on Github here or on Kaggle here. The interactive versions of the chloropleth and the tree maps are made available on my Kaggle code. I’ve used python as the programming language with a primary use of numpy, pandas, matplotlib, seaborn and plotly for the inferences.

How covid cases aggravated and what is the present state?

https://www.kaggle.com/nidhipai99/pandemic-pandemonium-and-the-panacea-an-eda?rvi=1&scriptVersionId=62971205&cellId=7

We can clearly see that the cases have risen exponentially in almost every country however they’re showing signs of improvement and the transitions are evidently portrayed in the two chloropleth maps. I’ve deliberately avoided going deeper into this dataset. The situation feels a little too grim to elaborate on hence, I’ll take the small wins we get and use this opportunity to dive into the vaccinations dataset.

Exploring the vaccinations dataset

This dataset is a relatively small one with 15 columns and 17607 rows. This data is collected daily from Our World in Data GitHub repository for covid-19, merged and uploaded.

  1. How many people are vaccinated in each country?

We can see that China, USA and India are the top 3 contenders for the total number of vaccinated people. However, it is not clear if this is due to large size of the population that they’re topping the charts or if they actually have most people in the country vaccinated (density wise).

2. Which countries have the most number of fully vaccinated people?

The above bar plot suggests that on a cumulative, at least 5 million people from each country have already been completely vaccinated. As mentioned earlier, I suppose this would have been lucid considering a population to vaccination ratio.

3. What’s the trend noticed when comparing date with daily vaccinations?

With the first doses of vaccinations out in December 2020, there’s been a steep rise in the number of vaccinations starting April, 2021. This is a positive change since this helps us infer that more and more people are becoming aware of the necessity and importance of a vaccine and that they’re willing to get their shot. Way to go y’all!

4. What’s the scenario concerning vaccinations in India?

That’s a positive change, indeed! I hope this is the slope that keeps going higher and higher and that we’re able to get all and sundry vaccinated.

5. Which is the most popularly used vaccine?

From the wordcloud, we can clearly notice that AstraZeneca closely followed by Pfizer and Oxford seem to be the most popularly used vaccines. This again is confirmed by the visualisation in the bar plot. Vaccines like BioNTech, Johnson&Johnson, Sinopharm appear to be next in line. That being said, do not wait for a particular vaccine to head your way. You get a chance to get vaccinated? Grab it.

6. Which country prefers what vaccine?

Want to check out more? Here’s a treemap with more information:
https://www.kaggle.com/nidhipai99/pandemic-pandemonium-and-the-panacea-an-eda?rvi=1&scriptVersionId=62971205&cellId=43

Why vaccines can bring about a change?

To assure the efficacy of the vaccines, let’s take into account a before-after scenario. Consider people fully vaccinated (per hundred) in the United State of America.

From the chronologically arranged chloropleth, let’s observe the number of cases on 15th Jan 2021 and 1st May 2021 and compare: We notice that the cases on 15th Jan 2021 total to 87,42,806. However, the cases take a nose dive to 65,89,842 as of 1st May 2021 (aka after the administration of vaccines) Hence, there’s definitely a reduction in the number of active cases.

Let’s consider another country to cement this observation well. Let’s take UAE this time and follow the same steps.

On 15th January 2021, the active cases are about 26,655. As of 15th April 2021, the number of active cases drops to 14,866. Once again, confirming the observation that yes, vaccines are efficient and they play a huge role in mitigating this spread of the virus. Back off, anti-vaxxers!

A gist

Conclusion

From the different plots visualised from the data provided in the dataset, I think it is safe to say that vaccination schemes are on the rise and so is the number of people getting vaccinated. This is crucial considering the culmination of the coronavirus at least in the past year and a half. Vaccinations have most definitely proven to be effective and there is an evident decline in the number of active cases. That being said, staying satiated with just one dose won’t do you or anyone else any good. If a particular vaccine is to be administered in two doses, take both those shots. Let’s do our bit to ease the load of the frontline workers and of course, to dwindle this pandemonium and the pandemic.

How can we stop Covid-19 from ravaging countries?

There’s no way to tell how long the pandemic will continue. There are many factors, including the public’s efforts to slow the spread, researchers’ work to learn more about the virus, their search for a treatment, and the success of the vaccines. Remember, the best covid vaccine is the one available to you. So, wait for your chance and go take a shot! Help others get their jab and if they seem to hesitate, convince them in all the ways you possibly can. Wear a mask (even if you’re fully vaccinated), use sanitisers and I’m guessing by now, you know the drill! Hoping to catch the endpoint in sight, let’s bring this virus down, together! We can do this!

Thank you for reading this far. All your opinions are welcome!

--

--

Nidhi Pai
Analytics Vidhya

I'm a computer science engineer with a keen interest in Statistics, Data science and the world of UI/UX Design. I love to read books and explore new tech.