/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 vote209 views1 answer
Object literal python
Python
5 votes226 views1 answer
How to print items in a list in a single line python
Python
0 vote254 views1 answer
Python bytes to megabytes
Python
19 votes233 views5 answers
Combine dataframes
Python
1 vote217 views1 answer
Python open file relative to module
Python
3 votes287 views2 answers
Python check if list
Python
0 vote232 views1 answer
Replace substrings in python
Python
2 votes233 views2 answers
Correlation plot python seaborn
Python
1 vote230 views1 answer
TypeError: strptime() argument 1 must be str, not Series
Python
0 vote310 views1 answer
: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend,
Python