CLN/TST: Parametrize/deduplicate test_invalid_arg
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them

 - Combined test_series_agg_nested_renamer and test_series_nested_renamer via parametrization
 - test_transform_nested_renamer is already a part of test_nested_renamer
 - test_transform_missing_columns is essentially a duplicate of test_missing_column