/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

1 vote313 views1 answer
Python practice questions on classes and objects
Python
21 votes316 views2 answers
Python string does not contain
Python
31 votes334 views4 answers
Float to string python
Python
5 votes312 views1 answer
Getpass
Python
0 vote341 views1 answer
Re python split()
Python
-1 vote331 views1 answer
Python type checking boolean
Python
2 votes358 views2 answers
Super in django manager
Python Django
0 vote286 views1 answer
Forward fill pandas ffill
Python
0 vote373 views1 answer
Resizing django embed player
Python Django
1 vote316 views1 answer
How to get total number of rows in listbox tkinter
Python