Helper Brasil Conta Comigo

29 Oct 2020

What is Brasil Conta Comigo?

logo_medway

Brasil Conta Comigo is a Governmental program that aims to increase the number of professionals in the fight against COVID-19. It intends to do so by recruiting students from the 5º and 6º years of Medical School along with last year students from the Nursing, physiotherapy, and farmaceutical school.


Problem Overview

The main spotted problem is the way the data is displayed. There is no filter. The places with vacancies are shown in a table at ApoiaSUS, followed by each profession slot number. Even though the data is grouped by states, there are more than 5570 cities in Brazil. With that said, finding a city near yours and that fulfills your profession type can be a difficult task.


Tools Used

The project was done entirely in Python and deployed with Heroku. The libraries used in Python were:


Preprocessing

The work consisted of Joining three tables, one table that contains the data in ApoiaSUS website, the data with the IBGE code and the data that stores the latitude and the longitude of each city, so we could use them to calculate an approximate distance.

We did the string preprocessing in each city and state name, removing accents and other characters that could lead to a more complex search system, and we lowered all the strings in the table that we use as search keys.

Web App

The entire application was done using streamlit. We used it to generate the data with the filter sidebar, along with the map visualization. To adjust the data shown with the filter we used pandas dataframe .loc methods and to calculate the distance we used geopy.distance.

The code can be found at the GitHub repository.

Results

The project is no longer working, since the govern has ended the program. You can see a preview of how it was by watching the video below.

Questions?

Thank you for your time!

You can reach me out on any social media at the end of the page.