Awaitingprof/Malaria-in-Africa

This project focuses on the development of malaria in Africa during the past two decades and gives a thorough knowledge of that development (2007-2017). # Malaria-in-Africa This project focuses on the development of malaria in Africa during the past two decades and gives a thorough knowledge of that development (2007–2017). In Africa, malaria is a widespread disease caused by mosquito bites and an untidy environment. It can be fatal even though it can be prevented by taking preventative measures. This dataset is gotten from Kaggle. It contains all African countries from 2007 to 2017 as well as the unique country code, Latitude and Longitude of each country, and the preventive measure that has been taken to curtail Malaria in Africa. This project provides a comprehensive understanding of how malaria has evolved in Africa over the last two decades (2007-2017). ## Methodology Data Cleaning Data Analysis Data Visualization ### Data Cleaning The dataset was downloaded in CSV(Comma Separated Values) format, and I converted it to Excel format. The duplicated data was removed, and some special characters were eliminated using find and replace Full documentation is available at ebenezeradebiyi.wixsite.com ### Data Analysis The dataset was imported into Sequel (SQL) and analyzed. The codes are shown below. select * from [dbo].[Africa$] /* Total Country */ SELECT COUNT(DISTINCT Country) FROM [dbo].[Africa$] As Total_Country; /* Total Malaria Case reported */ SELECT SUM(Malaria_reported) AS Total_Case_Reported FROM [dbo].[Africa$]; /* Trend in Malaria cases reported over the year */ SELECT Year,SUM(Malaria_reported) As Total_Case_Reported FROM [dbo].[Africa$] GROUP BY Year Order BY Total_Case_Reported; /* Total Malaria cases reported in West Africa */ SELECT SUM(Malaria_reported) AS Total_west_Africa FROM [dbo].[Africa$] WHERE Country IN ('Benin', 'Burkina Faso', 'Cape Verde', 'Cote Di voire', 'Gambia', 'Ghana', 'Guinea', 'Guinea_Bissau', 'Liberia', 'Mali', 'Mauritania', 'Niger', 'Nigeria', 'Senegal', 'sierra L …