/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 vote200 views1 answer
Adding number in set in python
Python
0 vote235 views1 answer
Getting input from button python
Python
1 vote218 views1 answer
Each line in a text file into a list in Python
Python
2 votes206 views2 answers
How to check if number is negative in python
Python
0 vote244 views1 answer
Flask No application found. Either work inside a view function or push an application context
Python
0 vote222 views1 answer
Python hex to bytes string
Python
0 vote208 views1 answer
Pip install pandas Getting requirements to build wheel
Python
3 votes206 views3 answers
Convert list to string separated by comma python
Python
0 vote210 views1 answer
Get more than one decimal in python
Python
0 vote208 views1 answer
Get last save id django model
Python