Get the index of minimum value in DataFrame column

In this article, we will learn how to get the index of the minimum value from a specific column in a Pandas DataFrame using .idxmin().

To download the dataset used in this article, click here.

Dataset Preview

Output

Code 1: Find Index of Minimum Weight

To find the row with the smallest weight, use idxmin(). It gives the index of that row.

Output

We can verify whether the minimum value is present in index or not.

Output

Explanation: df.iloc[140:155]: returns rows from position 140 to 154 of the DataFrame.

Code 2: Insert a Row and Find Minimum Salary

Insert a custom row at index 0 with the minimum salary, and check if .idxmin() correctly identifies it.

Output

Explanation:

• pd.concat([new_row, df]): Combines new_row with df, adding the new row at the top.
• .reset_index(drop=True): Resets the row numbers so they start from 0 and removes the old index.

Now check the minimum salary index:

Output

Related Articles:

• Pandas Tutorial
• Pandas dataframe.idmax()