Outlier detection and removal using percentile | Feature engineering tutorial python # 2

[@codebasics]

Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced

[@chivalrousforlan238]

Most of KZbin tutorials I've gone through are top notch, but yours is loads of miles away. What makes yours different is you start from the basics with a slow pace, which makes it easier to understand.

[@sumit121285]

a true comment for a true teacher......

[@onlyguitars]

Best channel by far. You have become my DS - DA youtuber by far. You tackle one of the most important things that is understanding the concepts and translating it into how to do it. I recently realized that is far better to understand well the concepts than knowing perfectly each pandas function and how to code them fast. Also makes things much more interesting and fun because it clicks and makes sense.

[@suyash7450]

You Teach from zero till the the end your pace is perfect and the best part is you provide exercises and resources , Thanks for helping us and teaching us

[@kirandeepmarala5541]

max_threshold = df['price'].quantile(0.90) print(max_threshold) min_threshold = df['price'].quantile(0.05) print(min_threshold) df1 = df[(df['price'] > min_threshold) & (df['price'] < max_threshold)] Really, I am Learning a Lot from Your Channel..Waiting everyday for your videos..Your way of Explaining Concepts, Giving Exercises and genuine Talks makes your channel Different from Others..Thank you once again

[@_SanchitaPatil]

how to decide the quantile values?

[@BarongoCalvine]

Thank you, I just had a DS interview and used the age example for the outlier question, thanks for your useful lessons

[@stuttzzzi]

thank you..'if a person cant explain simply,,means he hasnt understood/knows it properly' following ue entire playlists

[@vidhanmaheshwari2082]

i was stuck in middle of a project due to messy datasets and then i came acoss your video..it helped a lot..Thanks a lot

[@KenJee_ds]

Great video as always!

[@r7918]

Thanks a lot Sir!!! This video was very helpful for me. I was doing things wrong till now. I was under impression that outliers are meant to deleted. Instead of wasting time on irrelevant data points.

[@atunraseayomide2504]

You never go wrong watching codebasics, I soo much love your work sir.

[@codebasics]

👍👍 thanks for you kind words of appreciation Atunrase 🙏

[@AbhishekBalsara]

This is exactly what I was looking for and particularly for outliers, Thanks a lot for this 👍

[@codebasics]

Glad it was helpful!

[@iaconst4.0]

eres un excelente Profesor! gracias por compartir tus conocimientos!!

[@arhataria]

This is amazing, Thanks a lot for posting this valuable video!

[@Ankurkumar14680]

It is an amazing explanation, eager to watch more videos on this topic....thanks a lot for sharing your knowledge and skills :)

[@codebasics]

I am glad it was helpful

[@manojkumar-hf6vk]

you have created amazing series Sir.

[@pallavikharbanda1372]

Great video!!Please upload more methods to detect and remove outlier detection

[@sakshamverma3114]

Sir pls upload all the videos for feature engineering....... And you are teaching methods are great

[@codebasics]

Sure sakaham

[@r21061991]

Thank god u again started making videos😀😀

[@sumit121285]

you are a real teacher ..... thanks....thanks a lot....

[@codebasics]

Happy to help

[@kenny87ification]

Thank you for this video.. Got to learn a great way of how to detect Outliers and remove them

[@AjayKumar-id7mb]

Really you explain it in a very easy way.

[@codebasics]

Glad you liked it

[@shaikhkashif9973]

8:10 After this if u check outliers in box plot u will find again because of q1 q2 q3 again assigning so that's reason u can't go for remove better go for replacement

[@OceanAlves23]

👏👏👏✔ from Brazil - Teresina - Piauí

[@saswatleo]

Amazing Video... Superb Dhaval Sir🙏

[@codebasics]

☺️☺️

[@naveenkalhan95]

would request you , if possible please add the link to the playlist of this series in the description of the video... though i have bookmarked it.. but it becomes really easy :) thank you very much for your good work again

[@mallickamu]

Correct me if I am wrong.... We can use percentile based outlier detection only if we know that the variation is normal distribution. For the height example taken by you, we know that it follows normal distribution, so the percentile based outlier detection can be applied. What if the variable distribution is Weibull type. Can we use percentile based outlier detection?

[@Deepsim]

Very clear explaination! Thank you.

[@codebasics]

Glad it was helpful!

[@leelavathigarigipati3887]

Thanks a lot for sharing your knowledge and skills.

[@rajasekharboppasamudram4463]

Your videos are very easy to understand and thanks for the content. one request from my side, volume of your videos are less compared with other sources. If possible , please increase volume

