What it means by cleaning data
hello everyone in the previous videos we talked about how we can create an
invoice in the exo and also we talked about the data type of the data type of
excel how we can enter the data into the Excel souls and we showed a type to
users by using format cells so right now we do not need any of this way so I
delete this tab and today I want to talk about how we can have a clean data so
what I mean by having a clean data so in the first video we talked about the exo
and we say that Excel the soft word for analyzing details the data I can come
into into the Excel with any formats in most cases we may have a more than
thousands of the data more than a million details and we want to analyze
those data for example I want to analyze my cells data what the product I sold if
previously how much I get by and how much I saw that for example how many of
those products are sold how many customers I have this means I need to
analyze my data of the sales data in any industry we have data and nowadays there
is a lot of data tanks for software tax for thanks for
computers and software and Internet we have lots of lots of data in any of
format that you can imagine so what what how I can analyze those
dates all Sodexo the first step is to cleaning the data so before I go too
deep into the analyzing the details for example I want to analyze this data but
not today before that I want to talk about how I can have such data so I as I
told you as I told you data can come in any format so we're trying to come from
it can come from the web's the website in the internet websites from the
software database it can come from questionnaires for example if you are a
student or if if you want to analyze something you make some questions and
give it to the some person to fill it and then you enter those data into the
software into the exo so it can be directly index so director funding so
and so there is lots of source of data so these are the main source of data so
we can have it from the web we can have it from the software databases and we
can have it from the we have which I'm introductory in today Excel and into the
Excel with whatever app which you have so we have some data index so I don't
know it can be in any format what I need to know what I need to do I need to
clean those data I need to have a clean data so what I mean by having a clean
data the clean data in the analyzed field is the date
that are in the table format so whenever I want to have a clean data I need to
reform my data into the table format I need to reform that
so the reforming process is called cleaning the data when I reform the data
which are comes from any format in any sources when I reform it to the table
format I call that dessert the clean data and
the process of doing that is cleaning data is the process of cleaning the data
so what is the table format table format
is the format that uses headers and records so most of us see the tables the
tables have something like this you have first row I say F 1 and we will have
another rows here this can be let me say that this is the row 1 this is the Row 2
Row 3 we go into the row for example n so in the road 1 we enter the table
headers
and in the next rows we will have the road details in here so these are raw
data we call them raw data because we do not have any formal Zana we do not
manipulate those data these are just data it can be the text data it can be
the date data it can be two numbers whatever are they these are not
manipulated these are the data I want to you or do you want to analyze them and
each row so we need to talk about the headers what is the header exactly and
what records each of these row is called a record so right now we need to specify
what is the header and what is the record when we get a good definition of
those we can't we will be able to reformat or the data to these formats
let me have it on your table here this is my table okay each table need to have
the name at first so the name of the table is represented data I want to
analyze so for example this can be my sales table if it's a sales table I
assume I will have the data of my cells or it can be
the marketing campaign so when I have the marketing campaign all I can assume
this table should have the marketing's data when that camp is started when that
chime in and how many people watch that cam or use that charm whatever and how
many for example customers came to my website based on that cam or they buy
from me based on that cam and so on so we need to specify what is the tables
represent for example in our examples this is a sales data so if it's the
sales data I have to assume that these are draw data here should represent my
cells these are the things that you need define you need to define before you
want to clean your data so when I have the sales data I shall assume that each
cells ID for example it can be my invoice number and for example the
customer name or for example the quantity of that customer white or for
example the price of the product I forgot to say that the first thing we
need to have is a product name which product at this customer bought how many
dis customer bought this product what is the price of this product so these are
the raw data that I need to have it when I want to analyze my soul's data and in
the headers disk my data specifications actually these
specification specifies my yourselves which I want to analyze and these are do
I really come to my header so header is the place that I will have my data
specification and I need to have that in the table approach in the table approach
I will have one column for one of these specification for example for ID I need
to have one column and for another one customer name I need to have another
column and for product name I need to have another color and for quantity
amount I need to have another column for price I need to have another column as
well so these are the headers of my table the headers of the table not just
called the header it can be called column name so some people can call them
the column name or the field name so header name my header the column name
each columns name the fields name each of in it Adam is the field are all the
same so remember that we have three other we can call them the headers we
can call them the column we can call them then field so in each row
we'll have a rotator data-id for the selves one for example if these are the
record 1 or 1 this is the r1 this record is the data of the same one so in each
row I will have the data for each cell this can be called beyond whatever says
I have and this can go all for RN so we will have n records which represent the
N cells the total cells I have until now it may be go bigger and bigger and video
so I if I want to analyze the Amazon the cells data for example it can go beyond
the millions of the series it can go beyond the billion of the souls this is
the table approach that whenever I were happy theta whenever I have a data for
example if I'm an Amazon sales data analyzer when I plot the data of the
cells from the Amazon it can be from the software it can be a found a website
whatever it has I need to reform the data into this manner into this table
manner so whatever format you have whatever shape that data has when you
reform the data into this format we call that you are cleaning the data when you
are reformat into this format and this is the format this table format this
the clean data when you have this format you format you have the clean data in
the analyzing having the clean data is the first step for analyzing the data
so whatever whenever you have the data you have to be sure your data is clean
your data is on the base on the table formats you need to reformat it to have
that clean data when you do not have this clean data analyzing your data can
be so hard complex and even you are will even you
will not be able to analyze your data so keep that approach in your mind you have
to have the table format and for example this is the data I get from my customer
this is the sales data you can assume that we have this data you can assume
that we download this data from the Microsoft Word database or from the
website whatever you have and you want to analyze this state I will provide you
the link of downloading this excel file its route data so you are able to
analyzing this data by your own and if you want to have the district's or just
click on the link and download that and in the next video we will talk about the
table tool index so if you find out that this video is useful for you please
subscribe into our YouTube channel and like our videos and see our website
koco.com ok and see our products as well thanks a lot bye goodbye