Atohor/fifa-21-data-cleaning-task-Pidgin-Version

This is the Pidgin English translation of my #DatacleaningChallenge documentation # fifa-21-data-cleaning-task-Pidgin-Version ### Note if u know say u nor sabi read pidgin English then this article nor be for you , jejely waka pass go look the oyibo version here English Version Oyibo talk say person wen never fit clean d dirty wen dey for inside e house , how the outside compound won take clean ?  And for Data analysis , the inside house na be the data , while analysis/visualization na the outside compound . So follow me waka make we go clean our inside house Introduction this now how I take jejely clean the FIFA 21 dataset when some big names for the data industry drop ontop twitter , make omomo analyst and egbon analyst take try their hands, wether you sabi work or you be jjc .Dem tag the challenge #Datacleaningchallenge. Omo The data sef nor be small data , e carry 77 columns and 18,979 rows on everything about many footballers for around 2021. The dataset dey where everybody go fit see am for kaggle and the guy when run am  gather scrap the data from sofifa Them still drop dictionary about this data when go give you more expo about the footballers incase some things de miss from your data or you nor too understand some kind stuff for the data  Many tools dey when person fit take tackle data cleaning .For me personally, Based on sability, I come choose Power Query editor when de ontop power query to take battle this challenge ## Data Cleaning process To make sure say my data na ogbonge quality , see how i take run am pass  After I load the data , the space too much for inside so to remove the spaces ,na just one button I click for the view tab . Dem call the button “show white spaces “ . I say no nor show am , cause the spaces them too many, e almost reach one plot of land. Whitespaces | Before | After | |--------|-------| | **1. Data Auditing** : this one mean say I use eagle eye take observe my data, make i for see all the dirty things when I need scrub well for my data. I see many columns when my broom of justice go …