/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

3 votes231 views3 answers
User input dictionary python
Python
1 vote233 views1 answer
Using regex validators in django models
Python Django
0 vote249 views1 answer
Find the middle of the document in the image opencv
Python
55 votes219 views3 answers
Python read values from file
Python
0 vote234 views1 answer
Pandas qcut
Python
0 vote233 views1 answer
Scatter plot | create scatter plot
Python
4 votes253 views2 answers
Django queryset group by
Python
0 vote233 views1 answer
Week of the year pandas
Python
1 vote225 views1 answer
How to re run code in python
Python
0 vote219 views1 answer
Python autocorrelation plot
Python