/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 vote325 views1 answer
X= [10] def List_ex(): x.append(20) def add_list(): x=[30,40] x.append(50) print (x) List_ex() print (x) add_list() print (x)
Python
0 vote319 views1 answer
Read list stored as a string with pandas read csv
Python
0 vote385 views1 answer
Python json random number generator
Python
5 votes343 views1 answer
Instead, it is recommended that you transition to using 'python3' from within Terminal.
Python
0 vote338 views1 answer
Python email subject decode
Python
0 vote273 views1 answer
Find optimal number of clusters sklearn
Python
4 votes330 views3 answers
Csv to json
Python
0 vote280 views1 answer
Space complexity python
Python
0 vote343 views1 answer
Format numbers in dataframe pandas
Python
2 votes340 views1 answer
User input of int type in python
Python