Incorrect identically-labeled DataFrame objects Exception comes with df.compare method #50083
- [ ] closes #50083
- [ ] All code checks passed


First time contributing to the code base and hopefully everything goes smoothly. I will try to fix the failing tests tonight. @MarcoGorelli  would the following work as a whatsnew note?
**Whatsnew Note**

- Updated the Exception messages for df.compare method to include that both index and columns that are identically-labeled can be compared.
- Updated the test associated with these Exceptions.

Edit: sorry for all the commits please see the most recent one with the message "fixed formatting"; if you would like I will try to get rid of the two before the last You can just say that you improved the error message - I think there's some similar entries in the what's new file

No need to mention tests, it's a user facing note @MarcoGorelli I have updated the whats new file. Please review whenever you have a moment I have updated the whatsnew comment and added back in the all the other changes. I wanted to make sure all the checks were passed before requesting a review but some of the checks keep failing with the following error message `ERROR  - SystemError: initialization of _internal failed without raising an exception`. Is this due to the change requested? Also sorry this is taking so much or your time @MarcoGorelli  but I appreciate your time as this process as taught me alot. Hey - CI failures are unrelated, they're showing up in other PRs, I'll see what's going on there Thanks @tpackard1 