STYLE Enable Pylint statement import-self
Issue #48855.  This PR enables the pylint type "W" warning `import-self`.
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
Thanks @uzzell 