/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

4 votes337 views2 answers
Python linux command
Python
10 votes360 views6 answers
Progress bar python
Python
112 votes341 views6 answers
Do while python
Python
18 votes351 views5 answers
Continue statement python
Python
0 vote368 views1 answer
Subtract constant from list
Python
0 vote365 views1 answer
Sessions in flask
Python
0 vote315 views2 answers
Generate random phone number python
Python
1 vote361 views1 answer
How to sort a list by the second element in tuple python
Python
0 vote370 views1 answer
Fake-useragent proxy webscraping browser change
Python
0 vote354 views1 answer
Box Plot in Seaborn
Python