获取特定索引后带有符号的行

你需要掩盖真相 wer 也

s = (df['col1'].str.contains('\$')           # rows containing $
     & df['col1'].eq('wer').cumsum().gt(0)   # rows after the first 'wer'
    ).idxmax()
# s == 7

使用:

#df=df.set_index('Index') #if 'index' is a column
df2=df[df['col1'].eq('wer').cumsum()>0]
df2['col1'].str.contains('\$').idxmax()

或者:

df[(df['col1'].eq('wer').cumsum()>0) & df['col1'].str.contains('\$')].index[0]

输出:

7

细节:

df['col1'].eq('wer').cumsum().eq(1)
Index
1    False
2    False
3    False
4     True
5     True
6     True
7     True
8     True
Name: col1, dtype: bool

print(df2)
       col1
Index      
4       wer
5       exr
6       ert
7      $546
8      $456