How do I find the closest values in a Pandas series to an input number?

by

You could use argsort() like

Say, input = 3

In [198]: input = 3

In [199]: df.iloc[(df['num']-input).abs().argsort()[:2]]
Out[199]:
   num
2    4
4    2

df_sort is the dataframe with 2 closest values.

In [200]: df_sort = df.iloc[(df['num']-input).abs().argsort()[:2]]

For index,

In [201]: df_sort.index.tolist()
Out[201]: [2, 4]

For values,

In [202]: df_sort['num'].tolist()
Out[202]: [4, 2]

Detail, for the above solution df was

In [197]: df
Out[197]:
   num
0    1
1    6
2    4
3    5
4    2

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. Combine two columns of text in pandas dataframe
  4. Convert DataFrame column type from string to datetime
  5. How to apply a function to two columns of Pandas dataframe
  6. How to convert an XML file to nice pandas dataframe?
  7. Dynamically evaluate an expression from a formula in Pandas
  8. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  9. Can pandas automatically read dates from a CSV file?
  10. df.append() is not appending to the DataFrame
  11. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  12. pandas dataframe str.contains() AND operation
  13. Pandas groupby mean – into a dataframe?
  14. Get column index from column name in python pandas
  15. Count occurrences of each of certain words in pandas dataframe
  16. pandas DataFrame output end of csv
  17. python pandas dataframe slicing by date conditions
  18. Python/Pandas convert string to time only
  19. Row-wise average for a subset of columns with missing values
  20. Plot multiple columns of pandas DataFrame using Seaborn
  21. Python: Removing Rows on Count condition
  22. Dynamically filtering a pandas dataframe
  23. Anti-Join Pandas
  24. Remove NaN/NULL columns in a Pandas dataframe?
  25. Python: How to drop a row whose particular column is empty/NaN?
  26. Combine Pandas data frame column values into new column
  27. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  28. DataFrame object has no attribute append
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path

Leave a Comment