条件行号Pandas

import pandas as pd

# 创建示例数据集
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'Gender': ['Female', 'Male', 'Male', 'Male', 'Female']}
df = pd.DataFrame(data)

# 使用条件行号对满足条件的行进行编号
df['Conditional_Row_Number'] = df[df['Age'] > 30].index + 1

# 打印结果
print(df)

      Name  Age  Gender  Conditional_Row_Number
0    Alice   25  Female                     NaN
1      Bob   30    Male                     NaN
2  Charlie   35    Male                     1.0
3    David   40    Male                     2.0
4      Eve   45  Female                     3.0