/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

5 votes253 views4 answers
Python generator
Python
23 votes379 views3 answers
Django rest framework
Python Django
0 vote263 views1 answer
Convert .tiff image stack to unit8 format
Python
2 votes273 views2 answers
Calculate mean on python
Python
199 votes344 views6 answers
Pip upgrade
Python
0 vote242 views1 answer
Choose custom index pandas
Python
0 vote267 views1 answer
Take union of two dataframes pandas
Python
6 votes252 views2 answers
Python code for where to save the figures
Python
0 vote242 views1 answer
Pil normalize image
Python
0 vote254 views6 answers
Python math
Python