Hello Guys, How are you all? Hope You all Are Fine. Today We Are Going To learn about **How do I find the closest values in a Pandas series to an input number** **in Python**. So Here I am Explain to you all the possible Methods here.

Without wasting your time, Let’s start This Article.

Table of Contents

## How do I find the closest values in a Pandas series to an input number?

**How do I find the closest values in a Pandas series to an input number?**I recommend using

`iloc`

in addition to John Galt's answer since this will work even with unsorted integer index, since .ix first looks at the index labels**find the closest values in a Pandas series to an input number**I recommend using

`iloc`

in addition to John Galt's answer since this will work even with unsorted integer index, since .ix first looks at the index labels

## Method 1

You could use `argsort()`

like

Say, `input = 3`

In [198]: input = 3 In [199]: df.iloc[(df['num']-input).abs().argsort()[:2]] Out[199]: num 2 4 4 2

`df_sort`

is the dataframe with 2 closest values.

In [200]: df_sort = df.iloc[(df['num']-input).abs().argsort()[:2]]

For index,

In [201]: df_sort.index.tolist() Out[201]: [2, 4]

For values,

In [202]: df_sort['num'].tolist() Out[202]: [4, 2]

Detail, for the above solution `df`

was

In [197]: df Out[197]: num 0 1 1 6 2 4 3 5 4 2

## Method 2

I recommend using `iloc`

in addition to John Galt’s answer since this will work even with unsorted integer index, since .ix first looks at the index labels

df.iloc[(df['num']-input).abs().argsort()[:2]]

**Conclusion**

It’s all About this issue. Hope all Methods helped you a lot. Comment below Your thoughts and your queries. Also, Comment below which Method worked for you? Thank You.

**Also, Read**