Get first and second highest values in pandas columns

by

To get the highest values of a column, you can use nlargest() :

df['High'].nlargest(2)

The above will give you the 2 highest values of column High.

You can also use nsmallest() to get the lowest values.

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Split (explode) pandas dataframe string entry to separate rows
  3. Binning a column with Python Pandas
  4. Performant cartesian product (CROSS JOIN) with pandas
  5. Pandas read_csv low_memory and dtype options
  6. How to take column-slices of dataframe in pandas
  7. replace() method not working on Pandas DataFrame
  8. Numpy “where” with multiple conditions
  9. How to map numeric data into categories / bins in Pandas dataframe
  10. Coalesce values from 2 columns into a single column in a pandas dataframe
  11. Conditionally fill column values based on another columns value in pandas
  12. How can I map True/False to 1/0 in a Pandas DataFrame?
  13. How to check if a value is in the list in selection from pandas data frame?
  14. Pandas finding local max and min
  15. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  16. Pandas lookup from one of multiple columns, based on value
  17. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  18. ‘DataFrame’ object has no attribute ‘sort’
  19. python pandas flatten a dataframe to a list
  20. how do I calculate a rolling idxmax
  21. What is dtype(‘O’), in pandas?
  22. vectorize conditional assignment in pandas dataframe
  23. Why is np.where faster than pd.apply
  24. How can I count the number of consecutive TRUEs in a DataFrame?
  25. Binning a column with pandas
  26. Unpivot Pandas Data
  27. Store numpy.array in cells of a Pandas.DataFrame
  28. Python pandas: how to remove nan and -inf values
  29. Filtering pandas dataframe with multiple Boolean columns
  30. What’s the best way to sum all values in a Pandas dataframe? [duplicate]

Leave a Comment