/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

1 vote136 views2 answers
Extract numbers from list of strings python using regex
Python
0 vote128 views1 answer
X y coordinates in python
Python
0 vote130 views1 answer
Pyqt5 qpush button pressed
Python
0 vote130 views1 answer
Install python package from git colab
Python
0 vote124 views2 answers
Conda install dash
Python
8 votes125 views2 answers
Reverse python script
Python
0 vote135 views1 answer
Slicing time series
Python
6 votes125 views2 answers
Python gzip a file
Python
2 votes172 views3 answers
Marks input using list in python
Python
2 votes128 views1 answer
OPENCV GET CONTOURS
Python