CLN: raise ValueError instead of Exception
This is necessary for tightening up a bunch of Exception catching in groupby/apply/resample.  Doing this as a separate step because I find the isolation clearer.