/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 vote167 views2 answers
How to kill python process started by excel
Python
1 vote148 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
1 vote165 views1 answer
'charmap' codec can't decode byte 0x98 in position 11354: character maps to <undefined>
Python
33 votes166 views10 answers
Elon musk
Python
0 vote170 views1 answer
Sorting-a-python-list-by-two-fields
Python
12 votes165 views5 answers
Python random uuid
Python
25 votes214 views2 answers
Python if null
Python
5 votes165 views1 answer
Python remove punctuation from text file
Python
19 votes164 views1 answer
Python ignore runtimewarning
Python
12 votes184 views5 answers
Plot size
Python