/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

189 votes196 views10 answers
New Year's Eve
Python
0 vote130 views1 answer
Numpy remove rows containing nan
Python
0 vote153 views1 answer
Install qt designer python ubuntu
Python
1 vote172 views1 answer
Django return only part of string
Python Django
0 vote138 views1 answer
Python os path safe string
Python
0 vote138 views1 answer
Python - How To Concatenate List of String
Python
2 votes125 views1 answer
Variable in regex python
Python
0 vote115 views1 answer
Pandas query on datetime
Python
36 votes124 views6 answers
Remove letter from string python
Python
7 votes129 views2 answers
Python check for duplicate
Python