/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

19 votes210 views6 answers
Pandas change column order
Python
0 vote202 views1 answer
Fibonacci sequence generator python
Python
2 votes215 views3 answers
Str to datetime time
Python
8 votes205 views4 answers
Print pandas version
Python
12 votes159 views10 answers
Print in python
Python
0 vote214 views1 answer
"'S3' object has no attribute 'Bucket'", python boto3 aws
Python
2 votes226 views2 answers
Python how to sum two lists
Python
0 vote182 views1 answer
How to resize image with pillow in django
Python Django
1 vote207 views1 answer
Tf get devices
Python
0 vote201 views1 answer
Legend outside subplot not displayed
Python