/Python/How to find the closest value in column python

How to find the closest value in column python

	result_index = df['col_to_search'].sub(search_value).abs().idxmin()

#.sub(search_value) subtracts search_value from the df[col_to_search] to make the nearest value almost-zero,
#.abs() makes the almost-zero the minimum of the column,
#.idxmin() yields the df.index of the minimum value, or the closest match to search_value.

Similar codes

-2 votes193 views4 answers
Django datepicker
Python Django
0 vote195 views1 answer
Hacker earth
Python
-1 vote167 views4 answers
Play video in colab
Python
0 vote217 views1 answer
Python mettre en minuscule
Python
11 votes169 views6 answers
Python Dictionaries
Python
2 votes207 views2 answers
Python unresolved import local visual studio code 2019
Python
4 votes127 views2 answers
How to remove all elements from dictionary python
Python
39 votes150 views6 answers
Python check if int
Python
0 vote174 views1 answer
Pandas plot hide object type
Python
14 votes197 views4 answers
How to detect keypress in python
Python