/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

22 votes340 views5 answers
If else python
Python
4 votes343 views1 answer
Urlpatterns = [ path('SignUp/', views.SignupPage, name='user_data')\
Python
0 vote418 views1 answer
Superpixel
Python
0 vote389 views1 answer
Disable console messages in Flask server
Python Flask
0 vote375 views1 answer
Django vs code extensions
Python Django
15 votes362 views6 answers
Python last element of list
Python
0 vote415 views1 answer
Django database connection isn't set to UTC postgresql
Python Django
0 vote342 views1 answer
Python sum 1-50
Python
17 votes335 views2 answers
Python filter data from list
Python
0 vote332 views1 answer
Python MinMaxScaler()
Python