@evans_jnr

I just came across this, I'm new to every thing analytics, but this was well explained into details

@morounkejiadewumi7364

Great work you are doing here

@edehogochukwu9649

This is awesome. Thank you sir

@eaadeboyesermonsamuel-ikir733

Good afternoon Sir

@richardsonanyanwu

This is awesome, Thank you so much

@samuelagber3507

Good job sir. Found you just now on twitter

@perolagos9666

Good afternoon Mr Anietie.
Pls do you offer a physical class teaching?

@oluchiobiekee2519

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?

@victorbassey223

Great class Aniete Etuk, i'm down for the assignment

@adelekebasheer1466

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

@pusamkanism3656

Good Morning Mr. Anietie Etuk,
I'm one of your recent followers on YouTube, 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,

@iamferdico

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.

@jmicos

Sir, I can't find the column quality and  column profiling option in my excel.  How can I locate it??

@victorbassey223

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?

@samfordata

Good morning sir, 

Please, what version of Excel are you using as mine - 2106 doesn't have column profiling?

@iamferdico

Please sir can I get the powerpoint presentation slides file?
thank you sir

Secondly is the Dataset cleaning challenge still open?

@adelekebasheer1466

Sir, please i cant find the dataset to work with

@oluchiukeachi3032

Hello sir, pls what version of excel are you using. There are some features I can't find on my excel app.

@IhekwoabaChristopher-ud2gw

pls can i get the data to a can try cleaning it