Africa COVID-19 Data Cleaning
Lindo Mahlangu
In this project, I worked with a dataset that contained information about COVID-19 in Africa. The data was split across three separate spreadsheets - Infected, Recovered, and Deaths - all of which shared the same dates.
To make the data more useful, I created a new sheet where I could clean and manipulate the data. This involved combining the data into a single sheet, transposing it, and removing any duplicates. Once this was done, the data was much easier to work with and could be used to create pivot tables and dashboards.
Overall, this project was a valuable experience that gave me a taste of what it's like to work with real-world data as a data analyst. I enjoyed the challenge of making the data more structured, clean, and understandable, and I look forward to taking on similar projects in the future.
Like this project
Posted Feb 21, 2023
Simplified a complex COVID-19 dataset to enable its potential for insightful pivot tables and dashboard, providing a valuable taste of real-world data analysis.
Likes
0
Views
30
