BUG: allow as_index=False for non aggregating groupby methods

closes #4648
closes #3417