BUG: If both index and axis are passed to DataFrame.drop, raise a clear error
- [x] closes #61823
pre-commit.ci autofix @camriddell I have made the changes. Can @rhshadrach take a look and provide some guidance? If we want to maintain backwards compat. then this is likely the final form of this PR.

However there is a deeper issue that is not present in either (thanks for finding these @khemkaran10) [DataFrame.reindex](https://github.com/pandas-dev/pandas/blob/bc6ad140daf230c470fef92bec598831d4f94a16/pandas/core/generic.py#L5368), [DataFrame.rename](https://github.com/pandas-dev/pandas/blob/bc6ad140daf230c470fef92bec598831d4f94a16/pandas/core/generic.py#L1019C13-L1022C18). Namely, those methods have a default of `axis=None` and can therefore check when that value is passed, whereas in `.drop` the axis argument defaults to `axis=0` thus making it always "set". So we can check for `axis==1` as @khemkaran10 did in the PR (or `axis != 0`).  LGTM cc @rhshadrach  Thanks @khemkaran10!