/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 vote105 views1 answer
Convert tuple to array python
Python
1 vote98 views1 answer
Pyton count number of character in a word
Python
0 vote126 views1 answer
Django 2.2 disable cache settings.STATIC_URL
Python Django
0 vote123 views1 answer
Add url parameter in anchor django template
Python Django
0 vote103 views1 answer
Standard scaler vs min max scaler
Python
0 vote130 views1 answer
Onetoone vs foreign key django
Python Django
0 vote99 views1 answer
Python - Comment Parse String to List
Python
0 vote121 views1 answer
Save changes flask sqlalchemy
Python
1 vote102 views1 answer
Python install tabulate
Python
1 vote98 views1 answer
Tuple with one element python
Python