Where There’s a Link, There’s a Way

Since the COVID-19 pandemic began, there has been a proliferation of websites and portals developed to share resources about the topic. Your challenge is to find innovative ways to present and analyze integrated, real-time information about the environmental factors affecting the spread of COVID-19.

COVID-19 spread through Mobility and Weather

Summary

This project ventures to determine the following two correlations with COVID-19 spread1) Precipitation/Temperature on a landscape2) Mobility of people in various sectors like, Grocery & Essentials, parks, residentials and Workplaces etc.

How We Addressed This Challenge

The motto of this challenge being to find an innovative way or ground-breaking analysis of existing data from various promising web portals and sources and obtain a result , we at RogerThat had anticipated and attempted to discover insights based on mobility data and precipitation data of top effected states in India.

How We Developed This Project

Why Precipitation Data?

In Southern hemisphere, as everybody knows precipitation is going to embark amidst this COVID-19, answering the question of “How precipitation might affect the disease spread?“ has become significantly vital. And India being the second-most populous country, it is a win-win to perform analytics in this space to prevent the excessive spread of the disease.

Why Mobility data?

In various countries the lockdown is being lifted off steadily due to various reasons like economy, ………,……. . As a result of this mobility of people in different sectors like Grocery & Essentials, Parks, Residentials and Workplaces will keep varying in chronological manner. Finding a correlation between disease spread rate and mobility in various verticals, helps us understand what is that sector that is most affecting the disease spread and thereby giving an opportunity for the government to impose rules against movement in the highly correlated space.


After collecting the data we ventured a prolific analysis using the following technologies,

- Python (Programming Language)

- Jupyter Notebook (Where we coded)

- Plotly 

- Pandas profiling

- Numpy

- Pandas Dataframe

- Docker

Conclusions:

-  Spearman correlation of different metrics has being calculated and observed some correlation between states which have higher COVID-19 confirmed cases and states which have lower COVID-19 cases in the following metrics.

1) Transit metric

2) Temperature metric

- We also observed 14 day moving avg data have better correlation with the metrics,

- We need to study/focus more on transit related phenomenon and temperature related features. 

- Further studies will surely help on predicting when and where COVID-19 spread will occur.


Project Demo

Our results are in the following github link

https://github.com/gaganpreet97/covid_correlation.git

Data & Resources

- https://www.covid19india.org/ (Covid spread details)

- https://www.google.com/covid19/mobility/ (Global Mobility information)

- https://www1.ncdc.noaa.gov/ (Weather data)

Tags
#data analytics, #weather impact, #mobility impact
Global Judging
This project was submitted for consideration during the Space Apps Global Judging process.