how to find values greater than 500 in pandas dataframe

Asked Mar 15 '21 at 14:34

Active Mar 15 '21 at 14:34

Viewed 18 times

here is my code, but i'm not able to understand that why it is giving me value 13.000 in the output.



    data[data.Fare>500].index
    output: Int64Index([258, 679, 737, 343], dtype='int64')
    
    data.iloc[[258, 679, 737, 343], 9]
    output: 
    258    512.3292
    679    512.3292
    737    512.3292
    343     13.0000
    Name: Fare, dtype: float64

asked Mar 15 '21 at 14:34

Swapnil

If use `data[data.Fare>500]` then got same ouput? – jezrael Mar 15 '21 at 14:38
yes, it also gave me 13.000 and I'm not sure why – Swapnil Mar 15 '21 at 15:35
I got an answer, there are two rows with the same index 343 which containing values 512.3292 and 13.000 respectivly. – Swapnil Mar 16 '21 at 05:13

how to find values greater than 500 in pandas dataframe

0 Answers0