Good evening, Sir. When you remove unwanted or duplicate rows on Primary keys simpliciter, does this not shorten the number of the primary key column while leaving others complete? What do you think?
Good Morning Mr. Anietie Etuk, I'm one of your recent followers on UA-cam, Facebook and others. I was following one of your videos Part 1: Top 20 Data Cleaning Tricks in 2024 and I'm using Excel 2019 and Power BI. Along the line while following, the PBI and Excel where not responding to the Conditional command in Add Column. Please advise. Regards,
Hello Sir, like to ask on the yesterday's class, -In fixing the "Date Error", after making use of the average - replacing 7/25/2007 by the Avg - 6/20/2018, why going further to replace again on that column by 8/8/2018 please?
Many thanks sir, it's a boy o. Will go get the version and install. I need to complete the cleaning using Excel than Power BI then conclude other parts. Sir, can I still enroll into the mentorship program announced in the description of this video? Apologies for my late show of interest, I came across your channel two days ago through a random search on "data analysis using Excel" Kindly let me in sir 🙏
Good day sir please how do one handle blank and null cells in a dataset that's quite too much, like under a column , there will be 101 (10%) rows, out of 978 rows with null values. Same goes with other columns which either have 10 to 40 rows of blank/null values. Am I to remove them, fill them with "not available"? The null/blank values appears both in number and text columns. Secondly, some column values aren't consistent, under some columns you will be seeing values, that are not in same category. eg having "yam" under electronics column. any help on possible solution please? thank you sir.
If the bull values are less than 10% (most analyst allow up to 20%) of the data, you can replace it with the mean or median (for numerical data) , and by the mode (for categorical data).
Sir, I am having problem with changing of values in the department column and gender column. Also, on how to add conditioner column about the marital status, after the operation, it's only bringing others not with single and married
I just came across this, I'm new to every thing analytics, but this was well explained into details
Sir can i use excel 2016 for this project?
Great work you are doing here
This is awesome. Thank you sir
You're welcome
This is awesome, Thank you so much
You're welcome
Good afternoon Mr Anietie.
Pls do you offer a physical class teaching?
Yes. Are you in Lagos or PH?
@@LearnwithEtuk Lagos
SkillAhead, 39 unity road, off Toyin Street, Ikeja, call admin 08034730987
Good evening, Sir.
When you remove unwanted or duplicate rows on Primary keys simpliciter, does this not shorten the number of the primary key column while leaving others complete?
What do you think?
It affects all
Ok. Thanks
Good Morning Mr. Anietie Etuk,
I'm one of your recent followers on UA-cam, Facebook and others.
I was following one of your videos Part 1: Top 20 Data Cleaning Tricks in 2024 and I'm using Excel 2019 and Power BI. Along the line while following, the PBI and Excel where not responding to the Conditional command in Add Column. Please advise.
Regards,
Good job sir. Found you just now on twitter
You are welcome
Sir my power query doesn't have column profile, using Excel 2021
@@samuelagber3507 since it's Excel 2021, I may not know the reason. But check, which Windows are you using?
Windows 10 sir
Hello Sir, like to ask on the yesterday's class, -In fixing the "Date Error", after making use of the average - replacing 7/25/2007 by the Avg - 6/20/2018, why going further to replace again on that column by 8/8/2018 please?
Replacing by 6/20/2018 is to reset the range since the outlier set the range off.
And with the new range, we now have a new average
Good morning sir,
Please, what version of Excel are you using as mine - 2106 doesn't have column profiling?
Excel 2021.
Good day madam.
Many thanks sir, it's a boy o. Will go get the version and install. I need to complete the cleaning using Excel than Power BI then conclude other parts.
Sir, can I still enroll into the mentorship program announced in the description of this video?
Apologies for my late show of interest, I came across your channel two days ago through a random search on "data analysis using Excel"
Kindly let me in sir 🙏
Good day sir
please how do one handle blank and null cells in a dataset that's quite too much, like under a column , there will be 101 (10%) rows, out of 978 rows with null values.
Same goes with other columns which either have 10 to 40 rows of blank/null values.
Am I to remove them, fill them with "not available"?
The null/blank values appears both in number and text columns.
Secondly, some column values aren't consistent, under some columns you will be seeing values, that are not in same category. eg having "yam" under electronics column.
any help on possible solution please?
thank you sir.
If the bull values are less than 10% (most analyst allow up to 20%) of the data, you can replace it with the mean or median (for numerical data) , and by the mode (for categorical data).
Please sir can I get the powerpoint presentation slides file?
thank you sir
Secondly is the Dataset cleaning challenge still open?
Sir, I am having problem with changing of values in the department column and gender column. Also, on how to add conditioner column about the marital status, after the operation, it's only bringing others not with single and married
To replace values you need to trim the text column first, and make sure to type it exactly.
Trim the column first
Great class Aniete Etuk, i'm down for the assignment
Great. Let's keep building
Sir, I can't find the column quality and column profiling option in my excel. How can I locate it??
If it's not in view, then it's just an issue of the version of Excel you're using
Hello sir, pls what version of excel are you using. There are some features I can't find on my excel app.
Excel 2021
Thanks
Sir, please i cant find the dataset to work with
Check the description section.
pls can i get the data to a can try cleaning it
Yes you can. Check the description section of this video.