/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 vote174 views1 answer
Python visualize fft of an image
Python
0 vote141 views1 answer
Get ip address in django
Python
0 vote149 views1 answer
Swap two columns python
Python
0 vote191 views1 answer
Import "whitenoise.django" could not be resolved
Python Django
0 vote177 views1 answer
Serializing nested objects drf,django restframework nested object serialization
Python Django
0 vote198 views1 answer
Purpose of migration folder in django
Python Django
0 vote147 views1 answer
Python set workdir
Python
0 vote157 views1 answer
How to convert a list to a string by newline python
Python
0 vote148 views1 answer
Python chunk text
Python
33 votes115 views2 answers
Find a largest number in function list python
Python