BUG: inconsistent behaviour for empty DataFrames
- [ ] Closes #47959
- [x] Tests added



Hello @Th3nn3ss! Thanks for updating this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:







There are currently no PEP 8 issues detected in this Pull Request. Cheers! :beers: 

##### Comment last updated at 2022-09-08 07:55:53 UTC @jorisvandenbossche Yes, The idea is to show some inconsistencies with empty inputs with some failing tests.

I will love to fix it.
 This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Still working on this @Th3nn3ss or has this been superseded with your other work? Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.