BUG: allow as_index=False for non aggregating groupby methods

closes #4648.