[@codebasics]

Can you check volume of your computer. I played this video on my computer and it's quite good in terms of volume

[@kratugautam304]

​@@codebasicsSavage😂

[@fahadreda3060]

Thanks for the video .. keep up the good work.. wish you all the best

[@codebasics]

thank you

[@naveenkalhan95]

@10:24 when you take min and max quantile as .001 and .999... I am confused with 0.001... Should it not be 0.01? (meaning 1 percentile). Thank you again.

[@kketanbhaalerao]

Yes, I am also. bcz 0.001 means 0.1% ?

[@viveksingh881]

no need to get confused he just went too low with quantile value.... happy learning.....

[@aldot1532]

no, basically he excluded 0.1 % of samples in both ends (upper and lower). the lower end is 0.1 %, which means he excluded 0.1% of samples below the upper end is 99.9%, which means he excluded 0.1 % of samples above

[@nafisehyazdi9876]

this tutorial was really good, Thank you

[@codebasics]

Glad it was helpful!

[@matlabtutorials2986]

Sir , hdbscan outlier detection pe bhe video banaye please

[@tauhidanwar3512]

I am confused between the percentage you have taken in min and max thersold. You said that you used 1% as min but you used 0.001 which 0.1 % and 99 % as max but you used 0.999 which is 99.9%. Plz clarify this issue sir. Thanks for this hard work for us.

[@codebasics]

I actually meant 0.1% and 99.9%, exact percentage or quartile can really vary on case to case bases. You basically use your sense of judgement to come up with these threshold values

[@_Raz_]

This is good only for small data sets . But if we have big datasets with multiple of col so it's very hard to apply

[@abhimistry9226]

Thank you dhaval bhai

[@immanuelsuleiman7550]

great content you just gained a new subscriber thank you for your efforts sir

[@codebasics]

I am glad it was helpful

[@santoshkumarmishra441]

nice explanation sir like always

[@haintuvn]

"quantile(0.001 , 0.999)". When we choose 0.001 or why dot not we choose 0.005 or other? Are there any regulation/ suggestions to choose these numbers? Thank you teacher!

[@abhimanyutiwari100]

Same question

[@demoprog6878]

This is a matter of intuition

[@dhruvshah3394]

Just one correction @12:15 you mentioned minimum threshold is 1% but isn't it actually 0.1% ?

[@javedj5338]

nice explanation. clear

[@codebasics]

I am glad you liked it

[@Ashokkumar-ds1nq]

The Tutorial is just amazing, can you please magnify your screen a bit for a clearer view?

[@MindyBrockdesigns]

What if you have several variables to fix outliers for in one data set. For example What if you wanted to remove outliers in the ‘price’ and ‘price-per-square’ variables.

[@saisridatta844]

Awesome sirr

[@robertaraujo347]

I'd like to know why you've used the variable price per area (which is just the quotient between price and area) to do the outlier treatment instead of using the mahalanobis distance (that infact, take into account the correlation between the variables) since you have 4 numerical columns. I hope someone can answer to me. I'm new in this and I have so many questions about it :)

[@NikitaSharma-bs4gg]

thank you- really helpful

[@soniadubey4773]

thanks. very clearly explained.

[@codebasics]

Glad it was helpful!

[@saramoeini4286]

thanks alot. i have question . should we do this procedure for all features one by one for detecting outliers and then remove it?

[@khushpatelmd]

Shouldn’t it be 97.5 and 2.5 as 95% of values are within 2SD

[@yashikasorathia8639]

Amazing tutorial sir, but I have one question. How would you decide what quantile value to keep since dataset would be from different domain apart from retail price such as weather report or sales report or any other?

[@covelus]

If I properly understood your question (good one, BTW), I would say domain knowledge mixed with an initial dataset statistical analysis.... Right?

[@TheShubham743]

Great video

[@temurochilov]

thank you a lot great content.

[@ishandaar]

thanks, this video is really helpful

[@codebasics]

Glad it was helpful!

[@bhaskartripathi]

Good explanation mate ! However you can apply fix percentile removal only on toy datasets. For real world data you would Hampel filters, Isolation forest, rolling window based MAD etc for outlier removal.

[@preeethan]

What if we want to treat the outliers rather than removing them.? Which is a better practise.?

[@codebasics]

You can treat them based on a situation either of them is good

[@yogeshbharadwaj6200]

Tks for the great video...

[@Unclear-Reality]

Thank you Sir

[@mithilanavishka4531]

