/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 vote269 views1 answer
Pandas to latex table width pylatex
Python
0 vote264 views1 answer
.lstrip()
Python
1 vote260 views1 answer
Python ieee 754 converter
Python
25 votes291 views2 answers
Copy text to clipboard python
Python
2 votes269 views1 answer
Python read text file next line
Python
1 vote252 views1 answer
Accuracy score sklearn syntax
Python
0 vote313 views1 answer
Aws lambda logging with python logging library
Python
11 votes247 views6 answers
Get file size python
Python
-1 vote327 views1 answer
Install grepper for edge
Python
0 vote251 views1 answer
How to insert files in tuple python
Python