/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

0 vote318 views1 answer
Matrix outer product python
Python
0 vote313 views1 answer
Python check if type
Python
1 vote318 views1 answer
Frequency
Python
0 vote299 views2 answers
I want to check my python code online
Python
-1 vote357 views9 answers
Django for Beginners
Python Django
1 vote313 views1 answer
Python plot bins not lining up with axis
Python
0 vote346 views1 answer
Django Signup view
Python Django
12 votes307 views2 answers
Column.replace
Python
0 vote302 views1 answer
Python triée plusieurs fois avec virgule
Python
0 vote322 views1 answer
Repalce na with mean per group
Python