查找数据帧中第二个最小值的索引

import pandas as pd

# 示例数据帧
df = pd.DataFrame({
    'A': [3, 1, 4, 1, 5],
    'B': [2, 7, 1, 8, 2]
})

# 按列'A'排序并获取第二个最小值的索引
second_min_index = df.sort_values(by='A').index[1]
print(second_min_index)

import pandas as pd
import numpy as np

# 示例数据帧
df = pd.DataFrame({
    'A': [3, 1, 4, 1, 5],
    'B': [2, 7, 1, 8, 2]
})

# 找到列'A'中第二小的值
second_min_value = np.sort(df['A'].unique())[1]

# 找到该值的索引
second_min_index = df[df['A'] == second_min_value].index[0]
print(second_min_index)

import pandas as pd

# 示例数据帧
df = pd.DataFrame({
    'A': [3, 1, 4, 1, 5],
    'B': [2, 7, 1, 8, 2]
})

# 找到列'A'中第二小的值
unique_values = df['A'].unique()
second_min_value = sorted(unique_values)[1]

# 找到该值的索引
second_min_index = df[df['A'] == second_min_value].index[0]
print(second_min_index)

import pandas as pd

# 示例数据帧
df = pd.DataFrame()

if not df.empty:
    # 找到列'A'中第二小的值
    unique_values = df['A'].unique()
    second_min_value = sorted(unique_values)[1]
    # 找到该值的索引
    second_min_index = df[df['A'] == second_min_value].index[0]
    print(second_min_index)
else:
    print("数据帧为空")