/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

4 votes329 views3 answers
Python image crop
Python
1 vote287 views1 answer
Wheter
Python
0 vote336 views1 answer
Epoch to datetime utc python
Python
9 votes306 views1 answer
Delete object from table django
Python Django
9 votes280 views2 answers
Read live video from usb opencv python
Python
0 vote315 views2 answers
Reset repo
Python
0 vote332 views1 answer
What will be the output of the following python code? i = 0 while i < 5: print(i) i += 1 if i == 3: break else: print(0)
Python
2 votes349 views1 answer
Get stats from array python
Python
0 vote353 views1 answer
Pivot table but keep nan
Python
6 votes245 views2 answers
Python loop through folders and subfolders
Python