Sir, How do we decide based on, which column to remove the outliers what is the logic for finding that column? I mean why cant we use other fields like total_sqft after I got describe of data, I saw 75% of samples have total_sqft less than 1672, and max total_sqft is 52272, I wanted remove row have maximum total_sqft, is it wrong ? the way I thought

[@mohlagare3417]

thanks a lot for sharing your knowledge and skills , can you please give us dataset. Thanks in advance

[@AlonAvramson]

Thank you!

[@sudhanshusingh8508]

Hello Sir, I have been through your video and its nice. Since I am new to data analytics I have fair theoretical knowledge about quantiles but don't know on what basis you choose the quantile level, I mean what do you look for in the describe command of any table. please help me with this.

[@suryanshsingh2873]

How to find that where is the outlier present, because there are so many variable presents in the data set

[@chrschra]

Nice explanation, thx! But what do to if my data points following are following an exponential distribution?

[@manish17788]

what if data has no outlier. In that case we will loose tiny data? how to know if not outlier removal is needed in big dataset?

[@ankitac4994]

Are there outliers present in categorical data?

[@amc8437]

How about using log transformation to remove the skewness, doesn't it do a similar job with min, max thresold?

[@zainnaveed267]

min_thresold = df['price'].quantile(0.01) _thresold = df['price'].quantile(0.9999)

[@sagar8460830871]

please make video how to setup gpu laptop. for deep learning project. i have gpu laptop but when i am starting training gpu is not process my task my haul task done on cpu. i have 4gb nvidia gtx 1650 graphics card

[@mitalipatle4993]

Can we use this method with larger Data Set?

[@YO-in2ij]

thank you

[@ismailkaracakaya260]

But how do you know if the outlier value is above 0.95th percentile?

[@haneulkim4902]

There are different ways to remove outliers, when to use what??

[@raghuram6382]

Is it possible to filter out the outliers of multiple columns in a single program? please do let me know...

[@mayanktripathi4u]

Is Outlier and Imbalanced are same concept or different? if different could you please share some information... i tried to find based on Definition both seems to be same, but both have different methods to detection and removal. So bit confused.

[@codebasics]

They are different concepts. By imbalanced most likely you are referring to imbalanced data sets in terms of machine learning where one class label have very less samples compared to another class label

[@mayanktripathi4u]

@@codebasics - Does it means that Imbalanced data is mainly for Target / Class label and Outlier is for other features from the dataset?

[@ashfakurrahman79]

Why quantile? and how quantile works?

[@mihirit7137]

the outliers in this video are the mean prices today 😅

[@sa89879]

can yo do an example of removing outliers using box plot

[@codebasics]

Yes that is coming up

[@sa89879]

@@codebasics thank you very much

[@panduenglishacademy7856]

I downloaded data from.kagle to.do hand on but when I import csv file in jupyter notebook by its name , it warn an error( name error, file not found Pls help me in solving this issue.)

[@panduenglishacademy7856]

Attribute error :- model panda has no attribute 'read'

[@swapnshah3234]

@@panduenglishacademy7856 df = pd.read_csv('yourfilename.csv') . it should be like this format.

[@trashantrathore4995]

Hi, anyone did the Exercise? Actually, the main quantile outlier removal is done using the process but what to do with 10k NAN values in "last_review" and 'reviews_per_month" column? Apart from this exercise if we encounter that big number as NAN what should we do? Any suggestions...

[@malinibhattacharyya304]

Sir, how to get jupiter note book?

[@JatinSharma-tu2zg]

Sir secand wala dataset chahiye

[@akashgaddam6320]

how can we fix the thresole value

[@muditsrivastava7719]

Sir i am not able to download this csv file, it says that data is very large, what to do?

[@codebasics]

Can you just git clone it?

[@muditsrivastava7719]

@@codebasics yes sir i did, but it says we can't make it to csv ( only raw data is available)

[@AnushkaSingh-YearBTechChemical]

This wont work in case if the data contains na values

[@jaitiwari241]

where i can find 'bhp.csv file

[@tharallaanil4115]

Data set please sir

[@codebasics]

You can find it on GitHub page

[@shubhamtyagi4962]

exercise done github.com/styagi9817/oulier-detection-using-quantile-funtion

[@codebasics]

That’s the way to go Shubham, good job working on that exercise

[@borgir6368]

who else spot binod at 4:09 lol ;()

[@jeevan999able]

binod

[@krutkanjiya2434]

4:00 Binod xD

[@allasrinivasulu1464]

Thank you so much sir