Our project seeks to compare the impact of Covid-19 on the environment, comparing before and after the pandemic. For them we will take datasets that will be processed in Python, in order to process and analyze these changes.
We focus on obtaining the data set from reliable sources (provided for the challenge) and on formats that can be entered in our model (csv, excel, json formats), finding a problem here since not all the information is found in these formats. Here we think of a Big Data model, because the source of information selected from different sources and in different formats, all of them go through a data cleaning. We did not manage to implement a database. As a database engine we can use MongoDB, easy to use and maintain as it is a NoSQL database.
The drawback encountered is obtaining centralized data in formats ready to enter our project, on the other hand, the data for South America is not grainy.
How to implement our solution ?
The first step is to obtain the data, in this case we navigate and choose the following information to demonstrate the procedure for the treatment of information and the generation of information for our project and observe the human trail with the Covid-19.
Source:https://www.google.com/covid19/mobility/index.html?hl=en
Type: File format csv (https://www.gstatic.com/covid19/mobility/Global_Mobility_Report.csv)
Project: Community Mobility Reports
Data description: These data sets show by country, how visits of persons change and how long they last compared to a baseline. We calculate the changes using the same type of aggregated and anonymized data that we use to display the peak times of places on Google Maps. The changes for each day are compared to a reference value for that day of the week.
Data analysis description: As was our proposal, we propose to analyze the data using Colab.
In the first instance, the project was inspired by the resources we had. NASA gave us material to work with, and we tried to make the most of everything we could.
Why design a web page? For the simple fact of being on the web, on the internet. People from all over the world can access this URL. In these times of pandemic, because of COVID-19, most of the population lies in their homes in the possibility.
So ... what can we offer? Mainly, updated information on the course of the climate, environment, and health of the planet. The data is something very precious by the population today, because it is thanks to these that we can obtain statistics, progressions, and awareness, in addition. Although there are no purely numerical data on the current website (5/31/2020), there are many analyzes of these.
No one today has been involved in a pandemic, as the last one occurred long ago. However, that does not mean that we, as humans, do not learn with the history and data we have. Thanks to the technology that exists today, and the one that continues to develop; we can manipulate an unquantifiable amount of data in our environment. The point is such that we wanted to develop this website, COVID LAMBDA. This is the means by which we as a team can channel free, quality information to those who need it. We are a team that works together, and for that very reason, we want people to feel unified with each other, through the manipulation of common data, the use of similar tools, etc.
We took the google data set to analyze how the displacements of your community have changed due to COVID-19. We take the 4 country as an demo.
Initially we take dataset in Colab:
📷 (PAGE 4)
Then, is necessary review data, if is necessary we need aplicate “Data Wrangling”, this is mapping and transforming data. For this demo we take 4 countries and a small range of date, recent dates:
📷 (PAGE 5)
Finally get graphic with information about ‘parks percent change from baseline’.
📷 (PAGE 6)
This information show us the percentage that attends a park in these four countries, choosing as a sample their capitals.
Source:https://www.google.com/covid19/mobility/index.html?hl=en
Type: File format csv (https://www.gstatic.com/covid19/mobility/Global_Mobility_Report.csv)
Project: Community Mobility Reports