/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 vote135 views1 answer
How to install pandas datareader in conda
Python
0 vote126 views1 answer
Python display map
Python
36 votes121 views2 answers
Python3 iterate through indexes
Python
11 votes114 views2 answers
Python datetime yesterday
Python
0 vote117 views1 answer
Pandas pull value from column
Python
25 votes122 views3 answers
Download youtube video in python
Python
0 vote124 views1 answer
Python output parameter
Python
1 vote126 views2 answers
Pyttsx3 set volume
Python
3 votes82 views1 answer
How to present if statement in dfd
Python
1 vote124 views2 answers
Np matrix drop zero column
Python