/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 vote133 views2 answers
How to display csv in pandas
Python
0 vote117 views2 answers
Odoo wizard current user login
Python
-1 vote132 views2 answers
Get tuple value python
Python
3 votes124 views3 answers
Python post request
Python
1 vote161 views1 answer
Find index of max value in 2d array python
Python
1 vote132 views1 answer
How to merge two column pandas
Python
0 vote132 views1 answer
Pyqt5 drop down menu
Python
0 vote170 views2 answers
Count items in a model django rest
Python Django
0 vote166 views1 answer
Arma-garch model python
Python
8 votes131 views1 answer
Printing python dictionary values
Python