/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

28 votes194 views2 answers
Tofixed in python
Python
1 vote194 views1 answer
How to input 2-d array in python
Python
0 vote193 views1 answer
How to change dtype object to int
Python
2 votes181 views10 answers
Lol
Python
0 vote195 views1 answer
Return position of a unique value in python array
Python
4 votes193 views2 answers
Plt dashed line
Python
0 vote172 views1 answer
Load image metadata with pil
Python
1 vote252 views1 answer
Counter in django template
Python
0 vote175 views1 answer
Root = tk() python 3
Python
4 votes211 views1 answer
Histogram | creating a histogram
Python