/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

2 votes265 views2 answers
Str replace pandas
Python
6 votes272 views2 answers
Read data from yaml file in python
Python
0 vote269 views2 answers
Filter pandas stack overflow
Python
0 vote226 views1 answer
Assosciate keys as list to values in python
Python
0 vote272 views1 answer
Couldn't open showimage no such file or directory
Python
0 vote288 views1 answer
How to make a function repeat itself a specifc amount of times python
Python
0 vote297 views1 answer
Current page django
Python
0 vote225 views2 answers
Access matrix value opencv
Python
0 vote272 views1 answer
Web3.py failing not installing
Python
0 vote285 views1 answer
Use latest file on aws s3 bucket python
Python