/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 vote144 views1 answer
Skewness removal
Python
-1 vote158 views1 answer
List of letter in word python
Python
0 vote196 views1 answer
Python - How to subtract values from dictionaries
Python
0 vote185 views1 answer
Python set negative infinity
Python
3 votes140 views2 answers
How to install pygame in python 3.8
Python
0 vote156 views1 answer
Networkx create graph from dataframe
Python
6 votes142 views2 answers
Remove all html tags and text from string python
Python
0 vote163 views1 answer
Django builtin signals
Python
22 votes152 views6 answers
Python average
Python
2 votes135 views1 answer
Discord.py check if user has role
Python