/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

1 vote310 views1 answer
Flask render error template
Python
12 votes295 views1 answer
Copy a dict in python
Python
0 vote320 views1 answer
Serializing nested objects drf,django restframework nested object serialization
Python Django
0 vote274 views1 answer
Pandas extracting tables from pdf
Python
0 vote304 views1 answer
Determine how 2 string si equal py
Python
0 vote282 views1 answer
Where to import kivy builder
Python
0 vote285 views1 answer
Poetry python download windows
Python
0 vote283 views1 answer
Python excel zelle schreiben
Python
0 vote297 views1 answer
Pandas datetime.time
Python
0 vote292 views1 answer
Mongoengine ObjectIdField
Python