/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 vote176 views1 answer
Sort for Linked Lists python
Python
3 votes170 views1 answer
Python initialize multidimensional list
Python
0 vote143 views1 answer
Python assign variable to another variable
Python
0 vote166 views1 answer
Python pandas convert comma separated number string to integer list
Python
8 votes150 views4 answers
Primes python
Python
0 vote159 views1 answer
Cache-control no cache django
Python
24 votes178 views1 answer
Python datetime strptime hour minute second
Python
7 votes188 views1 answer
Np array n same values
Python
0 vote148 views1 answer
Admin site
Python
20 votes228 views3 answers
Matplotlib custom legend
Python