/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

177 votes270 views6 answers
Read file in python
Python
0 vote173 views1 answer
Flatmap in python
Python
1 vote165 views1 answer
How to access items in a list
Python
14 votes176 views2 answers
How to change the background of heading in tkinter
Python
10 votes174 views4 answers
Discord.py to discord.js converter
Python
21 votes193 views5 answers
Python stop script
Python
15 votes186 views6 answers
List to text file python
Python
21 votes263 views4 answers
Send dm discord py
Python
9 votes249 views5 answers
Get dummies pandas
Python
2 votes164 views1 answer
Extract text regex python
Python