Unable to remove the outlier

Data Science, AI and ML
#1

Doubt
Doubt1366×768 225 KB

#2

@ankur-kumar-30985975. This error is not regarding outlier. It is because you are comparing 2 wrong dtypes. One is series and other i guess int

#3

sir both are in float… i guess

#4

Doubt2
Doubt21366×768 173 KB

Both are Showing series data type sir

#5

check this

#6

Sir I saw that but didn’t understand

#7

https://drive.google.com/file/d/16BiFIRBIcDTbDyADrK0eq1z8siI81xtZ/view?usp=sharing

import pandas as pd

import numpy as np
import matplotlib as mlt
import matplotlib.pyplot as plt
import seaborn as sns

data = pd.read_excel(“Tips.xlsx”)

data.drop(data.index[244],inplace=True)

max_threshold1=data.total_bill.quantile([0.95])
max_threshold2=data.tip.quantile([0.95])

data.total_bill< max_threshold1

Clnd_data=data[(data.total_bill < max_threshold1) & (data.tip < max_threshold2)]

type(data.total_bill)

#8

I got your problem… the issue is because of max_threshold 1… It has index as 0.95… and data.totalbill has index as 1,2,3. Try resetting the index for max_threshold1

#9 
max_threshold1=data.total_bill.quantile([0.95])

max_threshold1.reset_index(inplace=True,drop=‘True’)
max_threshold1

data.total_bill < max_threshold1

doubt3
doubt31366×768 212 KB

still not happening sir, even after changing the index.

#10

Ok
Try this approach
It worked for me

import pandas as pd
import numpy as np
import matplotlib as mlt
import matplotlib.pyplot as plt
import seaborn as sns

data = pd.read_excel(‘Tips.xlsx’)

data.drop(data.index[244],inplace=True)

max_threshold1=data[‘total_bill’].quantile(0.95)
max_threshold1

data.total_bill < max_threshold1

#11

I tried this too previously but didn’t work. It worked only once, after I changed the name it stopped working and started giving error. I’m unable to understand the error.

#12

share the notebook with errors

#13

http://localhost:8888/notebooks/Untitled11.ipynb