<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Adebayo Ayokanmi on Medium]]></title>
        <description><![CDATA[Stories by Adebayo Ayokanmi on Medium]]></description>
        <link>https://medium.com/@ayokanmivictor?source=rss-4ea79ff2d076------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*DXk-fi_6EkuludBE</url>
            <title>Stories by Adebayo Ayokanmi on Medium</title>
            <link>https://medium.com/@ayokanmivictor?source=rss-4ea79ff2d076------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 09:22:06 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@ayokanmivictor/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Article on Data cleaning]]></title>
            <link>https://medium.com/@ayokanmivictor/article-on-data-cleaning-6364af70ce1a?source=rss-4ea79ff2d076------2</link>
            <guid isPermaLink="false">https://medium.com/p/6364af70ce1a</guid>
            <category><![CDATA[sports]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[self-improvement]]></category>
            <dc:creator><![CDATA[Adebayo Ayokanmi]]></dc:creator>
            <pubDate>Tue, 14 Mar 2023 10:53:07 GMT</pubDate>
            <atom:updated>2023-03-14T10:53:07.497Z</atom:updated>
            <content:encoded><![CDATA[<p>Data cleaning is one of the vital components of any analysis. It is nothing but fixing incorrect data which impacts data analysis. The basic approaches in data cleaning are correcting missing values,removing null values and standardizing features.</p><p>In this article, I will walk you through some of the very useful Excel tips on to clean a rough data and prepare it in a presented manner. which can use for further analysis and also use to prepare a vivid visualization for end users. For this section, I have used the https://www.kaggle.com/datasets/yagunnersya/fifa-21-messy-raw-dataset-for-cleaning-exploring shared in Kaggle. Here is a snapshot of the data set,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/479/1*Gg-iQ_rCf-okMYe4Q-BF2w@2x.jpeg" /></figure><p>Inspiration</p><ol><li>Convert the height and weight columns to numerical forms</li><li>2. Remove the unnecessary newline characters from all columns that have them.</li><li>3. Based on the ‘Joined’ column, check which players have been playing at a club for more than 10 years!</li><li>4. ‘Value’, ‘Wage’ and “Release Clause’ are string columns. Convert them to numbers. For eg, “M” in value column is Million, so multiply the row values by 1,000,000, etc.</li><li>5. Some columns have ‘star’ characters. Strip those columns of these stars and make the columns numerical</li><li>6. Which players are highly valuable but still underpaid (on low wages)? (hint: scatter plot between wage and value)</li></ol><p><strong>The processes I took in other to provide answers to the above questions are:</strong></p><p>Firstly the messy data was loaded in Excel worksheet. using power query. which can be used for data cleanings such as split data, Find and replace , remove duplicates and to perform some statistical expressions.</p><p>Thus on this data i carried out the following:</p><p><strong>} Data Splitting/Trimming</strong></p><p>The dataset was loaded and transformed using Unicode (UTF8) in which table was created and trimming was carried out columns where needed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/335/1*YNcd88aLQupvJMtuSOeJVA@2x.jpeg" /></figure><p><strong>} Find and Replace Value</strong></p><p>Columns such as contract, W/F was cleaned using find and replace to remove or change unnecessary characters.</p><p>}<strong>Data manipulation/ Statistical expression</strong></p><p>As required that the Value’, ‘Wage’ and “Release Clause’ are string columns and should be converted. into numbers. For eg, “M” in value column is Million, so multiply the row values by 1,000,000. This was done by Adding a conditional column where some commands and clause were used</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/463/1*2t4BQ7ryaa3CrMwS46A5FQ@2x.jpeg" /></figure><p><strong>} Data Filtering was also used to remove necessary </strong>columns ( profile url as it also servers same purpose as players URL)</p><p>The dataset was successfully cleaned and loaded into excel workbook where further analysis can be carried out.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6364af70ce1a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>