Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A B
- 0 1 0.810743
- 1 2 0.595866
- 2 3 0.154888
- 3 4 0.472721
- 4 5 0.894525
- 5 6 0.978174
- 6 7 0.859449
- 7 8 0.541247
- 8 9 0.232302
- 9 10 0.276566
- dfb = df[df['A']==5].index.values.astype(int)
- dfbb = df[df['A']==8].index.values.astype(int)
- df.loc[dfb:dfbb,'B']
- A B
- 4 5 0.894525
- 5 6 0.978174
- 6 7 0.859449
- dfb = df[df['A']==5].index.values.astype(int)[0]
- dfbb = df[df['A']==8].index.values.astype(int)[0]
- dfb = int(df[df['A']==5].index[0])
- dfbb = int(df[df['A']==8].index[0])
- dfb = next(iter(df[df['A']==5].index), 'no match')
- print (dfb)
- 4
- dfb = next(iter(df[df['A']==50].index), 'no match')
- print (dfb)
- no match
- print (df.loc[dfb:dfbb-1,'B'])
- 4 0.894525
- 5 0.978174
- 6 0.859449
- Name: B, dtype: float64
- print (df[(df['A'] >= 5) & (df['A'] < 8)])
- A B
- 4 5 0.894525
- 5 6 0.978174
- 6 7 0.859449
- print (df.loc[(df['A'] >= 5) & (df['A'] < 8), 'B'])
- 4 0.894525
- 5 0.978174
- 6 0.859449
- Name: B, dtype: float64
- print (df.query('A >= 5 and A < 8'))
- A B
- 4 5 0.894525
- 5 6 0.978174
- 6 7 0.859449
- df[df['A']==5].index.item()
- i5, i8 = df.index.searchsorted([df.A.eq(5).idxmax(), df.A.eq(8).idxmax()])
- df.iloc[i5:i8]
- def find_between(df, col, v1, v2):
- vals = df[col].values
- mx1, mx2 = (vals == v1).argmax(), (vals == v2).argmax()
- idx = df.index.values
- i1, i2 = idx.searchsorted([mx1, mx2])
- return df.iloc[i1:i2]
- find_between(df, 'A', 5, 8)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement