title: Conditional filtering in a multiindex
body: <p>I'm attempting to conditionally remove rows (per the <code>Symbol</code> index) in a multiindex (if <code>Limit</code> equals 1), then keep it removed for the following days until column <code>Reset</code> for said Symbol equals 1.
  The <code>Limit</code> defines how many symbols are allowed for said <code>Date</code>.
  Limit is the same for each <code>Date</code> while Reset is per <code>Symbol</code>.</p>
  <p>If there's a way to do this without looping over groups, it would be most preferable. I'd also appreciate suggestions on methods on how to approach this.</p>
  <p>Generate the df:</p>
  <pre><code>import pandas as pd
  import numpy as np
  from datetime import datetime, timedelta
  
  np.random.seed(55)
  symbols, symlen =   2, 3
  times =             np.arange(datetime(2021, 1, 5), datetime(2021, 1, 15), timedelta(days=1)).astype(np.datetime64)
  tlen =              len(times)
  A, Z =              np.array(['A', 'Z']).view('int32')
  symbol_names =      np.random.randint(low=A, high=Z, size=symbols * symlen, dtype='int32').view(f'U{symlen}')
  limit =             np.random.randint(low=0, high=2, size=symbols*tlen, dtype='int32')
  end =               np.random.randint(low=0, high=2, size=symbols*tlen, dtype='int32')
  times =             np.concatenate([times] * symbols)
  names =             np.array([y for x in [[s] * tlen for s in symbol_names] for y in x])
  value_col =         np.random.randint(low=40, high=60, size=len(times), dtype='uint32')
  
  df = pd.DataFrame({'Value': value_col, 'Limit': limit, 'End': end}, index=[names, times])
  df.index = df.index.set_names(['Symbol', 'Date'])
  df['Limit'] = df.groupby('Date')['Limit'].transform('sum')-1
  
  groups = df.groupby(['Date', 'Symbol']).sum()
  </code></pre>
  <p>Current result:</p>
  <pre><code>                    Value   Limit   Reset
  Date        Symbol          
  2021-01-05  FXF     58      0       1
              NHI     49      0       0
  2021-01-06  FXF     50      0       0
              NHI     52      0       1
  2021-01-07  FXF     40      0       1
              NHI     52      0       1
  2021-01-08  FXF     50      0       0
              NHI     53      0       1
  2021-01-09  FXF     43      1       0
              NHI     49      1       1
  2021-01-10  FXF     47      0       0
              NHI     41      0       0
  2021-01-11  FXF     58      0       0
              NHI     53      0       1
  2021-01-12  FXF     41      1       0
              NHI     58      1       0
  2021-01-13  FXF     59      0       0
              NHI     56      0       1
  2021-01-14  FXF     53      0       1
              NHI     53      0       1
  </code></pre>
  <p>Desired output:</p>
  <pre><code>                    Value   Limit   Reset
  Date        Symbol          
  2021-01-05  FXF     58      0       1
              NHI     49      0       0
  2021-01-06  FXF     50      0       0
              NHI     52      0       1
  2021-01-07  FXF     40      0       1
              NHI     52      0       1
  2021-01-08  FXF     50      0       0
              NHI     53      0       1
  2021-01-09  FXF     43      1       0
  2021-01-10  FXF     47      0       0
  2021-01-11  FXF     58      0       0
              NHI     53      0       1
  2021-01-12  FXF     41      1       0
  2021-01-13  FXF     59      0       0
              NHI     56      0       1
  2021-01-14  FXF     53      0       1
              NHI     53      0       1
  </code></pre>